X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=show_bonus.php;h=6ac941f49fd1da50b97a583c7b1cf4ef9ee209bc;hb=199db88bf11bedd3d6c1dac997f942228ccb34d1;hp=0d5c910e7f7427bc6fc5be0679077f999acdad35;hpb=58b29a924c48e7c1ce38c435c92e541b53984c56;p=mailer.git diff --git a/show_bonus.php b/show_bonus.php index 0d5c910e7f..6ac941f49f 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -68,19 +68,19 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install if (!empty($t)) { // Check for data - $result = SQL_QUERY_ESC("SELECT DISTINCT d.sex, d.surname, d.family, b.level, b.points + $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=%d AND b.".$t."='%s' LIMIT 1", +WHERE d.status='CONFIRMED' AND d.userid=%s AND b.".$t."='%s' LIMIT 1", array(bigintval($_GET['uid']), bigintval($_GET['d'])), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 1) { // Load data - list($sex, $sname, $fname, $level, $points) = SQL_FETCHROW($result); + list($gender, $sname, $fname, $level, $points) = SQL_FETCHROW($result); // Prepare constants for the pre-template - define('__SALUT' , TRANSLATE_SEX($sex)); + define('__GENDER' , TRANSLATE_GENDER($gender)); define('__SNAME' , $sname); define('__FNAME' , $fname); define('__RANK' , $level);