Fixes for sending pool

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 7ebf85b15940cf085d5ba6e091cba73281b42745..45019b90f62f869f5f18aabb8397c099f5dd2f7c 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -46,7 +46,7 @@ $GLOBALS['module'] = "show_bonus"; $CSS = 0;
 require ("inc/config.php");
 
 // List only rankings when script is installed
-if (defined('mxchange_installed') && (mxchange_installed))
+if (isBooleanConstantAndTrue('mxchange_installed'))
 {
        // Include header
        include(PATH."inc/header.php");
@@ -68,19 +68,19 @@ if (defined('mxchange_installed') && (mxchange_installed))
                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);