X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=0615d8517621e86918b67f2acaba27468750635a;hp=130f7147c3fcfeeaf3301cc8adee3a2224f3afc9;hb=6ffd980d7f79fce2605158b04f4e82f1a7968d1b;hpb=2ec9007220186d54f84846871ed1f7638c29baf7 diff --git a/show_bonus.php b/show_bonus.php index 130f7147c3..0615d85176 100644 --- 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) {