www is out-dated

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

diff --git a/inc/daily/daily_user.php b/inc/daily/daily_user.php
index 99211777ba14add8af3f1fc25f1e283d42320cee..f7b9085e2a566b3e3e03955e9a9a0bf0b5923ab5 100644 (file)
--- a/inc/daily/daily_user.php
+++ b/inc/daily/daily_user.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -108,7 +108,9 @@ 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,
@@ -117,11 +119,29 @@ WHERE
        `userid`=%s AND
        `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')) {