]> git.mxchange.org Git - mailer.git/commitdiff
Doubler and jackpot fixes
authorRoland Häder <roland@mxchange.org>
Thu, 7 Feb 2008 21:58:43 +0000 (21:58 +0000)
committerRoland Häder <roland@mxchange.org>
Thu, 7 Feb 2008 21:58:43 +0000 (21:58 +0000)
inc/doubler_send.php
inc/monthly/monthly_beg.php
inc/mysql-manager.php
inc/reset/reset_beg.php
inc/reset/reset_daily.php

index c3ccc8dcf3c07df1a54d5371544a8e251acc7c93..c10ece39d9376b992c9fc1ce4163c676fafc303c 100644 (file)
@@ -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;
index 6576bd8819961e4cf22367bad47343d5aaf64392..c944d040425933ba4b24c50725fa21d4d96aef2b 100644 (file)
@@ -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__);
        }
 
index 593e21e0295076ec8c555f1c7b1a459850dfe5fe..76fba5d9f7fc89853f481afec2f3dd37c31f4dbf 100644 (file)
@@ -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;
                }
        }
index 830398a1682620e84bccc998bb3666ec58910600..062b602a5d7ce7975e2095be7129f2617b89b4f0 100644 (file)
@@ -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__);
 
 //
index 53a30fc828dee3c66d50770a437b44a61e54b6a0..f7b54682eb839d54b290aeea159c2cfa732ef8a4 100644 (file)
@@ -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__);