Crons

[MNG]

  <?
include 'dbcon.php';
include 'classes.php';


$resultgrow = mysql_query("SELECT * FROM `growing`");
while($line = mysql_fetch_array($resultgrow, MYSQL_ASSOC)) {
$lost = floor(rand(0, $line['amount'] * 4));
if ($lost != 0){
	$newamount = $line['cropamount'] - $lost;
	Send_Event($line['userid'], $lost." of your ".$line['croptype']." plants have died. Crop ID:".$line['id']);
}

$resultgrowupdate = mysql_query("UPDATE `growing` SET `cropamount` = '".$newamount."' WHERE `id` = '".$line['id']."'");
}

//delete rows that are empty and give back land to owner
$resultgrow = mysql_query("SELECT * FROM `growing`");
while($line = mysql_fetch_array($resultgrow, MYSQL_ASSOC)) {
if ($line['cropamount'] == 0){
	Give_Land($line['cityid'], $line['userid'], $line['amount']);
	$result = mysql_query("DELETE FROM `growing` WHERE `id`='".$line['id']."'");
}
}


//$result2 = mysql_query("DELETE FROM `spylog` WHERE `age` < ".time() - 172800);// clear out old spy log stuff

$deletechat = mysql_query("DELETE FROM `message`");
//Events
	mysql_query("UPDATE events SET age=age+1");
	mysql_query("UPDATE gang_events SET age=age+1");

               mysql_query("UPDATE mail SET age=age+1");

	mysql_query("DELETE FROM gang_events WHERE age >= 3");
//END EVENTS


// Lottery Stuff
$checklotto = mysql_query("SELECT * FROM `lottery`");
$numlotto = mysql_num_rows($checklotto);
$amountlotto = $numlotto * 750;

$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `lottery` ");
$offset_row = mysql_fetch_object( $offset_result );
$offset = $offset_row->offset;
$result = mysql_query( " SELECT * FROM `lottery` LIMIT $offset, 1 " );
$worked = mysql_fetch_array($result);

$winner = $worked['userid'];

$lottery_user = new User($worked['userid']);
$newmoney = $lottery_user->money + 20000 + $amountlotto;;
Send_Event($lottery_user->id, "You won the lottery! Congratulations, you won $".$amountlotto);
$result2 = mysql_query("UPDATE `grpgusers` SET `money` = '".$newmoney."' WHERE `id` = '".$lottery_user->id."'");
$result2 = mysql_query("DELETE FROM `lottery`");
// Lottery Stuff

// Points Lottery Stuff
$checkplotto = mysql_query("SELECT * FROM `plottery`");
$numplotto = mysql_num_rows($checkplotto);
$amountplotto = $numplotto * 24;

$poffset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM `plottery` ");
$poffset_row = mysql_fetch_object( $poffset_result );
$poffset = $poffset_row->offset;
$presult = mysql_query( " SELECT * FROM `plottery` LIMIT $poffset, 1 " );
$worked = mysql_fetch_array($presult);

$pwinner = $worked['userid'];

$plottery_user = new User($worked['userid']);
$newpoints = $plottery_user->points + $amountplotto;;
$pointsss =   Points;
Send_Event($plottery_user->id, "You won the points lottery! Congratulations, you won ".$amountplotto   .$pointsss);
$result2 = mysql_query("UPDATE `grpgusers` SET `points` = '".$newpoints."' WHERE `id` = '".$plottery_user->id."'");
$result2 = mysql_query("DELETE FROM `plottery`");
// Points Lottery Stuff

