How to clean inventory in a specific char?

[babayfd]

i have a bug in a char in my server
i can't login into it & also i cant see the items in CMC
if anyone one could help me with that or give me a code to clean inventory in a specific char?

[WickedNite.]

_Inventory, get char ID from _Char.

[tschulian]

PHP Code:


set YOURJID    = (SELECT UserJID FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = YOURCHARID)

/*    Clean Chest    */
    UPDATE SRO_VT_SHARD.._Chest 
        set ItemID = 0
    where UserJID = YOURJID and ItemID !=  0

/*    Clean Inven    */
    UPDATE SRO_VT_SHARD.._Inventory 
        set ItemID = 0
    where CharID = YOURCHARID and ItemID != 0 


PS: thx to epvpers converting @s to "Mentionings"

[​Exo]

^Use [NOPARSE] tag

[tschulian]

Originally Posted by ​Exo

^Use [/NOPARSE] tag

It doesnt work dude. @