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

[PcFreak]

Originally Posted by nso

Is there any way to disable the parts that use Javascript?

Open Template "headinclude" in your AdminCP
del this line

PHP Code:

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


Originally Posted by nso

The Javascript increased my bandwidth usage with about 50%

hmm????
A 9kb file with 4 querys (normal 2 if the user counted) need so many bandwith?

You must have a board with one forum and one post and 10 vistors in the week. (If that, you have a bandwith from 100 kb the week)
Of course the javacountig need then between 30-40 kb.

This script use only 2 querys. (4 querys the User was not logged befor).
For a board with 1 Millon Users it?s need not more than 0.001% of the bandwith. But the srcipt work with ervery side refresh.
I think there must be a misunderstanding by your side. You interpret you server log not correctly.

Originally Posted by nso

Is there perhaps another script that only collects stats from the database, and not from utilizing Javascript?

It?s not possible to log resolution or plugins without javascrit (js)

PcFreak

[PcFreak]

Originally Posted by alderwazeh

First Many thanks for the auther of this hack...
Now getting this error although the hack has been successfully instaled ?!
when I move from the stat or the vb or CMPS it gives randomly this error massege ... when I refresh ..it disapear and the pages display normaly including the stat! what is the problem and how I can fix it ?

Warning: main(./statistic/statistic_spider.php): failed to open stream: No such file or directory in /statistic_counter.php on line 99

Fatal error: main(): Failed opening required './statistic/statistic_spider.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/alderwa/public_html/vb/statistic_counter.php on line 99

Have you upload the statistic_spider.php?
There must be in the statistic directory.
On line 99 of the statistic_counter.php this file is require.
But the spider.php is missing.

Tipp: Check your statistic directory.

PcFreak

[PcFreak]

Originally Posted by nso

Is there any way to disable the parts that use Javascript?
The Javascript increased my bandwidth usage with about 50% - something I'm not really interested in.

Is there perhaps another script that only collects stats from the database, and not from utilizing Javascript?

I will it better explain.
The statistic javscript is like a bypass.
This script is not more as an function.
The javascript started with every php. Always then, if you refresh a side.
In your logs you see then that each second file was loaded wich the javascript. (Ups thus 50% . From 10 files wich was loaded they are 5 javascript files?)

But that is not bandwith!!
The script no range bandwith.

It is possibel take the javacounter in a normal vBulletin.file.

But I imagined much more better is: Don?t touch the orginal vBulletin files.
It more simple to install this mod (and uninstall, of course . But that makes nobody Because this mod is simple great )

[wolfyman]

I'm running 3.0.7, it llooks like everything is working ok - EXCEPT the cronjob. when I go to mydomain.com/forum/includes/cron/statisticupdate.php I get this error:
Fatal error: Call to a member function on a non-object in /home/me/public_html/forum/includes/cron/statisticupdate.php on line 20

Help please

[nso]

Originally Posted by PcFreak

Open Template "headinclude" in your AdminCP
del this line

PHP Code:

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


Will this disable the javscript-required sections? I do not currently have the script installed, I deinstalled it, so I cannot check for myself.

hmm????
A 9kb file with 4 querys (normal 2 if the user counted) need so many bandwith?

What does queries have do to with bandwidth?
You do realize that with no-cache headers, the javascript does not get cached?

You must have a board with one forum and one post and 10 vistors in the week. (If that, you have a bandwith from 100 kb the week)
Of course the javacountig need then between 30-40 kb.

Users online: 117 (78 members and 39 guests) 
Users online the last 24 hours: 4668 (3644 members and 1024 guests)  
Most user online at the same time was 683, 3. February 2005 at 22:07. 

Threads: 31.567, Posts: 379.803, Members: 7.406

Bandwidth usage per day: ~1GB (increased to ~1,5GB the three days I had the hack installed)

Also the 'hits' (files sent from the server to the users) increased with about 50/100%.

This script use only 2 querys. (4 querys the User was not logged befor).
For a board with 1 Millon Users it?s need not more than 0.001% of the bandwith. But the srcipt work with ervery side refresh.
I think there must be a misunderstanding by your side. You interpret you server log not correctly.

Again, what does queries have to do with bandwidth usage? This is an increase in CPU-cycles, not the amount of bits and bytes transfered.

It?s not possible to log resolution or plugins without javascrit (js)

I am very well aware of this. I am not interested in logging that information. I'm simply interested in a script that shows top posters/top threads/top views/etc. (information that is allready located in the database)

[nso]

Originally Posted by T3MEDIA

Bandwith or server resources? I am asking not being sarcastic.

JavaScript is downloaded by the visitor and executed on the users computer - Downloading it does not increase the CPU-load any more than, say, a standard HTML-file.
It does however require bandwidth to download a file from an external server - that is also what I am saying.

All that aside, my Dual Xeon 2.4 GHZ dedicated server can handle a couple of filetransfers and/or queries before you start to see it's behaviour change

[PcFreak]

Originally Posted by by PcFreak in the first Post of this thread

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

If you want just show Information of the existing vB database .
Don?t activate the counter.

==============================
== 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");

Delete this lines.
But I do not understand nevertheless your JavaScript problem.
There are a lot of other js scripts active in vB. Even in the headinclude.

Or I have an understanding problem.
Did you mean java (not the Island or the coffee) or did you mean "js" (JavaScript)

@wolfyman
This is line 20 in your statisticupdate.php

PHP Code:

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "statistic_log_java    WHERE last_logtime < " . (TIMENOW - 3600)); 


I am not shure, why you get an error.
Have you del the statistic_log_java table in you db?

PcFreak

[Lionel]

I just got an email about the database. Notice that the referrer is yahoo, and the error is from homepage which was up (am sure of that) at the time it happened.

What should I make out of this database error?

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = 'haiti news\'

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''haiti news\'' at line 3

mysql error number: 1064

Date: Saturday 09th of April 2005 08:21:31 PM
Script: http://www.site.com/
Referer: http://search.yahoo.com/search?p=haiti+news%5C&ei=UTF-8&fr=FP-tab-web-t-224&fl=0&x=wrt
Username: Unregistered

[nso]

Originally Posted by PcFreak

There are a lot of other js scripts active in vB. Even in the headinclude.

Yes there is. And they all use bandwidth off course - like your javascript. Your javascript is massive and uses a lot of bandwidth on top of the allready required bandwidth.

Grosse file -> grosse bandwidth usage <-- semi deutch

[PcFreak]

Originally Posted by Lionel

I just got an email about the database. Notice that the referrer is yahoo, and the error is from homepage which was up (am sure of that) at the time it happened.

What should I make out of this database error?

Search in your /statistic/statistic_searchengines.php
(Line round 221)

found:

PHP Code:

$keyword_found = ereg_replace("'","",$keyword_found);      //Abfangen eines Fehlers der auftreten kann wenn ' Keyword vorkommt 


replace with:

PHP Code:

    $keyword_found = ereg_replace("'","",$keyword_found);      //Abfangen eines Fehlers der auftreten kann wenn ' Keyword vorkommt    
    $keyword_found = eregi_replace(""", "",$keyword_found); //Abfangen eines Fehlers der auftreten kann wenn \ Keyword vorkommt 


PcFreak