Cronjob problem...

[Mr Sweg]

/usr/www/mdg/public/donations/cronjob.php: line 1: ?php: No such file or directory
/usr/www/mdg/public/donations/cronjob.php: line 2: syntax error near unexpected token `"connectionfile.php"'
/usr/www/mdg/public/donations/cronjob.php: line 2: `include("connectionfile.php");'

cronjob.php:

Code: Select all

<?php
include("connectionfile.php");
include("config.php");

$auth = $_GET['p'];
if($auth == "test"){
	$q = $dbc->prepare("SELECT * FROM users WHERE used = ? AND expiration != ?");
	$query = $q->execute(array(
		1,
		0
	));
	$arr = $q->fetchAll();

	foreach($arr as $row){
		$newExp = $row['expiration'] - 1;
		$qT = $dbc->prepare("UPDATE users SET expiration = ?");
		$queryT = $qT->execute(array(
			$newExp
		));

		if($queryT){
			echo "The user with the SteamID of ".$row['steamid']." has expired another day<br>";
		}
	}
}else{
	echo "Authorization failed!";
}
?>

[Edge100x]

It appears that whatever is trying to run this script is not executing it correctly with the PHP interpreter executable. Make sure that it is set up to use /usr/bin/php.

[Mr Sweg]

Made it to:

Code: Select all

* * * * * /usr/bin/php ~/public/donations/cronjob.php

and now I get this...
Authorization failed!

[Spray]

The "Authorization failed!" error is because you're hitting this section of code:

Code: Select all

else{
   echo "Authorization failed!";
}

Looking over your code, in order to have the first if...else statement evaluate to true, the following must be set:

Code: Select all

$auth == "test"

You're populating your $auth variable via the superglobal array $_GET, which looks for variables passed to the current script via the URL parameters.

When running this script using the PHP interpreter on the command line, you are unable to pass query strings like you normally would through a webserver. If you're only going to use this as a cron script I would consider using the following to populate this variable:

Code: Select all

$opts = getopt('f:');

$auth = $opts['f'];

You could then run the script like this:

Code: Select all

/usr/bin/php /path/to/my/script.php -f test

[Mr Sweg]

I love how stupid I am at times ;-;

NVM, didn't read your post fully >_>
Thanks!