Wanted Hero Mode System !!

VsroHost · 09/22/2014, 23:55

Hello EveryOne
Today i Will Release Here Mode Wanted System
Let's Do it

Refskill

Code:

1	50021	1042	SKILL_SKALIDOR_WANTED_S_02	?:??? ?	SKILL_SKALIDOR_WANTED_S_2	0	2	1	0	99999999	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\wanted.ddj	SN_SKILL_SKALIDOR_WANTED_S_2	xxx	SN_SKILL_SKALIDOR_WANTED_S_2_TT_DESC	SN_SKILL_SKALIDOR_WANTED_S_2_STUDY	0	0	3	1667396966	1851946342	1685418593	3600000	6582901	2	2	1868849522	2	2	25970	0	2	26738	0	2	1819632491	2	1634493301	1	1937011305	2	0	1768846441	2	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50022	1042	SKILL_SKALIDOR_WANTED_S_03	?:??? ?	SKILL_SKALIDOR_WANTED_S_3	0	3	1	0	99999999	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\wanted.ddj	SN_SKILL_SKALIDOR_WANTED_S_3	xxx	SN_SKILL_SKALIDOR_WANTED_S_3_TT_DESC	SN_SKILL_SKALIDOR_WANTED_S_3_STUDY	0	0	3	1667396966	1851946342	1685418593	3600000	6582901	3	3	1868849522	3	3	25970	0	3	26738	0	3	1819632491	3	1634493301	1	1937011305	3	0	1768846441	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50023	1042	SKILL_SKALIDOR_WANTED_S_04	?:??? ?	SKILL_SKALIDOR_WANTED_S_4	0	4	1	0	99999999	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\wanted.ddj	SN_SKILL_SKALIDOR_WANTED_S_4	xxx	SN_SKILL_SKALIDOR_WANTED_S_4_TT_DESC	SN_SKILL_SKALIDOR_WANTED_S_4_STUDY	0	0	3	1667396966	1851946342	1685418593	3600000	6582901	4	4	1868849522	4	4	25970	0	4	26738	0	4	1819632491	4	1634493301	1	1937011305	3	0	1768846441	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
1	50024	1042	SKILL_SKALIDOR_WANTED_S_05	?:??? ?	SKILL_SKALIDOR_WANTED_S_5	0	5	1	0	99999999	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	255	255	0	0	0	0	0	255	255	255	255	skill\china\wanted.ddj	SN_SKILL_SKALIDOR_WANTED_S_5	xxx	SN_SKILL_SKALIDOR_WANTED_S_5_TT_DESC	SN_SKILL_SKALIDOR_WANTED_S_5_STUDY	0	0	3	1667396966	1851946342	1685418593	3600000	6582901	5	5	1868849522	5	5	25970	0	5	26738	0	5	1819632491	5	1634493301	1	1937011305	3	0	1768846441	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

RefSkillGroup

Code:

1042	SKILL_SKALIDOR_WANTED_S

Create Procedure

Code:

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  StoredProcedure [dbo].[_Wanted]    Script Date: 9/12/2014 6:25:37 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE  procedure [dbo].[_Wanted] 
@CharID		int,
@EventID		tinyint,
@Desc		varchar(128)
as 

Declare @Kc int
Declare @CharName VARCHAR(52) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)	 
DECLARE @K_Name VARCHAR(512) = @Desc
        SELECT @K_Name = REPLACE(@K_Name, LEFT(@K_Name, CHARINDEX('(', @K_Name)), '')
        SELECT @K_Name = REPLACE(@K_Name, RIGHT(@K_Name, CHARINDEX(')', REVERSE(@K_Name))), '')
  ----- Killed CharID
        DECLARE @K_CharID INT =(SELECT  CharID FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @K_Name) 
  ------
 -- Check if he kills the char more than 3 times  
 DECLARE @PKill int = (select COUNT(*) from _RowKills where KillerID = @CharID and KilledID = @K_CharID)     
 DECLARE @MaxK int = (select COUNT(Kills) from _RowKills where KillerID = @CharID and Kills = '1')  
 IF ( @PKill <= '9' and @MaxK <= '50' ) 
    BEGIN
