Renamed all SQL-related functions to camel-case notation

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

diff --git a/inc/modules/admin/what-list_unconfirmed.php b/inc/modules/admin/what-list_unconfirmed.php
index 6d48d8ee22b8f74b6ab7fa994b8cd232d4e0d999..cd6da112e6d7816dc91e04c0e1957b4222a5a157 100644 (file)
--- a/inc/modules/admin/what-list_unconfirmed.php
+++ b/inc/modules/admin/what-list_unconfirmed.php
@@ -119,12 +119,12 @@ LIMIT 1",
 // Shall I display links or not?
 if (($listed === TRUE) && (!empty($sql))) {
        // Load mail data
-       $result_master = SQL_QUERY($sql, __FILE__, __LINE__);
+       $result_master = sqlQuery($sql, __FILE__, __LINE__);
 
        // Is there an entry?
-       if (SQL_NUMROWS($result_master) == 1) {
+       if (sqlNumRows($result_master) == 1) {
                // Mail order / bonus mail found
-               $poolData = SQL_FETCHARRAY($result_master);
+               $poolData = sqlFetchArray($result_master);
 
                // If there is a pool id and $ID is not set, we take it
                if (($poolData['id'] > 0) && ($ID == '-1')) {
@@ -139,7 +139,7 @@ if (($listed === TRUE) && (!empty($sql))) {
                // Load unconfirmed mail links. Hmmm, this select query is pretty cool
                // but it does only show unconfirmed mail links from existing user
                // accounts. So if you have delete one you did not see those links
-               $result = SQL_QUERY_ESC("SELECT
+               $result = sqlQueryEscaped("SELECT
        `l`.`userid`,
        `u`.`status`,
        `u`.`surname`,
@@ -164,10 +164,10 @@ LIMIT %s",
                        ),__FILE__, __LINE__);
 
                // Are there entries?
-               if (!SQL_HASZERONUMS($result)) {
+               if (!ifSqlHasZeroNums($result)) {
                        // At least one link left to confirm
                        $OUT = '';
-                       while ($row = SQL_FETCHARRAY($result)) {
+                       while ($row = sqlFetchArray($result)) {
                                // User data found? We can take any field of u.
                                if (!is_null($row['status'])) {
                                        // Prepare data for the row template
@@ -196,12 +196,12 @@ LIMIT %s",
 
                // Prepare content
                $content                = $poolData;
-               $content['unconfirmed'] = SQL_NUMROWS($result);
+               $content['unconfirmed'] = sqlNumRows($result);
                $content['timestamp']   = generateDateTime($poolData['timestamp'], 2);
                $content['rows']        = $OUT;
 
                // Free memory
-               SQL_FREERESULT($result);
+               sqlFreeResult($result);
 
                // Load final template
                loadTemplate('admin_list_unconfirmed', FALSE, $content);
@@ -223,7 +223,7 @@ LIMIT %s",
        }
 
        // Free result
-       SQL_FREERESULT($result_master);
+       sqlFreeResult($result_master);
 } // END - if
 
 // [EOF]