Renamed all SQL-related functions to camel-case notation

[mailer.git] / inc / modules / guest / what-mediadata.php

diff --git a/inc/modules/guest/what-mediadata.php b/inc/modules/guest/what-mediadata.php
index f40322b2b9db17ffd680fd9add8dfc440f480f3d..7bb56305bc18b23d75e8d439b51ca915c5d56bfb 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -139,14 +139,14 @@ if (empty($jackpot)) $jackpot = '0';
 $content['jackpot'] = $jackpot;
 
 // Total referral link clicks, total logins
-$result = SQL_QUERY('SELECT
+$result = sqlQuery('SELECT
        SUM(`d`.`ref_clicks`) AS `total_ref_clicks`,
        SUM(`d`.`total_logins`) AS `total_logins`
 FROM
        `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ' . runFilterChain('user_exclusion_sql', ''), __FILE__, __LINE__);
-list($ref, $logins) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
+list($ref, $logins) = sqlFetchRow($result);
+sqlFreeResult($result);
 
 // Get total points
 $points = getMediadataEntry('total_points');
@@ -163,9 +163,9 @@ $content['total_logins']    = $logins;
 $total = countSumTotalData('Y', 'refbanner', 'id', 'visible', TRUE);
 
 // Total views and clicks
-$result = SQL_QUERY("SELECT SUM(`counter`) AS `views`, SUM(`clicks`) AS `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
-list($views, $clicks) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
+$result = sqlQuery("SELECT SUM(`counter`) AS `views`, SUM(`clicks`) AS `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
+list($views, $clicks) = sqlFetchRow($result);
+sqlFreeResult($result);
 
 if (empty($total))  $total  = '0';
 if (empty($views))  $views  = '0';
@@ -226,7 +226,7 @@ if (isExtensionActive('doubler')) {
 
 if (isExtensionActive('holiday')) {
        // Total holiday requests
-       $result = SQL_QUERY("SELECT
+       $result = sqlQuery("SELECT
        COUNT(`h`.`userid`) AS `count_holidays`
 FROM
        `{?_MYSQL_PREFIX?}_user_holidays` AS `h`
@@ -238,8 +238,8 @@ WHERE
        `d`.`holiday_active`='Y'
 " . runFilterChain('user_exclusion_sql', ' '),
        __FILE__, __LINE__);
-       list($holiday) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
+       list($holiday) = sqlFetchRow($result);
+       sqlFreeResult($result);
        if (empty($holiday)) $holiday = '0';
        $data = array(
                'lang'  => '{--MEDIA_HOLIDAY_COUNT--}',
@@ -250,7 +250,7 @@ WHERE
 
 if (isExtensionActive('transfer')) {
        // Statistics for points transfers
-       $result = SQL_QUERY("SELECT
+       $result = sqlQuery("SELECT
        COUNT(`t`.`id`) AS `cnt`,
        SUM(`t`.`points`) AS `points`
 FROM
@@ -261,12 +261,12 @@ ON
        `t`.`userid`=`d`.`userid`
 " . runFilterChain('user_exclusion_sql', ''),
                __FILE__, __LINE__);
-       list($count_in, $points_in) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
+       list($count_in, $points_in) = sqlFetchRow($result);
+       sqlFreeResult($result);
        if (empty($count_in))  $count_in  = '0';
        if (empty($points_in)) $points_in = '0';
 
-       $result = SQL_QUERY("SELECT
+       $result = sqlQuery("SELECT
        COUNT(`t`.`id`) AS `cnt`, SUM(`t`.`points`) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_transfers_out` AS `t`
@@ -276,8 +276,8 @@ ON
        `t`.`userid`=`d`.`userid`
 " . runFilterChain('user_exclusion_sql', ''),
        __FILE__, __LINE__);
-       list($count_out, $points_out) = SQL_FETCHROW($result);
-       SQL_FREERESULT($result);
+       list($count_out, $points_out) = sqlFetchRow($result);
+       sqlFreeResult($result);
        if (empty($count_out))  $count_out  = '0';
        if (empty($points_out)) $points_out = '0';