[Mod] More Statistics for your visitors

[Stoleti]

I'm using a MOD (Files List 1.3) by V@no , and i want know how can i added the number of files on STATS !?

Total Files : XX

 :

And make it only for Admin / Reg. Members 

[lemccoy]

I have the guestbook mod and i have made a counter for the number of guestbook entries:

Code: [Select]

//-----------------------------------------------------
//--- Guestbook Signatures-----------------------------
//-----------------------------------------------------
$sql = "SELECT SUM(comment_id) AS sum
         FROM ".GUESTBOOK_TABLE;
 $row = $site_db->query_firstrow($sql);

 $sum = (isset($row['sum'])) ? $row['sum'] : 0;
 $total_signatures = "".$lang['total_signatures']."<B> ".$row['sum']."</B>\n";
 
 $site_template->register_vars("total_signatures", $total_signatures);
unset($total_signatures);

With the corresponding language and calls etc.  However, when it counts it counts deleted posts as there.  I know because I made an entry, deleted it, made another entry.  It now says there are 2 instead of 1.  Is there a better variable to count than the "comment_id"?

[IcEcReaM]

Code: [Select]

//-----------------------------------------------------
//--- Guestbook Signatures-----------------------------
//-----------------------------------------------------
$sql = "SELECT COUNT(comment_id) AS sum
         FROM ".GUESTBOOK_TABLE;
$row = $site_db->query_firstrow($sql);

$sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_signatures = "".$lang['total_signatures']."<B> ".$row['sum']."</B>\n";

$site_template->register_vars("total_signatures", $total_signatures);
unset($total_signatures);
you should use COUNT instead of SUM,
so the number of entries is outputed and not the sum of the comment_id.

[lemccoy]

Great, that works.  Thanks.

[fish4carp]

Hi

Where abouts do I place the following below in the home.html, categories.html, lightbox.html & top.html, Thanks. 

Gallery Statistics
{total_users}
{total_votes}
{total_comments}
{total_hits}
{total_downloads}
{total_rating}

[IWS_steffen]

toller MOD

klappt alles super. Danke

Gruüsse aus Hamburg

Steffen

[fish4carp]

To Vraxor

Please can you tell me how you edited your home.html etc so it shows the Site Statistics
 like you have them.

Thanks

[Zyga]

meybe someone could help me show number of registered users only for admin ?

[mstgokcen]

is anyone put this code to show total images...I get the code total categories but still there is no code for total images...

[CharlieF.]

Hi,
the mod works great.

The only thing is that the stats won't show up on the details, member and search sites.

Here's how i tried to implement it:

Code: [Select]

<table width="100%" border="0" cellspacing="0" cellpadding="0">
   <tr>
   <td class="head1">
   <table width="100%" border="0" cellspacing="0" cellpadding="3">
    <tr>
    <td class="head1" valign="top" background="{template_url}/images/top_bg.gif">Statistik</td>
    </tr>
    <tr>
    <td class="row2" valign="top">
{total_users} <br />
{total_votes} <br />
{total_comments} <br />
{total_hits} <br />
{total_downloads} <br /></td>
    </tr>
   </table>
   </td>
   </tr>
  </table>
The strange thing is that "Statistik" is displayed on every page just the stats themselves do not.
I'd appreciate any help.

regards
Charlie

[mawenzi]

@ CharlieF.
... you must insert the following in your details.php, member.php a.s.o ...

Code: [Select]

include(ROOT_PATH.'includes/stats.php');


[CharlieF.]

Thanks mawenzi.
For some reason i just forgot that in these files.
Again, thanks alot

[mstgokcen]

is anyone put this code to show total images...I get the code total categories but still there is no code for total images...

how can we see total images?

[mawenzi]

@ mstgokcen

... all total images on index ... 
... in stats.php use this ...

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'];
  $lang_all_total_images = $lang['all_total_images'];
  $site_template->register_vars("all_total_images", $all_total_images);
  $site_template->register_vars("lang_all_total_images", $lang_all_total_images);
  unset($all_total_images);
  unset($lang_all_total_images);
//-----------------------------------------------------

... in /lang/<your_lang>/main.php use this ...

Code: [Select]

$lang['all_total_images'] = "Total Images :";

... now you can use in home.html this tags ...

Code: [Select]

{lang_all_total_images} {all_total_images}


[mstgokcen]

tnx a lot it is ok