Douglas (and Dan).
daevid.com
> -Original Message-
> From: Douglas Sims [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 02, 2006 10:42 AM
> To: Miles Thompson
> Cc: mysql@lists.mysql.com
> Subject: Re: Automatically add +1 every 30mins
>
>
> You probably don't
You probably don't want to do it with events or as a cron job. As
it sounds from your description the amount of gold is a function of
time, perhaps time since they started playing or joined the game.
Thus, instead of updating every 30 minutes, when you are selecting
the current amount o
Dan,
Did not know about events in MySQL. That's a terrific feature.
Miles
At 09:44 AM 6/2/2006, Dan Buettner wrote:
Alex, as Miles noted, this could easily be accomplished with an external
cron event. Doesn't have to be written in an external language like PHP
or perl, even - could be a se
Alex, as Miles noted, this could easily be accomplished with an external
cron event. Doesn't have to be written in an external language like PHP
or perl, even - could be a self-contained crontab entry a la:
0,30 * * * * /path/to/mysql -u user -psecret database_name -e "update
table_name set g
At 07:58 AM 6/2/2006, Alex Major wrote:
Hi there.
I've posted this up on both this list, and the php list as I'm not sure
whether this is something that I'd need to do with the php or mysql.
Basically, I am making an add-on to my small website which is a mini online
game. Every user will have g
Hi there.
I've posted this up on both this list, and the php list as I'm not sure
whether this is something that I'd need to do with the php or mysql.
Basically, I am making an add-on to my small website which is a mini online
game. Every user will have gold, and every 30mins I'd like their amoun
