]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-lock_user.php
Renamed all SQL-related functions to camel-case notation
[mailer.git] / inc / modules / admin / what-lock_user.php
index db708f0f1601fe63f523de00a8a21962b9091d61..f43f83b4a576f7f059041e0120663a54c748b01d 100644 (file)
@@ -55,16 +55,16 @@ if (isGetRequestElementSet('userid')) {
                        // Ok, lock the account!
                        if (isExtensionInstalledAndNewer('user', '0.3.5')) {
                                // Lock with reason
-                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED',`lock_reason`='%s',`lock_timestamp`=NOW() WHERE `userid`=%s LIMIT 1",
+                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED',`lock_reason`='%s',`lock_timestamp`=NOW() WHERE `userid`=%s LIMIT 1",
                                        array(postRequestElement('reason'), bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
                        } else {
                                // Lock with no lock reason saved
-                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED' WHERE `userid`=%s LIMIT 1",
+                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='LOCKED' WHERE `userid`=%s LIMIT 1",
                                        array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
                        }
 
                        // Entry updated?
-                       if (!SQL_HASZEROAFFECTED()) {
+                       if (!ifSqlHasZeroAffectedRows()) {
                                // Send an email to the user! In later version you can optionally switch this feature off
                                $message = loadEmailTemplate('member_user_locked', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid')));
 
@@ -79,7 +79,7 @@ if (isGetRequestElementSet('userid')) {
                        // Ok, unlock the account!
                        if (isExtensionInstalledAndNewer('user', '0.3.5')) {
                                // Reset lock reason as well
-                               SQL_QUERY_ESC("UPDATE
+                               sqlQueryEscaped("UPDATE
        `{?_MYSQL_PREFIX?}_user_data`
 SET
        `status`='CONFIRMED',
@@ -91,12 +91,12 @@ LIMIT 1",
                                        array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
                        } else {
                                // No lock reason to reset
-                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='CONFIRMED' WHERE `userid`=%s LIMIT 1",
+                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `status`='CONFIRMED' WHERE `userid`=%s LIMIT 1",
                                        array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__);
                        }
 
                        // Entry updated?
-                       if (!SQL_HASZEROAFFECTED()) {
+                       if (!ifSqlHasZeroAffectedRows()) {
                                // Send an email to the user! In later version you can optionally switch this feature off
                                $message = loadEmailTemplate('member_user_unlocked', array('text' => postRequestElement('reason')), bigintval(getRequestElement('userid')));