[SOLVED] help with crons!

[uwannadonkey]

im using a free host, and i need a cron for my website

 

lets say i wanna add 5 energy, every 10 minutes, right

 

how would i do it?

 

in my php, i would have

<?php

db_connect

 

then like mysql_query(update `users` SET energy= energy + (5);

?>

 

would that work? and what should i write in my crontab?

[btherl]

Here are some examples:

 

http://en.wikipedia.org/wiki/Crontab#Examples

 

In your case, something like:

 

0,10,20,30,40,50 * * * * /home/users/uwannadonkey/add_energy.php

 

That will run at 0, 10,20,30,40 and 50 minutes past each hour, every hour

[uwannadonkey]

thanks for that post!

 

what should i write in the php? any examples would be nice!

 

i think curl isnt allowed by my free host

[btherl]

No curl should be fine.  You can connect to the database directly from the php script called from cron.  Much like the example in your original post.

 

I can't give you a detailed example as I'm not too sure about your database setup.  But it really is as simple as your example there.  Just connect to the database and do the update.

[uwannadonkey]

still not solved.!

 

all i have for crons is this:

<?php
$dbh=mysql_connect ("localhost", "donkey9_Admin", "xxx) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("donkey9_Game");

$sql2="UPDATE `users` SET energy=energy+10 WHERE energy < '$max_energy'";

if(mysql_query($sql2))
{
echo $sql2;
}

?>

as my cron.php and my command line is wget http://donkeygame.1gig.biz/cron.php

 

thats all i got, i know im doing something wrong, cuz if i  go to my cron.php page, i dont gain any energy, so i doubt if cron runs it, ill get any?

 

in ANY case, my crons arent working, i mean, im not getting any emails, and its been like 10 minutes

[rlindauer]

You are missing a closing quote there:

<?php
$dbh=mysql_connect ("localhost", "donkey9_Admin", "xxx)
?>

 

[uwannadonkey]

why would i close it? theres php script right after?

[trq]

Your missing the closing quote. Look...

 

<?php
$dbh=mysql_connect ("localhost", "donkey9_Admin", "xxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("donkey9_Game");

$sql2="UPDATE `users` SET energy=energy+10 WHERE energy < '$max_energy'";

if(mysql_query($sql2))
{
echo $sql2;
}

?>

[uwannadonkey]

ohhh psssht! thats right, my badddd

 

umm that works now   what about the command line? i have a free host, so i ono if wget or curl works?

[trq]

To run a cron every ten minutes via wget, you would use...

 

*/10 * * * * /usr/bin/wget http://donkeygame.1gig.biz/cron.php

[rlindauer]

why would i close it? theres php script right after?

Because it is a syntax error.