[MOD] YaSt - Yet another Statistic Tool - Statistic Mod v1.01

[IcEcReaM]

how do you mean that?
There is already an option to show the top images by hits.
or do you mean a monthly stats?
then it is not possible without more modifications,
cause the hits doesn't get count by month.

[koikonut]

I installed the statistics mod and modified the template. I put everything in two columns everything above each other. Now when I see  the statistics.php there is a big space in the right column and I really don't know why. Perhaps you could take a look and help me

The page: http://www.konradin.net/galerie/statistics.php

The template Code:

Code: [Select]

{header}
<h2>Kategorien</h2>
{categories_list}
</div><!-- divID left -->
<div id="content">
<h2>{site_name}</h2>
<br />
<div class="kasten">
<div>

      {if stats_overview}
      <h3>{lang_langstats_overview}</h3>
      <table width="100%" border="0" cellspacing="3" cellpadding="3" class="row2">
         {stats_overview}
      </table>
       <br />
      {endif stats_overview}

   <table width="100%">
    <tr>
<td width="50%">
{if stats_user_stats}
{lang_langstats_userstats}
{stats_user_stats}
{endif stats_user_stats}



{if stats_commentstats}
{stats_commentstats}
{endif stats_commentstats}


{if stats_topuploaders}
{stats_topuploaders}
{endif stats_topuploaders}



{if stats_topusersnewusers}
{stats_topusersnewusers}
{endif stats_topusersnewusers}



{if stats_toppostcardssenduser}
{stats_toppostcardssenduser}
{endif stats_toppostcardssenduser}



{if stats_topimagehitsfromuser}
{stats_topimagehitsfromuser}
{endif stats_topimagehitsfromuser}



{if stats_topimagevoter}
{stats_topimagevoter}
{endif stats_topimagevoter}



{if stats_topusersshouted}
{stats_topusersshouted}
{endif stats_topusersshouted}



{if stats_topuserslastaction}
{stats_topuserslastaction}
{endif stats_topuserslastaction}
<br />
<br />
  </td>



<td width="50%">
{if stats_votestats}
{stats_votestats}
{endif stats_votestats}

{if stats_topagegroups}
{lang_langstats_topagegroups}
{stats_topagegroups}
{endif stats_topagegroups}



{if stats_imagestats}
{stats_imagestats}
{endif stats_imagestats}



{if stats_topdownloaders}
{stats_topdownloaders}
{endif stats_topdownloaders}



{if stats_topcommenter}
{stats_topcommenter}
{endif stats_topcommenter}



{if stats_toppostcardsfromuser}
{stats_toppostcardsfromuser}
{endif stats_toppostcardsfromuser}



{if stats_topimageratingsfromuser}
{stats_topimageratingsfromuser}
{endif stats_topimageratingsfromuser}



{if stats_topimagevotedfromuser}
                 {stats_topimagevotedfromuser}
          {endif stats_topimagevotedfromuser}
 
 
 
   {if stats_topusersprofilehits}
                 {stats_topusersprofilehits}
          {endif stats_topusersprofilehits}
 

 
   {if stats_topcommented}
                          {stats_topcommented}
          {endif stats_topcommented}
</td>
</tr>
   
   </table>
   <br />
   <br />
<div align="center">Statistics {stats_version} by IcEcReaM</div>
<!--  Please don't remove the copyright    -->
<!--  Statistics v1.0 (c)2006 by IcEcReaM  -->
     
</div>
</div>

{copyright}
<br />
</div> <!-- DivID content -->
<div id="right">
{footer}
Bye, thank you very much

[gustav]

How can I I show useravatars instead of userimages? Guess most users will use avatars to identify themself on a site instead of using a custom userpic.....
Maybe like.... If no userpic then show useravatar... and if no userpic and no useravatar show nopic

And how can I disable specific users from being counted or shown in the stats?

Would be great if somwone could figure out how to do it...

[timerex]

hallo,

wann wird es den mod für die online zeit geben?

mfg timerex

[stomka.net]

Hi
Greate mod


can you tel me how to add in statistics  funcion "Display all images added by... " (from member profil) neer user nick?

thx for replay

[chull]

hello,

I've copied all files into the several dictionaries. But when I want to open the statistics.php file, the page makes only a refresh and I can't see the statistics. What could be the problem?

Thanks and Greetz


Chull

[medo007]

I installed the mod and it works great but time is not displaying right!
Time is late for 6 hours!

