Delete users inventory

03/09/2012 00:39 Serenduk#1

another admin added items to my invent on smc showed up once in char 3 times so i'd crash im not able to delete via smc, changed name and got into char sold the items but unable to do any edits via smc as just get db query failed

the sql command used was
exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = '[GM]bleh'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_13_C_RARE',1,200

03/09/2012 11:45 InPanic Kev#2

drg13 sun +200 sword ? :awesome:

what u need ?

a query to delete ur inventar ?

Code:

SELECT IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF
Right Join _Items As IT On IT.RefItemID = REF.ID
Right Join _Inventory As INV On INV.ItemID = IT.ID64
Right Join _Char as CH On CH.CharID = INV.CharID
Where CodeName128 like '%13_C_RARE'

than delete