* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
* For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// Init userid exclusion
$excludeSql = '';
$excludedUserids = runFilterChain('config_userid_exclusion_sql', array());
- if (count($excludedUserids) > 0) {
+ if (isFilledArray($excludedUserids)) {
// Exclude all
$excludeSql = ' AND `userid` NOT IN (' . implode(', ', $excludedUserids) . ')';
} // END - if
} // END - if
// Check for all accounts
- $result_inactive = SQL_QUERY("SELECT
+ $result_inactive = sqlQuery("SELECT
`userid`,
`email`,
`last_online`
`status`='CONFIRMED' AND
(UNIX_TIMESTAMP() - `joined`) >= {?ap_inactive_since?} AND
(UNIX_TIMESTAMP() - `last_online`) >= {?ap_inactive_since?} AND
- (UNIX_TIMESTAMP() - `ap_notified`) >= {?ap_inactive_since?} AND
+ (UNIX_TIMESTAMP() - `ap_notified`) >= {?ap_inactive_since?}
" . runFilterChain('user_exclusion_sql', $excludeSql) . "
ORDER BY
`userid` ASC", __FILE__, __LINE__);
- if (!SQL_HASZERONUMS($result_inactive)) {
+ if (!ifSqlHasZeroNums($result_inactive)) {
// Prepare variables and constants...
$userids = array();
$content['since'] = (getApInactiveSince() / 60 / 60);
$content['time'] = (getApInactiveTime() / 60 / 60);
// Mark found accounts as inactive and send an email
- while ($row = SQL_FETCHARRAY($result_inactive)) {
+ while ($row = sqlFetchArray($result_inactive)) {
// Merge both arrays
$content = merge_array($content, $row);
sendEmail($content['userid'], '{--MEMBER_AUTOPURGE_INACTIVE_SUBJECT--}', $message);
// Update this account
- addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ap_notified`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
+ addSql(sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ap_notified`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
array(bigintval($content['userid'])), __FILE__, __LINE__, FALSE));
} // END - while
} // END - if
// Free memory
- SQL_FREERESULT($result_inactive);
+ sqlFreeResult($result_inactive);
/*
* Now let's have a look for inactive accounts for deletion. Use the newly
* added exclude list here for e.g. excluding holiday users, test users et
* cetera.
*/
- $result_inactive = SQL_QUERY("SELECT
+ $result_inactive = sqlQuery("SELECT
`userid`,
`email`,
`last_online`
ORDER BY
`userid` ASC", __FILE__, __LINE__);
- if (!SQL_HASZERONUMS($result_inactive)) {
+ if (!ifSqlHasZeroNums($result_inactive)) {
// Prepare userid array for admin...
$userids = array();
// Delete inactive accounts
- while ($content = SQL_FETCHARRAY($result_inactive)) {
+ while ($content = sqlFetchArray($result_inactive)) {
// Remember userids for the admin
array_push($userids, $content['userid']);
} // END - if
// Free memory
- SQL_FREERESULT($result_inactive);
+ sqlFreeResult($result_inactive);
// Run all SQLs
runFilterChain('run_sqls');