Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / admin / what-email_details.php

diff --git a/inc/modules/admin/what-email_details.php b/inc/modules/admin/what-email_details.php
index f36b94f0960c1d7b0b866b088c601bd3d9dfa396..d0b8d1365578734e6588252ca8da97f803bc4a58 100644 (file)
--- a/inc/modules/admin/what-email_details.php
+++ b/inc/modules/admin/what-email_details.php
@@ -128,7 +128,7 @@ $result_bonus = FALSE;
 
 if ((isExtensionActive('bonus')) && (empty($WHO))) {
        // Check for maximum pages
-       $result_bonus = SQL_QUERY("SELECT
+       $result_bonus = sqlQuery("SELECT
        `id`,
        `subject`,
        `text`,
@@ -152,7 +152,7 @@ ORDER BY
 } // END - if
 
 // Check for maximum pages
-$result_normal = SQL_QUERY($sql, __FILE__, __LINE__);
+$result_normal = sqlQuery($sql, __FILE__, __LINE__);
 
 // Set offset an current page to default values
 if (!isGetRequestElementSet('page')) setGetRequestElement('page', 1);
@@ -180,36 +180,36 @@ if (!(isPostRequestElementSet('id')) && (isGetRequestElementSet('type')) && (pos
 } // END - if
 
 // Run SQL query for normal mails
-$result_list = SQL_QUERY($sql, __FILE__, __LINE__);
+$result_list = sqlQuery($sql, __FILE__, __LINE__);
 if ((!empty($SQL2)) && (empty($WHO))) {
-       $result_bonus = SQL_QUERY($SQL2, __FILE__, __LINE__);
+       $result_bonus = sqlQuery($SQL2, __FILE__, __LINE__);
 } // END - if
 
 // Calculate pages
 $numPages = '0';
 if (isConfigEntrySet('mails_page')) {
-       $numPages = round(SQL_NUMROWS($result_normal) / getMailsPage() + 0.3);
+       $numPages = round(sqlNumRows($result_normal) / getMailsPage() + 0.3);
 } // END - if
 
 // Free result
-SQL_FREERESULT($result_normal);
+sqlFreeResult($result_normal);
 
 $MAIL = FALSE;
-if (!SQL_HASZERONUMS($result_list)) {
+if (!ifSqlHasZeroNums($result_list)) {
        // Init rows
        $OUT = '';
 
        // Walk through all entries
-       while ($content = SQL_FETCHARRAY($result_list)) {
+       while ($content = sqlFetchArray($result_list)) {
                // Unconfirmed mails and sent mails
-               $result_uncon = SQL_QUERY_ESC("SELECT (`max_rec` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
+               $result_uncon = sqlQueryEscaped("SELECT (`max_rec` - `clicks`) AS `unconfirmed` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
                        array(bigintval($content['id'])), __FILE__, __LINE__);
 
                // Load and merge data
-               $content = merge_array($content, SQL_FETCHARRAY($result_uncon));
+               $content = merge_array($content, sqlFetchArray($result_uncon));
 
                // Free result
-               SQL_FREERESULT($result_uncon);
+               sqlFreeResult($result_uncon);
 
                // Unconfirmed mails
                $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], ($content['unconfirmed']), 'normal');
@@ -222,7 +222,7 @@ if (!SQL_HASZERONUMS($result_list)) {
        } // END - while
 
        // Free memory
-       SQL_FREERESULT($result_list);
+       sqlFreeResult($result_list);
 
        // Add navigation (with change box and colspan=3)
        $content['nav'] = addEmailNavigation($numPages, getMailsPage(), FALSE, 3, TRUE);
@@ -237,19 +237,19 @@ if (!SQL_HASZERONUMS($result_list)) {
        $MAIL = TRUE;
        if ((isExtensionActive('bonus')) && (empty($WHO))) {
                // Only check if bonus extension is active
-               if (!SQL_HASZERONUMS($result_bonus)) outputHtml('<br /><br />');
+               if (!ifSqlHasZeroNums($result_bonus)) outputHtml('<br /><br />');
        } // END - if
 } // END - if
 
 if ((isExtensionActive('bonus')) && (empty($WHO))) {
        // Load bonus mails only when extension is active
-       if (!SQL_HASZERONUMS($result_bonus)) {
+       if (!ifSqlHasZeroNums($result_bonus)) {
                // Calculate pages
-               $numPages = round(SQL_NUMROWS($result_bonus) / getMailsPage() + 0.5);
+               $numPages = round(sqlNumRows($result_bonus) / getMailsPage() + 0.5);
 
                // List emails
                $OUT = '';
-               while ($content = SQL_FETCHARRAY($result_bonus)) {
+               while ($content = sqlFetchArray($result_bonus)) {
                        // Add link to list_unconfirmed what-file
                        $content['unconfirmed'] = generateUnconfirmedAdminLink($content['id'], $content['unconfirmed'], 'bonus');