Total Downloads on the index page.

[unite]

Well I think this should be easy but I cant seem to find the (tag) I want to show the (total downloads) on the index page. I just need the tag for it and I will place it in the code. Can anyone help... I have seen others sites with the stats showing on the index page but I cant find that mod either...

[mawenzi]

... you can find "total downloads" and other statistics here :
... http://www.4homepages.de/forum/index.php?topic=6484.msg28576#msg28576

[unite]

Yeah that's not exactly what I'm looking for and I cant read German. In the admin CP there is a stat for total downloads. I just need that bit of code so I can insert in on the index page.

[unite]

V@no can you help me with this? It seems simple enough I just cant seem to figure it out.

[V@no]

just install that mod and then use {total_downloads} in the templates...

[mawenzi]

... add this in your index.php ...

Code: [Select]

//-----------------------------------------------------
//--- Downloads ---------------------------------------
//-----------------------------------------------------
 $sql = "SELECT SUM(image_downloads) AS sum
         FROM ".IMAGES_TABLE;
 $row = $site_db->query_firstrow($sql);

 $sum = (isset($row['sum'])) ? $row['sum'] : 0;
 $total_downloads = $row['sum'];
 $lang_total_downloads = $lang['total_downloads'];
 
 $site_template->register_vars("total_downloads", $total_downloads);
 $site_template->register_vars("lang_total_downloads", $lang_total_downloads);
 unset($total_downloads);
 unset($lang_total_downloads);

... and use this in your home.html ...

Code: [Select]

{total_downloads}