Is there somethnig to modify like time offset or something?

Thanks

[Darkness2001]

[ Introduction ]
With this mod you have an extra site where some useful informations are provided in statistic form.

[ Features ]
Fully configurable
Depending on which mods you have installed several display options can be turned on/off

[ Changed Files ]
lang/<your language>/main.php
(for some additional infos you have to modify more files)

[ New Files ]
templates/statistics.html
templates/statistics_memberbox.html
templates/statistics_monthbox.html
statistics.php

[ Installation ]
Download the rar archive.
unpack the files.
follow the installation note.
Configuration (important!)
Open the statistics.php and edit/modify in the head of the file your settings,
depending on your installed mods.
If you get sql error messages then you have not configured the settings part probably.

A Demo can be seen here: Demo Link

Download here
You can register your own account (no email verification is needed)
or login in with 4images/4images.

Have Phun.

Update Version 1.01
Added the mode parameter,
cause for some users the displayed site is too large,
so you can split up the statistics php.
Only the for the needed infos the querys will be executed to save some ressources.
changed files:
statistics.php
statistics.html

From installation note:
you can call the statistics.php with 3 different mode parameters.
e.g. statistics.php?mode=xxx
for xxx there are 3 modes available:
all: show all options
topusers: shows only the topuser statistics
stats: shows only the main statistics



P.S.: Thanks to my Betatesters (JensF,trez,ivan,Vincent,Loda) who provided me some errors which has been fixed now.

14.03.2006 Updated the Archive: dutch language file added (thx to wallpapers)
15.03.2006 Updated statistics.php v1.01 // added mode parameter
16.03.2006 Updated statistics.php v1.01 // added config option: show admin values in top users statistics on/off

Hallo,

kann mir jemand die unktionierende zip Datei senden ?
Die auf der Seite ist kaputt bzw. Fehler beim entpacken.

Danke und Grüße Darkness

[medo007]

I installed the mod and it works great but time is not displaying right!
Time is late for 6 hours!

Is there somethnig to modify like time offset or something?

Can someone help me? Please? Anyone?!? 

[mariano]

It's a great mod i'm very happy with it. I use part of it as a "top users"

It is possible to add top users by average comments/images and top users by average views/images
Im not a PHP coder... I think this features can show well who are the best photographers uploading picture to my site.

thanks!
Sorry by my english...

[skiemor]

very nice MOD! Thank you!!!!

[Jasi]

@ IcEcReaM

erst einmal danke und ein großes Kompliment auch für diesen (Statistic Mod v1.01) tollen MOD von dir !

Meine Frage:

wo bekomme ich den MOD Onlinetime

