Probeer dit eens:
PHP
<?php
include 'connect.php';
require_once("functions.php");
$player = $_SESSION['player'];
$userstats = "SELECT
*
FROM
km_users
WHERE
playername = '".$player."'";
$userstats2 = mysql_query($userstats) or die ("Could not get user stats");
$userstats3 = mysql_fetch_array($userstats2);
$addenergy = $userstats3['energycron'] * 10;
if($userstats3['energycron'] > 0)
{
if($userstats3['energycron'] > 10)
{
mysql_query("UPDATE
km_users
SET
energycron='10'
WHERE
ID = '".$userstats3['ID']."'") or die ("cron failed");
}
if($userstats3['numturns'] > 100)
{
mysql_query("UPDATE
km_users
SET
numturns='100',
energycron='0'
WHERE
ID = '".$userstats3['ID']."'") or die("energy failed");
}
else
{
mysql_query("UPDATE
km_users
SET
numturns=numturns+'".$addenergy."',
energycron='0'
WHERE
ID = '".$userstats3['ID']."'") or die("energy failed");
}
}
?>Je gebruikte 2x $player = $_SESSION['player'];.
Query's waren niet netjes of je gebruikte meerdere query's, waarbij 1 voldoende was.
