™Dev Microsoft™
23-11-2014, 06:14 AM
http://im26.gulfup.com/2012-07-04/1341434007131.png
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
الموضوع ده ناس كتير الفترة اللي فاتت سألت عليه
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
كل اللي هاتعملو هاتضيف دي في الـ_AddLogChar
Declare @CharName varchar (64)
---------------Change srzor to ur gameserver name.. you should be using a gameserver that records the unique kills at a specific table
SET @Charname = (Select charname from SRO_VT_ACCOUNT.dbo.srzor_uniques where mobname = 'MOB_CH_TIGERWOMAN')
update SRO_VT_SHARD.dbo._Char set hwanlevel = '0' where hwanlevel like 'tiger girl slayer title number' ------ this part is to remove title from the old unique killer .
delete from SRO_VT_ACCOUNT.dbo.SrZor_Uniques where charname = @Charname ----------- don't remove this because if you removed it the charname will not be removed from srzor_uniques and he will keep getting the title name
update SRO_VT_SHARD.dbo._Char set hwanlevel = 'tiger girl slayer title number' where charname16 = @Charname --------giving title to the unique killer
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
الموضوع ده ناس كتير الفترة اللي فاتت سألت عليه
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
كل اللي هاتعملو هاتضيف دي في الـ_AddLogChar
Declare @CharName varchar (64)
---------------Change srzor to ur gameserver name.. you should be using a gameserver that records the unique kills at a specific table
SET @Charname = (Select charname from SRO_VT_ACCOUNT.dbo.srzor_uniques where mobname = 'MOB_CH_TIGERWOMAN')
update SRO_VT_SHARD.dbo._Char set hwanlevel = '0' where hwanlevel like 'tiger girl slayer title number' ------ this part is to remove title from the old unique killer .
delete from SRO_VT_ACCOUNT.dbo.SrZor_Uniques where charname = @Charname ----------- don't remove this because if you removed it the charname will not be removed from srzor_uniques and he will keep getting the title name
update SRO_VT_SHARD.dbo._Char set hwanlevel = 'tiger girl slayer title number' where charname16 = @Charname --------giving title to the unique killer
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png