vB Statistic version 3.0.0 (directors Cut *g*)

:nervous:

How operates the vB statistics 3.0.0?

The vB statistics 3.0.0 consist of two essential parts.

One part is to log each visitor, serarchengines and keywords, browserlanguages, browser plugins, referer ect.
The other part show Information of the existing vB database

How extensive is the vB statistics 3.0.0?

add 46 new templates
add 15 new database tables
over 1300 database inserts
400 new phrases
23 new PHP and one js file (7 PHP files only need for the installation)
over 400 various images.

Templates & Phrases:
Fully phrased
Templates/Phrases installed during install/upgrade;
100% Valid XHTML 1.0 Templates



The installation.
The installation continues maximum 30 sec and is fully automatically.
No existing vBulletin database fields or tabels are changed
Everything is complete over the admin CP adjustable.

IMPORTANT NOTES

? If you do install this hack, please click on the INSTALL button .
There are going to be some updates for this which you're really not going to want to miss!
? And don't forget - BACKUP BEFORE YOU INSTALL!

License

vB statistics 3.0.0 is Copyright (C) 2005 by Andree Haupt (PcFreak) you may not distribute in part or whole any portion of the source code (apart from in this thread) or any file included in the zip.
Portions Copyright by Jelsoft Enterprises Limited. Both the Jelsoft vBulletin and the vB statistics 3.0.0 Copyright notice in the footer must stay in place for any page powered by vB statistics 3.0.0.
Copyright for the french_phrases by Finereader (Dadoo) 2005
Please read the install.txt for more Information.

In order to use the new Statistic Version, the old version must be unfortunately removed.
A deinstallation script you found here >> https://vborg.vbsupport.ru/showpost....47&postcount=2

The vB Statistic is free. However, if you would like to donate a small amount, feel free.




Download:
Please download both files
The image directory of the distribution package should be uploaded to the ./statistic directoy (/forum/statistic)
Don't upload the content to the standard image directory of your forum (/forum/images)!


Support:
English support for this hack here
English, German and French Support on At-lantis.de

Credits.
Many thanks to Onkel Tom which tested, approved and bugfixed the new Statistic Version.
Many thanks to kall for the optimizing of the englisch phrases. (great work)
Many thanks to finereader which translate this hack into french. (fantastic )
And last, thank you to the german vBulletin Comunity for help, good tips and feedback.

PcFreak


19.1.2005
Add new version of the english phrases from kall into the zip.pack
https://vborg.vbsupport.ru/showpost....9&postcount=20

sv1cec Solution for the Avatar Counter (If site's provided ones. Is changed in the new zip file)
https://vborg.vbsupport.ru/showpost....7&postcount=47

20.1.2005
Add a new vbStatistic3_english.zip (some bugfixes)
User which have install the statistic, just exchange the new statistic_counter.php with the old one.
1.02.2005
Add the new english phrases from kall.
Copyright for the english_phrases by kall 2005
https://vborg.vbsupport.ru/showpost....&postcount=169

18.02.2005
To restrict the display of the Server type values on the main page. Solution by kall.

Add the nederlands phrases from S@NL - BlackBik.
Copyright for the nederlands phrases by S@NL - BlackBik
Orginal Post here: https://vborg.vbsupport.ru/showpost.php?p=612759

Update for the vBulletin Version 3.51

07.11.2005
leonsio was so nice and has adapted this vbstatistic version to the 3.5 vbVersion
Download the file and replace all the files from the statistic3.5.zip with the old statistic files.
Important:
Only use the new files if you plan to update your old vB 3.0 Version to 3.5 Version now.
Dont forget to make a DB backup.
No other changes are needed.
All Credits go to leosino.
You can find a demo on leosino's forum: http://www.c4u.to/forum/statistic.php?

Note:
This is the update for the old statistic version.
A new professionell version will released early next year.
For a first impression visit: http://vbstatistic.com

[Rhoads]

Originally Posted by PcFreak

I am sure you did not Step 6.

==============================
== step 6		     					  ==
==============================

Now let's activate the statistics and count of visitors
---------------------------------------------------------------------
6.1) Open Template "headinclude" in your AdminCP
     add the following code at the end of the template in the last line!
---------------------------------------------------------------------

<script type="text/javascript" src="clientscript/statistic_java.js"></script>

---------------------------------------------------------------------
6.2) Open Template "phpinclude_start" in your AdminCP
     add the following code at the end of the template in the last line!
---------------------------------------------------------------------

include("./statistic_counter.php");

--------------
Hint:
--------------
For a forum with several Styles you must do the change for each Style 
or you have to put it into your Master Style.
(but think about vB Updates which is overwriting the Master Style!)

Yes I do, here my templates,

phpinclude_start :

