vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Statistic version 3.0.0 (directors Cut *g*) (https://vborg.vbsupport.ru/showthread.php?t=74603)

PcFreak 01-17-2005 10:00 PM

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

https://vborg.vbsupport.ru/external/2010/10/30.jpg

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 https://vborg.vbsupport.ru/.
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.

https://vborg.vbsupport.ru/external/2010/02/12.gif


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

PcFreak 01-18-2005 06:57 PM

Some Screenshoots

Torqued 01-18-2005 06:58 PM

woo hoo!!! :D

kall 01-18-2005 07:02 PM

Woop! You released it! YAY!

I've needed to click that install button for over a week, now I can.

:)

*edit* Your demo site is running the old (un-kalled) language settings...if you want to stick my site up as a demo of the new English translation, go ahead.

Andreas 01-18-2005 07:14 PM

Awesome!

How many queries does it add for the logging part?

Is it possible to display
- new users today/last week/last month
- new posts today/last week/last month
- new threads today/last week/last month
- page views today/last week/last month
- guests online today last week/last month
- registered members online today/last week/last month
?

PcFreak 01-18-2005 07:15 PM

Sorry kall.
In this install Pack are the newest phrases. (with kall ;))
On my forum i change this now.

PcFreak

h75 01-18-2005 07:39 PM

Install the German one :D Nice one!!

Chris-FH 01-18-2005 07:40 PM

Simply great, you're the best PcFreak... ;-)

C.

Trosun 01-18-2005 07:57 PM

Thank you very much for this...
I was hoping to be the first, but i fell asleep.
It's kinda like time-travel.
Anyway, thank you.

PcFreak 01-18-2005 08:12 PM

Quote:

Originally Posted by KirbyDE
Awesome!

How many queries does it add for the logging part?

Is it possible to display
- new users today/last week/last month
- new posts today/last week/last month
- new threads today/last week/last month
- page views today/last week/last month
- guests online today last week/last month
- registered members online today/last week/last month
?

Is possible show the Statistics of the last x days in a popup window.
You can set X in the admincp.
Page views for each days are not supported.

But i will write an update.file and more of this Infos would be display on new sides.

Querys for the logging part.

Max. 6 Querys for the first log. (3 normal and 3 shoutdown querys)
After that, 3 Querys. (1 normal and 2 shoutdown) for each side refresh.

PcFreak

Ian Emu-UK 01-18-2005 08:12 PM

statistic_database_install.php and statistic_inserts_install.php in the english pack are in German.

KTBleeding 01-18-2005 08:13 PM

Nice!

/me waits to get home before installing..

TheVirus 01-18-2005 08:24 PM

Thank you so much! Been waiting for this version for a while now :)

PcFreak 01-18-2005 08:34 PM

Quote:

Originally Posted by Ian Emu-UK
statistic_database_install.php and statistic_inserts_install.php in the english pack are in German.

My small contribution for the world communication ;)
Today few geman words, tomorrow geman as world language
That is true but not tragic.
The install script functioned also with some German words correctly :up:

PcFreak

bL@De 01-18-2005 08:41 PM

Worked a treat on 3.0.5, now to worry about the upgrade to vB 3.0.6 I guess.

Keep up the great work :D

TheVirus 01-18-2005 08:57 PM

Any chance of releasing an image pack for users with a darker colored theme? My background is dark and the images don't go well with the color...white borders around the images. :ninja:

Trosun 01-18-2005 09:00 PM

Installed... nice..

Oh, typo in Phrase "vbstatistic_the_side_calls"
It reads; Page hits since statistics begam: <strong>{1}</strong>

Once again, thanks.

PcFreak 01-18-2005 09:13 PM

Quote:

Originally Posted by TheVirus
Any chance of releasing an image pack for users with a darker colored theme? My background is dark and the images don't go well with the color...white borders around the images. :ninja:

Are you or anybody interests to provide a new?
Please contact me.

Sorry, but i am not a graphic freak.

PcFreak

S@NL - BlackBik 01-18-2005 09:14 PM

