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)
-   -   vbHome (lite) - your vBulletin(powered) main homepage (https://vborg.vbsupport.ru/showthread.php?t=36756)

nokia8860 09-30-2002 02:34 AM

With the poll option off my page loads under .2 sec but with it on thats when it bogs down to 12 sec.

I still wonder where all these extra queries are coming from.

TECK 09-30-2002 02:37 AM

it's not the query, orelse it would load really slow on everyone's page. i will ask my friend PPN, who is really good with queries if it's ok everything.

from my knowledge, it looks solid like the way it is now.

PIMPY 09-30-2002 05:54 AM

umm ya i'll check it soon, but the old custom templates are not for this i ment templates for OTHER things..

k i turned on polls and i found NO difference

still did it at same speed, i think it was like .001 secs diff , avg, some times i got less :P

but whats this about turnning on pms? how/where do i do that? its not in the index.php

TECK 09-30-2002 11:25 AM

is not the query. i check it in EMS mysql manager and it returned the results in 0.02sec...
redownload the file pimpy. you dont have the "latest" version...
i added like 5min later the private messages, when i released the 3.1.
so go ahead and download it, the password is the same... then read the uninstall procedure for the older version you have:
https://vborg.vbsupport.ru/showthrea...785#post303785

LeeCHeSSS 09-30-2002 11:48 AM

Hmm, just tested vbHome on my home computer. It works correctly as far as I can tell, but I'll have to heavily edit the templates in order to get a somewhat decent page :)

This might take a while with my current amount of free time :(

PIMPY 09-30-2002 11:59 AM

you know.. ya really should tell people of this.. :P

ug i hate heaving to un-install and re-install and edit again and UG!

intinig 09-30-2002 03:36 PM

I would like to install the hack. My website is www.warcraft3.it

TECK 09-30-2002 04:02 PM

Quote:

Originally posted by PIMPY
you know.. ya really should tell people of this.. :P

ug i hate heaving to un-install and re-install and edit again and UG!

pimpy, please, be mature.. i said to people this several times.. if you dont read the thread, that's not my problem.
if you are not happy, please dont install my hack. thank you.

intinig, turn your pm's ON, so i can send you the password.

TECK 09-30-2002 04:55 PM

In, vbHL index.php, find this code:
Code:

  if ($poll=$DB_site->query_first("
    SELECT * FROM poll LEFT JOIN thread ON (thread.pollid=poll.pollid) WHERE visible=1 AND open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1
  ")) {

replace it with:
Code:

  if ($poll=$DB_site->query_first("
    SELECT * FROM thread LEFT JOIN poll ON (poll.pollid=thread.pollid) WHERE thread.visible=1 AND thread.open<>10 $iforumperms $ipollperms ORDER BY thread.pollid DESC LIMIT 1
  ")) {

That will avoid the table poll to be scanned entirely to get the poll information you need, increasing the performance.
If your file does not contain the latest query, please update it asap.

Also, still in vbHL index.php, find:
Code:

  eval("\$articlelink = \"".gettemplate('home_articlelink')."\";");
DELETE that line, it will drop your queries to 14 (17 with all options enabled).

bouncer18 09-30-2002 05:47 PM

where do we post to let you know we want the pwd to the zip.. there is no link on the first thread.... you cant click where it says "click here"


All times are GMT. The time now is 02:46 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.05919 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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