[Mohamed_Candy]

This'll grant the best hunter/trader/thief a title based on 'Level, Contribution, Exp'
Else you will be able to edit or add rewards ( coins , silk or anything )
here we go

Run a query and Execute this:

CREATE TABLE _Top3J ( Trader int, Thief int, Hunter int, Count int );

_AddLogChar -> (SRO_VT_LOG -> Programmability -> Stored Procedures -> Right click on _AddLogChar and press on 'Modify')

IF @eventID = 9 BEGIN declare @CidTrader int, @CidThief int, @CidHunter int, @TTrader int, @THunter int, @tthief int; SELECT TOP 1 @CidTrader = CharID from SRO_VT_SHARD.._CharTrijob WHERE JobType = 1 Order By Exp,Contribution,Level DESC SELECT TOP 1 @CidThief = CharID from SRO_VT_SHARD.._CharTrijob WHERE JobType = 2 Order By Exp,Contribution,Level DESC SELECT TOP 1 @CidHunter = CharID from SRO_VT_SHARD.._CharTrijob WHERE JobType = 3 Order By Exp,Contribution,Level DESC -- ######################################### -- Replace '1, 2, 3' with the title's hwanlevel, Name explanation. 'T' means title, 'Hunter' means hunter? lol you got it now. -- ######################################### SET @THunter = 1 SET @TTrader = 2 SET @tthief = 3 -- ######################################### -- removing the titles -- ######################################### UPDATE SRO_VT_SHARD.._Char set HwanLevel = 0 WHERE HwanLevel in (@THunter, @TTrader, @tthief) -- ######################################### UPDATE SRO_VT_SHARD.._Char set HwanLevel = @TTrader WHERE CharID = @CidTrader UPDATE SRO_VT_SHARD.._Char set HwanLevel = @tthief WHERE CharID = @CidThief UPDATE SRO_VT_SHARD.._Char set HwanLevel = @THunter WHERE CharID = @CidHunter -- ###################################################################### -- Some log shit, I haven't really tested it as I no longer own a server. -- ###################################################################### IF NOT EXISTS (SELECT * FROM _Top3J where Trader = @CidTrader AND Thief = @CidThief AND Hunter = @CidHunter AND Count > 0) BEGIN INSERT INTO _Top3J SELECT @CidTrader, @CidThief, @CidHunter, 1 END ELSE BEGIN UPDATE _Top3J SET Count += 1 END END

And press 'Execute'. There you're.


Thank you!