page info and such at bottom

[misfits7702]

i cant seem to find this mod, it prints out at the bottom of page:

Generated In: 0.93489384 seconds | MySQL Queires: 17 | Server Load: 4.29

if nobody know where to get it tell me some of the code and stuff or make it for me

[Spaceman-Spiff]

Generated In: 0.93489384 seconds

its already in Subs.php but commented, dunno why

MySQL Queires: 17

it can be done, but will require editing everywhere a query is executed
there's been discussions about these, but long time ago (cant remember where)

Server Load: 4.29

no clue about this one...

[1979Z28]

So in order to get this to work, you should un comment it?

[Spaceman-Spiff]

http://www.yabb.info/community/index.php?board=137;action=display;threadid=10597;start=0

[groundup]

the time thingy doesn't really work. to find out how many queries are used, just find a batch replacer and replace mysql_query with yyquery and create a function in subs called yyquery(). have that add a number each time a query is called. it is pretty self explanitory

[misfits7702]

ok well i have no true knowledge of php so anyone please someone tell me really detailed how to do it

[Spaceman-Spiff]

the time thing works, i uncommented it, and it works fine
i also just added the query counter, as groundup suggested
to do this:
0. Make backups
1. open all files in Sources directory in a text editor program that can do batch replace.
2. replace "mysql_query(" with "yyDBquery("
3. in Subs.php replace totalTime function with these

Code Select Expand

function totalTime($comment) {
   global $start_time,$waste,$endComment;
   list($now,$waste) = explode(" ",microtime());
   $endComment = "$comment: ".($now-$start_time);
   $start_time = $now;
   return $endComment;
}

function yyDBquery($query) {
   global $queryCounter;
   $queryCounter++;
   return mysql_query($query);
}

function yyShowTotalQuery() {
   global $queryCounter;
   $totalTime = totalTime("Page was generated in ")."secs.";
   echo "<font face=\"Verdana, Arial\" size=\"1\">$totalTime | $queryCounter queries executed.</font><br>";
}4. upload all the contents of Sources directory
5. add this somewhere in index.php to reset the counter

Code Select Expand

$queryCounter = 0; and upload it when done
6. edit forum template and add <yabb showtotalquery> right before <yabb copyright>

it will displays something like this:

Page was generated in : 0.445135secs. | 37 queries executed.
MyForum | Powered by YaBB SE
© 2001-2002, YaBB SE Dev Team. All Rights Reserved.

i dont know if they're accurate or not
in some pages, the query count is quite high
in a normal page (like edit template), there are 9 queries

[Spaceman-Spiff]

i think the time isnt accurate, its showing - (minus) sometimes
i'll try using mediman's code...

[Spaceman-Spiff]

i've replaced some more mysql_query function to count it
my boardindex:
Page was generated in 0.84028 secs, and 60 queries were executed.
messageindex:
Page was generated in 0.91705 secs, and 66 queries were executed.
so many queries  

[misfits7702]

to every file!??! make a mod please someone

[groundup]

the time thing is inaccurate. Very inaccurate.

you must have done somethign wrong for your query script.

I have a mod file but I don't want to upload it. it is huge. so just go to download.com and download a "batch replacer" script

[Spaceman-Spiff]

i change the time using microtime() script like in the this page: http://www.php.net/manual/en/function.microtime.php
but it was showing something like: 1534234554.9434134, so i removed the (float)$sec part, and looks like its working...

for the query part, i've replaced some more msql_query, before i didnt change the ones that have a space between mysql_query and ("
now, a normal page has 14 queries, like edit template, i dont know about the accuracy, cuz i dont want to count it one by one

well.. maybe i'll count the minimum number of queries...

[Nemesis]

http://yapp.phpworld.net/index.php?board=13;action=display;threadid=367

[Spaceman-Spiff]

after counting, minimal queries for non-guest when executing an empty page using YSE template:
index.php: 4 queries
Subs.php: 8 queries (only counted the ones in template_header(), timeformat(), writelog(), clicklog())
Load.php: 3 queries (LoadBoard(), LoadUserSettings())
Security.php: 3 queries (banning())
total = 4 + 8 + 3 + 3 = 18

above are assuming if these functions are enabled:
- track stats & hitstats (minus 2 queries if function is disabled)
- shownews (1 query)
- todaymod (1 query)
- guest (4 queries)

count might be a bit inaccurate, but should be close
i dont know how to count the queries inside BoardIndex.php x number of boards