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

[Marco van Herwaarden]

I would do it different, just change:
[sql]$keywords_known = $DB_site->query("
SELECT counter
FROM " . TABLE_PREFIX . "statistic_searchengine_keywords
WHERE keywords = '$keyword_found'
");
[/sql]into[sql]$keywords_known = $DB_site->query("
SELECT counter
FROM " . TABLE_PREFIX . "statistic_searchengine_keywords
WHERE keywords = '" . addslashes($keyword_found) . "'
");
[/sql]
You should allways use addslashes around alphanumeric data to protect against sql insert vulnerability.

I suggest that the coder of this hack review his sources and update with a patch.

[sv1cec]

Some day I should have a look at what exactly those functions are doing. I think you are right, at least this is a common way of doing things in vB.

Rgds and tnx

[Delphiprogrammi]

hi,

this is not a big a issue and probably i'm doing something wrong but it is prett annoying and working on my nerves when i login to my admincp the vbstatistics navgroup is always "collapsed out" (look at the image and you see what i mean)

the insructions tell us to open admincp/indexcp and to look for this code

PHP Code:

$printhr = false;
    if (can_administer('canadminstyles'))
    { 


after that this

PHP Code:

$printhr=true;
construct_nav_option($vbphrase['vbstatistic_admin_index_general'],'statistic_admin.php?do=statistic_setting_general','<br />');        
    construct_nav_option($vbphrase['vbstatistic_admin_index_tld'],'statistic_admin.php?do=statistic_setting_limits','<br />');
    construct_nav_option($vbphrase['vbstatistic_admin_index_browser'],'statistic_admin.php?do=statistic_setting_limits_a','<br />');
    construct_nav_option($vbphrase['vbstatistic_admin_index_spider'],'statistic_admin.php?do=statistic_setting_limits_b','<br />');
    construct_nav_option($vbphrase['vbstatistic_admin_index_maintenance'],'statistic_admin.php?do=statistic_maintenance','<br />');    
construct_nav_group($vbphrase['vbstatistic_admin_index_setting']); 


i can't see anything wrong with it ....

[Viks]

=========================================
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

=========================================

AND

Database error in vBulletin 3.0.3:

Invalid SQL:
DELETE FROM statistic_referer_full
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

=========================================

on running
Optimizing Referring Domains
AND
Optimizing for the Referring Pages Table

hmm... What do I need to change in the syntax to fix it.. and how?

suggestions?

Vik

[S@NL - BlackBik]

@Delphiprogrammi: Just collapse that part of the menu and then click "Save prefs" on top of the left hand menu. The setting that the statisticsmenu is collapsed when opening the control panel should now be saved

[mtha]

01. If I set the Usergroups allowed to show stat. = 0 => the timeline show as 1970

Set your Usergroups which are allowed to show the statistics 0


You can use one of the following choices
Show statistic pages only for administrators and moderators: type in 0
Show statistic pages only for registered users: type in 1
Show statistic pages for everybody visiting your forums: type in 2

This Option was changed last at: 01.01.1970, 07:00

02. Somehow I get this on More information about Java Scripting

Users who allow Javascript to run on their system: 119 (154.5%) allowed
Users who block Javascript on their system: -42 (-54.5%) not allowed

Anyone has the same problem?

[Viks]

Originally Posted by Viks

=========================================
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

=========================================

AND

Database error in vBulletin 3.0.3:

Invalid SQL:
DELETE FROM statistic_referer_full
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

=========================================

on running
Optimizing Referring Domains
AND
Optimizing for the Referring Pages Table

hmm... What do I need to change in the syntax to fix it.. and how?

suggestions?

Vik

hello mr. pcfreak.

[Nordinho]

Originally Posted by MarcoH64

I would do it different, just change:
[sql]$keywords_known = $DB_site->query("
SELECT counter
FROM " . TABLE_PREFIX . "statistic_searchengine_keywords
WHERE keywords = '$keyword_found'
");
[/sql]into[sql]$keywords_known = $DB_site->query("
SELECT counter
FROM " . TABLE_PREFIX . "statistic_searchengine_keywords
WHERE keywords = '" . addslashes($keyword_found) . "'
");
[/sql]
You should allways use addslashes around alphanumeric data to protect against sql insert vulnerability.

I suggest that the coder of this hack review his sources and update with a patch.

how would I add the ' to this?? since that one causes some errors as well...

[Polo]

How can I just install a simple visit counter with this hack.. without the rest of all the other stuff?

[Polo]

Originally Posted by Q_vns_Q

wondering why there so many useless shyt, all over 1000 + of hacks for vbb, this is crayz every thread peoples say good job ima install bla bla.. so it take ur ass forever to install all those useless hack

that's what you gotta say for your fist post? :ermm: