Wanted Hero Mode System !!

**CandyQ** · 22-09-14

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

Hero Mode Wanted By Candy1337.rar

http://www.virustotal.com/en/file/bf...is/1411485598/

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

Thanks You ;)
Skype Lol.awii

**MentaL**

**BadFist** · 23-09-14

tx for release here is link from virustotal (some ppl will troll with this) https://www.virustotal.com/en/file/b...is/1411485598/

**CandyQ** · 23-09-14

<3..................

- - - Updated - - -

okay Mate

**Jangan** · 23-09-14

CandyQ

For next time, please upload a virus scan when posting files <3

Thank you for your hard work.

~ Jangan

**CandyQ** · 24-09-14

Originally Posted by Jangan

CandyQ

For next time, please upload a virus scan when posting files <3

Thank you for your hard work.

~ Jangan

Done <3

**DarSage** · 24-09-14

Need Help to install pliss

- - - Updated - - -

who Help me

**CandyQ** · 24-09-14

Originally Posted by DarSage

Need Help to install pliss

- - - Updated - - -

who Help me

okay wait ...

**RenePunik** · 24-09-14

Useless system.

**CandyQ** · 24-09-14

Originally Posted by RenePunik

Useless system.

Thanks for your comment

**DarSage** · 25-09-14

them'm honest I'm a little rough with this part of Add_Charlog that more should I add and where in the DB

**Blackdiana** · 27-09-14

Add_Charlog have in shardlog db, and progammability, and stored procedures

**a22345875** · 28-09-14

want 34243-34247 _RefSkill

**Mitaka Filipov** · 05-10-14

i can't create the procudure

Code:

Msg 102, Level 15, State 1, Procedure _Wanted, Line 12
Incorrect syntax near '('.
Msg 139, Level 15, State 1, Procedure _Wanted, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 14
Must declare the scalar variable "@K_Name".
Msg 137, Level 15, State 2, Procedure _Wanted, Line 15
Must declare the scalar variable "@K_Name".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 17
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 17
Must declare the scalar variable "@K_Name".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 20
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 20
Must declare the scalar variable "@K_CharID".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 21
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 22
Must declare the scalar variable "@PKill".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 24
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure _Wanted, Line 37
Incorrect syntax near '@CharID'.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 38
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Procedure _Wanted, Line 44
Must declare the scalar variable "@CharName".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 48
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure _Wanted, Line 52
Incorrect syntax near '@CharID'.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 58
Must declare the scalar variable "@CharName".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 62
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure _Wanted, Line 66
Incorrect syntax near '@CharID'.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 72
Must declare the scalar variable "@CharName".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 76
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure _Wanted, Line 80
Incorrect syntax near '@CharID'.
Msg 137, Level 15, State 2, Procedure _Wanted, Line 86
Must declare the scalar variable "@CharName".
Msg 102, Level 15, State 1, Procedure _Wanted, Line 91
Incorrect syntax near '@CharID'.
Msg 102, Level 15, State 1, Procedure _Wanted, Line 95
Incorrect syntax near '@CharID'.

**ilowe** · 30-11-14

link ?

**Coolza** · 02-12-14

Re upload

Wanted Hero Mode System !!

Thread Tools

Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Re: Wanted Hero Mode System !!

Advertisement