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 @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 :
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 ).
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 @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 :
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 ).
110 Cap D11 Pve new Uninques new System / new Job System / Free Silk / Easy System 05/26/2013 - SRO PServer Advertising - 19 Replies AT the Frist i will give Info about the game
Server will start lv 1
Max Lv 110
Free Silk 500K
New System for Job
Egy A CaN Get From FGW So Easy :)
Egy B Can Get From Uniques FGW
Set Egy A Distraction With Coin
Set Egy B Immortality With Coin