SQL query to detect character is wearing job (trader, thief) ?

07/02/2012 10:17 TheShinichi#1

Hi all,

I hope some guy can help me a SQL query to detect character is wearing job (trader, thief) ?

Thanks !

07/02/2012 13:13 magicanoo#2

There is a possible solution.
First,you need to find the slot ID in inventory that holds the job suit,
then use this query

PHP Code:


			
declare @charname varchar (60)
set @charname='charnamehere'

select CodeName128 from _RefObjCommon 
where ID=(select RefItemID from _Items 
where ID64=(select ItemID from _Inventory 
where Slot='itemslothere' and CharID=(select charid from _char where 
CharName16=@charname)))

Find the slot ID and put it in the 'itemslothere'