More misc fixes and rewrites (sorry, lame description)

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 130f7147c3fcfeeaf3301cc8adee3a2224f3afc9..0615d8517621e86918b67f2acaba27468750635a 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -61,7 +61,7 @@ if (!isInstalled()) {
 // Include header
 loadIncludeOnce('inc/header.php');
 
-if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t')))) {
+if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET('t'))) {
        // Set row name
        $t = '';
        switch (REQUEST_GET('t')) {
@@ -81,13 +81,17 @@ if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t
        // Valid type?
        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
-ON d.userid=b.userid
-WHERE d.`status`='CONFIRMED' AND d.userid=%s AND b.%s=%s
+               $result = SQL_QUERY_ESC("SELECT 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
+ON
+       d.userid=b.userid
+WHERE
+       d.`status`='CONFIRMED' AND d.userid=%s AND b.%s=%s
 LIMIT 1",
-               array(bigintval(REQUEST_GET('uid')), $t, bigintval(REQUEST_GET('d'))), __FILE__, __LINE__);
+                       array(bigintval(REQUEST_GET('uid')), $t, bigintval(REQUEST_GET('d'))), __FILE__, __LINE__);
 
                // Entry found?
                if (SQL_NUMROWS($result) == 1) {