X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=birthday_confirm.php;h=b9b4242e5a043526530ab0ce4f81cf1eb6e234dc;hb=00c41ee95139ba90f2ed355da6503f03fb9096a3;hp=68fd150ef9c2194ff03db3b43bbcf5f8dd4b17b3;hpb=a1ef1533f17e1ca5db81a9912632491e72626694;p=mailer.git diff --git a/birthday_confirm.php b/birthday_confirm.php index 68fd150ef9..b9b4242e5a 100644 --- a/birthday_confirm.php +++ b/birthday_confirm.php @@ -53,7 +53,7 @@ if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_install $chk = bigintval($_GET['check'], false); // Check if link is not clicked so far - $result = SQL_QUERY_ESC("SELECT b.points, d.sex, d.surname, d.family, d.status, d.ref_payout + $result = SQL_QUERY_ESC("SELECT b.points, d.gender, d.surname, d.family, d.status, d.ref_payout FROM "._MYSQL_PREFIX."_user_birthday AS b INNER JOIN "._MYSQL_PREFIX."_user_data AS d ON b.userid=d.userid @@ -87,7 +87,7 @@ WHERE b.userid=%s AND b.chk_value='%s' LIMIT 1", } // Transfer data to constants for the template - define('__SALUT', TRANSLATE_SEX($data['sex'])); + define('__GENDER', TRANSLATE_GENDER($data['gender'])); define('__SNAME', $data['surname']); define('__FNAME', $data['family']); define('__GIFT' , $data['points']);