X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fholiday_functions.php;h=1e74c62d324b27603ebcc0f0f805e48c9a448161;hb=8ece7fd45c386f7ccd60f9c4800ad207602b0240;hp=a63d334d27bfecfd9346640df3a979a7f29eaefe;hpb=89c00e43d2ce1dd1afe11c2c8485307342805f97;p=mailer.git diff --git a/inc/libs/holiday_functions.php b/inc/libs/holiday_functions.php index a63d334d27..1e74c62d32 100644 --- a/inc/libs/holiday_functions.php +++ b/inc/libs/holiday_functions.php @@ -41,7 +41,7 @@ if (!defined('__SECURITY')) { 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) { @@ -49,11 +49,11 @@ ORDER BY userid", __FILE__, __LINE__); $admin = ""; while (list($uid, $start, $end, $comments) = SQL_FETCHROW($result_stop)) { // Stop holiday - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_holidays WHERE userid=%s LIMIT 1", + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_holidays` WHERE userid=%s LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__); // Unlock account - 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__);