Great, I've been looking forward to this release. :)

A couple of questions though. Do I have to uninstall Statistics version 2.0 before installing this version?
If so, do I lose all gathered info from the last 6 months?
And if so, does the installer detect it automaticaly or do I have to uninstall manualy?
If I have to do it by hand, is there a manual for this?

kall 01-18-2005 09:46 PM

Quote:

Originally Posted by Trosun
Installed... nice..

Oh, typo in Phrase "vbstatistic_the_side_calls"
It reads; Page hits since statistics begam: <strong>{1}</strong>

Once again, thanks.

That shouldn't be...I'm sure I fixed that in my last version...

That's the corrected language xml there. (removed - obsolete - get the one from the first post.)

Rhoads 01-18-2005 10:04 PM

Hi hello

First, a lot thanks for these beautiful Statistic Version
I think, there must be always someone first with a problem :disappointed:

Everything have run well ,but now when I go to my statistic url, I get a database error :

Code:

Database error in vBulletin 3.0.5:

Invalid SQL:
            SHOW TABLE STATUS
            FROM mydomein_nl_-_drl
            LIKE 'pm'
           
mysql error: You have an error in your SQL syntax near '-_drl
            LIKE 'pm'
            ' at line 3

mysql error number: 1064

Date: Tuesday 18th of January 2005 05:27:21 PM
Script: http://www.mydomein.nl/forum/statistic.php
Referer:
Username: drl2005
IP Address: xx.xxx.xxx.xxx

I have followed the instructions from the read me :ermm:

yoyoyoyo 01-18-2005 10:11 PM

** clicks install **

and a HUGE thanks to you for all of your hard work!

Ian Emu-UK 01-18-2005 10:13 PM

Quote:

Originally Posted by drl2005
Hi hello

First, a lot thanks for these beautiful Statistic Version
I think, there must be always someone first with a problem :disappointed:

Everything have run well ,but now when I go to my statistic url, I get a database error :

Code:

Database error in vBulletin 3.0.5:
 
Invalid SQL:
        SHOW TABLE STATUS
        FROM mydomein_nl_-_drl
        LIKE 'pm'
 
mysql error: You have an error in your SQL syntax near '-_drl
        LIKE 'pm'
        ' at line 3
 
mysql error number: 1064
 
Date: Tuesday 18th of January 2005 05:27:21 PM
Script: http://www.mydomein.nl/forum/statistic.php
Referer:
Username: drl2005
IP Address: xx.xxx.xxx.xxx

I have followed the instructions from the read me :ermm:

find this

Code:

FROM $dbname
in forum.php in the sides directory and delete it.

I had the same problem with the old statistics and this fixed it, as it does with this version too.

Rhoads 01-18-2005 10:33 PM

Quote:

Originally Posted by Ian Emu-UK
find this

Code:

FROM $dbname
in forum.php in the sides directory and delete it.

I had the same problem with the old statistics and this fixed it, as it does with this version too.

Thank Ian for the tip, it work perfectly now. ;)

plubius 01-18-2005 10:46 PM

Will this work with 3.0.3?

Trosun 01-18-2005 10:48 PM

Quote:

Originally Posted by S@NL - BlackBik
Great, I've been looking forward to this release. :)

A couple of questions though. Do I have to uninstall Statistics version 2.0 before installing this version?

Quote:

Originally Posted by PcFreak
In order to use the new Statistic Version, the old version must unfortunately be removed.
A deinstallation script can be found here >> https://vborg.vbsupport.ru/showpost....47&postcount=2


I'm not sure if you HAVE to delete the v2 data.
But i would anyway, since it's logging more things now etc.


Quote:

Originally Posted by plubius
Will this work with 3.0.3?

I'm running 3.0.3 and it works like a charm.
Check it out...

PcFreak 01-18-2005 11:41 PM

@kall
Zip.file is up to date now. I pack your last statistic_install_phrasen.xml into the zip.file

@Ian Emu-UK and drl2005
I am not really sure.

