Filters for configurable userid exclusion added:

[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 8828b53ffda9d79ccc10ca11c9b51bd208a9a66c..a79c6ebddded29999070cf9c168e043897ae537c 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -140,8 +140,8 @@ $content['jackpot'] = $jackpot;
 
 // Total referral link clicks, total logins
 $result = SQL_QUERY('SELECT
-       SUM(d.`ref_clicks`) AS `total_ref_clicks`,
-       SUM(d.`total_logins`) AS `total_logins`
+       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__);
@@ -233,9 +233,9 @@ FROM
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       h.`userid`=d.`userid`
+       h.`userid`=`d`.`userid`
 WHERE
-       d.`holiday_active`='Y'
+       `d`.`holiday_active`='Y'
 " . runFilterChain('user_exclusion_sql', ' '),
        __FILE__, __LINE__);
        list($holiday) = SQL_FETCHROW($result);
@@ -251,14 +251,14 @@ WHERE
 if (isExtensionActive('transfer')) {
        // Statistics for points transfers
        $result = SQL_QUERY("SELECT
-       COUNT(t.`id`) AS `cnt`,
-       SUM(t.`points`) AS `points`
+       COUNT(`t`.`id`) AS `cnt`,
+       SUM(`t`.`points`) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_transfers_in` AS `t`
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       t.`userid`=d.`userid`
+       `t`.`userid`=`d`.`userid`
 " . runFilterChain('user_exclusion_sql', ''),
                __FILE__, __LINE__);
        list($count_in, $points_in) = SQL_FETCHROW($result);
@@ -267,13 +267,13 @@ ON
        if (empty($points_in)) $points_in = '0';
 
        $result = SQL_QUERY("SELECT
-       COUNT(t.`id`) AS `cnt`, SUM(t.`points`) AS `points`
+       COUNT(`t`.`id`) AS `cnt`, SUM(`t`.`points`) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_transfers_out` AS `t`
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_user_data` AS `d`
 ON
-       t.userid=d.userid
+       `t`.`userid`=`d`.`userid`
 " . runFilterChain('user_exclusion_sql', ''),
        __FILE__, __LINE__);
        list($count_out, $points_out) = SQL_FETCHROW($result);