<?

//Updates

$updates_sql = mysql_query("SELECT * FROM `updates` WHERE `name` = 'trevor'");

while ($line = mysql_fetch_array($updates_sql, MYSQL_ASSOC))
    $update = $line['lastdone'];

$timesinceupdate = time() - $update;

if ($timesinceupdate>=300)
{
    $num_updates = floor($timesinceupdate / 300);

    //stock market stuff
    $result = mysql_query("SELECT * FROM `stocks`");
    while($line = mysql_fetch_assoc($result))
    {
        $amount = rand (strlen($line['cost']) * -1, strlen($line['cost']));
        $newamount = $line['cost'] + $amount;
        if ($newamount < 1)
            $newamount = 1;
        $result2 = mysql_query("UPDATE `stocks` SET `cost`='".$newamount."' WHERE `id`='".$line['id']."'");
    }
    //stock market stuff
    $result = mysql_query("SELECT * FROM `grpgusers`");
    while($line = mysql_fetch_assoc($result))
    {
        $updates_user = new User($line['id']);
        if ($updates_user->rmdays > 0)
            $multiplier = 2;
         else
            $multiplier = 1;
        $username = $updates_user->username;
        $newawake = $updates_user->awake + (50 * $num_updates) * $multiplier;
        $newawake = ($newawake > $updates_user->maxawake) ? $updates_user->maxawake : $newawake;
        $newhp = $updates_user->hp + $updates_user->maxhp/5 * $multiplier;
        $newhp = ($newhp > $updates_user->maxhp) ? $updates_user->maxhp : $newhp;
        $newenergy = $updates_user->energy + $updates_user->maxenergy/5 * $multiplier;
        $newenergy = ($newenergy > $updates_user->maxenergy) ? $updates_user->maxenergy : $newenergy;
        $newnerve = $updates_user->nerve + $updates_user->maxnerve/5 * $multiplier;
        $newnerve = ($newnerve > $updates_user->maxnerve) ? $updates_user->maxnerve : $newnerve;
        $result2 = mysql_query("UPDATE `grpgusers` SET `awake` = '".$newawake."', `energy` = '".$newenergy."', `nerve` = '".$newnerve."', `hp` = '".$newhp."' WHERE `username` = '".$username."'");
    }
    //update the timer and db
    $thetime = time();
    $result2 = mysql_query("UPDATE `updates` SET `lastdone` = '".$thetime."' WHERE `name` = 'trevor'");
    $leftovertime = $timesinceupdate - (floor($timesinceupdate / 300) * 300);
    if ($leftovertime>0)
    {
        $newupdate =  time() - $leftovertime;
        $setleftovertime = mysql_query("UPDATE `updates` SET `lastdone` = '".$newupdate."' WHERE `name` = 'trevor'");
    }
}
mysql_query("UPDATE effects SET timeleft=timeleft-1 WHERE timeleft>0");
mysql_query("UPDATE grpgusers SET bguard=bguard-1 WHERE bguard>0");
mysql_query("UPDATE smartads SET timeleft=timeleft-60 WHERE timeleft>0");
mysql_query("UPDATE gangs SET crimetimeleft=crimetimeleft-60 WHERE crimetimeleft>0");
$result2 = mysql_query("DELETE FROM `effects` WHERE `timeleft` < 1");

//update the timer and db
$thetime = time();
$result2 = mysql_query("UPDATE `updates` SET `lastdone` = '".$thetime."' WHERE `name` = 'hospital'");
$leftovertime = $timesinceupdate - (floor($timesinceupdate / 60) * 60);
    if ($leftovertime>0)
        $newupdate =  time() - $leftovertime;

?>