Use countSumTotalData() instead of SQL query

[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 df1d0e8d7505c14f5458ed77caf489fb987471a1..8828b53ffda9d79ccc10ca11c9b51bd208a9a66c 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -163,7 +163,7 @@ $content['total_logins']    = $logins;
 $total = countSumTotalData('Y', 'refbanner', 'id', 'visible', TRUE);
 
 // Total views and clicks
-$result = SQL_QUERY("SELECT SUM(`counter`) AS `cnt`, SUM(`clicks`) AS `clicks` FROM `{?_MYSQL_PREFIX?}_refbanner` WHERE `visible`='Y'", __FILE__, __LINE__);
+$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);