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)
-   -   vbMicroStats: page load time, queries, GZIP and PHP version (https://vborg.vbsupport.ru/showthread.php?t=35811)

TECK 05-07-2002 08:21 AM

the latest. soon it will be out 4.2
this hack was tested on PHP 4.1.2 (wich most providers have it installed).
actually, VB is not working properly on such low version of PHP.

KuraFire 05-07-2002 08:29 AM

I'm using 4.0.4pl1 on my own system and vB is working fine on it...

it's this hack that isn't, but that's cos of the low version, but vB itself works. (I have 4 boards running on my comp, all for work-in-progress to produce 1 single board, online... :eek: )

TECK 05-07-2002 08:59 AM

i think there was an fervent discussion related to this at vb.com
tubedogg was telling people that VB will not work properly. honestly, i dont remember the version he mentioned, but it was something with 4.0.x

maybe one of the people here can let me know what is the lowest PHP version vB can run properly on it? thanks.

KuraFire 05-07-2002 09:09 AM

4.0.4pl1 allows my vB to run perfectly fine.

So it has to be lower than that before vB _won't_ work, cos I have proof running in 4-fold (;)) that it works in 4.0.4pl1 :)

(though, I really have to upgrade to 4.1.2 ASAP...)

DWZ 05-07-2002 12:20 PM

err... this hack had been working fine for the last few weeks or so, but I just noticed it says this these days:
Quote:

Page generated in 0.2891870 seconds (100.00% PHP - 0.00% MySQL) with 24 queries.
0% MySQL?

Admin 05-07-2002 12:25 PM

Quote:

Originally posted by nakkid
i think there was an fervent discussion related to this at vb.com
tubedogg was telling people that VB will not work properly. honestly, i dont remember the version he mentioned, but it was something with 4.0.x

maybe one of the people here can let me know what is the lowest PHP version vB can run properly on it? thanks.

I don't know where you heard that, but vBulletin will run properly on 3.0.7 or even lower. Of course it won't have PCRE support but it will still run.

Admin 05-07-2002 12:26 PM

Quote:

Originally posted by DWZ
err... this hack had been working fine for the last few weeks or so, but I just noticed it says this these days:0% MySQL?
Hahaha you wish.

KuraFire 05-07-2002 12:29 PM

You are using the new db_mysql.php file, look up in the past 20~ posts to see how to re-modify it. If you haven't added the new hack for the new db_mysql.php file, it'll show 100% php and 0% mysql constantly.

DWZ 05-07-2002 12:45 PM

Quote:

Originally posted by KuraFire
You are using the new db_mysql.php file, look up in the past 20~ posts to see how to re-modify it. If you haven't added the new hack for the new db_mysql.php file, it'll show 100% php and 0% mysql constantly.
:D worked great, thanks :)

[high]* DWZ should read thread next time :)
[/high]

on that note, I never got an email to say this hack was updated :confused:

TECK 05-07-2002 06:23 PM

hi DWZ.. i didnt send an email, because 226 was not released.. :)

scubasteve 05-07-2002 11:32 PM

thanks for the quick clarifications to the new db_mysql. i see the 'explain' function was removed, ostensibly because of a security concern - now i'm trying to figure out how that created insecurity ;)

anyways, thx for the update :)

oh, since it is disabled, you might want to change this line of code in admin/functions.php:

PHP Code:

$adminstats="PHP version $versionphp with $gziptext. [<a href=\"$PHP_SELF?explain=1\" target=\"_blank\">details</a>]"

to

PHP Code:

$adminstats="PHP version $versionphp $debugmode with $gziptext."


TECK 05-07-2002 11:54 PM

i wait for the new VB226 release.. and i think i will add those back as part of the hack.. the tables. i will ask then firefly or anyone here who knows well VB security if the mod is reliable.

scubasteve 05-08-2002 12:03 AM

:) sounds like a plan

Jawelin 05-08-2002 08:19 AM

Hi. With the new modified db_mysql.php version (post #306), does someone have noticed an increment (BY 1, only...) of query counts ?

I switched, on the same forumhome page, from 40 to 41 queries (nakkid, grin!!! ;) ) right after the upload of such hacked file.

Thanks.
Bye

TECK 05-08-2002 08:27 AM

i just tried with the old file to do an explain=1. it's the same number of queries, in forumhome (i did a refresh on the page). maybe you forgot some template out of the equation? could be anything... let me know jawelin. curious on this.

Jawelin 05-08-2002 05:10 PM

No.... :O
Simply I loaded my forumhome in the browser...
With that index.php page displayed, I uploaded the db_mysql.php file ONLY to server via FTP, and after the successful transfer i pressed the 'page reload' button.

Very very strange: before 40 queries, after (and now, since then) 41 !!! :)
It's just a mistery, not a problem, of course....

I've no time at the moment to investigate into db flow, but that's my black-box experiment.... :)
Thanks

TECK 05-08-2002 05:33 PM

let us know if you find out something. :)

Lethal 05-11-2002 08:35 AM

Works great, thanks.

Page generated in 0.1183040 seconds (73.35% PHP - 26.65% MySQL) with 19 queries

Pauly 05-11-2002 01:35 PM

can someone heeellllpppp me!1..lol

i have vb 2.2.5 installed on my pc along with mysql 3.23 & php 4.2.0 ....i have installed the hack but still getting 100 php and 0 mysql.....have checked the updated db_mysql.php ....but copy i have does not tally with copy that peeps have adjusted in this thread...is it just me?....can someone point me in right direction...cos its doing my nut in!! :) ...even if i do a fresh installl can u tell me what i need to do with db_mysql.php from scratch!!...sorry for being a little dumb!! gotta start somewhere!!

