The Arcive of Official vBulletin Modifications Site.

vB Statistic version 3.0.0 (directors Cut *g*) · **Released**: 01-17-2005

: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

bkaul · #**152** 01-27-2005, 10:04 PM

Threads in hidden forums are shown to users who don't have access when listing the top replied to threads, etc. - this is a *BIG* flaw for anyone with "secret" subforums!

Other than that, great add-on...

yinyang · #**153** 01-27-2005, 10:54 PM

Quote:

Originally Posted by kall

Did you do the include thing for the statistic_counter.php file?

Check your error logs if you did, it may be trying to call it from the wrong place, in which case you would need to change the path.

thanks kall. i went through and everything is where it should be. and it still doesn't work. *sigh*

Sir_Yaro · #**154** 01-27-2005, 11:21 PM

PcFreak you shoud say that its SO easy to add new browser to statistic code....
just add

Code:

elseif(strpos($agent, 'links') !== false)  $browser = "Links";

under

Code:

elseif(strpos($agent, 'mozilla') !== false)  $browser = "Mozilla";                                                          //Mozilla

in statistic_browser_os.php file

Regards

Viks · #**155** 01-27-2005, 11:57 PM

Thanks PCfreak.

Installed on vb3.0.x with no issues

Thanks Kall for showing how to hide sever details for selected users.

Viks

azher · #**156** 01-28-2005, 05:24 PM

Hello,

Is there some sort of caching feature I'm missing? If I haven't hit the stats page all day, it usually takes between 120-200 seconds to generate the page. After that lag, the pages usually load up a bit quicker but this could definitely benefit from some form of a statscache.

PcFreak · #**157** 01-29-2005, 07:49 AM

Quote:

Originally Posted by azher

Hello,

Is there some sort of caching feature I'm missing? If I haven't hit the stats page all day, it usually takes between 120-200 seconds to generate the page. After that lag, the pages usually load up a bit quicker but this could definitely benefit from some form of a statscache.

This could be an other Problem (Performance Hit Since PHP 4.3.10 / 5.0.3)

Quote:

Originally Posted by kier from vBulletin

Many people have noticed that vBulletin (any a lot of other PHP applications) suddenly started to run significantly slowed than normal after installing PHP 4.3.10 or 5.0.3 in order to patch the security flaw in previous versions of PHP.

This cause of this slow-down has been identified as a problem with the unserialize() function in PHP. For more details, see bugs.php.net.

The full artikel you can read here: http://www.vbulletin.com/forum/showt...545#post801545

@Sir_Yaro
Ups. Sorry. It could be that i have forgot to define the Links Browser. I cant remember.

Quote:

Originally Posted by bkaul

Threads in hidden forums are shown to users who don't have access when listing the top replied to threads, etc. - this is a *BIG* flaw for anyone with "secret" subforums!

I cant confirm this.
I have make tests on my forum, but this funktion works well for me.
User without the permission to see a hidden forum cant see a hidden thread.

Perhaps, it could be you have not set the userpermission correctly or you have build new usergroups which have this permissions.
My tip. Check the userpermissions of your forum. I think, there is set something wrong.

PcFreak

Anarchy · #**158** 01-29-2005, 08:48 AM

Code:

Database error in vBulletin 3.0.6:

Invalid SQL: 
    	SHOW TABLE STATUS
    	FROM toontowncentral_com_-_database
    	LIKE 'pm'
    	 
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 '-_database
    	LIKE 'pm'' at line 2

mysql error number: 1064

Date: Saturday 29th of January 2005 04:50:21 AM
Script: http://www.toontowncentral.com/forums/statistic.php
Referer: 
Username: Nick
IP Address: 203.173.16.50

PcFreak · #**159** 01-29-2005, 09:16 AM

@Anarchy
in statistic/sides/forum.php found

PHP Code:


			
$pm_speicher_groesse = $DB_site->query("

        SHOW TABLE STATUS

        FROM $dbname

        LIKE '" . TABLE_PREFIX . "pm'

         ");

replace ist with

PHP Code:


			
    $pm_speicher_groesse = $DB_site->query("

        SHOW TABLE STATUS

        FROM $dbname

        LIKE 'pm'

         ");

This will fix this error (i hope)

(toontowncentral_com_-_database is not a good database name. This "-" is a the sign for subtraction. Better is to use this "_".)

Greets
PcFreak

Guy G · #**160** 01-29-2005, 09:35 AM

Is there uninstallation script as well?

Anarchy · #**161** 01-29-2005, 10:51 AM

Quote:

Originally Posted by PcFreak

@Anarchy
in statistic/sides/forum.php found

PHP Code:


			
$pm_speicher_groesse = $DB_site->query("

        SHOW TABLE STATUS

        FROM $dbname

        LIKE '" . TABLE_PREFIX . "pm'

         ");

replace ist with

PHP Code:


			
    $pm_speicher_groesse = $DB_site->query("

        SHOW TABLE STATUS

        FROM $dbname

        LIKE 'pm'

         ");

This will fix this error (i hope)

(toontowncentral_com_-_database is not a good database name. This "-" is a the sign for subtraction. Better is to use this "_".)

Greets
PcFreak

After much playing around, i back quoted the `$dbname`

This fixed the problem.

Maybe you want to add this to your next release.

Code:

 $pm_speicher_groesse = $DB_site->query("SHOW TABLE STATUS FROM `$dbname` LIKE 'pm'");

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05147 seconds Memory Usage 2,337KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (4)bbcode_code (4)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!