vb3 Statistic Version 1.01

vb3 Statistic

Many people had ask me when i release this hack?

The problem is, my english is bad and its hard for me, write a installations text.
So everyone feel free to help me with the instructions.

A live demo you found:
http://at-lantis.de/statistik.php

OK. Now we come to the hack.

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.

[The Geek]

Originally Posted by the nail geek

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']); 


Here are the other updated templates for english:

template name: statistik_referer
-------------------------

PHP Code:

<tr>
<td class="alt2" valign="top">
&nbsp;<a href="$referer_adresse">$referer_adresse
</a>&nbsp;($referer_summe Visitors)
</td>
</tr> 


template name: statistik_letztenbeitraege
-------------------------

PHP Code:

<tr>
    <td> <small><a href="showthread.php?$session[sessionurl]t=$beitragsid">$beitragstitel</a>
<br>
by<b><font color="#FF0000"> $geschrieben_von</font></b> posted 
<font color="#FF0000"><i>
$geschrieben_am</i></font> last reply from <b><font color="#663300">$letzte_antwort</font></b><font color="#996633"> </font>
posted 
<font color="#663300"> <i>$letzte_antwort_am</i></font></small><font color="#996633"></td>
</tr></font> 


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).

[The Geek]

Just updated a couple more country names I noticed I missed (Network and Commercial) go figure

BTW: havent mentioned it yet... but this is a kick ass hack.

[PcFreak]

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.

[Ming Keong]

Originally Posted by the nail geek

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.

Thanks..

[PcFreak]

Originally Posted by the nail geek

but this is a kick ass hack.

Is this good or bad?

[The Geek]

Originally Posted by PcFreak

Is this good or bad?

very good

[The Geek]

Updated the English transaltion of the countries again (found 3 or 4 I had missed). I think I should have about 95% of them now.
https://vborg.vbsupport.ru/showpost....8&postcount=61

[Intex]

the_nail_geek - nice work . Amazing how quickly we can all get it done when a few people help out.

PCFreak - Yeah new stats look good. Let me know if you want any translation doing prior to release. I'm sure the_nail_geek will also help out too .

[PcFreak]

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

[Intex]

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!

Could you investigate. Cheers.