$result = mysql_query("SELECT * FROM `grpgusers`");
while($line = mysql_fetch_assoc($result)) {
$updates_user = new User($line['id']);
$newmoney = $updates_user->money;
$username = $updates_user->username;
$newrmdays = $updates_user->rmdays - 1;
$newrmdays = ($newrmdays < 0) ? 0 : $newrmdays;
if($newrmdays > 1) {
	$interest = .03;
} else {
	$interest = .01;
}
$newbank = ceil($updates_user->bank + ($updates_user->bank * $interest));

       if($newrmdays > 1) {
	$interest = .0001;
} else {
	$interest = .00001;
}
$newbank2 = ceil($updates_user->bank2 + ($updates_user->bank2 * $interest));

if($updates_user->job != 0){
	$result_job = mysql_query("SELECT * FROM `jobs` WHERE `id`='".$updates_user->job."'");
	$worked_job = mysql_fetch_array($result_job);
	$newmoney = $updates_user->money + $worked_job['money'];
	$newwexp33 = $updates_user->workexp +$worked_job['workexp'];
               $newwstr = $worked_job['strengthgain'];
               $newwdef = $worked_job['defensegain'];
               $newwspd = $worked_job['speedgain'];
               $result5846 = mysql_query("UPDATE `grpgusers` SET `workexp` = '".$newwexp33."',`money` = '".$newmoney."', `strength` = strength +'".$newwstr."', `defense` = defense +'".$newwdef."', `speed` = speed +'".$newwspd."' WHERE `id`='".$updates_user->id."'");
	Send_Event($updates_user->id, "You earned $".$worked_job['money']." and ".$worked_job['workexp']." exp from your job. You now have $".$newmoney);
}                    	 
if($updates_user->gangjobs != 0){
$result_job = mysql_query("SELECT * FROM `gangjobs` WHERE `id`='".$updates_user->gangjobs."'");
$worked_job = mysql_fetch_array($result_job);
$newmoney21 = $worked_job['money'];
$result141 = mysql_query("UPDATE `gangs` SET `vault` = vault +'".$newmoney21."' WHERE `id`='".$updates_user->gang."'");
Send_Event($updates_user->id, "<font color = 'yellow'>You earned </font><font color = '#ffffff'>$".$worked_job['money']."</font> <font color = 'yellow'>from your gangjob. You now have </font> $".$newmoney);
}
// hooker stuff
if($updates_user->hookers > 0){
$newbank = $newbank + (500 * $updates_user->hookers);
$newhookers = ceil($updates_user->hookers - 0);

	Send_Event($updates_user->id, "You earned $".($updates_user->hookers * 500)." from your Drug Dealers. You now have $".$newbank);
}
//hooker stuff
// hooker stuff
if($updates_user->hoes > 0){
$newbank = $newbank + (100 * $updates_user->hoes);
$newhoes = ceil($updates_user->hoes );

	Send_Event($updates_user->id, "You earned $".($updates_user->hoes * 100)." from your Hookers. You now have $".$newbank);
}
//hooker stuff


}
$result2 = mysql_query("UPDATE `grpgusers` SET `workexp` = '".$newwexp."',`bank` = '".$newbank."',`bank2` = '".$newbank2."',`money` = '".$newmoney."', `hoes` = '0',`hookers` = '".$newhookers."', `rmdays` = '".$newrmdays."', `bank` = '".$newbank."', `searchdowntown` = '100', `csmuggling` = '10', `luckyrm` = '1', `lucky` = '1', `freefill` = '1',`boxes_opened` = '0', `slapping` = '0', `votemtl` = '0', `votegtop` = '0', `gymss` = '3',`gyms` = '1',`gs100` = '0', `m100` = '0',`bogd` = '0',`apex` = '0',`g200` = '0', `crack` = '0',`lastchase` = '0'");


mysql_query("UPDATE grpgusers SET userBANKDAYS = userBANKDAYS - 1 WHERE userBANKDAYS > 0") or mysql_error();
mysql_query("DELETE FROM `rates`") or mysql_error();

mysql_query("UPDATE mailbans SET days = days - 1 WHERE days > 0") or mysql_error();
mysql_query("DELETE FROM `mailbans` WHERE days < 1") or mysql_error();

mysql_query("UPDATE bans SET days = days - 1 WHERE days > 0") or mysql_error();
mysql_query("DELETE FROM `bans` WHERE days < 1") or mysql_error();



?>

 

Everyday a user bank reset to 0, not sure whats the problem in this.

[MNG]

Fixed, I just recreated the cron and checked everything manually.