( define('STATS_SHOW_TOPUSERS_ONLINETIME',0);  // displys Top User by Onlinetime spent in Gallery )

dazu her?

Kannst du mir den MOD bitte mit Anleitung posten!

Das wäre sehr nett

Schon mal vorab besten Dank und

Gute Grüße

Jasi

[Jasi]

@ ivan,

Hallo ivan,

danke dir für die Info,  ich hatte leider nicht nachgesehen wann IcEDreaM zuletzt online war!

Vielleicht findet sich ja jemand der den Onlinetime-MOD hat?

THX Jasi

[happyfeet]

hab das jetzt eingebaut und bekomme diese meldung:

DB Error: Bad SQL Query: SELECT COUNT(*) AS count_guestbook_entries FROM GUESTBOOK_TABLE
Table 'wef07.GUESTBOOK_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT COUNT(*) AS count_shoutbox_entries FROM SHOUTBOX_TABLE
Table 'wef07.SHOUTBOX_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT SUM(image_postcards) AS sum FROM 4images_images
Unknown column 'image_postcards' in 'field list'

DB Error: Bad SQL Query: SELECT vote_time FROM VOTED_TABLE WHERE vote_time > 1167606000
Table 'wef07.VOTED_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT (YEAR(CURRENT_DATE ) - YEAR( birthday)) - ( RIGHT( CURRENT_DATE, 5 ) < RIGHT( birthday, 5 ) ) AS age, COUNT( * ) AS age_hits FROM 4images_users WHERE birthday != '0000-00-00' AND user_id <> -1 GROUP BY age ORDER BY age ASC LIMIT 40
Unknown column 'birthday' in 'field list'

DB Error: Bad SQL Query: SELECT COUNT(i.image_id) AS user_topuploaders, u.user_name, u.user_id ,u.userpic FROM 4images_users u LEFT JOIN 4images_images i ON (i.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY user_topuploaders DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'

DB Error: Bad SQL Query: SELECT user_id,user_name,image_downloads ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY image_downloads DESC, user_id ASC LIMIT 5
Unknown column 'image_downloads' in 'field list'

DB Error: Bad SQL Query: SELECT user_id,user_name,user_comments ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY user_comments DESC, user_id ASC LIMIT 5
Unknown column 'userpic' in 'field list'

DB Error: Bad SQL Query: SELECT COUNT(c.comment_id) as user_comments,u.user_id,u.user_name ,userpic FROM 4images_comments c LEFT JOIN 4images_images i ON (i.image_id = c.image_id) LEFT JOIN 4images_users u ON (u.user_id = i.user_id) WHERE i.image_active = 1 AND u.user_level > '-1' GROUP BY u.user_id ORDER BY user_comments DESC LIMIT 5
Unknown column 'userpic' in 'field list'

DB Error: Bad SQL Query: SELECT user_id,user_name,send_postcards ,userpic FROM 4images_users WHERE user_id <> -1 ORDER BY send_postcards DESC, user_id ASC LIMIT 5
Unknown column 'send_postcards' in 'field list'

DB Error: Bad SQL Query: SELECT SUM(i.image_postcards) AS top_postcards, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_active = 1 AND u.user_level > -1 GROUP BY u.user_id ORDER BY top_postcards DESC, u.user_id ASC LIMIT 5
Unknown column 'i.image_postcards' in 'field list'

DB Error: Bad SQL Query: SELECT SUM(i.image_hits) AS image_hits, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_active = 1 AND u.user_level > -1 GROUP BY u.user_id ORDER BY image_hits DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'

DB Error: Bad SQL Query: SELECT ROUND(AVG(i.image_rating),2) as avg_rating, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE i.image_rating != 0 AND u.user_level > -1 GROUP BY u.user_id ORDER BY avg_rating DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'

DB Error: Bad SQL Query: SELECT COUNT(v.image_id) AS vote_count, u.user_name, u.user_id ,u.userpic FROM VOTED_TABLE v LEFT JOIN 4images_users u ON (v.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY vote_count DESC, u.user_id ASC LIMIT 5
Table 'wef07.VOTED_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT SUM(i.image_votes) AS vote_sum, u.user_name, u.user_id ,u.userpic FROM 4images_images i LEFT JOIN 4images_users u ON (i.user_id = u.user_id) WHERE u.user_level > -1 GROUP BY u.user_id ORDER BY vote_sum DESC, u.user_id ASC LIMIT 5
Unknown column 'u.userpic' in 'field list'

DB Error: Bad SQL Query: SELECT COUNT(s.id) AS shout_count, u.user_name, u.user_id ,u.userpic FROM SHOUTBOX_TABLE s LEFT JOIN 4images_users u ON (s.usrid = u.user_id) WHERE u.user_id > -1 AND s.usrid != 0 GROUP BY u.user_id ORDER BY shout_count DESC, u.user_id ASC LIMIT 5
Table 'wef07.SHOUTBOX_TABLE' doesn't exist

DB Error: Bad SQL Query: SELECT SUM(profile_hits) AS profilehits_count, user_name, user_id ,userpic FROM 4images_users WHERE user_id > -1 GROUP BY user_id ORDER BY profilehits_count DESC, user_id ASC LIMIT 5
Unknown column 'profile_hits' in 'field list'

DB Error: Bad SQL Query: SELECT u.user_id, u.user_name, u.user_lastaction ,u.userpic FROM 4images_users u WHERE u.user_id > -1 ORDER BY u.user_lastaction DESC LIMIT 5
Unknown column 'u.userpic' in 'field list'

DB Error: Bad SQL Query: SELECT u.user_id, u.user_name, u.user_joindate ,u.userpic FROM 4images_users u WHERE u.user_id > -1 ORDER BY u.user_joindate DESC LIMIT 5
Unknown column 'u.userpic' in 'field list'

[paule]

Hallo,

ich habe den Mod eingebaut. Funktioniert alles gut... aber nur beim Download von ZIP Dateien zählt der Counter (im folder: Note 2 - User Download Counter Mod) alle Bilder des ZIP doppelt.

Hat jemand eine Idee?

Gruß paule