[SQL] Reset Status

[Vietlubu]

prontera,156,176,4 Script Text 100,{
mes "Reset?";
next;
menu "Yes.", yes, "No.", no;
yes:
mes "Reset.";
Set .@stat,query_sql("update `char` set `str` = 1, `agi` = 1, `vit` = 1, `int` = 1, `dex` = 1, `luk` = 1 where `name` = '" + strcharinfo(0) + "'");
close;
no:
mes "Bye";
close;

}

When select "Yes" . database is change.But where logout and login again database rollback

[Emistry]

why not just use this ?

*resetstatus;

This is a character reset command, which will reset the stats on the invoking
character and give back all the stat points used to raise them previously.
Nothing will happen to any other numbers about the character.
Used in reset NPC's (duh!)

for your case...you should kick the character out ...so that the data wont "rollback" after updated it.

[Vietlubu]

thanks

how to kick a character

[Emistry]

atcommand "@kick "+strcharinfo(0);