Reseting character's whole look

[xmaniacx]

what's the correct way to reset a whole style of character.

this is what i did but im getting sql error.

query_sql "UPDATE `char` SET `hair` , `hair_color` , `clothes_color` = '0' , '0' , '0' WHERE `name` = '"+getcharid

(3)+"'";

atcommand "@kick "+strcharinfo(0);

end;

[Euphy]

If you're running the script on the attached character, you can just do it using script commands, no need for SQL/relog:

setlook 7,0;
setlook 1,0;
setlook 6,0;

You only need an SQL query to modify values for offline characters (in which case @kick would still not be needed xP).

[xmaniacx]

thank you euphy.