function UpdateBonds(){
$sql_rand = mysql_query("SELECT rand FROM ref_bonds_rand WHERE date = '".date("Y-m-d")."' AND id = '1'");
if (mysql_num_rows($sql_rand)) {
$rand = mysql_result($sql_rand,0,0);
$dohrand = $rand / 100;
}else{
$dohodMin = 10; //мин. доход в копейках
$dohodMax = 100; //макс. доход в копейках
$rand = rand($dohodMin, $dohodMax);
$dohrand = $rand / 100;
$sql_rand1 = "UPDATE ref_bonds_rand SET rand = ".$rand.", date = '".date("Y-m-d")."' WHERE id = '1'";
$sql_Krupder = mysql_query("SELECT id FROM ref_users ORDER BY bonds DESC LIMIT 1");
$Krupder = mysql_result($sql_Krupder,0,0);
$sql_rand2 = "UPDATE ref_users SET balance_vivod = balance_vivod + ".(100 * $dohrand)." WHERE id='".$Krupder."'";
$sql_rand3 = "INSERT INTO ref_bonds_stat (userid,dohod,date, comment) VALUES('".$userid."','".$dohrand."','".date("Y-m-d")."','Вы получили облигации $dohrand доход Пользователь $userid')";
mysql_query("START TRANSACTION");
if (mysql_query($sql_rand1) and mysql_query($sql_rand2) and mysql_query($sql_rand3)) {
mysql_query("COMMIT");
}else{
mysql_query("ROLLBACK");
}
}
if($dohrand > 0) {
$sql = mysql_query("SELECT * FROM ref_bonds WHERE date != '".date("Y-m-d")."' LIMIT 1");
if (mysql_num_rows($sql)) {
while ($row = mysql_fetch_assoc($sql)) {
if($row["maxdohod"] > $row["dohod"]){
$sql_update1 = "UPDATE ref_bonds SET dohod = dohod + ".($row["kol"] * $dohrand).", date = '".date("Y-m-d")."' WHERE id='".$row["id"]."'";
$sql_update2 = "UPDATE ref_users SET balance_vivod = balance_vivod + ".($row["kol"] * $dohrand)." WHERE id='".$row["userid"]."'";
mysql_query("START TRANSACTION");
if (mysql_query($sql_update1) and mysql_query($sql_update2)) {
mysql_query("COMMIT");
}else{
mysql_query("ROLLBACK");
}
}else{
$sql_update1 = "UPDATE ref_users SET bonds = bonds - ".$row["kol"]." WHERE id='".$row["userid"]."'";
$sql_update2 = "UPDATE ref_bonds_conf SET vsego = vsego + ".$row["kol"]." WHERE id='1'";
$sql_update3 = "DELETE FROM ref_bonds WHERE id='".$row["id"]."'";
mysql_query("START TRANSACTION");
if (mysql_query($sql_update1) and mysql_query($sql_update2) and mysql_query($sql_update3)) {
mysql_query("COMMIT");
}else{
mysql_query("ROLLBACK");
}
}
}
}
}
}
UpdateBonds();