I noticed the problems with the stats too, and I discovered that the stats for the clicks are multiplying with how many days the ad has been "on". So i looked in the adsmanager.inc.php file and saw the sql that gets the stats, and I think it has something to do with that somewhat complicated sql so I made my own, but I havent gotten around to showing the "views", only the clicks as we use google analytics to do find out how many views a page has gotten.
I saw in the database that clicks and views are correctly counted.
The SQL is on line 390 in adsmanager.inc.php. I just commented out this and put this in instead:
$query = "
SELECT {$this->db_prefix}ads.id, {$this->db_prefix}ads.tags, {$this->db_prefix}ads.title, COUNT({$this->db_prefix}ads_clicks.id) AS bclick, {$this->db_prefix}ads.id as bshows, {$this->db_prefix}ads.id as ctr
FROM {$this->db_prefix}ads
INNER JOIN {$this->db_prefix}ads_clicks ON {$this->db_prefix}ads_clicks.banner = {$this->db_prefix}ads.id
GROUP BY {$this->db_prefix}ads.id
";
I hope someone can take my findings and make it even better so we can make the views show the right amount.
☆ A M B ☆
☆ A M B ☆