TECK 05-11-2002 01:57 PM

you probably have the old db_mysql.php file. make sure you download the new one from the link.

Jawelin 05-11-2002 10:26 PM

Quote:

Originally posted by nakkid
let us know if you find out something. :)
Actually I'm looking forward an help to make my 40+ queries dropped down under 30 .... ;)
But need a lot of help (see HERE) about optimisation... :bunny:

Could you give a look?

I would OUTER JOIN almost my queries on forumhome.... :squareeyed:
Thnx

Twig Deez 05-12-2002 12:25 AM

updated version works fine for me.

thanks! :)

jjj0923 05-12-2002 04:46 PM

I have 2.5 followed the instructions to the T and got this error:

Parse error: parse error in /usr/local/websites/fastboats/upload/global.php on line 271

Fatal error: Call to undefined function: getpermissions() in /usr/local/websites/fastboats/upload/index.php on line 10

TECK 05-13-2002 04:11 AM

this is have to do nothing with the vBMS hack.

pattox2k1 05-18-2002 07:22 AM

ok guyz i need help here..........how do i put the microstats on a non-vB or vBportal page????? i have looked through the hacks code and cant work it out......plz help me?????

Boofo 05-18-2002 08:54 AM

Can anyone tell me what this means and if I need to worry about it? I got it in the "details" in the footer where I have microstats running.

Cannot add header information - headers already sent by (output started at /home/virtual/site3/fst/var/www/html/forum/global.php:122) in /home/virtual/site3/fst/var/www/html/forum/admin/functions.php on line 1683

I don't have no-cache headers turned on, should I turn them on? Or does that have anything to do with anything? I'm not complaining, just curious. :)

TECK 05-18-2002 06:11 PM

details are not working with the new db_mysql.php.
i will release a new version once VB226 is out. until then you cannot use details.

regards,
nakkid.

Boofo 05-18-2002 06:43 PM

I had to go back to the db_mysql.php file that came with 2.2.5 originally because the new one didn't have the code I needed to replace for microstats.

The details work fine, I just get that error in one of the listings on down the page in details. The rest of the details looks fine.

What does it mean, exacxtly, and how do I fix it, or do I need to worry about it?

TECK 05-18-2002 06:47 PM

your headers are sent twice by the script. that means you added something there in your file that calls twice the headers. a function, most probably.

look on the first post in this thread on how to update the newest db_mysql.php file.

Boofo 05-18-2002 07:05 PM

Ok, did that and it is working. You're right, now the details don't work. :)

On the already sent header error, that is nothing to worry about right? I have no idea where or what to fix to change it. It won't mess anything up, right? Or does it add an extra query that really isn't needed?

Peabody 05-19-2002 01:01 AM

Does this show for the members too? I don't like the idea of anyone knowing which verison of PHP I'm running, since there always a new vulnerability being discovered. :eek:

Boofo 05-19-2002 03:32 AM

In a few posts back they said that the PHP and GZIP part of it (along with the details) only showed to the Admin (as long as the Admin was set to the default on your board, which is 6), so you're safe. :)

TECK 05-19-2002 03:32 AM

no. only to admins.

Erwin 05-23-2002 07:17 AM

Just to confirm - with the new db_mysql, I cannot access ?showqueries=1 or ?explain=1 - no wonder! :)

TECK 05-23-2002 07:23 AM

you are correct erwin. due to some mods needed for php421, db_mysql.php was modified. i will drop that part when 226 is released. until then, i leave it like that. you can remove the link details, it will not work with the new file.

DWZ 05-23-2002 10:11 AM

I'm sort of confused...

I have 2.2.5 installed with the PHP 4.2.0 version of db_mysql that I got of vb.com (from this thread: http://www.vbulletin.com/forum/showt...threadid=44820)

Now, uploading that deleted all the changes I had made to my old db_mysql file, so I just went back then to update the file so I dont get the 100% PHP and 0% MySQL error, and I cant find
PHP Code:

  function query($query_string) {
    global 
$query_count

Now, what I did find was this:
PHP Code:

  function query($query_string) {
    global 
$query_count,$showqueries,$explain,$querytime

which looks like it already has part of this hack installed in it? The code below that also has bits of this hack in it....

Im really sort of confused here :\

What do I need to replace and with what to stop the 100% PHP / 0% MySQL thing?

TECK 05-23-2002 10:20 AM

DWZ, in the first post of this thread is a link with all the instructions necesary to download the new db_mysql.php file and also how to mod it.

DWZ 05-23-2002 10:54 AM

ahh, ok, sorry :)

Done that and its working fine now :D

mtf169 05-25-2002 10:05 PM

There was somebody several postings back that had the same exact problem I'm having now. I've tried installing this hack a dozen times with no success. I get all of the edits done and the one that seems to be breaking everything is:

Code:

  while ($var=$DB_site->fetch_array($vars) and $i++) {
    if ($var['findword']!="") {
      $findwords[$i]=$var['findword'];
      $replacewords[$i]=$var['replaceword'];
    }
  }

  $newtext=str_replace($findwords,$replacewords,$newtext);

The other guy posted this image which is exactly what's happening to me. How did he get this working?
https://vborg.vbsupport.ru/attachmen...&postid=239359

Thanks.

By the way, I installed your vbhome(lite) and love it. Awesome hack.

TECK 05-25-2002 10:15 PM

ahh, the pic you show in the link was due to the PHP version. it was to old. what MySQL and PHP ver you run?


All times are GMT. The time now is 01:13 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.02109 seconds
  • Memory Usage 1,826KB
  • 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
  • (1)bbcode_code_printable
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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