System

Quote:

Originally Posted by nemo08 Here you are .. NOTICE : DONT TEST IT AS A GM YOU MUST BE NORMAL PLAYER First of all Create this table : PHP Code: USE [SRO_VT_SHARDLOG] GO /****** Object:  Table [dbo].[_Top100]    Script Date: 12/24/2017 12:54:52 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[_Top100](     [CharID] [int] NULL,     [Data2] [tinyint] NULL, ) ON [PRIMARY] GO CREATE TABLE [dbo].[_Top200](     [CharID] [int] NULL,     [Data2] [tinyint] NULL, ) ON [PRIMARY] GO CREATE TABLE [dbo].[_Top300](     [CharID] [int] NULL,     [Data2] [tinyint] NULL, ) ON [PRIMARY] GO CREATE TABLE [dbo].[_ToplevelsReward](     [Silk1] [smallint] NULL,     [Silk2] [smallint] NULL,     [Silk3] [smallint] NULL,     [Reward1Top100] [varchar](50) NULL,     [Reward1Count100] [smallint] NULL,     [Reward2Top100] [varchar](50) NULL,     [Reward2Count100] [smallint] NULL,     [Reward3Top100] [varchar](50) NULL,     [Reward3Count100] [smallint] NULL,     [Reward1Top200] [varchar](50) NULL,     [Reward1Count200] [smallint] NULL,     [Reward2Top200] [varchar](50) NULL,     [Reward2Count200] [smallint] NULL,     [Reward3Top200] [varchar](50) NULL,     [Reward3Count200] [smallint] NULL,     [Reward1Top300] [varchar](50) NULL,     [Reward1Count300] [smallint] NULL,     [Reward2Top300] [varchar](50) NULL,     [Reward2Count300] [smallint] NULL,     [Reward3Top300] [varchar](50) NULL,     [Reward3Count300] [smallint] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO  Then Create this procedure : PHP Code: USE [SRO_VT_SHARDLOG] GO /****** Object:  StoredProcedure [dbo].[TopLevelsReward]    Script Date: 12/24/2017 1:24:22 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[TopLevelsReward] @CharID int,  [MENTION=336745]DaTa[/MENTION]2 tinyint as ---------------////////////////************///////////////--------------------- Declare  [MENTION=890760]silk1[/MENTION]Reward smallint ,  [MENTION=292158]Silk[/MENTION]2Reward smallint ,  [MENTION=2852760]silk3[/MENTION]Reward smallint   [MENTION=1064142]reward[/MENTION]1Top100 varchar(50) [MENTION=1064142]reward[/MENTION]2Top100 varchar(50) [MENTION=1401497]reward3[/MENTION]Top100 varchar(50) [MENTION=1064142]reward[/MENTION]1Count100 smallint [MENTION=1064142]reward[/MENTION]2Count100 smallint [MENTION=1401497]reward3[/MENTION]Count100 smallint  [MENTION=1064142]reward[/MENTION]1Top200 varchar(50) [MENTION=1064142]reward[/MENTION]2Top200 varchar(50) [MENTION=1401497]reward3[/MENTION]Top200 varchar(50) [MENTION=1064142]reward[/MENTION]1Count200 smallint [MENTION=1064142]reward[/MENTION]2Count200 smallint [MENTION=1401497]reward3[/MENTION]Count200 smallint  [MENTION=1064142]reward[/MENTION]1Top300 varchar(50) [MENTION=1064142]reward[/MENTION]2Top300 varchar(50) [MENTION=1401497]reward3[/MENTION]Top300 varchar(50) [MENTION=1064142]reward[/MENTION]1Count300 smallint [MENTION=1064142]reward[/MENTION]2Count300 smallint [MENTION=1401497]reward3[/MENTION]Count300 smallint Declare [MENTION=3898309]charname[/MENTION] varchar(64) = (select CharName16 from SRO_VT_SHARD.dbo._Char Where CharID = @CharID) DECLARE  [MENTION=292919]user[/MENTION]JID varchar(10) = (SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User U WITH(NOLOCK) INNER JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCK) ON U.JID = U2.UserJID WHERE CharID = @CharID)  Declare  [MENTION=368275]top[/MENTION] smallint = (Select Count(*) From SRO_VT_SHARD.dbo._Char inner Join SRO_VT_SHARD.dbo._User on SRO_VT_SHARD.dbo._Char.CharID =  SRO_VT_SHARD.dbo._User.CharID inner join SRO_VT_ACCOUNT.dbo.TB_User on SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID Where sec_content = 3 And sec_primary = 3 )  Select  [MENTION=890760]silk1[/MENTION]Reward=Silk1  [MENTION=292158]Silk[/MENTION]2Reward=Silk2  [MENTION=2852760]silk3[/MENTION]Reward=Silk3 [MENTION=1064142]reward[/MENTION]1Top100=Reward1Top100 [MENTION=1064142]reward[/MENTION]2Top100=Reward2Top100 [MENTION=1401497]reward3[/MENTION]Top100=Reward3Top100 [MENTION=1064142]reward[/MENTION]1Top200=Reward1Top200 [MENTION=1064142]reward[/MENTION]2Top200=Reward2Top200 [MENTION=1401497]reward3[/MENTION]Top200=Reward3Top200 [MENTION=1064142]reward[/MENTION]1Top300=Reward1Top300 [MENTION=1064142]reward[/MENTION]2Top300=Reward2Top300 [MENTION=1401497]reward3[/MENTION]Top300=Reward3Top300 [MENTION=1064142]reward[/MENTION]1Count100=Reward1Count100 [MENTION=1064142]reward[/MENTION]2Count100=Reward2Count100 [MENTION=1401497]reward3[/MENTION]Count100=Reward3Count100 [MENTION=1064142]reward[/MENTION]1Count200=Reward1Count200 [MENTION=1064142]reward[/MENTION]2Count200=Reward2Count200 [MENTION=1401497]reward3[/MENTION]Count200=Reward3Count200 [MENTION=1064142]reward[/MENTION]1Count300=Reward1Count300 [MENTION=1064142]reward[/MENTION]2Count300=Reward2Count300 [MENTION=1401497]reward3[/MENTION]Count300=Reward3Count300 From SRO_VT_SHARDLOG.dbo._ToplevelsReward IF  [MENTION=368275]top[/MENTION] < 100 Begin if not exists (select CharID,Data2 From SRO_VT_SHARDLOG.dbo._Top100 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2) begin insert into SRO_VT_SHARDLOG.dbo._Top100 values (@CharID [MENTION=336745]DaTa[/MENTION]2) exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top100 [MENTION=1064142]reward[/MENTION]1Count100,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top100 [MENTION=1064142]reward[/MENTION]2Count100,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top100 [MENTION=1401497]reward3[/MENTION]Count100,1 Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own +  [MENTION=890760]silk1[/MENTION]Reward Where JID  [MENTION=292919]user[/MENTION]JID End End IF  [MENTION=368275]top[/MENTION] Between 100 and 200 Begin if not exists (select CharID,Data2 From _Top200 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2) begin insert into SRO_VT_SHARDLOG.dbo._Top200 values (@CharID [MENTION=336745]DaTa[/MENTION]2) exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top200 [MENTION=1064142]reward[/MENTION]1Count200,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top200 [MENTION=1064142]reward[/MENTION]2Count200,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top200 [MENTION=1401497]reward3[/MENTION]Count200,1 Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own +  [MENTION=292158]Silk[/MENTION]2Reward Where JID  [MENTION=292919]user[/MENTION]JID End End IF  [MENTION=368275]top[/MENTION] Between 200 and 300 Begin if not exists (select CharID,Data2 From _Top300 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2) begin insert into SRO_VT_SHARDLOG.dbo._Top300 values (@CharID [MENTION=336745]DaTa[/MENTION]2) exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top300 [MENTION=1064142]reward[/MENTION]1Count300,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top300 [MENTION=1064142]reward[/MENTION]2Count300,1 exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top300 [MENTION=1401497]reward3[/MENTION]Count300,1 Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own +  [MENTION=2852760]silk3[/MENTION]Reward Where JID  [MENTION=292919]user[/MENTION]JID End End GO  Last add this to "AddLogChar" Procedure and dont forget to change @[Only registered and activated users can see links. Click Here To Register...]2 = 110) 110 = level to what ever you want : PHP Code: --======================-- --Top Levels Reward System-- --======================-- Declare [MENTION=291440]Limit[/MENTION]Reward int , @GM tinyint Set [MENTION=291440]Limit[/MENTION]Reward = (Select Count(CharID) From SRO_VT_SHARD.dbo._Char Where CurLevel = 110 And CharID in (Select CharID From SRO_VT_SHARD.dbo._User Where UserJID in (Select JID From SRO_VT_ACCOUNT.dbo.TB_User Where sec_content = 3 And sec_primary = 3 )))  Set @GM = (Select sec_content From SRO_VT_ACCOUNT.dbo.TB_User Where JID in (Select UserJID From SRO_VT_SHARD.dbo._User Where CharID =@CharID)) IF (@EventID = 22) And  [MENTION=336745]DaTa[/MENTION]2 = 110) And  [MENTION=291440]Limit[/MENTION]Reward < 300) And (@GM =3)  begin exec [SRO_VT_SHARDLOG].[dbo].[TopLevelsReward] @CharID , [MENTION=336745]DaTa[/MENTION]2 end ----------------------------------------------------------------------------  adding Rewards : [Only registered and activated users can see links. Click Here To Register...] as you see in this picture Silk 1 = Reward silk for first 100 --> add the number of silk what ever you want .. Silk 2 = Reward silk for second 100 --> add the number of silk what ever you want .. Silk 3 = Reward silk for third 100 --> add the number of silk what ever you want .. Reward1Top100 = Reward item for first 100 --> add the 'codename128' of any item like "ITEM_ETC_....." Reward1Count100 = The Item Quantity ( how many ). Reward2Top100 = Reward item for Second 100 --> add the 'codename128' of any item like "ITEM_ETC_....." Reward2Count100 = The Item Quantity ( how many ). Reward3Top100 = Reward item for Third 100 --> add the 'codename128' of any item like "ITEM_ETC_....." Reward3Count100 = The Item Quantity ( how many ).

Quote:

Originally Posted by [GM]Dejo Thanks for your help dude

Quote:

Originally Posted by nemo08 NP mate I hope it will work well with u ^^

Quote:

Originally Posted by Skedaddle! You didn't help him, you just killed his host's CPU