Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / member / what-earning.php

diff --git a/inc/modules/member/what-earning.php b/inc/modules/member/what-earning.php
index af3ea8b5aad64e0db2a47cc57d564a51917cfebc..608078b99ecd0432d1799b8a2672aa26046f90ad 100644 (file)
--- a/inc/modules/member/what-earning.php
+++ b/inc/modules/member/what-earning.php
@@ -56,7 +56,7 @@ if (isFormSent()) {
 } // END - if
 
 // Check for all earnings
-$result = SQL_QUERY('SELECT
+$result = sqlQuery('SELECT
        `d`.`earning_id`,
        `d`.`earning_group`,
        `d`.`earning_provider`
@@ -66,14 +66,14 @@ ORDER BY
        `d`.`earning_sorting` ASC', __FILE__, __LINE__);
 
 // Are there entries?
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
        // Init output
        $OUT = '';
 
        // List all entries
-       while ($content = SQL_FETCHARRAY($result)) {
+       while ($content = sqlFetchArray($result)) {
                // Load user_earning data
-               $result2 = SQL_QUERY_ESC('SELECT
+               $result2 = sqlQueryEscaped('SELECT
        `u`.`earning_active`,
        UNIX_TIMESTAMP(`u`.`earning_added`) AS `earning_added`,
        UNIX_TIMESTAMP(`u`.`earning_canceled`) AS `earning_canceled`,
@@ -91,13 +91,13 @@ LIMIT 1',
                        ), __FILE__, __LINE__);
 
                // Is there an entry?
-               if (SQL_NUMROWS($result2) == 1) {
+               if (sqlNumRows($result2) == 1) {
                        // Load it
-                       $content = merge_array($content, SQL_FETCHARRAY($result2));
+                       $content = merge_array($content, sqlFetchArray($result2));
                } // END - if
 
                // Free result
-               SQL_FREERESULT($result2);
+               sqlFreeResult($result2);
 
                // Is there user_earning data available?
                if (!isset($content['earning_active'])) {
@@ -117,7 +117,7 @@ LIMIT 1',
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // [EOF]
 ?>