query masking rewritten in more SQLs, several cleanups and fix on beg link

[mailer.git] / inc / reset / reset_daily.php

diff --git a/inc/reset/reset_daily.php b/inc/reset/reset_daily.php
index f7b54682eb839d54b290aeea159c2cfa732ef8a4..ab015cec0019a378e7d3b40aa3e77776d9a2e19c 100644 (file)
--- a/inc/reset/reset_daily.php
+++ b/inc/reset/reset_daily.php
@@ -64,7 +64,7 @@ WHERE userid=%d 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
-WHERE userid=%d AND ref_depth='%s' LIMIT 1",
+WHERE userid=%d AND ref_depth=%d LIMIT 1",
                                 array($locked, bigintval($uid), $dep), __FILE__, __LINE__);
 
                                // Update mediadata as well