X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-transfer.php;h=59d36bc655c7eeef9a58ca7d21c3ed6ba0a2203a;hp=0e9c148ae811478d6e9b9e6793f8583905bdb465;hb=82d53dfb7f59fa1e37bd500e3db3d10a9d4a78da;hpb=ae80e170b5d25a4782af90a7c3d81fbb176fa293

diff --git a/inc/modules/member/what-transfer.php b/inc/modules/member/what-transfer.php
index 0e9c148ae8..59d36bc655 100644
--- a/inc/modules/member/what-transfer.php
+++ b/inc/modules/member/what-transfer.php
@@ -112,26 +112,26 @@ case "new": // Start new transfer
 			$nick = true;
 		}
 		// Re-check receivers and own personal data
-		$result = SQL_QUERY_ESC("SELECT userid, sex, surname, family, email".$ADD." FROM "._MYSQL_PREFIX."_user_data WHERE userid IN ('%s', '%s') AND status='CONFIRMED' ORDER BY userid LIMIT 2",
+		$result = SQL_QUERY_ESC("SELECT userid, gender, surname, family, email".$ADD." FROM "._MYSQL_PREFIX."_user_data WHERE userid IN ('%s', '%s') AND status='CONFIRMED' ORDER BY userid LIMIT 2",
 		 array($GLOBALS['userid'], bigintval($_POST['to_uid'])), __FILE__, __LINE__);
 		$valid_data = (SQL_NUMROWS($result) == 2);
 
 		if ($valid_code && $valid_pass && $valid_amount && $valid_reason && $valid_recipient)
 		{
 			// Let's start the transfer and load user data
-			list($uid1, $sex1, $sname1, $fname1, $email1, $nick1) = SQL_FETCHROW($result);
-			list($uid2, $sex2, $sname2, $fname2, $email2, $nick2) = SQL_FETCHROW($result);
+			list($uid1, $gender1, $sname1, $fname1, $email1, $nick1) = SQL_FETCHROW($result);
+			list($uid2, $gender2, $sname2, $fname2, $email2, $nick2) = SQL_FETCHROW($result);
 			SQL_FREERESULT($result);
 			if ($uid1 == $GLOBALS['userid'])
 			{
 				// Data row 1 is sender's data
-				define('__SENDER_SEX'     , TRANSLATE_SEX($sex1));
+				define('__SENDER_GENDER'     , TRANSLATE_GENDER($gender1));
 				define('__SENDER_NICK'    , $nick1);
 				define('__SENDER_SNAME'   , $sname1);
 				define('__SENDER_FNAME'   , $fname1);
 				define('__SENDER_EMAIL'   , $email1);
 				// Data row 2 is recpient's data
-				define('__RECIPIENT_SEX'  , TRANSLATE_SEX($sex2));
+				define('__RECIPIENT_GENDER'  , TRANSLATE_GENDER($gender2));
 				define('__RECIPIENT_NICK' , $nick2);
 				define('__RECIPIENT_SNAME', $sname2);
 				define('__RECIPIENT_FNAME', $fname2);
@@ -144,13 +144,13 @@ case "new": // Start new transfer
 			 else
 			{
 				// Data row 2 is sender's data
-				define('__SENDER_SEX'     , TRANSLATE_SEX($sex2));
+				define('__SENDER_GENDER'     , TRANSLATE_GENDER($gender2));
 				define('__SENDER_NICK'    , $nick2);
 				define('__SENDER_SNAME'   , $sname2);
 				define('__SENDER_FNAME'   , $fname2);
 				define('__SENDER_EMAIL'   , $email2);
 				// Data row 1 is recpient's data
-				define('__RECIPIENT_SEX'  , TRANSLATE_SEX($sex1));
+				define('__RECIPIENT_GENDER'  , TRANSLATE_GENDER($gender1));
 				define('__RECIPIENT_NICK' , $nick1);
 				define('__RECIPIENT_SNAME', $sname1);
 				define('__RECIPIENT_FNAME', $fname1);
@@ -362,7 +362,7 @@ case "list_out": // List only outgoing transactions
 	}
 
 	// Run the SQL command
-	$total = "0";
+	$total = 0;
 	$result = SQL_QUERY_ESC($SQL, array($GLOBALS['userid']), __FILE__, __LINE__);
 	if (SQL_NUMROWS($result) > 0)
 	{
@@ -422,8 +422,8 @@ case "list_all": // List all transactions
 	// First of all create the temporary table
 	$result = SQL_QUERY("CREATE TEMPORARY TABLE "._MYSQL_PREFIX."_transfers_tmp (
 trans_id VARCHAR(12) NOT NULL DEFAULT '',
-party_uid BIGINT(20) NOT NULL DEFAULT '0',
-points BIGINT(20) NOT NULL DEFAULT '0',
+party_uid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+points BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
 reason VARCHAR(255) NOT NULL DEFAULT '',
 time_trans VARCHAR(10) NOT NULL DEFAULT '0',
 trans_type ENUM('IN', 'OUT') NOT NULL DEFAULT 'IN',
@@ -456,7 +456,7 @@ array($GLOBALS['userid'], $_CONFIG['transfer_max']), __FILE__, __LINE__);
 	// Free memory
 	SQL_FREERESULT($result);
 
-	$total = "0";
+	$total = 0;
 	if (SQL_NUMROWS($result) > 0)
 	{
 		// Output rows