Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
See all threads of subforums in a main forum Details »
See all threads of subforums in a main forum
Mod Version: 1.00, by vBarab (Member) vBarab is offline
Developer Last Online: Jul 2012 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.8 Rating: (0 vote - 0 average) Installs: 3
Released: 25 Sep 2007 Last Update: Never Downloads: 2
Not Supported  

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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 25 Sep 2007, 22:40
dj_f16 dj_f16 is offline
 
Join Date: Sep 2006
Real name: Metin METE
caps or demo?????
Reply With Quote
  #3  
Old 28 Sep 2007, 06:44
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
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?
Reply With Quote
  #4  
Old 22 Oct 2007, 13:54
matt3830 matt3830 is offline
 
Join Date: Jan 2006
Real name: Matt
Great idea, but I couldn't get it to work.
Reply With Quote
  #5  
Old 23 Oct 2007, 20:35
rooban12's Avatar
rooban12 rooban12 is offline
 
Join Date: May 2007
any samples?
Reply With Quote
  #6  
Old 23 Nov 2007, 04:38
weeno weeno is offline
 
Join Date: Jan 2002
looking for a sample also...

arn
Reply With Quote
  #7  
Old 25 May 2008, 17:58
matt3830 matt3830 is offline
 
Join Date: Jan 2006
Real name: Matt
Could you upgrade this to 3.7?
Reply With Quote
  #8  
Old 25 May 2008, 18:21
koolfire koolfire is offline
 
Join Date: Apr 2008
Get everythin in codez
__________________
gσσ∂ υѕєя кησωѕ тнє яυℓєѕ, gяєαт υѕєя кησωѕ тнє α∂мιηѕ!
When you're right, no one remembers. When you're wrong, no one forgets
Reply With Quote
  #9  
Old 08 Jun 2008, 09:27
hoku hoku is offline
 
Join Date: May 2006
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 http://www.vbulletin.org/forum/showthread.php?t=181876

Last edited by hoku; 08 Jun 2008 at 10:33.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 03:08.

Layout Options | Width: Wide Color: