Filters for configurable userid exclusion added:

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 6814e52df7c19d2ade469593479b9e0ca9423f2c..ff3545d61bc8052793dbad772bbfb11399a84223 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -78,19 +78,19 @@ if ((isValidId(getRequestElement('userid'))) && (getRequestElement('d') > 0) &&
        if (!empty($t)) {
                // Check for data
                $result = SQL_QUERY_ESC("SELECT
-       d.`userid`,
-       b.`level`,
-       b.`points`
+       `d`.`userid`,
+       `b`.`level`,
+       `b`.`points`
 FROM
-       `{?_MYSQL_PREFIX?}_user_data` AS d
+       `{?_MYSQL_PREFIX?}_user_data` AS `d`
 INNER JOIN
-       `{?_MYSQL_PREFIX?}_bonus_turbo` AS b
+       `{?_MYSQL_PREFIX?}_bonus_turbo` AS `b`
 ON
-       d.`userid`=b.`userid`
+       `d`.`userid`=`b`.`userid`
 WHERE
-       d.`status`='CONFIRMED' AND
-       d.`userid`=%s AND
-       b.`%s`=%s
+       `d`.`status`='CONFIRMED' AND
+       `d`.`userid`=%s AND
+       `b`.`%s`=%s
 LIMIT 1",
                        array(
                                bigintval(getRequestElement('userid')),