• [Ravin Online] Cap 100 - D10 - CH & EU - Grand Opening 20-8-2019
  • XEON Online | 130 Cap - CH * EU - 1500+ Online Player!
    1. #1
      Spare - ait Kullanıcı Resmi (Avatar)
      Üyelik Tarihi 
      05 Kasım 2011
      Şehir 
      İstanbul
      Konular 
      3
      Mesajlar 
      5
      Beğenme 
      0
      Beğenilme 
      0
      Rep Gücü 
      Sosyal Ağ
       




      Merhabalar değerli joymax.org, takipçileri,

      Sizlere bu rehberde Wanted Hero Sistemini anlatmaya çalışacağım.


      Wanted Prosedürü;

      Kod:
      USE [SRO_VT_LOG]
      GO
      /****** Object:  StoredProcedure [dbo].[_Wanted]    Script Date: 08/04/2014 16:15:04 ******/
      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 <= '2' and   @maxK <= '50' ) 
         BEGIN
      INSERT INTO _RowKills (KillerID , KilledID , Kills) VALUES (@CharID , @K_CharID,'1')
                 END    
      ----- End inserting           
                 
                   
      declare   @NiceName varchar (52) = (select NickName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
      
      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 = '35140' or CharID = @CharID and JobID between '35141' and '35144')
               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 , 35140 , 7200000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 )
       INSERT INTO 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 '35141' and '35144')
      BEGIN 
      INSERT INTO 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 = '35140')
      BEGIN
      DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID = '35140'    
      INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 35141 , 7200000 , 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 = '35140')
      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 , 35141 , 7200000 , 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 '35142' and '35144')
      BEGIN 
      INSERT INTO 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 = '35141' or CharID = @CharID and JobID = '35140')
      BEGIN
      DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID = '35141' or CharID = @CharID and JobID = '35140'    
      INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 35142 , 7200000 , 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 = '35141' or CharID = @CharID and JobID = '35140')
      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 , 35142 , 7200000 , 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 '35143' and '35144')
      BEGIN 
      INSERT INTO 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 = '35142' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141')
      BEGIN
      DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID = '35142' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141'    
      INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 35143 , 7200000 , 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 = '35142' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141')
      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 , 35143 , 7200000 , 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 = '35144')
      BEGIN 
      INSERT INTO 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 = '35143' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141' or CharID = @CharID and JobID = '35143')
      BEGIN
      DELETE FROM SRO_VT_SHARD.dbo._TimedJob where CharID = @CharID  and JobID = '35143' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141' or CharID = @CharID and JobID = '35143'    
      INSERT INTO SRO_VT_SHARD.dbo._TimedJob (CharID ,Category , JobID , TimeToKeep , Data1 , Data2 , Data3 , Data4 , Data5 , Data6, Data7 , Data8 , Serial64 , JID ) VALUES (@CharID , 0 , 35144 , 7200000 , 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 = '35143' or CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID = '35141' or CharID = @CharID and JobID = '35143')
      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 , 35144 , 7200000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 72339069015696862 , 0 ) 
                END
                   END                                
      print 'joymax.org için kullanıma sunulmuştur. (Spare)'
      RowKills_ Prosedürü;

      Kod:
      USE [SRO_VT_LOG]
      GO
      
      /****** Object:  Table [dbo].[_RowKills]    Script Date: 09/05/2014 00:25:08 ******/
      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
      print 'joymax.org için kullanıma sunulmuştur. (Spare)'
      AddLogChar; (AS'dan sonra eklemelisiniz.)

      Kod:
      --- Wanted System        
      if @EventID = '19'   -- Count kills
          BEGIN
      if (@strPos like '%(0x63ec)%')
           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 >= 115
             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 = '35140' or CharID = @CharID and JobID between '35141' and '35144')
           BEGIN
            DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID and JobID = '35140' or CharID = @CharID and JobID between '35141' and '35144' 
                END
                   END
                      END
      --------- End of wanted system  
      ------------------------------------------------------------------
      
      print 'joymax.org için kullanıma sunulmuştur. (Spare)'


      Geri kalan herşey rar dosyamızın içinde; Tıklayınız.
      Rar Şifresi:
        Spoiler 


      Kimsin sen? Şüphesiz sen, sen değilsin!


    2. #2
      Spare - ait Kullanıcı Resmi (Avatar)
      Üyelik Tarihi 
      05 Kasım 2011
      Şehir 
      İstanbul
      Konular 
      3
      Mesajlar 
      5
      Beğenme 
      0
      Beğenilme 
      0
      Rep Gücü 
      Sosyal Ağ
       
      Rar şifresi eklenmiştir.


      Kimsin sen? Şüphesiz sen, sen değilsin!

    Konu Bilgileri

    Bu Konuya Gözatan Kullanıcılar

    Şu anda 1 kullanıcı bu konuyu görüntülüyor. (0 kayıtlı ve 1 misafir)

    Benzer Konular

    1. 100 Cap Csilkroad 100 Cap EU/CH Emek Server Job System Drop System Hero Wanted 01.11.2018
      Konu Sahibi Constantine Forum Silkroad Private Server Tanıtımları
      Cevap: 0
      Son Mesaj : 17 Ekim 2018, 11:39
    2. 110 Cap ALFA SRO 110 CAP İSRO SYSTEM/WANTED SYSTEM/COİN SYSTEM/FREE SİLK
      Konu Sahibi Alfa77 Forum Silkroad Private Server Tanıtımları
      Cevap: 0
      Son Mesaj : 14 Eylül 2018, 15:28
    3. 80 Cap Caps Online 80 Cap / Job Based | Wanted System/ Free Silk / Drop Sistem/18.05.2018
      Konu Sahibi ghosthunter35 Forum Silkroad Private Server Tanıtımları
      Cevap: 1
      Son Mesaj : 17 Haziran 2018, 12:39
    4. 90 Cap Destiny Online |90Cap CH |Hard System| Wanted System|Job System|QuestSystem|Free Silk
      Konu Sahibi realitysro35 Forum Silkroad Private Server Tanıtımları
      Cevap: 8
      Son Mesaj : 04 Haziran 2017, 17:41

    Bu Konu için Etiketler



    Giriş

    Giriş