Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Statistic version 3.0.0 (directors Cut *g*) Details »»
vB Statistic version 3.0.0 (directors Cut *g*)
Version: 1.00, by PcFreak PcFreak is offline
Developer Last Online: Mar 2015 Show Printable Version Email this Page

Version: 3.0.6 Rating:
Released: 01-17-2005 Last Update: 11-06-2005 Installs: 295
DB Changes
 
No support by the author.

: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

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #142  
Old 01-27-2005, 06:52 AM
Jenta Jenta is offline
 
Join Date: Dec 2004
Posts: 377
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

great job on this
its amazing
the only thing i would hope is to exclude myself from being counted as im always there and it tends to scew? the stats
Reply With Quote
  #143  
Old 01-27-2005, 07:13 AM
kall's Avatar
kall kall is offline
 
Join Date: Apr 2004
Location: New Zealand
Posts: 2,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by yinyang
hello? this is so odd!
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.
Reply With Quote
  #144  
Old 01-27-2005, 07:21 AM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Smitty
I had to uninstall. Too many database errors and other issues.

Oh, well. I'll probably put the old verson 2 back in.
I can't undestand!
We tested this version on more than one vB and all went fine. Also PcFreak do a lot of bugfixing before release and after release.
Did you really use the latest scripts ?
Or did you correct uninstall of the old vB2 version ?

Some guys didn't uninstall der vB 2 version correct and so they get database errors from the old one and not from the new version 3 !
Reply With Quote
  #145  
Old 01-27-2005, 07:29 AM
tpr tpr is offline
 
Join Date: Jan 2004
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PcFreak
My philosophy over the visitors
What is a visitor?
When i started to code the statistic, i have think about this very much
For me it is all the same whether now the visitor Spider, Crawler or an actual visitor is.
I wanted to know how many vistits or page hits are on my sides. (All together)
PcFreak
While i do like your philosophy it does seems to get in the way of me getting to know how my visitors act (where they come from etc...) so can we perhaps come to an understanding where you could choose your life philosophy ? :nervous:
(an option to turn the bot counting on/off).

its a great hack nontheless
Reply With Quote
  #146  
Old 01-27-2005, 08:15 AM
Beermonster Beermonster is offline
 
Join Date: Dec 2003
Location: England
Posts: 362
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I havn't had any problems with it but one of my mods was viewing it and it returened an error

Code:
Invalid SQL: 
SELECT Summe as Datum
FROM statistik_zaehler AS statistik_zaehler
WHERE Zaehler_fuer = 'Statistik_Aktiv'
        
mysql error: Table 'vb3.statistik_zaehler' doesn't exist

mysql error number: 1146
any ideas?
Reply With Quote
  #147  
Old 01-27-2005, 08:32 AM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Beermonster
I havn't had any problems with it but one of my mods was viewing it and it returened an error

Code:
Invalid SQL: 
SELECT Summe as Datum
FROM statistik_zaehler AS statistik_zaehler
WHERE Zaehler_fuer = 'Statistik_Aktiv'
        
mysql error: Table 'vb3.statistik_zaehler' doesn't exist

mysql error number: 1146
any ideas?
I think there is a TABLE_PREFIX missing in this query.
Reply With Quote
  #148  
Old 01-27-2005, 08:51 AM
Beermonster Beermonster is offline
 
Join Date: Dec 2003
Location: England
Posts: 362
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Onkel_Tom
I think there is a TABLE_PREFIX missing in this query.
Yes there is it's my database name, I removed it from the post
Reply With Quote
  #149  
Old 01-27-2005, 09:26 AM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Installed with no problems and works well on 3.0.6 .. great hack.

Clicked install
Reply With Quote
  #150  
Old 01-27-2005, 12:42 PM
Sir_Yaro's Avatar
Sir_Yaro Sir_Yaro is offline
 
Join Date: Jun 2004
Location: Ireland
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

PcFreak, you wrote that you never heard about Links browser - thats why statistic doesnt recognised it.
But why Links IS in this list:
http://justget.org/statistic.php?do=now_browser_info
(17th from below) ??

In that case which browser is recogniser as Links ?
Reply With Quote
  #151  
Old 01-27-2005, 01:27 PM
Smitty's Avatar
Smitty Smitty is offline
 
Join Date: Sep 2002
Location: Southern Ohio
Posts: 385
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Onkel_Tom
I can't undestand!
We tested this version on more than one vB and all went fine. Also PcFreak do a lot of bugfixing before release and after release.
Did you really use the latest scripts ?
Or did you correct uninstall of the old vB2 version ?

Some guys didn't uninstall der vB 2 version correct and so they get database errors from the old one and not from the new version 3 !
Well, one problem was with the 'posts since last visit' function. See: Issue with "Since Last Visit" Search

I was also getting database errors from referrer entries. I went through the uninstall of version 2 pretty thoroughly, I think. Example:
Quote:
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = '\iso rules for lead free solder\'

mysql error: You have an error in your SQL syntax near ''\iso rules for lead free solder\'
' at line 4

mysql error number: 1064

Date: Wednesday 26th of January 2005 07:03:59 PM
Script: http://elsmar.com/Forums/showthread.php?t=8031
Referer: http://search.yahoo.com/bin/search?p=\'iso%20rules%20for%20lead%20free%20solde r\'
Username: Unregistered
At this point I'm pretty busy with a few things and want to make sure the 'posts since last visit' function is working correctly without this 'hack'. This weekend I'll take a look at everything and see if I did something wrong in editing the files. Actually, version 2 was OK for me. There are some things in it I did like better as to presentation. And, as I said earlier, including bots / spiders in stats like visitors on the main page dilute the information. Bots and spiders come and go while my main interest is in the people who visit.

Most of this isn't an isssue for me over all - I saw this as something for forum users more than anything else - I have a log analysis program I use on the site as a whole which segrates things like bot / spiders vs. 'people' - And most everything else I need.

I like the idea. I think it's a very nice 'hack'. And I'm not disappointed. A lot of time and hard work went into it. But for me, it'll be something I have to look more closely at - And to do that I have to find some time.

Note that I'm not a programmer so I'm not really very good at debugging. As the old saying goes, I know enough to be dangerous.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.18759 seconds
  • Memory Usage 2,329KB
  • 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
  • (2)bbcode_code
  • (7)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