vb.org Archive - =V.2= vB3 Similar Threads

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - =V.2= vB3 Similar Threads (https://vborg.vbsupport.ru/showthread.php?t=46860)

TECK, thanks for offering what you did, but it doesn't work properly, I tried to uninstall the hack and my forum jump does not work :(

Ok, I enabled the forumJump just for you. I will take it off tomorrow...
Use tester/test to login onto my board and see that it's working. :D

View this forum, for example:
http://www.teckwizards.com/forum/for....php?forumid=5

@sparky2: yeah, that is certainly possible, but that would cancel out the purpose of this hack being named as "vB3 Similar Threads," as it is suppose to visually look and function like the vB3 feature over at vBulletin.com. Despite the fact that I use a mySQL function MATCH..AGAINST which is probably not as efficient compared to the method Freddie used, which he explained here, but oh well.... this version works well enough for me. :p

Feel free to make that request yourself, as it surely isn't difficult to do. ;)

Well, in VB2 the word table is not indexed... and I think that Freddie used there several LEFT JOIN's which also affect the performance...

TECK, you da man as usual, I will retry on a clean showthread file. Your recommendation for where to place it...Do i place chunk.txt right above the last line? I believe that is the part I got confused on

Thank you so much for helping me.

Quote:

Originally posted by TheComputerGuy
Your recommendation for where to place it...Do i place chunk.txt right above the last line? I believe that is the part I got confused on

Thank you so much for helping me.

Notice the [high]// Velocd's code here...[/high] part? Replace that line with the chunkcode (that makes me think of biscuits, heh)...

Quote:

Originally posted by TECK
Well, in VB2 the word table is not indexed...

Huh???

run this query:
show create table word

and you'll see that both (of the 2) columns are indexed

Actually it might vary from version sparky2, as both of my columns in the word table are not indexed ;) (running on 2.2.6)

It's not that significant anyway :p

It appears "freddie" was right that this was not the most optimized way to go about "similar threads".

Code:

Query: SELECT



thread.threadid,thread.lastposter,thread.title,thread.postusername,thread.replycount,thread.



lastpost,thread.postuserid,

                        thread.dateline,forum.title AS



ftitle,forum.forumid,forum.parentlist

                        FROM thread

                        LEFT JOIN forum ON (thread.forumid=forum.forumid)

                        WHERE thread.threadid<>256184 AND thread.forumid IN( 192,62,186,65,64,60,187,271,59,61,138,228,127,214,265,67,68,69,70,71,72,73,74,123,142,232,137,227,66,212,145,234,166,125,216,124,215,141,231,139,229,144,233,126,213,131,219,247,129,130,218,146,235,128,217,269,270,140,230,147,236,143,221,135,225,136,226,165,168,167,164,132,220,133,222,134,223,177,178,183,267,13,190,18,162,2,1,12,15,9,4,169,25,188,29,10,19,24,23,33,31,30,53,39,55,56,172,41,42,17,7,27,37,26,16,28,20,32,38,47,179,44,173,303,22,46,45,11,5,51,170,49,50,52,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,149,150,151,152,148,153,154,155,156,157,158,159,160,161,224,174,175,171,180,3,185,264,34,204,21,195,57,304,194,197,198,199,196,200,208,205,201,202,203,268,207,210,211,266,305,273,277,289,278,274,276,275,288,293,292,291,279,286,287,285,298,282,284,290,299,302,301,300,295,297,296 )

                        AND MATCH(thread.title) AGAINST ('old stock from closed store-cocker stuff, lots of redz and more')

                        AND thread.open<>10

                        AND thread.visible=1

                        ORDER BY dateline DESC

                        LIMIT 4

Time before: 0.39137995243073

Time after:  3.3633810281754

Check out the delay! :(

Nice try though. I was excited that you had made this hack...too bad I can't use it. Thanks anyway.

Ah yes, but I could defiantly understand why with your forums VirtueTechy--they're massive :p

Then again, this version of the hack is more improved from the last, in the major effect that it will compare threads to the current thread viewing until it has gathered whatever you set as "LIMIT", in your case 4. (in contrast to the old version where it would retrieve ALL threads, then compare). Not to mention, your forum must have dozens of threads with similar titles, so this hack shouldn't have a problem finding 4 similar threads and quickly. Then again, each similar thread could be seperated by 300 non-similar threads, thus having to read more.

This hack still proves very useful for the smaller forums, such as mine with 1,938 threads and not the slightest decrease in performance. ;)

X vBulletin 3.8.12 by vBS Debug 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01064 seconds Memory Usage 1,747KB 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 (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: