how to reset , only hair , hairstyle , cloth color in phpmyadmin

[blacklistro]

how to reset , only hair , hairstyle , cloth color  in phpmyadmin??

update char set hair = '0'
update char set hair_color = '0'
update char set clothes_color = '0'


like this ?

 

[ocelote]

but add - where char_id = '"+getcharid(0)+"'

[blacklistro]

but add - where char_id = '"+getcharid(0)+"'

if i want all ID/ Char in my SQL database.

[ocelote]

 

but add - where char_id = '"+getcharid(0)+"'

if i want all ID/ Char in my SQL database.

 

where hair > '0' and etc

[EL Dragon]

here

UPDATE `char` SET hair = 0, hair_color = 0, clothes_color = 0;

[Elsa Mist]

how to reset , only hair , hairstyle , cloth color  in phpmyadmin??

update char set hair = '0'

update char set hair_color = '0'

update char set clothes_color = '0'

like this ?

 

 

If you want to reset all dye in php you will need to reset at the guild table too.

update `char` set hair =1, hair_color =1, clothes_color=1;
update `guild_member` set hair =1, hair_color =1, 

just paste query the code on your php. 

Edited May 9, 2015 by Elsa Mist