From e0408cc79990e2a8d2b2a2476a3f2be346df48cd Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Thu, 7 Feb 2008 21:58:43 +0000 Subject: [PATCH] Doubler and jackpot fixes --- inc/doubler_send.php | 5 ++--- inc/monthly/monthly_beg.php | 2 +- inc/mysql-manager.php | 5 +++-- inc/reset/reset_beg.php | 2 +- inc/reset/reset_daily.php | 4 ++-- 5 files changed, 9 insertions(+), 9 deletions(-) diff --git a/inc/doubler_send.php b/inc/doubler_send.php index c3ccc8dcf3..c10ece39d9 100644 --- a/inc/doubler_send.php +++ b/inc/doubler_send.php @@ -132,9 +132,8 @@ if (((SQL_NUMROWS($result_total) > 0) && ($CONFIG['doubler_sent_all'] == 'Y')) | if (($jackpot > 0) && ($jackpot >= $points) && ($CONFIG['doubler_jackpot'] == 'Y')) { // Subtract points from jackpot - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_jackpot SET points=points-%s WHERE ok='ok' LIMIT 1", - array($points), __FILE__, __LINE__); - $jackpot -= $jackpot; + SUB_JACKPOT($points); + $jackpot -= $points; // Okay, done! $OK = true; diff --git a/inc/monthly/monthly_beg.php b/inc/monthly/monthly_beg.php index 6576bd8819..c944d04042 100644 --- a/inc/monthly/monthly_beg.php +++ b/inc/monthly/monthly_beg.php @@ -107,7 +107,7 @@ SET points=points+%s WHERE ref_depth='0' AND userid=%d LIMIT 1", if ($curr == "00") $curr = "12"; // Reset accounts - $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points='0.00000' WHERE beg_points > 0", + $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__); } diff --git a/inc/mysql-manager.php b/inc/mysql-manager.php index 593e21e029..76fba5d9f7 100644 --- a/inc/mysql-manager.php +++ b/inc/mysql-manager.php @@ -1564,7 +1564,7 @@ function SUB_JACKPOT($points) if (SQL_NUMROWS($result) == 0) { // Create line - $result = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok', '0.00000')", __FILE__, __LINE__); + $result = SQL_QUERY("INSERT INTO "._MYSQL_PREFIX."_jackpot (ok, points) VALUES ('ok', 0.00000)", __FILE__, __LINE__); } else { @@ -1576,7 +1576,8 @@ function SUB_JACKPOT($points) if ($jackpot >= $points) { // Update points when there are enougth points in jackpot - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_jackpot SET points=points-%s WHERE ok='ok' LIMIT 1", array($points), __FILE__, __LINE__); + $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_jackpot SET points=points-%s WHERE ok='ok' LIMIT 1", + array($points), __FILE__, __LINE__); $ret = $jackpot - $points; } } diff --git a/inc/reset/reset_beg.php b/inc/reset/reset_beg.php index 830398a168..062b602a5d 100644 --- a/inc/reset/reset_beg.php +++ b/inc/reset/reset_beg.php @@ -47,7 +47,7 @@ if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) if (($CSS == 1) || (!defined('__DAILY_RESET'))) return; // Reset accounts -$result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points='0.00000' WHERE beg_points > 0", +$result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_data SET beg_points=0.00000 WHERE beg_points > 0", __FILE__, __LINE__); // diff --git a/inc/reset/reset_daily.php b/inc/reset/reset_daily.php index 53a30fc828..f7b54682eb 100644 --- a/inc/reset/reset_daily.php +++ b/inc/reset/reset_daily.php @@ -56,14 +56,14 @@ if (SQL_NUMROWS($result_daily) > 0) while (list($uid) = SQL_FETCHROW($result_daily)) { $result_points = SQL_QUERY_ESC("SELECT ref_depth, locked_points FROM "._MYSQL_PREFIX."_user_points -WHERE userid=%d AND locked_points != '0.00000' ORDER BY ref_depth", +WHERE userid=%d AND locked_points != 0.00000 ORDER BY ref_depth", array(bigintval($uid)), __FILE__, __LINE__); if (SQL_NUMROWS($result_points) > 0) { // Ok transfer points while (list($dep, $locked) = SQL_FETCHROW($result_points)) { - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s, locked_points='0.00000' + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s, locked_points=0.00000 WHERE userid=%d AND ref_depth='%s' LIMIT 1", array($locked, bigintval($uid), $dep), __FILE__, __LINE__); -- 2.30.2