More SQL rewrites, TODO: Put all table and column names in backticks (`)

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 613fa13577ebe1f2676b03098a91e879902295b6..8b81926921f028a66b44063ced92110740038de9 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -78,7 +78,7 @@ 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
+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