[SOLVED] How to do a cron?

[marklarah]

Hi, you've all just seen my login script, but how do i set a cron in cPanel so that it checks every 10 minutes for an inactive user and resets their active bool? It updates the last active time each time a page loads with this:

 

$id = $_SESSION['userID'];

$lin = "UPDATE users SET llin = NOW() WHERE ID = '$id' ";
mysql_query($lin) or die('Error, query failed now');

 

I have a bool field called active where 0 would be inactive. How would I do this?

[marklarah]

just do a normal php file?

[marklarah]

<?php
include 'dbs.php';
include 'bar.php';
$cnow = date("H:i:s") - date("H:10:s");
$lin = "UPDATE users SET active = '0' WHERE llin > NOW($cnow)";
mysql_query($lin) or die('Error, query failed now');
?>

 

Doesn't show any errors, but it doesn't work either.

[marklarah]

...help?

[Fyorl]

Just put the path to the PHP script that you want to be run every 10 minutes into the cron manager in CPanel.

[marklarah]

i have but it don't work

[marklarah]

i get:

 

/home2/tlscom/public_html/check.php: line 1: ?php: No such file or directory

/home2/tlscom/public_html/check.php: line 2: include: command not found

/home2/tlscom/public_html/check.php: line 3: include: command not found

/home2/tlscom/public_html/check.php: line 4: syntax error near unexpected token `('

/home2/tlscom/public_html/check.php: line 4: `// $cnow = date("H:i:s") - date("H:10:s");'

 

Thats from the output (from teh email)

[marklarah]

it looks like it doesn't recognize the language as php. Is php okay? Also what should the normal permissions be for cron, so I can do i manually? at the mo it is 777, it was 644 before.

[Fyorl]

Try putting '#!/usr/bin/php' right at the top of the file, before the '<?php'

[marklarah]

Haaaa thankyou! Ill let you know in 10 mins if the script works. But what would be the best permissions for it? So i can run from the browser manually, and so the cron can do it too?

[Fyorl]

Erm well you should only need read and execute permissions for the owner if your server's setup properly. If it's not then you might need to add execute permissions for group and/or others too. That's something only your hosts can dictate though.

 

r-xr--r-- = 544

r-xr-xr-x = 555

rwxr--r-- = 744 (probably what it should be ideally as presumably you still want to be able to write to it)