<?

//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;





?>