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

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 06a0dd7139e9a62f9f474d154f083c8e1cb6c7c9..a71eee78e1637d77f3c725090f565327e48477a8 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -78,8 +78,8 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
                if (!empty($t)) {
                        // Check for data
                        $result = SQL_QUERY_ESC("SELECT DISTINCT d.gender, d.surname, d.family, b.level, b.points
-FROM `"._MYSQL_PREFIX."_user_data` AS d
-RIGHT JOIN "._MYSQL_PREFIX."_bonus_turbo AS b
+FROM `{!MYSQL_PREFIX!}_user_data` AS d
+RIGHT JOIN `{!MYSQL_PREFIX!}_bonus_turbo` AS b
 ON d.userid=b.userid
 WHERE d.status='CONFIRMED' AND d.userid=%s AND b.%s=%s
 LIMIT 1",