INSERT INTO _RowKills (KillerID , KilledID , Kills) VALUES (@CharID , @K_CharID,'1')
            END    
 ----- End inserting           
            
              

 SET @Kc = (SELECT COUNT(Kills) FROM _RowKills WHERE KillerID = @CharID and Kills = '1' )--and Recived = 'OFF')   
 --- if he kills 10 in row give him the buff      -- give Wanted level 1  
 IF @Kc = '10' AND NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between '34243' and '34247')
          BEGIN
  INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) 
  ---- Values
  VALUES (@CharID , 0 , 34243 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )  
  INSERT INTO SRO_VT_SHARDLOG.dbo.PlusNotice VALUES ('0',+@CharName+' : is Wanted "Hero Mode - 10Kills in row [Wanted Lv1]"',GETDATE())
        END  
             
  --- if he kills 20 in row give him the buff      -- give Wanted level 2  
 IF @Kc = '20'  AND NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where  CharID = @CharID and JobID between '34244' and '34247')
 BEGIN 
 INSERT INTO SRO_VT_SHARDLOG.dbo.PlusNotice VALUES ('0',+@CharName+' : is Wanted "Hero Mode - 20Kills in row [Wanted Lv2]"',GETDATE())
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID = '34243')
 BEGIN
 DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID = '34243'    
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 34244 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )  
 END
 ElSE IF NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID = '34243')
 BEGIN
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID )  VALUES (@CharID , 0 , 34244 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 ) 
           END
              END 
   --- if he kills 30 in row give him the buff      -- give Wanted level 3  
 IF @Kc = '30' AND NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where  CharID = @CharID and JobID between '34245' and '34247')
 BEGIN 
 INSERT INTO SRO_VT_SHARDLOG.dbo.PlusNotice VALUES ('0',+@CharName+' : is Wanted "Hero Mode - 30Kills in row [Wanted Lv3]"',GETDATE())
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between'34243' and '34244')
 BEGIN
 DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID between'34243' and '34244'   
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 34245 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )  
 END
 ElSE IF NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between'34243' and '34244')
 BEGIN
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID )  VALUES (@CharID , 0 , 34245 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 ) 
           END
              END   
  --- if he kills 40 in row give him the buff      -- give Wanted level 4  
 IF @Kc = '40' AND NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where  CharID = @CharID and JobID between '34246' and '34247')
 BEGIN 
 INSERT INTO SRO_VT_SHARDLOG.dbo.PlusNotice VALUES ('0',+@CharName+' : is Wanted "Hero Mode - 40Kills in row [Wanted Lv4]"',GETDATE())
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between '34243' and '34245')
 BEGIN
 DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID between '34243' and '34245'   
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 34246 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )  
 END
 ElSE IF NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between '34243' and '34245')
 BEGIN
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID )  VALUES (@CharID , 0 , 34246 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 ) 
           END
              END     
 --- if he kills 50 in row give him the buff      -- give Wanted level 5  
 IF @Kc = '50' AND NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where  CharID = @CharID and JobID = '34247')
 BEGIN 
 INSERT INTO SRO_VT_SHARDLOG.dbo.PlusNotice VALUES ('0',+@CharName+' : is Wanted "Hero Mode - 50Kills in row [Wanted Lv5]"',GETDATE())
 DELETE FROM _RowKills WHERE KillerID = @CharID 
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between '34243' and '34246')
 BEGIN
 DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID between '34243' and '34246'
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 34247 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )  
 END
 ElSE IF NOT EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID and JobID between '34243' and '34246')
 BEGIN
 INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID )  VALUES (@CharID , 0 , 34247 , 3600 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 ) 
           END
              END

GO

Create Table

Code:

USE [SHARDLOG]
GO

