View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0014253||phplist application||Statistics||public||24-04-08 08:59||21-06-18 14:05|
|Target Version||next major||Fixed in Version|
|Summary||0014253: clicktracking totals: sent msgs is calculated wrong (especially for RSS msgs)|
|Description||mviews.php: the SQL (which was already changed in bug #6531) is still not correct, it should include a where/having-condition to only select the msgs which were actually sent. If status is being counted, it has to select "where um.status='sent'", or else the stats will be horribly wrong for msgs with 2 or 3 RSS frequencies.|
|Tags||No tags attached.|
this also affects statsoverview.php ...
by the way, statsoverview and mviews are basically the same file, I suggest merging them to stats.php with different function blocks for voerview and details...
also code which does nothing should be assessed:
$timerange = ' and date_add(msg.entered,interval 6 month) > now()';
$timerange = '';