}
//
-function HOLIDAY_STOP_HOLIDAYS()
-{
+function HOLIDAY_STOP_HOLIDAYS () {
// Let's find some expired holiday requests...
$result_stop = SQL_QUERY("SELECT userid, holiday_start, holiday_end, comments
-FROM "._MYSQL_PREFIX."_user_holidays
+FROM `{!_MYSQL_PREFIX!}_user_holidays`
WHERE holiday_end <= UNIX_TIMESTAMP()
ORDER BY userid", __FILE__, __LINE__);
- if (SQL_NUMROWS($result_stop) > 0)
- {
+ if (SQL_NUMROWS($result_stop) > 0) {
// We foud at least one
$admin = "";
- while (list($uid, $start, $end, $comments) = SQL_FETCHROW($result_stop))
- {
+ while (list($uid, $start, $end, $comments) = SQL_FETCHROW($result_stop)) {
// Stop holiday
- $result_del = SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays WHERE userid=%s LIMIT 1",
- array(bigintval($uid)), __FILE__, __LINE__);
+ SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_holidays` WHERE userid=%s LIMIT 1",
+ array(bigintval($uid)), __FILE__, __LINE__);
// Unlock account
- $result_del = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data
+ SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data`
SET holiday_active='N', holiday_activated='0'
WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__);