X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fgen_mediadata.php;h=b2451b7479376754d5d69730bfb2ed573a9584bf;hp=07d1e7a7e9d04d7cef752cdb137a9fbbb8c92fd4;hb=0abe254a699e33eb40d8a9bbddb469830cf4ad93;hpb=75ad748a68473ace540251427a74fb781b1145e9 diff --git a/inc/gen_mediadata.php b/inc/gen_mediadata.php index 07d1e7a7e9..b2451b7479 100644 --- a/inc/gen_mediadata.php +++ b/inc/gen_mediadata.php @@ -32,18 +32,20 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; 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__); list($nsent, $nclicks) = SQL_FETCHROW($result_media); -if (empty($nsent)) $nsent = "0"; -if (empty($nclicks)) $nclicks = "0"; +if (empty($nsent)) $nsent = 0; +if (empty($nclicks)) $nclicks = 0; // Free memory SQL_FREERESULT($result_media); @@ -52,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"; -} + if (empty($bsent)) $bsent = 0; + if (empty($bclicks)) $bclicks = 0; +} // END - if // Load (maybe) missing file require_once(PATH."inc/libs/mediadata_functions.php");