Large code cleanups:

[mailer.git] / inc / modules / member / what-mydata.php

diff --git a/inc/modules/member/what-mydata.php b/inc/modules/member/what-mydata.php
index 0f21b5b461313087cca56fbfe1e161b8adc17230..83392c1cb0bf2c145ae91f7c12dec9c3c85a5283 100644 (file)
--- a/inc/modules/member/what-mydata.php
+++ b/inc/modules/member/what-mydata.php
@@ -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;