14-05-2020, 04:44 AM
|
#1
|
|
|
• الانـتـسـاب » Jan 2020
|
|
• رقـم العـضـويـة » 147322
|
|
• المشـــاركـات » 45
|
|
• الـدولـة »
|
|
• الـهـوايـة »
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
Top Hunter Trader Tittle system problem
وانا بدور لقيت الـ System ده صدفة شغال تمام معايا بس مشكلته لما بلاير تااني ياخد التايتل اللي اخدها الاول بيبقا من غير تايتل
ده السيستم
كود PHP:
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
|
|
|
|