X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-mediadata.php;h=61e30b224cee40fbe19f8933b2e1e023c4e7fad5;hp=ac1b450fbd88624803c535930d26a0bf99842e95;hb=4e47eb8b83ed2fcd4320aeed8b8c460eb1c8fe4b;hpb=8d640e7d58f17639919d054a3668463a235f2ba9

diff --git a/inc/modules/guest/what-mediadata.php b/inc/modules/guest/what-mediadata.php
index ac1b450fbd..61e30b224c 100644
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -128,15 +128,16 @@ if ($sent > 0) $clr = $clicks / $sent * 100;
 define('_clr', translateComma($clr).'%');
 
 // Load jackpot
-$result = SQL_QUERY("SELECT `points` FROM `{!_MYSQL_PREFIX!}_jackpot` WHERE `ok`='ok' LIMIT 1", __FILE__, __LINE__);
-list($jackpot) = SQL_FETCHROW($result);
-SQL_FREERESULT($result);
+$jackpot = GET_JACKPOT_POINTS();
+
 if (empty($jackpot)) $jackpot = 0;
 define('jackpot', translateComma($jackpot));
 
 // Total referal link clicks, total logins
-$result = SQL_QUERY("SELECT DISTINCT SUM(d.ref_clicks), SUM(d.total_logins)
-FROM `{!_MYSQL_PREFIX!}_user_data` AS d", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT DISTINCT
+	SUM(d.ref_clicks), SUM(d.total_logins)
+FROM
+	`{!_MYSQL_PREFIX!}_user_data` AS d", __FILE__, __LINE__);
 list($ref, $logins) = SQL_FETCHROW($result);
 SQL_FREERESULT($result);