Mohamed_Candy
12-09-2014, 03:17 PM
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!
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!