/****** Object:  Table [dbo].[_RowKills]    Script Date: 09/13/2014 11:35:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_RowKills](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[KillerID] [int] NULL,
	[KilledID] [varchar](50) NULL,
	[Kills] [int] NULL,
 CONSTRAINT [PK__RowKills] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

_AddLogChar -> (SRO_VT_LOG -> Programmability -> Stored Procedures -> Right click on _AddLogChar and press on 'Modify')

Code:

--- Wanted System		
if @EventID = '19'   -- Count kills
      BEGIN
 if (@strPos like '%(0x679a)%')
      BEGIN
    IF (@Desc LIKE '%Trader, Neutral, no freebattle team%'    -- Trader
        OR @Desc LIKE '%Hunter, Neutral, no freebattle team%'    -- Hunter
        OR @Desc LIKE '%Robber, Neutral, no freebattle team%'    -- Thief
        ) BEGIN
        
        DECLARE @KilledName VARCHAR(512) = @Desc
        DECLARE @ReqLevel INT = 0
        SELECT @KilledName = REPLACE(@KilledName, LEFT(@KilledName, CHARINDEX('(', @KilledName)), '')
        SELECT @KilledName = REPLACE(@KilledName, RIGHT(@KilledName, CHARINDEX(')', REVERSE(@KilledName))), '')
        SELECT @ReqLevel = CurLevel FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @KilledName
        if @ReqLevel >= 90
        BEGIN
      Exec [_Wanted] @CharID , @EventID , @Desc
           End
             END
               END
                 END
if @EventID = '20' -- if dies
BEGIN 
IF (@Desc LIKE '%Trader, Neutral, no freebattle team%'    -- Trader
        OR @Desc LIKE '%Hunter, Neutral, no freebattle team%'    -- Hunter
        OR @Desc LIKE '%Robber, Neutral, no freebattle team%'    -- Thief
        ) BEGIN
    UPDATE _RowKills SET Kills = '0' WHERE KillerID = @CharID
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID AND JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024')
      BEGIN
       DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID and JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024' 
           END
              END
                 END
 --------- End of wanted system

Media Lines+Data+particles

:woot_jump::woot_jump::woot_jump::woot_jump:

Thanks You

Skype Lol.awii
copied from SKALIDOR

~~Dancer™~~ · 09/23/2014, 00:08

nice release , thanks alot

Crue* · 09/23/2014, 00:11

copied from ortai database
no thing special

VsroHost · 09/23/2014, 00:15

Quote:

Originally Posted by Dancer™

nice release , thanks alot

URW <3

LastThief* · 09/23/2014, 00:15

Quote:

Originally Posted by Crue*

copied from ortai database
no thing special

From Skalidor, not ortai. Can you even read ?

VsroHost · 09/23/2014, 00:16

Quote:

Originally Posted by LastThief*

From Skalior, not ortai. Can you even read ?

Btw i dont Write Credits But Edit From Skalior

Crue* · 09/23/2014, 00:21

Quote:

Originally Posted by LastThief*

From Skalidor, not ortai. Can you even read ?

i mean he copied the procedures and tables from ortai database.

Jon.Gamexen · 09/23/2014, 05:22

Quote:

Originally Posted by Crue*

i mean he copied the procedures and tables from ortai database.

True...
And Btw Not Full release
He Forget Fix Particles.pk2 Effect

i Saw The Wanted logo Effect Have Something Wrong

Import The File on Attachment To Particles its Should Be Fix The Effect

~~asanoftw~~ · 09/23/2014, 06:16

Quote:

Originally Posted by Crue*

copied from ortai database
no thing special

ur idiot,

SKILL_SKALIDOR_WANTED

big enough to read, mr blind?

Crue* · 09/23/2014, 10:23

Quote:

Originally Posted by asanoftw

ur idiot,

SKILL_SKALIDOR_WANTED

big enough to read, mr blind?

Quote:

Originally Posted by Crue*

i mean he copied the procedures and tables from ortai database.

if you're blind you should wear a glasses
and i don't have enough time to waste with a kid like you

Eroticus · 09/23/2014, 11:47

Quote:

Originally Posted by Crue*

if you're blind you should wear a glasses
and i don't have enough time to waste with a kid like you

Stop wasting your own time and posting stupid unhappy comments all over the forum.

VsroHost · 09/23/2014, 14:06

Quote:

Originally Posted by Eroticus

Stop wasting your own time and posting stupid unhappy comments all over the forum.

+1

BTW i Write copied from SKALIDOR

Crue* · 09/23/2014, 22:38

Quote:

Originally Posted by Eroticus

Stop wasting your own time and posting stupid unhappy comments all over the forum.

hahahaha
look who talking.

VsroHost · 09/24/2014, 00:05

Quote:

Originally Posted by Crue*

hahahaha
look who talking.

but anyway thanks for your commenting

ipause · 09/24/2014, 01:42

thnx good relese