X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-sponsor_login.php;h=6da3f8aa85afe0833ce4d9f7e9767bc284bf103e;hb=f01652b7b8efac92d97889e312402c4a845c2f14;hp=12584c5fe23a9f39dce2e9de67ba60b96cac3f1b;hpb=80e2def8ef2125fd4d7d1312ee3993ab613f0846;p=mailer.git

diff --git a/inc/modules/guest/what-sponsor_login.php b/inc/modules/guest/what-sponsor_login.php
index 12584c5fe2..6da3f8aa85 100644
--- a/inc/modules/guest/what-sponsor_login.php
+++ b/inc/modules/guest/what-sponsor_login.php
@@ -55,7 +55,7 @@ if (!empty($_GET['mode']))
 if (!empty($_GET['hash']))
 {
 	// Lookup sponsor
-	$result = SQL_QUERY_ESC("SELECT id, status, salut, surname, family,
+	$result = SQL_QUERY_ESC("SELECT id, status, gender, surname, family,
 company, position, tax_ident,
 street_nr1, street_nr2, country, zip, city, email, phone, fax, cell,
 points_amount AS points, last_pay AS pay, last_curr AS curr
@@ -67,8 +67,8 @@ LIMIT 1", array($_GET['hash']), __FILE__, __LINE__);
 		// Sponsor found, load his data...
 		$SPONSOR = SQL_FETCHARRAY($result);
 
-		// Translate salut and comma
-		$SPONSOR['salut']  = TRANSLATE_SEX($SPONSOR['salut']);
+		// Translate gender and comma
+		$SPONSOR['gender']  = TRANSLATE_GENDER($SPONSOR['gender']);
 		$SPONSOR['points'] = TRANSLATE_COMMA($SPONSOR['points']);
 		$SPONSOR['pay']    = TRANSLATE_COMMA($SPONSOR['pay']);
 
@@ -145,7 +145,7 @@ WHERE id='%s' AND hash='%s' AND status='EMAIL' LIMIT 1",
 	if (isset($_POST['ok']))
 	{
 		// Check email
-		$result = SQL_QUERY_ESC("SELECT id, hash, status, remote_addr, salut, surname, family, sponsor_created
+		$result = SQL_QUERY_ESC("SELECT id, hash, status, remote_addr, gender, surname, family, sponsor_created
 FROM "._MYSQL_PREFIX."_sponsor_data
 WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
  array($_POST['email']), __FILE__, __LINE__);
@@ -155,7 +155,7 @@ WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
 			$SPONSOR = SQL_FETCHARRAY($result);
 
 			// Translate some data
-			$SPONSOR['salut']           = TRANSLATE_SEX($SPONSOR['salut']);
+			$SPONSOR['gender']           = TRANSLATE_GENDER($SPONSOR['gender']);
 			$SPONSOR['sponsor_created'] = MAKE_DATETIME($SPONSOR['sponsor_created']);
 
 			// Prepare email and send it to the sponsor
@@ -201,7 +201,7 @@ WHERE email='%s' AND (status='UNCONFIRMED' OR status='EMAIL') LIMIT 1",
 	if (isset($_POST['ok']))
 	{
 		// Check email
-		$result = SQL_QUERY_ESC("SELECT id, hash, remote_addr, salut, surname, family, sponsor_created
+		$result = SQL_QUERY_ESC("SELECT id, hash, remote_addr, gender, surname, family, sponsor_created
 FROM "._MYSQL_PREFIX."_sponsor_data
 WHERE email='%s' AND id='%s' AND status='CONFIRMED' LIMIT 1",
  array($_POST['email'], bigintval($_POST['id'])), __FILE__, __LINE__);
@@ -211,7 +211,7 @@ WHERE email='%s' AND id='%s' AND status='CONFIRMED' LIMIT 1",
 			$SPONSOR = SQL_FETCHARRAY($result);
 
 			// Translate some data
-			$SPONSOR['salut']           = TRANSLATE_SEX($SPONSOR['salut']);
+			$SPONSOR['gender']           = TRANSLATE_GENDER($SPONSOR['gender']);
 			$SPONSOR['sponsor_created'] = MAKE_DATETIME($SPONSOR['sponsor_created']);
 
 			// Generate password