CZ Scrolling Forums Block question

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   CZ Scrolling Forums Block question
archtype
CZ Newbie
archtype has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Nov 01, 2004
0.00 posts per day
Posts: 5
Points: 375
   
I have a small problem with the scrolling forum posts block. I need to exclude one specific forum from being displayed because that one forum is being displayed in another block and I don't want it in the main forum scroll block. How can I modify the query to remove that one particular forum from the display list in the block?
Any help is greatly appreciated.

Thanks



Back to top Reply with quote
#2   re: CZ Scrolling Forums Block question
archtype
CZ Newbie
archtype has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Nov 01, 2004
0.00 posts per day
Posts: 5
Points: 375
   
Thanks but I figured it out. Here is what I changed the query to in order to allow limiting the displayed forums.
$result1 = $db->sql_query("SELECT t.topic_id, t.topic_last_post_id,
t.topic_title, f.forum_name, f.forum_id, u.username, u.user_id,
p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time FROM
".$prefix."_bbtopics t, ".$prefix."_bbforums f LEFT JOIN
".$prefix."_bbposts p ON (p.post_id = t.topic_last_post_id) LEFT JOIN
".$prefix."_users u ON (u.user_id = p.poster_id) WHERE
t.forum_id=f.forum_id AND f.auth_view=0 AND f.forum_id !='14' ORDER BY
t.topic_last_post_id DESC LIMIT 20");



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum