Variables not resetting unless log off

[ToiletMaster]

Hi everyone,

 

i seem to be having an issue, as we store permanent character variables in char_reg_num, i have a script that deletes this on a timed basis.

 

	query_sql( "DELETE FROM `char_reg_num` WHERE `key`='variable' " );

However, the problem i find out is that the variables only saves once the person logs out, thus if the person interacts with the NPC and for example gets an additional ranking, it'll be the old value + new value together.

 

For example

Value before Scripts deletes the variables

• Variable = 100

 

If the person interacts with the NPC and let's say the variable adds 10 without logging off,

• Variable = 110

If the person interacts with the NPC and let's say the variable adds 10 after logging off

• Variable = 10

 

Is there any way to force it to clear the values? This is because i'm using a SQL based ranking for this and players are able to add that variable by themselves. Similar to Rachel's donation quest to open the gateway but instead with a ranking.

 

 

[nitrous]

You can use addrid https://github.com/rathena/rathena/blob/master/doc/script_commands.txt#L3824-L3844

It will look something like this:

	addrid(0);
	variable = 0;
	detachrid();
	query_sql( "DELETE FROM `char_reg_num` WHERE `key`='variable' " );

 

[ToiletMaster]

Thanks a lot @Nitrous ,

 

I've tested this and it works perfectly!