[SnapDragon]

I have being thinking about making Daily reward plugin, but i dont know how to make this daily reseting trigger at MySQL, so i dumped that project, now im asking if someone knows how to do it, or have something like it allready done.

[friagram]

Use a timestamp?

[nosoop]

Add a column last_day_claimed.

When the reward is claimed, set the account's last reward claim day to TO_DAYS(NOW());, then you can check that the daily reward for the day hasn't been claimed by selecting from the table WHERE last_day_claimed >= TO_DAYS(NOW()); (you'll get zero rows if the reward hasn't been claimed).

Daily rollover dependent on your MySQL instance, I think.

For SQLite, I think you can use cast(julianday('now') as int) instead.

[OSWO]

Do not use NOW().

Use: https://sm.alliedmods.net/new-api/sourcemod/GetTime

Save into the table and whenever the client rejoins, GetTime and then check their last unixtime stamp.

A simple if statement; if (CurrentTime > OldTime + 86400)

86400 = 1 Day.

[nosoop]

Originally Posted by OSWO Use: https://sm.alliedmods.net/new-api/sourcemod/GetTime A simple if statement; if (CurrentTime > OldTime + 86400) 86400 = 1 Day.

Your suggestion applies a 24-hour cooldown on claims. Not a system that resets each day.

Which seems the same, except that if a player plays in the evening and then plays in the morning the next day, they still have to wait for the evening until they can claim the next reward. Not to mention claims will end up happening later and later.

I was also going to suggest GetTime() / 86400 to get the number of days and store that, but taking leap seconds and whatnot into account means the "day" may not reset at a predictable time.

FormatTime(buffer, sizeof(buffer), "%Y%m%d") would work with string equality tests.