Fix for previous commit

[mailer.git] / inc / daily / daily_user.php

diff --git a/inc/daily/daily_user.php b/inc/daily/daily_user.php
index 72bb2cf596f830eb98397d89cbf422b0c287578b..775274518ede5022169a468beff175f85a9bdfed 100644 (file)
--- a/inc/daily/daily_user.php
+++ b/inc/daily/daily_user.php
@@ -95,7 +95,7 @@ FROM
        `{?_MYSQL_PREFIX?}_user_points`
 WHERE
        `userid`=%s AND
-       `locked_points` != 0.00000
+       `locked_points` > 0.00000
 ORDER BY
        `ref_depth` ASC",
                        array(bigintval($content['userid'])), __FILE__, __LINE__);
@@ -108,20 +108,40 @@ ORDER BY
                                $content = merge_array($content, $content2);
 
                                //* DEBUG: */ debugOutput(basename(__FILE__) . ':userid=' . $content['userid'].',depth='.$content['ref_depth'].',locked='.$content['locked_points']);
-                               addSql(SQL_QUERY_ESC("UPDATE
+                               if ($content['ref_depth'] > 0) {
+                                       // Level 1+
+                                       addSql(SQL_QUERY_ESC("UPDATE
        `{?_MYSQL_PREFIX?}_user_points`
 SET
        `points`=`points`+%s,
        `locked_points`=0.00000
 WHERE
        `userid`=%s AND
-       `ref_depth`=%d
+       `ref_depth`=%s
 LIMIT 1",
-                                       array(
-                                               $content['locked_points'],
-                                               bigintval($content['userid']),
-                                               $content['ref_depth']
-                                       ), __FILE__, __LINE__, false));
+                                               array(
+                                                       $content['locked_points'],
+                                                       bigintval($content['userid']),
+                                                       $content['ref_depth']
+                                               ), __FILE__, __LINE__, false)
+                                       );
+                               } else {
+                                       // Level zero
+                                       addSql(SQL_QUERY_ESC("UPDATE
+       `{?_MYSQL_PREFIX?}_user_points`
+SET
+       `points`=`points`+%s,
+       `locked_points`=0.00000
+WHERE
+       `userid`=%s AND
+       `ref_depth` IS NULL
+LIMIT 1",
+                                               array(
+                                                       $content['locked_points'],
+                                                       bigintval($content['userid'])
+                                               ), __FILE__, __LINE__, false)
+                                       );
+                               }
 
                                // Update mediadata as well
                                if (isExtensionInstalledAndNewer('mediadata', '0.0.4')) {