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.

[Vivi Ornitier]

templates911: I'm runnin it on vb3.0.0 and it's fine besides the table stretching

PcFreak: It's the same tables in those screenshots, it's the avatar tables.

http://forums.squareultima.com/statistik.php

[PcFreak]

I have fix this problem
Udate the zip.file very soon
PcFreak

[58sniper]

Okay, one problem I had was the referer links were fairly long, and were pushing the 'referer summary' box off the screen to the right. Here's how I fixed it:

in statistik.php, find

$referer_summe	= $top_referer['Zaehler'];

and paste this underneath:

$referer_short = substr($referer_adresse,0,50);

and then, in the statistik_referer template, replace the entire thing with

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

Also, the font surrounding the copyright doesn't match everything else. In the statistik_hauptseite template, I changed

<font face="Times New Roman">? by PcFreak</font>

to

? by PcFreak

although I don't see the reason for the copyright to appear so many times...

see my example (I've cleaned up some other things as well - just to suite my taste)

one thing that I'm still working on is the location that's reported in online.php. Currently, if you're viewing statistik.php, online.php reports "LOCATION UNKNOWN" with a link to statistik.php.

[PcFreak]

To show the statistic in online.php

Open the file includes/functions_online.php
find

PHP Code:

        default:
            if ($permissions['wolpermissions'] & CANWHOSONLINEBAD)
            { 


above add

PHP Code:

// ##### Statistik Start #####
        case 'statistik':
            $userinfo['action'] = 'View the statistic and think about Winston Churchill';
            $userinfo['where'] = "<a href=\"statistik.php\">$vboptions[bbtitle] Statistik</a>";
            break;
// ##### Statistik Ende ##### 


find

PHP Code:

    default:
        $userinfo['activity'] = 'unknown';
    }

    return $userinfo; 


above add

PHP Code:

// ##### Statistik Start #####
    case 'statistik.php':
        $userinfo['activity'] = 'statistik';
        break;
// ##### Statistik Ende ##### 


Thats all

@58sniper

Your Stats looks nice.
I have no problem with the copyright. One ?PcFreak on you side is enough. (make me a little bit proud )

Thank you for this mod

PcFreak

[58sniper]

Thanks. I've made that change (among others), and it's working fine.

Great hack!

Also, something else that some might like:


in the navbar template (in some themes, this could be in the header template instead):

find

<if condition="$show['admincplink']"><a href="$admincpdir/index.php?$session[sessionurl]">$vbphrase[admin]</a> -</if>

and replace with

<if condition="$show['admincplink']"><a href="$admincpdir/index.php?$session[sessionurl]">$vbphrase[admin]</a> - <a href="$vboptions[bburl]/statistik.php?$session[sessionurl]">Statistics</a> -</if>

that will put a link to the statistics down at the bottom along with the link for your admincp. Just a thought.

[gmarik]

Rather simple. Add most visitors @ hour ...

[PcFreak]

Do not referer you own domain.
In statsitik_counter find

PHP Code:

// Der User hat einen Link auf dem Board angeklickt, dann wird nichts eingetragen.                    
    if (strpos(strtolower($DER_REFERER), 'at-lantis.de') === false)
    { 


Replace 'at-lantis.de' with your own domain. Example: 'my-domain.net'

So your own links are not showing in the top referer part.

PcFreak

[Mijae]

A question before I install this...how many queries does this generate? On statistik.php? How many queries does it add to other forum parts, if any?

[PcFreak]

Originally Posted by Mijae

A question before I install this...how many queries does this generate? On statistik.php? How many queries does it add to other forum parts, if any?

On my statistics site (i have some futures more) the hack (the statistik.php) generate 35 queries. But most of them just select counters.

Here is the time for my statistik.php

Page generated in 0,42463 seconds with 35 queries,
spending 0.0515158176422 doing MySQL queries and -0.0515158176422 doing PHP things.


There are no other queries to other forum parts

PcFreak

[snyx]

Originally Posted by PcFreak

I hope this will help.

PcFreak

anyway to dump the browser stats and add "max user online, top reffers, top viewed threads, top replied threads" plus other board based stats?

this was the ultimate stat page, anyway to mod one like this..
https://vborg.vbsupport.ru/showthread.php?t=41421