Renamed all SQL-related functions to camel-case notation
[mailer.git] / inc / modules / member / what-mydata.php
index dead3e1b20f0f5558aaf5a87d1f7b54a9a204b92..a9f183abc28c5ffb5c784751f85cd1bc4741e8b2 100644 (file)
@@ -97,7 +97,7 @@ switch ($mode) {
        case 'edit': // Edit data
                if (isExtensionActive('country', TRUE)) {
                        // New way
-                       $result = SQL_QUERY_ESC('SELECT
+                       $result = sqlQueryEscaped('SELECT
        `surname`,
        `family`,
        `street_nr`,
@@ -120,7 +120,7 @@ LIMIT 1',
                        array(getMemberId()), __FILE__, __LINE__);
                } else {
                        // Old way
-                       $result = SQL_QUERY_ESC('SELECT
+                       $result = sqlQueryEscaped('SELECT
        `surname`,
        `family`,
        `street_nr`,
@@ -144,10 +144,10 @@ LIMIT 1',
                }
 
                // Get line
-               $content = merge_array($content, SQL_FETCHARRAY($result));
+               $content = merge_array($content, sqlFetchArray($result));
 
                // Free result
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
 
                $content['update_check'] = $content['last_update'] + getProfileLock();
 
@@ -271,7 +271,7 @@ LIMIT 1',
                                // Update member's profile
                                if (isExtensionActive('country')) {
                                        // New way
-                                       SQL_QUERY_ESC("UPDATE
+                                       sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_user_data`
 SET
        `gender`='%s',
@@ -309,7 +309,7 @@ LIMIT 1",
                                                ), __FILE__, __LINE__);
                                } else {
                                        // Old way
-                                       SQL_QUERY_ESC("UPDATE
+                                       sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_user_data`
 SET
        `gender`='%s',
@@ -348,7 +348,7 @@ LIMIT 1",
                                }
 
                                // Did something change?
-                               if (!SQL_HASZEROAFFECTED()) {
+                               if (!ifSqlHasZeroAffectedRows()) {
                                        // Get all modes ...
                                        $modes = explode(';', $mode);
 
@@ -366,7 +366,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",
+               sqlQueryEscaped("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;