Need PHP help

[Scarum]

I've been fiddling with programming for a long time. Now I think I'm ready to put everything I know into practice. Basically, I've designed a chunk of the first test of my new game (What I call the 'Alpha Core'), including the installation, the connecting script to the database, the incomplete index page,two shops, and a place where you can kill the monsters. But, this being a turn-based game, I've encountered my first of two problems. Crons. I would like someone to please post a reply containing a cron that runs these lines every day around midnight:

$getturns="Update user index set turns=turns+50";
$getturns2=mysql_query($getturns) or die("Could not get turns")

Oh, and I also have another problem. The inventory. Could someone please post an example of an inventory script as well, please? I realise I'll probably have to change the installation file to do that, and if so, could whoever posts the inventory script also post the changes that need to be made to other files, please?
Thanks,

Scarum.

[albinomonkey]

Ok as for your update at midnight script, basically you'll just add a table to your database for timed scripts. You'll first need a field for the time when to run EX: midnight, then you'll need a date last updated (which will be reupdated everynight at midnight). Basically all you do is place this code in your index page, when the first user stumbles across your site after midnight it will update, so... You determine wether the script has been run after midnight when a user accesses. You must take the current date and current time in PHP then use your database to compare to it your fields for the time to update, the last date updated. Now you must see wether your current date is 1 day greater than your last updated date (stored in the database), and you may need to know wether the time is after your update time (midnight).