X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=b2451b7479376754d5d69730bfb2ed573a9584bf;hp=66d5a4d8f0c2486726006840d2c89c014f2a79d7;hb=49ffe0a4fb551d0965e97db1ad4ff12f13f4b9ad;hpb=7f104f6fe558bb56b4205241435a2357c2feece1 diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 66d5a4d8f0..b2451b7479 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -37,6 +37,9 @@ if (!defined('__SECURITY')) { require($INC); } +// Init variables +$bsent = 0; $bclicks = 0; $bcount = 0; + // Check for normal mails $result_media = SQL_QUERY("SELECT SUM(max_rec) AS max_rec, SUM(clicks) AS clicks FROM "._MYSQL_PREFIX."_user_stats", __FILE__, __LINE__); @@ -51,25 +54,21 @@ SQL_FREERESULT($result_media); $result_media = SQL_QUERY("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_user_stats", __FILE__, __LINE__); list($ncount) = SQL_FETCHROW($result_media); SQL_FREERESULT($result_media); -$result_media = SQL_QUERY("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_bonus", __FILE__, __LINE__); -list($bcount) = SQL_FETCHROW($result_media); -SQL_FREERESULT($result_media); // Check for bonus extension -if (EXT_IS_ACTIVE("bonus")) -{ +if (EXT_IS_ACTIVE("bonus")) { + // Count bonus mails + $result_media = SQL_QUERY("SELECT COUNT(id) FROM "._MYSQL_PREFIX."_bonus", __FILE__, __LINE__); + list($bcount) = SQL_FETCHROW($result_media); + SQL_FREERESULT($result_media); + // Check for bonus mails $result_media = SQL_QUERY("SELECT SUM(mails_sent) AS bonus_sent, SUM(clicks) AS bonus_clicks FROM "._MYSQL_PREFIX."_bonus", __FILE__, __LINE__); list($bsent, $bclicks) = SQL_FETCHROW($result_media); if (empty($bsent)) $bsent = 0; if (empty($bclicks)) $bclicks = 0; -} - else -{ - // Not found! - $bsent = 0; $bclicks = 0; -} +} // END - if // Load (maybe) missing file require_once(PATH."inc/libs/mediadata_functions.php");