]> git.mxchange.org Git - mailer.git/blobdiff - inc/reset/reset_daily.php
Fixes for ref-level 0
[mailer.git] / inc / reset / reset_daily.php
index 250730be760b6b571b5ab45adb40cc0bc42c40f9..c763c0ecc5176e2e73d5777cfa65fd6841cc43ae 100644 (file)
@@ -63,7 +63,7 @@ WHERE userid=%s AND locked_points != 0.00000 ORDER BY ref_depth",
                        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
                        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
-WHERE userid=%s AND ref_depth=%s LIMIT 1",
+WHERE userid=%s AND ref_depth=%d LIMIT 1",
                                 array($locked, bigintval($uid), $dep), __FILE__, __LINE__);
 
                                // Update mediadata as well
                                 array($locked, bigintval($uid), $dep), __FILE__, __LINE__);
 
                                // Update mediadata as well