X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-mydata.php;h=83392c1cb0bf2c145ae91f7c12dec9c3c85a5283;hb=8202991f32bfb2056e94a11746c0b5308fe4a273;hp=2e15c02dad1bd3eab5c433a1808ebc575feedc46;hpb=4a0e224c4e1754dbc2151fd707a926521dbafa7f;p=mailer.git

diff --git a/inc/modules/member/what-mydata.php b/inc/modules/member/what-mydata.php
index 2e15c02dad..83392c1cb0 100644
--- a/inc/modules/member/what-mydata.php
+++ b/inc/modules/member/what-mydata.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -210,7 +210,7 @@ LIMIT 1",
 
 				// Did the user changed the password?
 				if ($hash != $content['password']) {
-					$AND = ", `password`='" . $hash . "'";
+					$AND = ",`password`='" . $hash . "'";
 					$mode = 'password';
 				} // END - if
 
@@ -231,11 +231,11 @@ LIMIT 1",
 					SQL_QUERY_ESC("UPDATE
 	`{?_MYSQL_PREFIX?}_user_data`
 SET
-	`gender`='%s', `surname`='%s', `family`='%s',
+	`gender`='%s',`surname`='%s',`family`='%s',
 	`street_nr`='%s',
-	`country_code`=%s, `zip`=%s, `city`='%s',
+	`country_code`=%s,`zip`=%s,`city`='%s',
 	`email`='%s',
-	`birth_day`=%s, `birth_month`=%s, `birth_year`=%s,
+	`birth_day`=%s,`birth_month`=%s,`birth_year`=%s,
 	`max_mails`='%s',
 	`last_update`=UNIX_TIMESTAMP()".$AND.",
 	`notified`='N',
@@ -263,11 +263,11 @@ LIMIT 1",
 					SQL_QUERY_ESC("UPDATE
 	`{?_MYSQL_PREFIX?}_user_data`
 SET
-	`gender`='%s', `surname`='%s', `family`='%s',
+	`gender`='%s',`surname`='%s',`family`='%s',
 	`street_nr`='%s',
-	`country`='%s', `zip`=%s, `city`='%s',
+	`country`='%s',`zip`=%s,`city`='%s',
 	`email`='%s',
-	`birth_day`=%s, `birth_month`=%s, `birth_year`=%s,
+	`birth_day`=%s,`birth_month`=%s,`birth_year`=%s,
 	`max_mails`='%s',
 	`last_update`=UNIX_TIMESTAMP()".$AND.",
 	`notified`='N',
@@ -311,7 +311,7 @@ LIMIT 1",
 		break;
 
 	case 'notify': // Switch off notfication
-		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `notified`='N', `last_update`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
+		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `notified`='N',`last_update`=UNIX_TIMESTAMP() WHERE `userid`=%s LIMIT 1",
 			array(getMemberId()), __FILE__, __LINE__);
 		$url = 'modules.php?module=login&what=mydata&code=' . getCode('PROFILE_UPDATED');
 		break;