Reset Account Variables

[Nokia]

hello. i wanna reset account variables automatically, without clicking an npc or some else.

so well, i want an reset every day at 14:00 PM.. would be nice if the player dosent have to be online.

i guess the onhour event wont work for this, right? because the variables wont reset if the player is not online? so are there another ways to delete variables?

[tr0n]

you could delete them directly from the sql table.

[Nokia]

uhm, are they located in global_reg_value? i think i will just fail to find them and make a script for this, but i will it try some things now.

so yeah i found them i global_reg.. is there any example script to query sql them?

Edited May 4, 2012 by Nokia

[Elliott]

uhm, are they located in global_reg_value? i think i will just fail to find them and make a script for this, but i will it try some things now.

Yes. You could use the OnHour trigger but you can't reference any player. You'd have to make iterations starting from the first accountID (the last column in global_reg_value) and either use the DELETE or SET commands in an sql query (depending on what your definition of 'reset' is).

Note that no On[whatever] scripts actually have to be attached to a RID to execute themselves unless they do RID specific things.

Edited May 4, 2012 by Elliott

[deathscythe13]

how about this

query_sql "DELETE FROM `global_reg_value` WHERE str LIKE '%#%'";

[Nokia]

Thanks, finally got it working:

query_sql "DELETE FROM `rathena`.`global_reg_value` WHERE `str`='#test'";