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

[sv1cec]

Could you please explain to me what's the meaning of the last two lines shown below:

Total threads: 2,353
Total posts: 15,636
Hits: 518,888
Ø: 221 times <<<<<<<<
Thread replies: Ø 5.65 times <<<<<<<<

It's taken from the right column of the first page which appears when you run the statistics.

I assume the second is averate replies per thread, but I am not sure and I do not understand the first one.

Rgds

[Lizard King]

Awesome statistics. Easy to install and very detailed statistics. Well Done.

[yoyoyoyo]

Here is a quick & dirty way to integrate the stats page in to your ACP:

In your admincp/index.php file find

PHP Code:

//##### Statistic 3 by PcFreak START #####
        $printhr = true; 


add below:

PHP Code:

        construct_nav_option('STATISTICS', '../statistic.php?', '<br />'); 


nothing too fancy, but it works. You can obviously put it wherever you want in your statistics ACP menu, and you can call it whatever you want. Again- I realize this isn't groundbreaking, but I thought one or two newbies like myself might find it useful.

[MissKalunji]

when i got to my statistic it says...
Forums online since: 12-31-1969 at 19:00 (12813 days)
This forum was installed by:

???????? how i can fix it?

[Lizard King]

Is there a way for me to see the second domain statistics in a different part like
xxxxxx.com page hits : 150.000
yyyyy.com page hits : 25.000
Is this possible ?

[jeepinator]

This is the best hack I've ever seen!
It's working great. Thank you very much.

Originally Posted by TheVirus

Hey dude, I'm working on a new image pack for you...will send it to you when it's done.

Waiting anxiously :lick:

[hXc Radio]

A lot of things are not working for me. I have no refer sites and no hits since installed, but 42 of my members have been online today.

I thought of trying the cron script manually and received this error...

Fatal error: Call to a member function on a non-object in /home/hxcradio/public_html/forum/includes/cron/statisticupdate.php on line 20

[hXc Radio]

I also ran $DB_site->query("
OPTIMIZE TABLE " . TABLE_PREFIX . "statistic_log , " . TABLE_PREFIX . "statistic_log_java , " . TABLE_PREFIX . "statistic_status"); in phpmyadmin just now... but still no updating

[kall]

I have further cleaned up the English translation, especially in the AdminCP, to make things a bit more understandable now that I understand what it all does.

To "upgrade", just backup your database/download your current language file, unzip the .xml in this zip and go to your AdminCP - Languages and Phrases - Download / Upload Languages and browse to it and upload it into your existing English language.

To see the 'new translation' in action: http://forums.nzboards.com/statistic.php (I have edited the STATISTIC template slightly to change the names of the 'Type' column on the right..if anyone wants the changes, I will post them here)

If you don't like it, just upload the language .xml you backed up prior.

[Harley77]

Any idea as to why all I get now when trying to open the Stats page is this:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT COUNT(*) AS forums
FROM forum
WHERE forumid IN(1, 4, 3, 19, 26, 38, 10, 6, 33, 35, 7, 18, 9, 8, 32, 11, 12, 13, 22, 36, 20, 21, 37, 0)

mysql error: The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok

mysql error number: 1104

I've completely uninstalled and reinstalled with no change. The only hacks I've installed recently since this started was the gift and ribbon hack for the store.