Please make a backup of your database, before installing this hack
This hack will show you an extra side with some Stats.
- show Summary stats
- show the Browser/Os System of the users
- show the countrys (countrys by Hoster and Countries by browserlanguage)
- show the last 10 threads
- show the last 20 top referers
- show spiders and crawlers
- Forum book of records (new)
- Statistic for the last ten days (new)
and many, many other interesting counts
Files to edit
Just one template
New files
4 new php files
6 templates
a lot (but very small) images
Database changes
six new tables
I will try to give support for this hack
BIG UPDATE ( to version 1.01)
Upload a new zipfile 11. June 2004 Reason
I have fix some bugs
The images Bhutan will show now. (If you install the old version you must change in table _statistik_laender under id 31 the flagge_link for Bhutan from images/statistik/flaggen/butan.gif to images/statistik/flaggen/bhutan.gif manuelly)
some templates are optimzed (Thank you obsidian and Zelda King)
I have modified the code for the last 10 threads (thanks go to Mystics from vBulletin Germany)
Now theads just show from the forum ids for all forums user is allowed to view.
fix some other little bugs
PcFreak
New
Statistic Version 2.0 is finish.
I will release the new version later this day.
I give no more support for the Version 1.01.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
I think I found the problem with the elongated bars... the calculations are not correct when you use results from number_format. I changed those to intval and it calculates correctly now:
Here is the area I changed... hope I havent missed any:
PHP Code:
//##################################################################################################
//## Auswertgung einger Top Resulte START
//##################################################################################################
$alle_beitraege = $DB_site->query_first("SELECT COUNT(*) as beitraege FROM " . TABLE_PREFIX . "post ");
$alle_beitraege = intval($alle_beitraege['beitraege']); //alle Beitr?ge
$alle_themen= $DB_site->query_first("SELECT COUNT( * ) as themen FROM " . TABLE_PREFIX . "thread ");
$alle_themen = intval($alle_themen['themen']); //alle Themen
$alle_user= $DB_site->query_first(" SELECT COUNT( * ) as benutzer FROM " . TABLE_PREFIX . "user ");
$alle_user = intval($alle_user['benutzer']); //alle Benutzer
$alle_pm= $DB_site->query_first("SELECT COUNT( * ) as pm FROM " . TABLE_PREFIX . "pm ");
$alle_pm = intval($alle_pm['pm']);
I also translated most of the countries that I could be bothered with (damn there are a few!)... here is the english table create and inserts. I am sure there are a few countries that I missed (or maybe got wrong).
I will update the zip.file later this day.
I have build more statistics (see them on my statistic Site) http:at-lantis.de/statistik.php
Now the statsitik show New are
- Statistic from the last 10 days
- Book of records
- Server and mysql infos
In the next update i hope every errors are eliminated
PcFreak
Click on install, so i can inform you about the new update.
use the updated template that intex put up about 4 posts back... the reason is that the template is the english... then the german for some reason.
Intex's updated template has only the english.
I udate a new zip.file in few minutes
The countrienames was translated. I have just upload the german functions_statistik.php and the german countrytables.
I have check my zipfile several times.
I think now it´s perfekt
PCFreak - I've discovered a problem. In the country stats there are stats for United Kingdom as well as Great Britain. These are the same country . What's funnier is the stats are different slightly too!