vb.org Archive - Help. Showing threads in both subforum and main forum

Page 1 of 2

Show 40 post(s) from this thread on one page

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Help. Showing threads in both subforum and main forum (https://vborg.vbsupport.ru/showthread.php?t=9121)

Essam

02-19-2001 01:37 AM

Hi,

I'm trying to make a hack that will show threads of the subforums in the main forum or the parent forum. This will encourage ppl to post in the right subforum cause they know it will be shown in the crowded forum also

I think the change should be done in forumdisplay.php
in specific this part.

Code:

$getthreadids=$DB_site->query(" 

SELECT ".iif($sortfield=="voteavg",$votequery,"")." thread.threadid 

FROM thread 

WHERE thread.forumid='$foruminfo[forumid]' AND thread.visible=1 

$datecut $limitothers $ignoreusers 

ORDER BY sticky DESC, $sortfield $sqlsortorder 

LIMIT ".($limitlower-1).",$perpage 

");

What I'm looking for now is the variable to add after

Code:

WHERE thread.forumid='$foruminfo[forumid]'

which will list all the subforums of this forum so it should look like

Code:

WHERE thread.forumid='$foruminfo[forumid]' 

OR thread.forumid=((SUBFORUMS))

Any suggestions guys?

Thanks in advance.

02-19-2001 08:57 PM

Nobody?

02-20-2001 02:47 PM

I would like an option to display subs in the main as well... Haven't had time to research it tho

02-20-2001 07:59 PM

I think what should be done is something like this

Code:

$getforumids=$DB_site->query(" 

forumid FROM forum

WHERE parent='$foruminfo[forumid]' AND thread.visible=1 

");

Then a while loop to fetch all the subforums,, then include what we get in the main query (getthreadsid).

I really can't put this together,, if anyone can give us a hand ? :)

02-23-2001 07:10 PM

Not even a hint? :)

02-23-2001 07:42 PM

Ya, no one else cares I quess...

02-23-2001 07:53 PM

Strange,, I showed most of what need to be changed,, we only need someone to tell us a small bit of information so I can proceed.

03-03-2001 12:03 PM

There is still no one able to help in that?

03-07-2001 09:13 AM

bump

03-07-2001 01:51 PM

Personally I don't see the point in this.

Explain to me the benefits of having posts in multiple forums? All I can see is confusion.

All times are GMT. The time now is 08:23 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01045 seconds Memory Usage 1,723KB 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 (4)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)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: