Re: [mccode v2] Stock Market. Working + Secured
I had trouble with the last part of the crons also.
my solution which was probaby not the best, but does work, was to change this:
$sel = mysql_query("SELECT stockID,stockNAME FROM `stock_stocks` WHERE `stockNPRICE` < 0");
while($soc = mysql_fetch_assoc($sel)) {
if(mysql_num_rows(mysql_query("SELECT holdingID FROM `stock_holdings` WHERE `holdingSTOCK` = ".$soc['stockID']))) {
$user = mysql_query("SELECT holdingUSER FROM `stock_holdings` WHERE `holdingSTOCK` = ".$soc['stockID']);
$user = mysql_fetch_assoc($user);
event_add($user['holdingUSER'], 'Stock '.$soc['stockNAME'].' crashed, you lost all your shares.');
}
mysql_query("DELETE FROM `stock_holdings` WHERE `holdingSTOCK` = ".$soc['stockID']);
mysql_query("UPDATE `stock_stocks` SET `stockUD` = 1,`stockCHANGE` = 0,`stockNPRICE` = `stockOPRICE` WHERE `stockID` = ".$soc['stockID']);
}
to this.
$sel = mysql_query("SELECT * FROM `stock_stocks` WHERE `stockNPRICE` < 0",$c);
while($soc = mysql_fetch_array($sel)) {
$user = mysql_query("SELECT * FROM `stock_holdings` WHERE `holdingSTOCK` = ".$soc['stockID'],$c);
$users = mysql_fetch_array($user);
$stuseris=$users['holdingUSER'];
event_add($stuseris, "Stock {$soc['stockNAME']} crashed, you lost all your shares.",$c);
mysql_query("DELETE FROM `stock_holdings` WHERE `holdingSTOCK` = ".$soc['stockID'],$c);
mysql_query("UPDATE `stock_stocks` SET `stockUD` = 1,`stockCHANGE` = 0,`stockNPRICE` = `stockOPRICE` WHERE `stockID` = ".$soc['stockID'],$c);
}
Thanks to haunted dawg for the mod, I have been having some fun with it.