But a table to call mydomein_nl_-_drl, is not a good idea.
Because this letter "-" is an operational sign for subtractions.
Could be, that this sign make the problem (Perhaps a reserved indication. I dont know like this one interprets in mysql)

@all
The statistic tested with vBulletin Version 3.03, 3.04, 3.05 and 3.06 (without problems puhhh... ;))

PcFreak

plubius 01-19-2005 12:04 AM

Thanks

Installs

Rhoads 01-19-2005 12:19 AM

Quote:

Originally Posted by PcFreak
@kall
Zip.file is up to date now. I pack your last statistic_install_phrasen.xml into the zip.file

@Ian Emu-UK and drl2005
I am not really sure.

But a table to call mydomein_nl_-_drl, is not a good idea.
Because this letter "-" is an operational sign for subtractions.
Could be, that this sign make the problem (Perhaps a reserved indication. I dont know like this one interprets in mysql)
PcFreak

It is not my officiele database name, dutchracingleague_nl_-_drl is de name and de - put down itself with produce. Everything what I fill in complies with dutchracingleague_nl_-_

fridayweb 01-19-2005 01:41 AM

Nice, added it a few minutes ago and it works great. :)

ADDED: One thing, when I saved my settings for the Domain name, it reloaded and showed me that the last two letters of my address were cut off:

"fridaythe13thforum.c"

Is that going to affect the program, or is that just a character display limit?

Torqued 01-19-2005 05:14 AM

Is this working for everyone that installed it? I am having some issues. The stats are not updating and I'm getting these errors in my error log.

Quote:

