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)
-   -   vBindex v2.1 (https://vborg.vbsupport.ru/showthread.php?t=41916)

NTLDR 10-09-2002 10:50 AM

Quote:

Originally posted by Till
This hack uses still 35 queries if all options are turned on?!

No, like the first post says unline version 2.0.1 this hack significatly reducues queries and should allways have less than 30 with everything I have supplied enabled.

NTLDR 10-09-2002 10:54 AM

Quote:

Originally posted by TheMasterG
First off, great hack :D

I'm running v2.1 RC1 with vBulletin 2.2.2 successfully for the past week but just noticed one problem today, the "Most users ever online" is getting overwritten from vbIndex somehow.

I've noticed some duplication between what's in my "Original vBulletin code" section and the "Users online today" section which may or may not be causing the problem. It could be because my original code is from v2.2.2 and maybe I should delete some or all of the maxloggedin code?

As you can see the UPDATE query for maxloggedin is duplicated so I know something's definetly wrong here. I found a thread on vBulletin.com which seems to indicate the problem is with this hack.
So should I remove some or all of the maxloggedin code? From both sections or just the "original code" part?

Thanks and once again, great hack :classic:

I know this is not the case with vB 2.2.4 upwards, if you want to PM me your vBindex PHP file I can add the code from 2.2.8 for you which works.

NTLDR 10-09-2002 10:58 AM

Quote:

Originally posted by digitalJE5U5
Nice hack!

I've got the page up and running, but one problem? The only image that loads on my vbindex.php page is my avatar. All the others lare pointing to the wrong DIR.

Ive installed this vbindex.php file in my base DIR and the forums are in base folder/vbulletin .

Change your images folder to the full URL, this will make sure the images load correctly.

find $only['showgroups'] is what you need to find and place the code AFTER it, vBhacker gives the wrong instructions for some reason.

Buddha 10-09-2002 01:34 PM

ntldr... i have a suggestion for the new version, if it's not too late. don't know how hard it would be either.
i haven't upgraded yet (and am unsure if i will) as i have done so much work with this and it would be a +++++ to have to redo all of it. i am using your hack to power all of my site (thank you so much). i have nearly twenty additional pages that i have created, using vbindex as the base. i then have gone in and changed the code to point that page to the proper templates. i've had to create a crapload extra templates for all of these additional pages. however, i've taken stuff out of the extra pages (such as the polls, and i'm currently searching for which part of vbindex to remove if you don't use the newest threads in the right menu... don't remember seeing a post about it here, but i am checking now) to reduce querries.
here's my suggestion... you say that the new one can be controlled through the admin cp now, to choose what you would like selected and whatnot. is it possible to have it so that you can create a copy within the cp, choose a name and all of the options you would like selected for that page, and which templates would correspond to the header/footer, left, main and right. know what i mean? then have a dropdown menu perhaps that displays all of the additional pages that you have created and then you can select one and do the work on it from there.

just a thought.
i know that it would make it a lot easier to upgrade my site to the newest version if you had this available.

*edit*
ok, checked through all of the pages, and it's nowhere to be found, so now i'm asking.
is there a way that i can trim the vbindex code to remove querries if i am not using the newest threads display in the right panel (using 2.0.1). thanks.

NTLDR 10-09-2002 02:38 PM

Quote:

Originally posted by Buddha
here's my suggestion... you say that the new one can be controlled through the admin cp now, to choose what you would like selected and whatnot. is it possible to have it so that you can create a copy within the cp, choose a name and all of the options you would like selected for that page, and which templates would correspond to the header/footer, left, main and right. know what i mean? then have a dropdown menu perhaps that displays all of the additional pages that you have created and then you can select one and do the work on it from there.
Changing the code so that a certain header/left and right templates are displayed based on the page would be quite easy, are you using the standard vbindex.php?page=template_name method for displaying extra pages? Alternativly you can make a copy of the vbindex.php and remove the code for the functions you don't use and use that php file for the rest of the site.

Quote:

ok, checked through all of the pages, and it's nowhere to be found, so now i'm asking.
is there a way that i can trim the vbindex code to remove querries if i am not using the newest threads display in the right panel (using 2.0.1). thanks.
If you are not using the latest threads bit at all for your site, you can comment out or delete all of the code starting at:

PHP Code:

// latest threads
// -------------------------
if (!isset($numthreads)) {
    
$numthreads=$maxthreads;


To:

PHP Code:

eval("\$threads = \"".gettemplate('home_threads')."\";");
// -------------------------
// end latest threads 

This will then remove the queries that are generated by it.

Buddha 10-09-2002 03:07 PM

thanks bud... just checked and i'd already taken that out but just wanted to check if there were any other querries anywhere else as well.
i'm using 2.0.1 and i'm not using the vbindex.php?page=template_name method... i've made copies and renamed them and did exactly what you said and took out all of the extra stuff that i don't want. i've been able to greatly reduce the querries on the extra pages by doing that.

Buddha 10-09-2002 04:16 PM

couple more questions for you ntldr.
what's the eta on a final version of 2.1?
also, how many querries is it cutting down. i know you said with everything on, it only adds 1, but i'm wondering how much it will cut down in general. were you able to get the loop going so that it doesn't matter how many posts are displayed?
thanks.

Ninth Dimension 10-09-2002 06:27 PM

Hi, just wanted to say that I've added the beta upgrade to my localhost forum (soon to be released) and after a bit of messing arround, and fixing the minor bugs you have it's working very well.

I love the shoutbox intregration that you have, my users will love it.

Keep up the good work, i look foward to seeing more updates on this soon :)

NTLDR 10-09-2002 07:16 PM

Quote:

Originally posted by Buddha
couple more questions for you ntldr.
what's the eta on a final version of 2.1?
also, how many querries is it cutting down. i know you said with everything on, it only adds 1, but i'm wondering how much it will cut down in general. were you able to get the loop going so that it doesn't matter how many posts are displayed?
thanks.

The final will be out when I have enough time to finish the installer and check everything works correctly, the actual coding for 2.1 has been pretty much finalished.

v2.1 allways has less than 30 queries will everything enabled, latest threads, news posts, poll, buddies, threads/post since last visit, who's online, who's online today. I have managed to optimise and get out of the loop for both the news and the threads queries on v2.1

The example site running a customised v2.1 (it has 5 extra queries for specific things not in vBindex and has the online users code removed) has the following microstats:

Quote:

Page generated in 0.506 seconds (47.40% PHP - 52.60% MySQL) with 30 queries.
Which is about 10-15 queries less than it had using v2.0.1 (with only 1 query added for a specific thing not in vBindex).

NTLDR 10-09-2002 07:18 PM

Quote:

Originally posted by Ninth Dimension
Hi, just wanted to say that I've added the beta upgrade to my localhost forum (soon to be released) and after a bit of messing arround, and fixing the minor bugs you have it's working very well.

I love the shoutbox intregration that you have, my users will love it.

Keep up the good work, i look foward to seeing more updates on this soon :)

Thanks for the feedback Ninth Dimension :D

As you have mentioned it were all the minor bugs you found have a fix in this thread? If not I'd like to know what they are so I can correct them :)


All times are GMT. The time now is 04:50 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.06804 seconds
  • Memory Usage 1,765KB
  • 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
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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