PDA

View Full Version : Forum Display Enhancements - See all threads of subforums in a main forum

vBarab
09-24-2007, 10:00 PM
open forumdisplay.php
find
---
$stickies = $db->query_read_slave("
SELECT thread.threadid, lastpost, open
FROM " . TABLE_PREFIX . "thread AS thread
WHERE forumid = $foruminfo[forumid]
AND sticky = 1
$visiblethreads
$limitothers
$globalignore
");
---
replace
---

$getparent_id = '';
$getparentid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "forum WHERE parentid='" . $foruminfo[forumid] . "'");

if (mysql_num_rows($getparentid) 0) {
while ($getparentids = $db->fetch_array($getparentid)) {

$getparent_id .= ',' . $getparentids[forumid];

}
}

$stickies = $db->query_read_slave("
SELECT thread.threadid, lastpost, open
FROM " . TABLE_PREFIX . "thread AS thread
WHERE forumid IN (" . $foruminfo[forumid] . $getparent_id . ")
AND sticky = 1
$visiblethreads
$limitothers
$globalignore
");
// End SubThread


---
find
---
$getthreadids = $db->query_read_slave("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " thread.threadid
$lastpost_info1
$hook_query_fields
FROM " . TABLE_PREFIX . "thread AS thread
$tachyjoin
$hook_query_joins
WHERE forumid = $foruminfo[forumid]
AND sticky = 0
$visiblethreads
$globalignore
$limitothers
$datecut
$hook_query_where
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");
---
replace
---
$getparent_id = '';
$getparentid = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "forum WHERE parentid='" . $foruminfo[forumid] . "'");
if (mysql_num_rows($getparentid) 0) {
while ($getparentids = $db->fetch_array($getparentid)) {
$getparent_id .= ',' . $getparentids[forumid];
}
}

$getthreadids = $db->query_read_slave("
SELECT " . iif($sortfield == 'voteavg', $votequery) . " thread.threadid
$lastpost_info1
$hook_query_fields
FROM " . TABLE_PREFIX . "thread AS thread
$tachyjoin
$hook_query_joins
WHERE forumid IN (" . $foruminfo[forumid] . $getparent_id . ")
AND sticky = 0
$visiblethreads
$globalignore
$limitothers
$datecut
$hook_query_where
ORDER BY sticky DESC, $sqlsortfield $sqlsortorder
LIMIT $limitlower, $perpage
");
// End SubThread


---

open
threadbit
find :
---
<a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]" id="thread_title_$thread[realthreadid]"<if condition="$show['gotonewpost']"> style="font-weight:bold"</if>>$thread[threadtitle]</a>
---

add after :

---
<span style="float:left"><a href="forumdisplay.php?f=$thread[forumid]">[$thread[forumtitle]]</a></span>
---

hack4: Fnan4arab
dj_f16
09-25-2007, 09:40 PM
caps or demo?????
Hornstar
09-28-2007, 05:44 AM
A demo of this would be great, and if forum 1 is set to now allow any posts, and only forum 2 and forum 3 are, then does that change anything?
matt3830
10-22-2007, 12:54 PM
Great idea, but I couldn't get it to work.
rooban12
10-23-2007, 07:35 PM
any samples?
weeno
11-23-2007, 03:38 AM
looking for a sample also...

arn
matt3830
05-25-2008, 04:58 PM
Could you upgrade this to 3.7?
koolfire
05-25-2008, 05:21 PM
Get everythin in codez
hoku
06-08-2008, 08:27 AM
nice hack, but a simple:
WHERE forumid IN ($foruminfo[forumid]," . implode(',',$foruminfo['childlist']) . ")
can do the same job in 1 line of code instead of 20, with no extra queries.

for 3.7.x version visit https://vborg.vbsupport.ru/showthread.php?t=181876