* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * 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 *
* it under the terms of the GNU General Public License as published by *
// Stops all expired holidays
function stopHolidays () {
// Let's find some expired holiday requests...
- $result_stop = SQL_QUERY("SELECT
- `userid`, `holiday_start`, `holiday_end`, `comments`
+ $result_stop = sqlQuery("SELECT
+ `userid`,
+ `holiday_start`,
+ `holiday_end`,
+ `comments`
FROM
`{?_MYSQL_PREFIX?}_user_holidays`
WHERE
`holiday_end` <= UNIX_TIMESTAMP()
ORDER BY
`userid` ASC", __FUNCTION__, __LINE__);
- if (!SQL_HASZERONUMS($result_stop)) {
+ if (!ifSqlHasZeroNums($result_stop)) {
// We foud at least one
$admin = '';
initSqls();
// Process all found entries
- while ($content = SQL_FETCHARRAY($result_stop)) {
+ while ($content = sqlFetchArray($result_stop)) {
// Stop holiday
- addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s LIMIT 1",
- array(bigintval($content['userid'])), __FUNCTION__, __LINE__, false));
+ addSql(sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_holidays` WHERE `userid`=%s LIMIT 1",
+ array(bigintval($content['userid'])), __FUNCTION__, __LINE__, FALSE));
// Unlock account
- addSql(SQL_QUERY_ESC("UPDATE
+ addSql(sqlQueryEscaped("UPDATE
`{?_MYSQL_PREFIX?}_user_data`
SET
- `holiday_active`='N', `holiday_activated`=0
+ `holiday_active`='N',
+ `holiday_activated`=0
WHERE
`userid`=%s
LIMIT 1",
- array(bigintval($content['userid'])), __FUNCTION__, __LINE__, false));
+ array(bigintval($content['userid'])), __FUNCTION__, __LINE__, FALSE));
// Prepare array
$content = merge_array($content, array(
sendEmail($content['userid'], '{--MEMBER_HOLIDAY_UNLOCK_SUBJECT--}', $message);
// Remember userid for admin
- $admin .= $content['userid']."\n";
+ $admin .= $content['userid'] . PHP_EOL;
} // END - if
// Send mail to admins
} // END - if
// Free memory
- SQL_FREERESULT($result_stop);
+ sqlFreeResult($result_stop);
+}
+
+// ----------------------------------------------------------------------------
+// Wrapper functions for configuration entries
+// ----------------------------------------------------------------------------
+
+// Getter for user_alpha
+function getHolidayLock () {
+ // Is there cache?
+ if (!isset($GLOBALS[__FUNCTION__])) {
+ // Determine it
+ $GLOBALS[__FUNCTION__] = getConfig('holiday_lock');
+ } // END - if
+
+ // Return cache
+ return $GLOBALS[__FUNCTION__];
}
// [EOF]