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
  #242  
Old 02-21-2005, 06:25 PM
S@NL - BlackBik's Avatar
S@NL - BlackBik S@NL - BlackBik is offline
 
Join Date: Jul 2004
Location: Netherlands
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Delphiprogrammi
hi,

this piece of php code is causing the error i get

PHP Code:
$pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE '" 
TABLE_PREFIX "pm'
         "
); 
but that query seems correct to me ?????? and i can't find anything in the MySQL manual about this just a "syntax" example on my old host this worked fine now it refuses to work on my new host ... i dropped my old host because they forced people to go dedicated if you want crontab support :devious:

if i comment that code out it works fine
Well, this doen't seem to be a problem with the vB Statistics but with your own host or configuration.
What you could do is open the database with e.g. MySQL Front and edit the field, in wich the name of your domain should be, manualy. That should do the trick.
Reply With Quote
  #243  
Old 02-21-2005, 06:27 PM
S@NL - BlackBik's Avatar
S@NL - BlackBik S@NL - BlackBik is offline
 
Join Date: Jul 2004
Location: Netherlands
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by shadiguy1
need unsinstall for this. please advise.
You could start by reading this whole thread. I even think it's on this page.
Don't just ask questions, but first read if the question is allready delt with
Reply With Quote
  #244  
Old 02-21-2005, 06:45 PM
TruthElixirX's Avatar
TruthElixirX TruthElixirX is offline
 
Join Date: Sep 2004
Location: Oklahoma
Posts: 517
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

okay...whoa. I just downloaded the english version and everything was english except the installer. The installer is Dutch(I think?) and so..am I going to have ot uninstall it or will the dutch install be okay?
Reply With Quote
  #245  
Old 02-21-2005, 06:51 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Punktek.com
okay...whoa. I just downloaded the english version and everything was english except the installer. The installer is Dutch(I think?) and so..am I going to have ot uninstall it or will the dutch install be okay?

installer that's german
Reply With Quote
  #246  
Old 02-21-2005, 06:54 PM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by S@NL - BlackBik
Well, this doen't seem to be a problem with the vB Statistics but with your own host or configuration.
What you could do is open the database with e.g. MySQL Front and edit the field, in wich the name of your domain should be, manualy. That should do the trick.
yeah i contacted the tech support from my host they didn't answered yet but i think the same there is something with there config ...

updated

i found a solution .for people who get this MySQL error

Code:
Database error in vBulletin 3.0.7:

Invalid SQL: 
    SHOW TABLE STATUS
    FROM 
    LIKE 'testvb_pm'
    
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 'LIKE 'testvb_pm'' at line 3

mysql error number: 1064

Date: Monday 21st of February 2005 10:25:35 PM
Script:**************
Referer: 
Username: **********
IP Address:**********
open op "statistick/sides/forum.php"

PHP Code:
// find this code 
$pm_speicher_groesse $DB_site->query("
        SHOW TABLE STATUS
        FROM 
$dbname
        LIKE '" 
TABLE_PREFIX "pm'
         "
);
//replace that with
$pm_speicher_groesse =  $DB_site->query("
        SHOW TABLE STATUS
        LIKE '" 
TABLE_PREFIX "pm'
         "
); 
you are done don't ask me why but for some reason MySQL is crashing if you add $dbname i don't know why

any cheers working now
Reply With Quote
  #247  
Old 02-21-2005, 09:30 PM
S@NL - BlackBik's Avatar
S@NL - BlackBik S@NL - BlackBik is offline
 
Join Date: Jul 2004
Location: Netherlands
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For the record, PcFreak has confirmed the bug I posted here and is working on a sollution
Reply With Quote
  #248  
Old 02-22-2005, 01:35 AM
MissKalunji's Avatar
MissKalunji MissKalunji is offline
 
Join Date: Aug 2003
Location: Canada
Posts: 2,845
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lizard King
Check out this thread

thx a million every upgrade i usually just redo everythin...
Reply With Quote
  #249  
Old 02-23-2005, 06:56 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Gentlemen,

I am receiving the following error, several times lately:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = 'crimp, pressure, reload\'

mysql error: You have an error in your SQL syntax near ''crimp, pressure, reload\'
' at line 4

mysql error number: 1064

Date: Tuesday 15th of February 2005 02:31:56 PM
Script: http://forum.m1911.org/showthread.php?t=1379&page=3
Referer: http://www.google.com/search?q=crimp...&start=10&sa=N
Username: Unregistered

I checked the code, and can't find anything wrong with it. The common thing I noticed in all the errors I received, is the \ at the end of the search words. Any idea on how to stop these error messages?

Rgds
Reply With Quote
  #250  
Old 02-23-2005, 07:07 AM
Freezerator Freezerator is offline
 
Join Date: Nov 2001
Location: Den Haag
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I get the same errors, but i think the reason is the \ in the query. As you can see when people search on google, their \ is above the enter button. When referrring to your site, the procedure to store the referrer goes wrong because of the \. Maybe a suggestion to strip \ from beeing inserted?
Reply With Quote
  #251  
Old 02-23-2005, 07:44 AM
sv1cec sv1cec is offline
 
Join Date: May 2004
Location: Athens, Greece
Posts: 2,091
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, I think you are right. I'll try to come up with some sort of patch, to strip that last \ from the string.

Since the backslash character is not used in normal word typing, and since I didn't want to spend too much time coming up with an elaborate solution, here is a simple patch.

Open your statistic_searchengines.php file and find:

PHP Code:
$keywords_known $DB_site->query("
        SELECT counter 
        FROM " 
TABLE_PREFIX "statistic_searchengine_keywords
        WHERE keywords = '
$keyword_found'
        "
); 
Right above that, add:

PHP Code:
$keyword_found=str_replace("\","",$keyword_found); 
That would strip any \ character from the query string.

Rgds
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:27 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.05292 seconds
  • Memory Usage 2,337KB
  • 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
  • (1)bbcode_code
  • (4)bbcode_php
  • (5)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