BlackClover
14-05-2020, 04:44 AM
وانا بدور لقيت الـ System ده صدفة شغال تمام معايا بس مشكلته لما بلاير تااني ياخد التايتل اللي اخدها الاول بيبقا من غير تايتل
ده السيستم
IF @eventID = 9 or @EventID = 11
BEGIN
declare @CidTrader int, @CidThief int, @CidHunter int,
@TTrader int,
@THunter int, @tthief int;
SET @CidTrader = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 1 Order By Level DESC)
SET @CidThief = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 2 Order By Level DESC)
SET @CidHunter = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 3 Order By 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
ف لو حد عنده خلفيه اخليه يرجع بالتايتل اللي كان معاه قبل ما ياخد التايتل trade
ده السيستم
IF @eventID = 9 or @EventID = 11
BEGIN
declare @CidTrader int, @CidThief int, @CidHunter int,
@TTrader int,
@THunter int, @tthief int;
SET @CidTrader = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 1 Order By Level DESC)
SET @CidThief = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 2 Order By Level DESC)
SET @CidHunter = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 3 Order By 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
ف لو حد عنده خلفيه اخليه يرجع بالتايتل اللي كان معاه قبل ما ياخد التايتل trade