vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vbStats (https://vborg.vbsupport.ru/showthread.php?t=30751)

Pilot 10-19-2001 05:36 PM

I installed it but have some questions/comments.

Step 5 - need to clarify that subdirectories under /images are used.

Step 7 - took me a little while to find this as I don't know much about templates.

Step 8 - Don't know where to do this - I have opted not to modify any VB php files - ie not to install the optional hacks - so how do I add these domains to the exclude list?

(Why is this needed anyhow?)

Can you also explain how to add the optional hacks in the "install.txt" file so I can later revisit this without re-running the install script?

It looks good - some problems - it shows 2301 threads new in last 24 hours and 36 new views (no way!).

I think the last 24 hr views and threads numbers might be mixed up.

PS - What is a link queue? What is the "activity level"?

Any idea of the performance overhead of this hack?

How much still works if you leave out the phpinclude part (which presumably cuts the overhead)?

You definitely need to exclude hidden forums (order value of 0) and obviously don't show information about threads that they can't normally see (eg forums they have no access to).

The security issues are rather problematic and I can't let my users see this until they are sorted.

Great hack for admins though. When you update it please include instructions on what's needed to upgrade for existing users of the hack.

Bane 10-19-2001 05:46 PM

Added to Asked Questions

I have opted not to modify any VB php files, so how do I add these domains to the exclude list?

Simply point your browser to your vb admin directory address and run the file vbstats_set.php?action=add

What are excluded domains anyhow?

Excluded domains are domains that are not counted as referrers. They wont show up in your referrer list or on the link queue.


Can you also explain how to add the optional hacks in the "install.txt" file so I can later revisit this without re-running the install script?

Good Idea

I think the last 24 hr views and threads numbers might be mixed up.

Will check

Any idea of the performance overhead of this hack?

No one that has installed it has noticed anything.

Bane 10-19-2001 05:48 PM

the phpinclude part is what updates the counter.

Take that out it wont track countries, referrers, browser, os, etc.. only what vB tracks by default.

Dunny 10-19-2001 05:50 PM

Database error in vBulletin: Invalid SQL: SELECT statloc,useonnow,usequeue,usevbp,usevbpl,queuemax, color1,color2,color3,acolor,sc olor,mocolor,mecolor,ucolor,norefer1 FROM vbstats_options
mysql error: Table 'dog.vbstats_options' doesn't exist
mysql error number: 1146
Date: Friday 19th of October 2001 12:26:53 PM
Script: /forum/vbstats.php
Referer:

i messed up i think, any idea what its telling me matey?

Bane 10-19-2001 05:55 PM

Did you run the install? :D

Thomas P 10-19-2001 06:18 PM

Two thumbs up,
terrific hack and definetely worth the waiting!
Thanks a bunch bane and contributing users,
-Tom

ColdFusion 10-19-2001 06:31 PM

Works great on 2.00 as well :D

RobAC 10-19-2001 06:33 PM

i'm still getting a ton of division by 0 errors and I made sure that the addition was made to the phpinclude template. And the file is uploaded....i've tried several combinations in the phpinclude file and nothing works. any ideas?

RobAC 10-19-2001 06:34 PM

Never mind. Figured it out. Nice job! :D

Dunny 10-19-2001 06:37 PM

yep good work mate, I got it sorted...and yes I did run the install, give me some credit here :D

TheComputerGuy 10-19-2001 06:48 PM

Very Nice HACK Bane, I hope to have it on Web+++++Forums Fully installed in jut a few minutes...images take so long on a 56k

badmeetsevil- 10-19-2001 07:00 PM

Great hack! Love it!

patvdv 10-19-2001 07:00 PM

Just installed the vbstats (superb) hack. But the hits generated from my *.be (belgium) domain are counted against Germany (*.ge). Any ideas?

Don ->LKSAB 10-19-2001 07:08 PM

Do a uninstall and change the country names :-)

Then rename the flag images.

/Don

Bane 10-19-2001 07:17 PM

Belgium lists fine on mine.

Are you using German encoding?

patvdv 10-19-2001 07:18 PM

I don't know if that will work because the install script has the right values:

Belgium -> .be
Germany -> .de (not .ge, my mistake)

How would swapping these around fix things?

patvdv 10-19-2001 07:20 PM

Bane,

My Internet Explorer is set to 'en-us'. Or do you mean something else?

Dalius 10-19-2001 07:22 PM

I LOVE YOU BANE

;)

Bane 10-19-2001 07:23 PM

When you installed windows and picked a country I suppose :D

I am going to rewrite the way it detects countries. I thought encoding would be much better but it seems a mess.

Bane 10-19-2001 07:23 PM

Quote:

Originally posted by Dalius
I LOVE YOU BANE

;)

I feel the love! :D :D :D

patvdv 10-19-2001 07:26 PM

I'll be eagerly awaiting the new country dedection method :)

