#KAFRAPOINTS #CASHPOINTS where this is being stored?

[laonglaing]

hello!
Im pretty new in making script, and i have this idea wherein players will have a certain points daily and will be reset the value if not used or anything was left and im thinking to use either #KAFRAPOINTS or #CASHPOINTS. I just wanted to ask where are these values being stored? in the database which table?
how can i implement this in a script? 

[Emistry]

acc_reg_num

its stored in this table.

however to reset it, its a bit tricky

• if there are no player online, you can safely execute the sql script to remove it from database
• if there are player currently online, you have to manually select each user to reset their points (of course this can be done is numerous ways)
  then run SQL script to remove points from those who aren't online.

 

[laonglaing]

40 minutes ago, Emistry said:

acc_reg_num

its stored in this table.

however to reset it, its a bit tricky

• if there are no player online, you can safely execute the sql script to remove it from database
• if there are player currently online, you have to manually select each user to reset their points (of course this can be done is numerous ways)
  then run SQL script to remove points from those who aren't online.

 

thanks for this. so its imposible to reset ingame. i see. so what about limit the usage of kafrapoints for a day. example. you have given 1000 kafrapoints for the week. and you only want the players to use upto 100 points per day. is it possible?
if its imposible to reset the kafra points of players while they are online, im thinking now to reset it every weekly maintenance. 

 

also, if i want to define custom points, is this the only where i define them and does it automatically usable ingame?
or should define it in other part of the emulator?

pc.hpp

[laonglaing]

okay i was able to implement the daily kafrapoints and reset it @12mn server time.  can i dm you for some other question? @Emistry