[JocAnis]

hi guys. i would like to make a plugin which will have two type of working:

1) like mainly, when player got saved in db, his stats will stay forever (so i will choose mysql)
2) but for this, i need player's info to be updated every 24h, can you suggest my saving method for this? more precisely, delete his stats after 24h of inserting

Worth mentioning is i would use .php with POST to show stats on motd, so with 1) mysql is better, but for two, what will be the logic of deleting mysql record/row with task of 24hours? maybe adding mysql column of date when it should be deleted, so check it on player connect? (about cron job bad idea probably)

I though also about nvault system for 2), with prune row after 24h but if something better is there pls tell inform me

Thanks in advance!

[redivcram]

Should be in Suggestions/Requests.

[JocAnis]

Okay my bad, if any admin can move it i would appreciate it

[redivcram]

Admins are less active than usual and we hope that they return enough to at least pass on the torch to someone who's more active. You can post this again in the section.

[JocAnis]

For the time you wrote these two replies you could do more something consturctive, for example give suggestion what should i use in 2) situation

[redivcram]

For the time it took for you to write the previous post, you could have posted in the right section.

[Bugsy]

Save each record with a unix timestamp

On plugin load/map change.. with %d being get_systime() in your plugin.

DELETE FROM db WHERE ((%d - TimeStampInDBRecord) >= 86400);

[JocAnis]

Yes, thats what i needed. big thatnks @Bugsy !