[Release]Grant Title after killing a unique

[Tyr*]

some of my friends asked me for this system so i decided to create and release it ^^ i didn't test it but iam sure it's 99% working.
explaining : when you kill a unique , example : tiger girl you will get rewarded with a title name, when another one kills it your title will get removed and that one will get your title.

Add this to _AddLogChar at Log DB.

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

i hope that this one becomes helpful

don't blame me for my english because it isn't my main language

[Storxy_]

create what lol its already released alot of times,
you can create at trigger in sr_zor table and its will be simple and more easier than this
about the trigger you can got it from Rebecca road database.

[Crue*]

 Spoiler

PHP Code:

update SRO_VT_SHARD.dbo._Char set hwanlevel = 'tiger girl slayer title number' where charname16 = @Charname 


looool

[bestprem]

Originally Posted by Crue*

 Spoiler

PHP Code:

update SRO_VT_SHARD.dbo._Char set hwanlevel = 'tiger girl slayer title number' where charname16 = @Charname 


looool

set HwanLevel = 'Deek om el hwan level #Mortada mansour'