Wed Jan 19 01:05:52 2005] [error] PHP Parse error: parse error, unexpected '<' in /home/mysite/public_html/forums/global.php(429) : eval()'d code on line 56
[Wed Jan 19 01:05:51 2005] [error] PHP Fatal error: main(): Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/statistic_java_counter.php on line 26
[Wed Jan 19 01:05:51 2005] [error] PHP Warning: main(./global.php): failed to open stream: No such file or directory in /home/mysite/public_html/statistic_java_counter.php on line 26
[
I've gone through the install about 4 times now and can't seem to get this sorted. :( Any ideas? Why is the path wrong for the statistc_java_counter.php?

edited to add:

when i remove the code from the headinclude template and the phpinclude_start template, the errors stop.

Spinball 01-19-2005 06:23 AM

Quote:

Originally Posted by KirbyDE
Awesome!

How many queries does it add for the logging part?

Is it possible to display
- new users today/last week/last month
- new posts today/last week/last month
- new threads today/last week/last month
- page views today/last week/last month
- guests online today last week/last month
- registered members online today/last week/last month
?

Hi PCFreak and thanks for this hack. *Installed* and works perfectly first time.
I agree with KirbyDE about suggesting some more stats to be able to produce information similar to Webtrends. Please note that potential advertisers want to know monthly stats. And as far as I'm concerned the most important use of these stats is to persuade advertisers to sign up.
Please have a think about these:

Average visitor session length (time between first and last activity in a session) (ignoring spiders?)
Number of visitors who visited once in the time period (ignoring spiders?)
Number of visitors who visited more than once in the time period (ignoring spiders?)
Number of page views for home page (ignoring spiders?)
List of most browsed forums % and numbers (clicks on categories) (ignoring spiders?).
Display average number of users registering per day in the time period. This thread shows what I mean though I expect you would get the data in a different way:
https://vborg.vbsupport.ru/showthread.php?t=69392
Also I would suggest being able to exclude certain user groups from the list of new users. I.e. I don't count those in the coppa, awaiting activation and banned user groups as new users since they can't actually participate in the forums.
Thanks for your consideration.

yinyang 01-19-2005 07:13 AM

great hack! well done!

i have this one really weird problem. after installing, there's an extra line above the header now. it's like a blank line was inserted above the whole page. this sort of messes up my formating. does anyone else have this weird oddity?

-yinyang

*clicks install*

kall 01-19-2005 07:29 AM

Quote:

Originally Posted by Torqued
Is this working for everyone that installed it? I am having some issues. The stats are not updating and I'm getting these errors in my error log.



I've gone through the install about 4 times now and can't seem to get this sorted. :( Any ideas? Why is the path wrong for the statistc_java_counter.php?

edited to add:

when i remove the code from the headinclude template and the phpinclude_start template, the errors stop.

Well...for one, you have the wrong path somewhere there.

statistic_java_counter.php should be in /public_html/forums , the same place as global.php and statistic.php

PcFreak 01-19-2005 08:05 AM

Quote:

Originally Posted by yinyang
great hack! well done!

i have this one really weird problem. after installing, there's an extra line above the header now. it's like a blank line was inserted above the whole page. this sort of messes up my formating. does anyone else have this weird oddity?

-yinyang

*clicks install*

Try this
this code in the headinclude template
PHP Code:

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

replace with this code
PHP Code:

<div style="display:none"><script type="text/javascript" src="clientscript/statistic_java.js"></script></div

@spinball
I will try to consider your suggestions with an update

@Torqued
You using a Portal, right?

PcFreak

yinyang 01-19-2005 08:17 AM

Quote:

Originally Posted by PcFreak
Try this
this code in the headinclude template
PHP Code:

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

replace with this code
PHP Code:

<div style="display:none"><script type="text/javascript" src="clientscript/statistic_java.js"></script></div

PcFreak

most excellent!!!

sv1cec 01-19-2005 08:24 AM

Most excellent hack. I was ready to hit Install a couple of hours ago, but we got a power failure here. So here it is.

One thing though. My forum's site domain is forum.m1911.org. In www.m1911.org there is another site, mine too of course, but I would like to exclude only the forum.m1911.org hits from the stats, not the ones from www.m1911.org.

When I try to enter the site's domain name in the options, it doesn't accept it, probably because you are trying to avoid people entering www.xxxxxx.com or whatever. However, if I can't do it, the stats I get would not be correct. Is there a way around it?

Tnx and rgds

PcFreak 01-19-2005 08:30 AM

Quote:

Originally Posted by fridayweb
Nice, added it a few minutes ago and it works great. :)

ADDED: One thing, when I saved my settings for the Domain name, it reloaded and showed me that the last two letters of my address were cut off:

"fridaythe13thforum.c"

Is that going to affect the program, or is that just a character display limit?

There is a character display limit of 25 spells.

You can change this manuelly
Run this query
PHP Code:

ALTER TABLE `statistic_settingCHANGE `setting_for` `setting_forVARCHAR40 NOT NULL 

40 is the new character display limit.

Or use the string "the13thforum.com", that will works, too.

Or antother way. Look in the installation_english.txt and read this part
HTML Code:

######################################################################
**********************************************************************
**If you want to exclude more than one domainname from beeing logged**
**********************************************************************
######################################################################

PcFreak

PcFreak 01-19-2005 08:44 AM

Quote:

Originally Posted by sv1cec
Most excellent hack. I was ready to hit Install a couple of hours ago, but we got a power failure here. So here it is.

One thing though. My forum's site domain is forum.m1911.org. In www.m1911.org there is another site, mine too of course, but I would like to exclude only the forum.m1911.org hits from the stats, not the ones from www.m1911.org.

When I try to enter the site's domain name in the options, it doesn't accept it, probably because you are trying to avoid people entering www.xxxxxx.com or whatever. However, if I can't do it, the stats I get would not be correct. Is there a way around it?

Tnx and rgds

You can use this string
"forum.m1911.org" as forum's site domain

PcFreak

sv1cec 01-19-2005 09:23 AM

Quote:

Originally Posted by PcFreak
You can use this string
"forum.m1911.org" as forum's site domain

PcFreak

Indeed, I can!!

I swear I tried it right after installation, and it kept coming back blank, but now it works!

Wonders!


All times are GMT. The time now is 04:46 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01923 seconds
  • Memory Usage 1,883KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_html_printable
  • (5)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete