Using time with php and mysql

[Baseball435]

hey everyone, well i wanted to make a game that uses time like for example every 24 hours if this person owns a store, they get paid 125 gold. How would you implement this? thanks guys!

~baseball435

[SpiritWebb]

Moved to the correct area.

[PaxBritannia]

Use a cron or alternative to run a script that checks for whoever owns a store every 24 hours and give them the gold.

pax.

[Callan S.]

Yeah, I'd store time() in some part of the database and then whenever a player logs in, it checks if a day or more has passed since the last storage of time(). If so count the number of days that have passed and go through the database with a while statement, adding gold to those with stores.

Or use a cron. I'm not familiar with them so I dunno.

[Jackolantern]

If you are actually looking for the ways to actually evaluate and deal with time calculations, I suggest to read this page of the PHP manual. It is mildly helpful, but there are a lot of good comments down the page. The very first comment has a working script for doing calculations to compare the current time with an existing timestamp.