Making an SQL column reset every 24hrs
Posted: Wed Oct 05, 2011 7:01 pm
I'm unsure where to really start on this. In my game, the better player you buy, the more dungeon, and battles you get everyday.
So in my characters table, I give an example of a Free Player, 1 dungeon and 1 pvp battle everyday. When they go through the dungeon, it will update the column to 0 dungeons.
How would I make that reset back to 1 every 24 hours. Hope I made myself clear, if you're confused just ask
So in my characters table, I give an example of a Free Player, 1 dungeon and 1 pvp battle everyday. When they go through the dungeon, it will update the column to 0 dungeons.
How would I make that reset back to 1 every 24 hours. Hope I made myself clear, if you're confused just ask