Dalius 10-19-2001 07:36 PM

I'll install it later, i'm having probs with my databse! :(

Pilot 10-19-2001 07:47 PM

My country list looks fairly accurate. Whatever you do some people will wrongly use the defaults which tend to be the US.

Bane 10-19-2001 07:59 PM

I'm going to release a new version in just a minute with the forum exclusions, fixed the hard coded colors, etc..

As far as the countries, Im going to write a two tiered system for that to try to make it as accurate as possible, but that will be a while.. my head hurts atm :) Gonna play some football.

patvdv 10-19-2001 08:01 PM

How about Alka Seltzer? :D

Bane 10-19-2001 08:20 PM

New Version in first post..

Changed v203.2
- Removed Hard Coded Color
- Added Link to Link Queue Help
- Added ability to exclude forums
- Added normalfont to top listings

badmeetsevil- 10-19-2001 08:21 PM

Bain, I want you to bare my children.

I love you man.

Bane 10-19-2001 08:22 PM

Quote:

Originally posted by badmeetsevil-
Bain, I want you to bare my children.
I love you man.

I'll love ya right back if you spell my name right :D

DarkReaper 10-19-2001 09:06 PM

I ran the upgrade script and then went to change the options:

Database error in vBulletin Control Panel: Invalid SQL: SELECT startdate,exforum,statloc,flagloc,useflags,useonno w,usequeue,usevbp,usevbpl,refe rmax,queuemax,toppostmax,topthreadmax,recruitmax,i ncbar1,incbar2,incbar3,incbar4 ,incbar5,incbar6,norefer1,norefer2,color1,color2,c olor3,acolor,scolor,mocolor,me color,ucolor FROM vbstats_options
mysql error: Unknown column 'exforum' in 'field list'
mysql error number: 1054
Date: Friday 19th of October 2001 10:58:05 PM
Script: /forums/admin/vbstats_set.php

DarkReaper 10-19-2001 09:13 PM

Arg. I just did an uninstall and reinstall. When I tried to reinstall:

Quote:

Database error in vBulletin Control Panel: Invalid SQL: CREATE TABLE vbstats_options (
startdate varchar(255) NOT NULL,
exforum varchar(255) NOT NULL,
statloc varchar(255) NOT NULL,
flagloc varchar(255) NOT NULL,
useflags smallint(6) NOT NULL,
useonnow smallint(6) NOT NULL,
usequeue smallint(6) NOT NULL,
usevbp smallint(6) NOT NULL,
usevbpl smallint(6) NOT NULL,
refermax smallint(6) NOT NULL,
queuemax smallint(6) NOT NULL,
toppostmax smallint(6) NOT NULL,
topthreadmax smallint(6) NOT NULL,
recruitmax smallint(6) NOT NULL,
incbar1 smallint(6) NOT NULL,
incbar2 smallint(6) NOT NULL,
incbar3 smallint(6) NOT NULL,
incbar4 smallint(6) NOT NULL,
incbar5 smallint(6) NOT NULL,
incbar6 smallint(6) NOT NULL,
norefer1 smallint(6) NOT NULL,
norefer2 smallint(6) NOT NULL,
color1 varchar(10) NOT NULL,
color2 varchar(10) NOT NULL,
color3 varchar(10) NOT NULL,
color4 varchar(10) NOT NULL,
acolor varchar(10) NOT NULL,
scolor varchar(10) NOT NULL,
mocolor varchar(10) NOT NULL,
mecolor varchar(10) NOT NULL,
ucolor varchar(10) NOT NULL
vbs_field1 varchar(255) NOT NULL
vbs_field2 varchar(255) NOT NULL
vbs_field3 varchar(255) NOT NULL
)
mysql error: You have an error in your SQL syntax near 'vbs_field1 varchar(255) NOT NULL
vbs_field2 varchar(255) NOT NULL
vbs_fiel' at line 33
mysql error number: 1064
Date: Friday 19th of October 2001 11:08:49 PM
Script: /forums/admin/install_vbstats.php?s=&step=3

DarkReaper 10-19-2001 09:17 PM

Jeez...bugs galore ;)

In the install file:

PHP Code:

