Fix for inserted codes while registering of extensions, many rewrites/cleanups:

[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 6fd3e085d1201f16b3c5b193eac09b69bf2d5ba0..733327beeba47653b71eaaceb1b70f322d2a8cdc 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -136,10 +136,10 @@ if (empty($jackpot)) $jackpot = '0';
 $content['jackpot'] = translateComma($jackpot);
 
 // Total referal link clicks, total logins
-$result = SQL_QUERY("SELECT
+$result = SQL_QUERY('SELECT
        SUM(d.ref_clicks), SUM(d.total_logins)
 FROM
-       `{?_MYSQL_PREFIX?}_user_data` AS d", __FILE__, __LINE__);
+       `{?_MYSQL_PREFIX?}_user_data` AS d', __FILE__, __LINE__);
 list($ref, $logins) = SQL_FETCHROW($result);
 SQL_FREERESULT($result);
 
@@ -258,10 +258,14 @@ ON
        if (empty($count_in))  $count_in  = '0';
        if (empty($points_in)) $points_in = '0';
 
-       $result = SQL_QUERY("SELECT COUNT(t.id), SUM(t.points)
-FROM `{?_MYSQL_PREFIX?}_user_transfers_out` AS t
-LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS d
-ON t.userid=d.userid",
+       $result = SQL_QUERY("SELECT
+       COUNT(t.id), SUM(t.points)
+FROM
+       `{?_MYSQL_PREFIX?}_user_transfers_out` AS t
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_user_data` AS d
+ON
+       t.userid=d.userid",
        __FILE__, __LINE__);
        list($count_out, $points_out) = SQL_FETCHROW($result);
        SQL_FREERESULT($result);