Top Hunter,Trader and thief Give him Title

[xEslamHamed]

Hello

I used This System And It works well but the problem is

IF Player (B) Take A Tittle From Player (A) Will Be With out Tittle
so I wanna Edit this System To
IF Player (B) Take Tittle From Player (A)
Player (A) Take Old Tittle
How To Make It ?
Sorry My Is Sh1t iknow

PHP Code:

    IF  [MENTION=2220328]Eventi[/MENTION]D = 9 or  [MENTION=2220328]Eventi[/MENTION]D = 11
BEGIN
declare  [MENTION=347097]cid[/MENTION]Trader int,  [MENTION=347097]cid[/MENTION]Thief int,  [MENTION=347097]cid[/MENTION]Hunter int,
  [MENTION=7236507]Ttrader[/MENTION] int,
  [MENTION=1936848]Thunter[/MENTION] int,  [MENTION=6017099]tth[/MENTION]ief int;
SET  [MENTION=347097]cid[/MENTION]Trader = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 1 Order By Level DESC)
SET  [MENTION=347097]cid[/MENTION]Thief = (Select Top 1 (CharID) From SRO_VT_SHARD.._CharTrijob WHERE JobType = 2 Order By Level DESC)
SET  [MENTION=347097]cid[/MENTION]Hunter = (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  [MENTION=1936848]Thunter[/MENTION] = 1
SET  [MENTION=7236507]Ttrader[/MENTION] = 2
SET  [MENTION=6017099]tth[/MENTION]ief = 3
-- #########################################
-- removing the titles
UPDATE SRO_VT_SHARD.._Char set HwanLevel = 0
WHERE HwanLevel in   [MENTION=1936848]Thunter[/MENTION],  [MENTION=7236507]Ttrader[/MENTION],  [MENTION=6017099]tth[/MENTION]ief)
-- #########################################

-- #########################################
UPDATE SRO_VT_SHARD.._Char set HwanLevel =  [MENTION=7236507]Ttrader[/MENTION] WHERE CharID =  [MENTION=347097]cid[/MENTION]Trader
UPDATE SRO_VT_SHARD.._Char set HwanLevel =  [MENTION=6017099]tth[/MENTION]ief WHERE CharID =  [MENTION=347097]cid[/MENTION]Thief
UPDATE SRO_VT_SHARD.._Char set HwanLevel =  [MENTION=1936848]Thunter[/MENTION] WHERE CharID =  [MENTION=347097]cid[/MENTION]Hunter
-- ######################################################################
-- Some log shit, I haven't really tested it as I no longer own a server.
-- ######################################################################
IF NOT EXISTS (SELECT * FROM _Top3J where Trader =  [MENTION=347097]cid[/MENTION]Trader AND Thief =  [MENTION=347097]cid[/MENTION]Thief AND Hunter =  [MENTION=347097]cid[/MENTION]Hunter AND Count > 0)
BEGIN
INSERT INTO _Top3J
SELECT  [MENTION=347097]cid[/MENTION]Trader,  [MENTION=347097]cid[/MENTION]Thief,  [MENTION=347097]cid[/MENTION]Hunter, 1
END
ELSE
BEGIN
UPDATE _Top3J
SET Count += 1
END


END 


I hope Some Help Some
Thanks

[VORTEX*]

you will need to create a table to record the old title number also edit the procedure
to check the table .. sample to edit

[xEslamHamed]

Originally Posted by Zerox*

you will need to create a table to record the old title number also edit the procedure
to check the table .. sample to edit

I am still learning I do not have enough experience to do what you say

[Laag#82]

Hello,


Create:

PHP Code:

ALTER TABLE dbo._Char ADD HwanLevelOld int NOT NULL DEFAULT 0; 


Add:

-- #########################################
-- removing the titles
-- #########################################
UPDATE SRO_VT_SHARD.._Char set HwanLevel = (select HwanLevelOld from SRO_VT_SHARD.._Char where HwanLevel = @THunter)
WHERE HwanLevel = @THunter
UPDATE SRO_VT_SHARD.._Char set HwanLevel = (select HwanLevelOld from SRO_VT_SHARD.._Char where HwanLevel = @TTrader)
WHERE HwanLevel = @TTrader
UPDATE SRO_VT_SHARD.._Char set HwanLevel = (select HwanLevelOld from SRO_VT_SHARD.._Char where HwanLevel = @TThief)
WHERE HwanLevel = @TThief
-- #########################################
-- add the titles old
-- #########################################
UPDATE SRO_VT_SHARD.._Char set HwanLevelOld = (select HwanLevel from SRO_VT_SHARD.._Char where CharID = @CIDTrader)
WHERE HwanLevel = @THunter
UPDATE SRO_VT_SHARD.._Char set HwanLevelOld = (select HwanLevel from SRO_VT_SHARD.._Char where CharID = @CIDThief)
WHERE HwanLevel = @TTrader
UPDATE SRO_VT_SHARD.._Char set HwanLevelOld = (select HwanLevel from SRO_VT_SHARD.._Char where CharID = @CIDHunter)
WHERE HwanLevel = @TThief
-- #########################################

[xEslamHamed]

Originally Posted by khaleed2010

Hello,


Create:

PHP Code:

ALTER TABLE dbo._Char ADD HwanLevelOld int NOT NULL DEFAULT 0; 


Add:

Well, I will try