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
  #122  
Old 01-23-2005, 10:01 PM
Sir_Yaro's Avatar
Sir_Yaro Sir_Yaro is offline
 
Join Date: Jun 2004
Location: Ireland
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PcFreak
Because these browsers are very exotic.
I have not found a browserstamp (agent) to detect this browsers.
Lynx will detect with the agent "lynx" (you linx agent must use an other agent) and the browser "link" was unknown for me.
Never heard something about this browser. Sorry...
They logged under the point "not identified" browsers
not link but links
http://links.sourceforge.net/
its a well known text browser in linux. only lynx is known better.

Quote:
Originally Posted by PcFreak
Is not very difficult to add new browsers and os.
Needed just one new data insert and just one new condition.
Will add more Browsers/OS/Spider and Crawlers with an Update.
Suggestions on further Browser/OS are welcome.
if you want im will help you with pleasure. just tell me how i can find this browserstamps....

and what with this topic duplicates? how can i remove it?
Reply With Quote
  #123  
Old 01-24-2005, 03:58 AM
tpr tpr is offline
 
Join Date: Jan 2004
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have a small problem with the statistics.
While you do show me how many bots entered (and what precentage they take out of my visitors) The rest of the statsistics do not take that into account.
This means that when i get 514 visitors today its actually more like 350 (damn slurp) or when i check in Referrers the precentage that come directly/through an external Referrer calculate the bots within which is not something i would want.
Any way to bypass thats ?

p.s.
am i the only one that gets harassed by slurp ?
Reply With Quote
  #124  
Old 01-24-2005, 04:19 AM
PixelFx PixelFx is offline
 
Join Date: Dec 2002
Posts: 1,117
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

your not the only one my site is getting attacked by Slurp as well.
Reply With Quote
  #125  
Old 01-24-2005, 05:48 AM
Carl Anderson's Avatar
Carl Anderson Carl Anderson is offline
 
Join Date: Apr 2003
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I ran the uninstall script for version 2 so I could upgrade to 3 and now I get this.....

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT LOGTIME FROM statistik_einstellungen

mysql error: Table 'goldism_goldism.statistik_einstellungen' doesn't exist

mysql error number: 1146

Date: Monday 24th of January 2005 02:47:10 AM
Script: http://goldismoney.info/forums/index.php?
Referer:
Username: G-khan
IP Address: 68.119.29.63

I can't log in or do anything not even to my admincp

Anyone know a fix......
Reply With Quote
  #126  
Old 01-24-2005, 05:59 AM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You haven't done the remove of the logging in your template phpinclude_start as it is described in the readme and also in the uninstalling file !!!
But you should login in admincp to get ride of this code in your phpinclude_start template also afterwards.
If this did't work you have to go with phpmyadmin to your database directly and edit the template there.
Reply With Quote
  #127  
Old 01-24-2005, 06:05 AM
Carl Anderson's Avatar
Carl Anderson Carl Anderson is offline
 
Join Date: Apr 2003
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Onkel_Tom
You haven't done the remove of the logging in your template phpinclude_start as it is described in the readme and also in the uninstalling file !!!
But you should login in admincp to get ride of this code in your phpinclude_start template also afterwards.
If this did't work you have to go with phpmyadmin to your database directly and edit the template there.
How do I get to my phpmyadmin as it wont let me login to my admincp....... I do not have a control panel on my server so I would have to telnet in...
Reply With Quote
  #128  
Old 01-24-2005, 06:13 AM
Carl Anderson's Avatar
Carl Anderson Carl Anderson is offline
 
Join Date: Apr 2003
Posts: 91
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I got this fixed..................
Reply With Quote
  #129  
Old 01-24-2005, 07:49 AM
h75's Avatar
h75 h75 is offline
 
Join Date: Sep 2004
Posts: 52
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Double-Posts!!!

yes you can use paypal
Reply With Quote
  #130  
Old 01-24-2005, 08:16 AM
tpr tpr is offline
 
Join Date: Jan 2004
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,
I recived a db error from the vB statistics (already works on my site for a couple of days)
here is the error :
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM frm_statistic_searchengine_keywords
WHERE keywords = '???\'

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 ''???\'' at line 3

mysql error number: 1064

The forum is in hebrew thus the ??? in the syntax, anyway around this ?
Reply With Quote
  #131  
Old 01-24-2005, 11:26 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by tpr
Hi,
I recived a db error from the vB statistics (already works on my site for a couple of days)
here is the error :
Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM frm_statistic_searchengine_keywords
WHERE keywords = '???\'

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 ''???\'' at line 3

mysql error number: 1064

The forum is in hebrew thus the ??? in the syntax, anyway around this ?
I am not the coder of this hack, but try the following changes.

in file statistic_searchengines.php
find:
PHP Code:
    $keywords_known $DB_site->query("
        SELECT counter 
        FROM " 
TABLE_PREFIX "statistic_searchengine_keywords
        WHERE keywords = '
$keyword_found'
        "
); 
Replace by:
PHP Code:
    $keywords_known $DB_site->query("
        SELECT counter 
        FROM " 
TABLE_PREFIX "statistic_searchengine_keywords
        WHERE keywords = '" 
addslashes($keyword_found) . "'
        "
); 
This will be a solution to this one query. I noticed there are more places where this could happen, so just keep adding the 'addslashes()' as you go.
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 02:04 PM.


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.12730 seconds
  • Memory Usage 2,333KB
  • 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_php
  • (4)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