1. Reklam


    1. joysro
      ledas
      jungler
      keasro
      zeus
      karantina

VSRO WANTED SYSTEM


  1. AmIMad

    AmIMad Bakalım be. moderator rank8

    Kayıt:
    7 Şubat 2015
    Mesajlar:
    373
    Beğenilen Mesajlar:
    33
    Ödül Puanları:
    28
    Meslek:
    Mermerci :)
    Şehir:
    Ankara
    Merhaba Arkadaşlar Bazı Serverlerde Görmüş Oldugunuz Wanted System Dosya Ve Girişlerini Vericegim
    RefSkill
    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
    1042 SKILL_SKALIDOR_WANTED_S

    Arkadaşlar Quary Okutucaksınız Sro_vt_log Dosyasınına
    Acmak İçin Olan Quary Procedure

    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
    Crate Table Yeni Table İçin Quary Sro_vt_log Gene

    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 -> Sag Tıklayın _AddLogChar Basın 'Modify') Konuda Anlatıdıgım Yerer Gelip Yapıştıracasınız Arkadaşlar

    --- 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

    Arkadaşlar Media Girişlerini Dikkatlı Bir Şekilde Yapın Yoksa Hata Cıkabilir


    Türkiye Piyasasında ilk Paylaşım :)


    İndirmek İçin Tıklayın http://www.mediafire.com/download/8q5tts79xm4j17t/wanted+Hero+System+Arkadaşlar.rar