How do you add total image hits to the main index page

[cam101]

Hi there, was just wondering if anyone knows how to add the total images hit number that is displayed in the control panel, on the main index page, i am typing it in manualy at the moment but its getting tedious and i am sure there must be a way.

[mawenzi]

1. All Images
... add this in your index.php ...

Code: [Select]

//-----------------------------------------------------
// --- All total images -----
//-----------------------------------------------------
  $sql = "SELECT COUNT(*) AS all_total_images
          FROM ".IMAGES_TABLE."
          WHERE image_active = 1";
  $row = $site_db->query_firstrow($sql);
  $all_total_images = $row['all_total_images'];
  $site_template->register_vars("all_total_images", $all_total_images);
  unset($all_total_images);
//-----------------------------------------------------

... then you can use this in your home.html ...

Code: [Select]

All images : {all_total_images}

2. All Image Hits
... add this in your index.php ...

Code: [Select]

//-----------------------------------------------------
// --- All Image Hits -----
//-----------------------------------------------------
  $sql = "SELECT SUM(image_hits) AS sum
          FROM ".IMAGES_TABLE;
  $row = $site_db->query_firstrow($sql);
  $total_image_hits = $row['sum'];
  $site_template->register_vars("total_image_hits", $total_image_hits);
  unset($total_image_hits);
//-----------------------------------------------------

... then you can use this in your home.html ...

Code: [Select]

All image hits : {total_image_hits}


[cam101]

sorry for the quick reply. I was actually looking to display the total number of "image hits" within the site, as displayed in the Administration panel rather than the actual Total images contained within the site.

I'm sure its just a case of altering variables, but as i've only recently started using the package i'm still unsure. Your help is appreciated, thanks.

[mawenzi]

... sorry , I was too fast ...  ...
... I updated my post above ...

[cam101]

Thanks for your quick reply and the code you have posted works but there is an error, not sure how to post this but in the first line i had to change it to get it to work. You had put   $sql = "SELECT SUM(total_image_hits) AS sum and i had to change it to this to get it to work $sql = "SELECT SUM(image_hits) AS sum  

Only writing this in case anyone else views this topic.
Thanks for your help, Problem solved.   

[HorrorCrafT]

mawenzi, sag mal schläfst du auch mal?

with "$sql = "SELECT SUM(image_hits) AS sum" it works perfect! thx!

[mawenzi]

@ HorrorCrafT
... danke der berechtigten Nachfrage ...
... dafür bin ich demnächst für 'ne Weile verschwunden ...