vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Using the A-Z index on memberlist.php within a forum? (https://vborg.vbsupport.ru/showthread.php?t=32004)

MarkB 11-02-2001 02:09 AM

I love the new A-Z hotlinks at the top of the memberlist, and was wondering if there's a way to use this within a forum? I use a forum for CD reviews, and would love a way for people to be able to jump through the reviews so they can more easily see threads/band names beginning with a particular letter...

apfeifer 11-02-2001 02:10 AM

This would probably be possible, but I'll have to give it more thought tomorrow as I'm going to bed in about 2 minutes. I'll post again tomorrow afternoon after school.

:cool:

MarkB 11-02-2001 02:12 AM

Wickedly cool :cool: Sleep well! ;)

apfeifer 11-02-2001 02:14 AM

Won't be a problem (sleeping, that is)!:p

:cool:

Freddie Bingham 11-02-2001 06:54 PM

Thread titles are not indexed so the query to grab a certain letter are going to grind on a large forum. You could index thread titles to help but that would be an index on a long varchar field so it might affect your performance.

The best solution would be to add a field that contains the first letter only, a 1 char field or an integer field (1 through 26) and place an index on that. Then you set that field when the thread is posted or when the title is changed. Then when someone clicks on A you could do a query on the new field to see what threadids match.

eva2000 11-02-2001 07:17 PM

or just hard code it... don't hit me :)


All times are GMT. The time now is 04:03 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.01087 seconds
  • Memory Usage 1,711KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete