mysql script/command needed.

[vijay]

Hello everyone!
I really need a command that unequips head,mid & top gears from all the char's in the server.
And also hairstyle,haircolor & dye.

I need this coz players in my server keeps crashing soon after the ID PW login.

~Thanks.

 

[Emistry]

-- Remove char custom sprite displayUPDATE	`char` SET	`hair_color` = '0',	`clothes_color` = '0',	`head_top` = '0',	`head_mid` = '0',	`head_bottom` = '0',	`robe` = '0'

-- Unequip all equipments.UPDATE	`inventory` SET	`equip` = '0'

 

[vijay]

Thanks a lot emistry!