X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=ff3545d61bc8052793dbad772bbfb11399a84223;hp=6814e52df7c19d2ade469593479b9e0ca9423f2c;hb=4f7df133f736da124e6f7bd02008b9093f736451;hpb=fb9a9090248ca810eab3028c660cc0fa429cf854 diff --git a/show_bonus.php b/show_bonus.php index 6814e52df7..ff3545d61b 100644 --- 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')),