// Update user profiles
if (isExtensionInstalledAndNewer('order', '0.1.1')) {
// Latest version
- SQL_QUERY('UPDATE
+ sqlQuery('UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
`receive_mails`=`max_mails`,
' . runFilterChain('user_exclusion_sql', ' ') . '', __FILE__, __LINE__);
} else {
// Obsolete version
- SQL_QUERY('UPDATE
+ sqlQuery('UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
`receive_mails`=`max_mails`
}
// Transfer points from locked_points to points
-$result_daily = SQL_QUERY("SELECT
+$result_daily = sqlQuery("SELECT
`userid`
FROM
`{?_MYSQL_PREFIX?}_user_data`
`userid` ASC", __FILE__, __LINE__);
//* DEBUG: */ debugOutput(basename(__FILE__) . ':payout=0;daily|numRows=' . SQL_NUMROWS($result_daily));
-if (!SQL_HASZERONUMS($result_daily)) {
+if (!ifSqlHasZeroNums($result_daily)) {
// Init SQLs
initSqls();
// Run through all 'locked_(foo)_points columsn
foreach (runFilterChain('locked_points_columns_array', array('points')) as $columnName) {
// Start checking accounts which are on 0 confirmed-to-go mails
- while ($content = SQL_FETCHARRAY($result_daily)) {
+ while ($content = sqlFetchArray($result_daily)) {
//* DEBUG: */ debugOutput(basename(__FILE__) . ':' . $content['userid']);
- $result_points = SQL_QUERY_ESC("SELECT
+ $result_points = sqlQueryEscaped("SELECT
`ref_depth`,
`locked_%s`
FROM
), __FILE__, __LINE__);
//* DEBUG: */ debugOutput(basename(__FILE__) . ':payout=0;points|numRows=' . SQL_NUMROWS($result_points));
- if (!SQL_HASZERONUMS($result_points)) {
+ if (!ifSqlHasZeroNums($result_points)) {
// Ok transfer points
- while ($content2 = SQL_FETCHARRAY($result_points)) {
+ while ($content2 = sqlFetchArray($result_points)) {
// Merge both arrays
$content = merge_array($content, $content2);
//* DEBUG: */ debugOutput(basename(__FILE__) . ':userid=' . $content['userid'].',depth='.$content['ref_depth'].',columnName=' . $columnName . ',locked='.$content['locked_' . $columnName]);
if ($content['ref_depth'] > 0) {
// Level 1+
- addSql(SQL_QUERY_ESC("UPDATE
+ addSql(sqlQueryEscaped("UPDATE
`{?_MYSQL_PREFIX?}_user_points`
SET
`%s`=`%s`+%s,
);
} else {
// Level zero
- addSql(SQL_QUERY_ESC("UPDATE
+ addSql(sqlQueryEscaped("UPDATE
`{?_MYSQL_PREFIX?}_user_points`
SET
`%s`=`%s`+%s,
} // END - if
// Free memory
- SQL_FREERESULT($result_points);
+ sqlFreeResult($result_points);
} // END - while
} // END - foreach
} // END - if
// Free memory
-SQL_FREERESULT($result_daily);
+sqlFreeResult($result_daily);
// Debug line
//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.');