* -------------------------------------------------------------------- *
* 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 *
} elseif ((!isHtmlOutputMode()) || (!isResetModeEnabled())) {
// Do not execute when script is in CSS mode or no daily reset
return;
-} elseif (!isExtensionActive('sql_patches')) {
- logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension disabled.');
+} elseif ((!isExtensionActive('sql_patches')) || (!isExtensionActive('user'))) {
+ logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension(s) disabled.');
return;
}
`{?_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__);
$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')) {