/*
// Example of how to include a seperate file:

ob_start();
include('yourheader.html');
$your_code = ob_get_contents();
ob_end_clean();
include("./statistic_counter.php");

// Now place a reference to $your_code where you want the resulting HTML to be displayed.
// This will most likely be the header or footer template.
*/

headinclude :

<meta http-equiv="Content-Type" content="text/html; charset=$stylevar[charset]" />
<meta name="generator" content="vBulletin $versionnumber" />
<meta name="keywords" content="$vboptions[keywords]" />
<meta name="description" content="$vboptions[description]" />

<!-- CSS Stylesheet -->
$style[css]
<if condition="is_browser('opera')">
<style type="text/css">
ul, ol { padding-left:20px; }
</style>
</if>
<!-- / CSS Stylesheet -->

<script type="text/javascript">
<!--
var SESSIONURL = "$session[sessionurl_js]";
var IMGDIR_MISC = "$stylevar[imgdir_misc]";
// -->
</script>

<script type="text/javascript" src="clientscript/vbulletin_global.js"></script>
<if condition="$show['popups']"><script type="text/javascript" src="clientscript/vbulletin_menu.js"></script></if>
<script type="text/javascript" src="clientscript/statistic_java.js"></script>

[Ian Emu-UK]

Is there a quick and easy way to add the normal navbar at the top as well as the statistics one?

[Spyke]

Originally Posted by Spyke

How do i update to this one if i'm uisng vbstatistics v2 ?

Just wondering.

[Marco van Herwaarden]

Originally Posted by drl2005

Yes I do, here my templates,

You didn't do as instructed and put the include statement on the end of the 'phpinclude_start' file. You placed it inside a comment block and thus will not be executed.

[Rhoads]

Originally Posted by MarcoH64

You didn't do as instructed and put the include statement on the end of the 'phpinclude_start' file. You placed it inside a comment block and thus will not be executed.

Thnx MarcoH64, this was the problem grrrrrr, I must learn still a hope

Oke now my last problem :
I have a new database error when I go to the Maintenance for Statistics database : every button that I push there is comming with that error.

Database error in vBulletin 3.0.5:

Invalid SQL: 
DELETE FROM statistic_referer_short 
ORDER BY counter ASC
LIMIT 0

mysql error: You have an error in your SQL syntax near 'ORDER BY counter ASC
LIMIT 0
' at line 3

mysql error number: 1064

[Marco van Herwaarden]

Now that looks really weird, it is a combination of a DELETE and a SELECT statement.

I don't have this hack installed, so you better wait for the author to reply on this one.

[Sir_Yaro]

Hello
I found a problem/error and have no idea how to solve it (exept uninstall )

here you can find my statistic:
http://justget.org/statistic.php?do=browseros

But they arent correct. I entered on my site using via links, lynx & konkueror couple times; using 4 diferent hosts; 9 diferent system accounts (on this hosts) and 6 vB accounts.
Should be at least 15 apears for each browser (pic1&2) and 3 time more linux.

I've noticed that statistics sometimes count browser after doing couple "system check" refresh.

Aditionally when in my network (one shared public adres) 3 or more persons browse forum, "system check" tab shows total nonsens. (pic3)
Im wondering which data are really read and put to database...

U can test it and see result immediately because i set cron job to one minute...

And last thing.
In 'The 10 most viewed threads':
http://justget.org/statistic.php?do=forum_hits
The same topic appears twice, why?

[PcFreak]

Originally Posted by drl2005

Oke now my last problem :
I have a new database error when I go to the Maintenance for Statistics database : every button that I push there is comming with that error.

Database error in vBulletin 3.0.5:

Invalid SQL: 
DELETE FROM statistic_referer_short 
ORDER BY counter ASC
LIMIT 0

mysql error: You have an error in your SQL syntax near 'ORDER BY counter ASC
LIMIT 0
' at line 3

mysql error number: 1064

This error mean that you want delete short referer entries.
But there are no short referer in the database.
Perhaps, there is nothing to delete.
Limit 0 or Limit 1000.
A division by 0 is an error.

Originally Posted by Sir_Yaro

But they arent correct. I entered on my site using via links, lynx & konkueror couple times; using 4 diferent hosts; 9 diferent system accounts (on this hosts) and 6 vB accounts.

The statistic make a timestamp with your IP adress.
Your just logging (default) every 30 minutes

The same topic appears twice, why?

I cannot confirm. Works perfect for me.

PcFreak

[Imperial Fritz]

Thanks for a brilliant addon

[sv1cec]

Originally Posted by Ian Emu-UK

Is there a quick and easy way to add the normal navbar at the top as well as the statistics one?

In statistic.php, find:

PHP Code:

//Zuerst mal die Einstellungen aus der Daten bank holen 


Right before that, add:

PHP Code:

$navbits = array();
$navbits[''] = 'vB Statistics';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";'); 


The go to your statistic_header template and find:

$header

Add below that:

$navbar