]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-lock_sponsor.php
Parser error fixed + some empty lines added between table rows (tr)
[mailer.git] / inc / modules / admin / what-lock_sponsor.php
index 7cbc90d677cbe04c3adbba6dbe47ec8119ac59af..ed39a54710319a52eb55a40deba5ea4d2b23d9af 100644 (file)
@@ -46,11 +46,11 @@ $message = '';
 
 if (isGetRequestElementSet('id')) {
        // Check for selected sponsor
-       $result_sponsor = SQL_QUERY_ESC("SELECT `gender`, `surname`, `family`, `email`, `status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
+       $result_sponsor = sqlQueryEscaped("SELECT `gender`, `surname`, `family`, `email`, `status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
                array(bigintval(getRequestElement('id'))), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result_sponsor) == 1) {
+       if (sqlNumRows($result_sponsor) == 1) {
                // Get sponsor's current status and let only confirmed and locked status pass
-               $content = SQL_FETCHARRAY($result_sponsor);
+               $content = sqlFetchArray($result_sponsor);
 
                if (($content['status'] == 'CONFIRMED') || ($content['status'] == 'LOCKED')) {
                        // Transfer data to constants
@@ -78,7 +78,7 @@ if (isGetRequestElementSet('id')) {
                                sendEmail($content['email'], $subject, $message);
 
                                // Update sponsor's account
-                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`=%s LIMIT 1",
+                               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`=%s LIMIT 1",
                                        array($content['status'], bigintval(getRequestElement('id'))), __FILE__, __LINE__);
                        } elseif (isPostRequestElementSet('no')) {
                                // No don't lock / unlock now!
@@ -111,7 +111,7 @@ if (isGetRequestElementSet('id')) {
        }
 
        // Free result
-       SQL_FREERESULT($result_sponsor);
+       sqlFreeResult($result_sponsor);
 } else {
        // Not called by what-list_sponsor.php
        $message = '{--ADMIN_CALL_NOT_DIRECTLY--}';