Date: 11/03/05 (PHP Community)    Keywords: php, mysql, sql

Hello! I am making an online MMORPG using PHP and MySQL. I have two questions.

First off, how would I make a turn system? As in, for example, I can have up to 100 turns at a time. When I use a turn, stuff happens; I get one turn every 10 seconds or so.

For example...
I have 100 turns.
I use 5. (The stuff the turns do happens.)
I now have 95 turns.
20 seconds pass.
I now have 97 turns.
40 seconds pass.
I now have 100 turns. (Not 101, because 100 is max.)

How could I do something like that using PHP and MySQL?

Secondly, is there a way using PHP (or MySQL) to automatically empty out a certain table at a certain time, even if a page isn't accessed? Like an auto-refresh if you will. I'm thinking that would be on the server, not in a particular script however...because scripts are only run when they're opened.

*Shrugs*

Insight would be helpful. Thank you!

Source: http://www.livejournal.com/community/php/363690.html