$DB_site->query("CREATE TABLE vbstats_options (
   startdate varchar(255) NOT NULL,
   exforum varchar(255) NOT NULL,
   statloc varchar(255) NOT NULL,
   flagloc varchar(255) NOT NULL,
   useflags smallint(6) NOT NULL,
   useonnow smallint(6) NOT NULL,
   usequeue smallint(6) NOT NULL,
   usevbp smallint(6) NOT NULL,
   usevbpl smallint(6) NOT NULL,
   refermax smallint(6) NOT NULL,
   queuemax smallint(6) NOT NULL,
   toppostmax smallint(6) NOT NULL,
   topthreadmax smallint(6) NOT NULL,
   recruitmax smallint(6) NOT NULL,
   incbar1 smallint(6) NOT NULL,
   incbar2 smallint(6) NOT NULL,
   incbar3 smallint(6) NOT NULL,
   incbar4 smallint(6) NOT NULL,
   incbar5 smallint(6) NOT NULL,
   incbar6 smallint(6) NOT NULL,
   norefer1 smallint(6) NOT NULL,
   norefer2 smallint(6) NOT NULL,
   color1 varchar(10) NOT NULL,
   color2 varchar(10) NOT NULL,
   color3 varchar(10) NOT NULL,
   color4 varchar(10) NOT NULL,
   acolor varchar(10) NOT NULL,
   scolor varchar(10) NOT NULL,
   mocolor varchar(10) NOT NULL,
   mecolor varchar(10) NOT NULL,
   ucolor varchar(10) NOT NULL
   vbs_field1 varchar(255) NOT NULL
   vbs_field2 varchar(255) NOT NULL
   vbs_field3 varchar(255) NOT NULL
)"
); 

SHOULD BE

PHP Code:

$DB_site->query("CREATE TABLE vbstats_options (
   startdate varchar(255) NOT NULL,
   exforum varchar(255) NOT NULL,
   statloc varchar(255) NOT NULL,
   flagloc varchar(255) NOT NULL,
   useflags smallint(6) NOT NULL,
   useonnow smallint(6) NOT NULL,
   usequeue smallint(6) NOT NULL,
   usevbp smallint(6) NOT NULL,
   usevbpl smallint(6) NOT NULL,
   refermax smallint(6) NOT NULL,
   queuemax smallint(6) NOT NULL,
   toppostmax smallint(6) NOT NULL,
   topthreadmax smallint(6) NOT NULL,
   recruitmax smallint(6) NOT NULL,
   incbar1 smallint(6) NOT NULL,
   incbar2 smallint(6) NOT NULL,
   incbar3 smallint(6) NOT NULL,
   incbar4 smallint(6) NOT NULL,
   incbar5 smallint(6) NOT NULL,
   incbar6 smallint(6) NOT NULL,
   norefer1 smallint(6) NOT NULL,
   norefer2 smallint(6) NOT NULL,
   color1 varchar(10) NOT NULL,
   color2 varchar(10) NOT NULL,
   color3 varchar(10) NOT NULL,
   color4 varchar(10) NOT NULL,
   acolor varchar(10) NOT NULL,
   scolor varchar(10) NOT NULL,
   mocolor varchar(10) NOT NULL,
   mecolor varchar(10) NOT NULL,
   ucolor varchar(10) NOT NULL,
   vbs_field1 varchar(255) NOT NULL,
   vbs_field2 varchar(255) NOT NULL,
   vbs_field3 varchar(255) NOT NULL
)"
); 

Thanks for the excellent hack, regardless! :)

Bane 10-19-2001 09:45 PM

Whoops :( All fixed in the new upload..

Delhaze 10-19-2001 10:48 PM

Problem:
All browsers are being picked up as "Other".
(Windows 2000 Server SP2. PHP 4.06 isapi)

I changed getenv("HTTP_USER_AGENT") to $GLOBALS["HTTP_USER_AGENT"] and it seems to fix it.

This also effect the OS detection.

Is it likely to effect others as well ?
If so what else should I try changing.

Also how would I keep unconfirmed users from showing up as newest member.

Bane 10-19-2001 10:52 PM

Check out vbstats.php?action=info

This is what I used to check vars. if these work they work :) If not you need to change that setting in your code.


The new user thing is actually the same code vb uses on the forumhome.

Delhaze 10-19-2001 11:07 PM

All blank. :(

Anymore no why getenv isn't working on my server, maybe a php.ini change needed ?

Oh yes, forgot I'd modified the new user thing there already.

Delhaze 10-19-2001 11:11 PM

Just found this on php.net.

Quote:

Note: This function does not work in ISAPI mode
Thats a bit of a bummer to say the least.

drumsy 10-20-2001 05:14 AM

How about an uninstall, does that come equipped???

WizyWyg 10-20-2001 05:40 AM

I just downloaded it and THERE is no install_vbstats.php in the zip file.

I downloaded it again, to be sure and nope, no install_vbstats.php

Nemesis77 10-20-2001 06:01 AM

I installed this for a friend on his board. I'm testing it now by trying different browsers, but all browsers are being picked up as Internet Explorer.

I tried change the getenv to $Global is suggested in a previous post but still didn't work. ANy other Ideas

Great hack BTW. thanks

BigSjedow 10-20-2001 07:10 AM

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 158

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 164

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 161

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 185

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 147

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 138

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 144

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 141

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 135

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 150

Warning: Division by zero in /usr/local/psa/home/vhosts/experienced.nl/httpdocs/VBB/vbstats.php on line 153

still get these


All times are GMT. The time now is 04:20 AM.

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.02170 seconds
  • Memory Usage 1,831KB
  • 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
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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