How to clean inventory in a specific char?

05/14/2016 00:44 babayfd#1

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?

05/14/2016 01:44 WickedNite.#2

_Inventory, get char ID from _Char.

05/20/2016 09:27 tschulian#3

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 @[Only registered and activated users can see links. Click Here To Register...]s to "Mentionings"

05/20/2016 11:08 Exo#4

^Use [NOPARSE] tag

05/20/2016 11:29 tschulian#5

Quote:

Originally Posted by Exo

^Use [/NOPARSE] tag

It doesnt work dude. @[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]