All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / inc / modules / admin / what-list_holiday.php

diff --git a/inc/modules/admin/what-list_holiday.php b/inc/modules/admin/what-list_holiday.php
index 713b45fcf497d2fc52ffee346a2e625c70c5ffa1..26907e3aea9d926b1040258af0b56c5593d39079 100644 (file)
--- a/inc/modules/admin/what-list_holiday.php
+++ b/inc/modules/admin/what-list_holiday.php
@@ -42,8 +42,8 @@ ADD_DESCR("admin", __FILE__);
 
 // Start listing holiday requests
 $result = SQL_QUERY("SELECT h.id, h.userid, h.holiday_start, h.holiday_end, h.comments, d.status, d.last_online
-FROM "._MYSQL_PREFIX."_user_holidays AS h
-LEFT JOIN `"._MYSQL_PREFIX."_user_data` AS d
+FROM `{!MYSQL_PREFIX!}_user_holidays` AS h
+LEFT JOIN `{!MYSQL_PREFIX!}_user_data` AS d
 ON h.userid=d.userid
 ORDER BY h.userid", __FILE__, __LINE__);