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)

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 01:03 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.01840 seconds
  • Memory Usage 1,751KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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