Total hits counter

[philoo]

As I wanted to offer my customers a message on the home page like

This website offers {total_ads} that have been viewed {total_hits} times

... I had to create a new Smarty Plugin to make the {total_hits} variable available (the {total_ads} is natively offered in 68C). This function is the sum of the number of visualisation of each ad (hitcount in database).

Basically this new function is a hack of the function.total_ads.php that allready exists in /includes/classes/smarty/plugin

The new function is named function.total_hits.php and also placed in /includes/classes/smarty/plugin

here is the code of function.total_hits.php you must create :

PHP Code:

function smarty_function_total_hits($params, &$smarty)
{
    global $db;
    
    //get total active listings
    $sSQL="SELECT SUM( hitcount ) as total FROM ".PREFIX."listings";
    $result=$db->query($sSQL);
    $rs=$result->fetch();
    $total_hits=$rs['total'];

    return $total_hits;
}
?> 


Enjoy the new {total_hits} variable in your templates

[bowers01]

Hi,
{total_ads} does not work. It is actually {total_listings}
Nick

[cathouse911]

Thanks for sharing it with us!