SQL_FREERESULT($result_media);
// Count mail orders
-$result_media = SQL_QUERY('SELECT COUNT(id) FROM `{!_MYSQL_PREFIX!}_user_stats`', __FILE__, __LINE__);
-list($ncount) = SQL_FETCHROW($result_media);
-SQL_FREERESULT($result_media);
+$ncount = GET_TOTAL_DATA('', 'user_stats', 'id', '', true);
// Check for bonus extension
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);
+ $bcount = GET_TOTAL_DATA('', 'bonus', 'id', '', true);
// Check for bonus mails
$result_media = SQL_QUERY('SELECT SUM(mails_sent) AS bonus_sent, SUM(clicks) AS bonus_clicks