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

[SycoPhant]

Help please?

I get insane amounts of errors, it ran fine for several months. I had to rename the files in the root so they couldn't be accessed and I'm still getting this:

Database error in vBulletin 3.0.6:

Invalid SQL: DELETE FROM vb3_statistic_log	WHERE last_logtime < 1114394350
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 24th of April 2005 10:59:11 PM
Script: http://www.fordexplorer.net/cron.php?&rand=408354
Referer: http://www.fordexplorer.net/showthread.php?t=10771
Username: Polc16
IP Address: 141.133.161.51

Any ideas?

[duplu]

Originally Posted by SycoPhant

Help please?

I get insane amounts of errors, it ran fine for several months. I had to rename the files in the root so they couldn't be accessed and I'm still getting this:

Database error in vBulletin 3.0.6:

Invalid SQL: DELETE FROM vb3_statistic_log	WHERE last_logtime < 1114394350
mysql error: Got error 127 from table handler

mysql error number: 1030

Date: Sunday 24th of April 2005 10:59:11 PM
Script: http://www.fordexplorer.net/cron.php?&rand=408354
Referer: http://www.fordexplorer.net/showthread.php?t=10771
Username: Polc16
IP Address: 141.133.161.51

Any ideas?

It looks like there is an error in the table. Go into phpmyadmin on your server/site and bring up the 'vb3_statistic_log' table and then choose the repair option.

[SycoPhant]

Originally Posted by duplu

It looks like there is an error in the table. Go into phpmyadmin on your server/site and bring up the 'vb3_statistic_log' table and then choose the repair option.

Duh, why didn't I think of that. Worked, thanks!!

[kthlnwrnr]

Is there any way I can get this error fixed?

Database error in vBulletin 3.0.3:

Invalid SQL: ALTER TABLE language DROP phrasegroup_vbstatistic
mysql error: Can't DROP 'phrasegroup_vbstatistic'. Check that column/key exists

mysql error number: 1091

My installation stops when I get to the ./statistic_templates_install.php or the 3rd step of the installation. And when I go to uninstall the hack I get the above quoted error. Will appreciate any suggestion. Thnx

[wirewolf]

Good Grief!! Long thread to read through!
Clicks Install - on vBulletin 3.0.7, vBadvanced CMPS v1.0.0, Photopost PHP 5.02 vB3 Enhanced, and vBadvanced Links Directory v1.0.0

I installed this add-on this morning and just had a few problems. One, you have to be sure of the corrrect file path in the headinclude and the phpinclude_start:

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

I used this path in the headinclude:

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

I've had this problem before. I have Photopost and a Links Directry that sit outside of my forum directory. If your are on a page from either of those two, and you call for a script that resides in the forum directory, but the path info is wrong, then you might get something like this: http://mysite.com/photopost/statistic.php?do=forum instead of this http://mysite.com/forum/statistic.php?do=forum

Everything was going fine, until............. I have a little script on my site that emails me if there are any 404 page not found and other errors etc. When I opened up my mail client, I got no less than 170 '404 page not found, missing urls' emails from my server!!! I nearly fell out of my chair!! This was one of the refering pages that generated a missing url:

/photopost/showgallery.php/cat/statistic_java_counter.php?&colordepth=32?=5&resol ution=800x600&maxresolution=800x570&
cookies=true&flash=true&mediaplayer=true&java=true &shockwave
=true&realplayer=true&quicktime=true&acrobat=true& svg=false

I new my file path was set correctly above. So I tracked down the problem to the the statistic_java.js file itself. On line 113:

var plugins= "statistic_java_counter.php?&colordepth=" + colordepth +

Change to this:

var plugins = "/yourforumdirectory/statistic_java_counter.php?&colordepth=" + colordepth +

Problem solved!!

For phpinclude_start, this worked fine for me: include("./statistic_counter.php");

I did some editing of the statistic main page. For one thing, the permissions option in the Admin statistic setting doesn't seem to work. No matter what number I typed in, 0, 1, or 2, it made no change. So I added a template group conditional in the statistic's navbar so only I, my Mods, and Members can see the menu. I want visiters to see the first stats page, but I don't want them hitting those links (Browsers / Operating Systems | Country of origin and browser language, etc).
Group conditional array:

<if condition="in_array($bbuserinfo[usergroupid], array(2,5,6,7))">
--stuff you don't want visiters to see---
</if>

or:

<if condition="in_array($bbuserinfo[usergroupid], array(5,6,7))">
---stuff you only want seen by Mods, Admin, and Super Mods---
</if>

If you don't want visiters to view the stats page at all, then use this in the front of the statistic.php script, just after:

PHP Code:

// ########################## REQUIRE BACK-END ############################
    require_once('./global.php');
// ############################ NO ACTION ################################ 


Put this:

PHP Code:

if (!$bbuserinfo['userid'] OR !($permissions['forumpermissions'] & CANVIEW))
{
    print_no_permission();
} 


It's the same permission check that is used for the UserCP. Other wise, use a template conditional wrapped around the navbar menu. I used it around the server info too. Only me or my Mods can see it. My members wouldn't have a clue as to what it meant anyway.

Took out some of the not too important stats on the main page. Did a few language fixes and changes, and added some script to the statistic.php file to query the database for some stats for my Photopost Gallery, Articles Section, Links Directory, and my Downloads Page.

The Ship Modeling Forum Statistics Page

I've only had it on my site for one day, but the stat numbers seem to be right so far.

Great work PcFreak, Onkel Tom, kall and all (heh, it rhymes!) The install went one, two, three, and besides the little problems above, it works like a charm.

John

[larryd]

I've installed and it seems to work great; I just noticed though that alot of information is not showing up yet.

Its been just under 24 hours and it says

Page hits since statistics began: 0
Number of visitors since statistics began: 0
Average visitors per day: 0

The rest of the tabs all have no information on them. It almost appears as though they arent collecting any stats?

[Ala21]

Does this hack show top daily/weekly/monthly posters? E.g. it counts how many posts all users made in the specified time frame and shows a top posters list based on that? It would be good to keep track of spammers, i'd like to know this before installing, great hack anyway

[topten]

Installed it and just get a blank box in my admincp - 25 pages of responses to this hack? Is this the beginning of my headaches?

[Smitty]

Originally Posted by topten

Installed it and just get a blank box in my admincp - 25 pages of responses to this hack? Is this the beginning of my headaches?

I tried it and it has a number of bugs. As far as I remember few, if any, of the bugs have been fixed and it appears that 'development' has ceased. I took it off my forum within a week because of many bogus numbers and the bugs, but reading through the thread a lot of people like it and have no problem with it as is.

I think it looks really, really neat, but many of the calculated numbers are not valid. Actually, the last version was OK for me once I customized it.

I suggest you try it and see if you like it - But, vB is coming out with a significantly improved version soon so whether this will work on it or not remains to be seen.

I contributed to the developer, and I think the developer worked hard to 'get it right'. I don't feel bad about contributing - But - Unfortunately, I think the developer just sorta dropped the project. Whether this is because the bugs were hard to fix or what, I do not know.

If everything worked right, and the numbers were all correct, I'd pay US$50 for it without blinking. But as it is....

[MissKalunji]

Originally Posted by topten

Installed it and just get a blank box in my admincp - 25 pages of responses to this hack? Is this the beginning of my headaches?

funny did you install all the templates and phrases? i had no problem and installed it and got it on the first shot...