Forums block - limiting the forums displayed

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

is there a way to limit what forums are displayed in the forums block? I have a forum where people can post comercial crap, but I don't want the "spam" forum posts to scroll through the scrolling block.

Captain Joined: Jan 17, 2003 Posts: 629 Location: Europe

Only private view forums are not displayed in the block.

Joined: Jan 31, 2004 Posts: -88

in the SQL statement in the block, add

Code:

WHERE forum_id <> '[insert Forum ID of the spam forum here]'

to the end before the ";
AI

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

I'm sorry... what is the SQL statement?

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

any help ?

Joined: Jan 31, 2004 Posts: -88

well being that I don't use / have the forum block I can't tell ya. Plst the code.

AI

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

Code:

<?php

/************************************************************************/
/* Forums Block for phpBB 2.0.0 port to PHP Nuke 6.5b6+ */
/* ==================================================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com) */
/* http://phpnuke.org */
/* */
/* Version 1, modified by Sébastien Vaast */
/* http://membres.lycos.fr/projectpluto/ */
/* */
/* Updated by Tom Nitzschner 22/06/2002 to add the scrolling text */
/* */
/* Updated by Paul Laudanski 14 Jan 2003 */
/* NukeCops.com | ComputerCops.biz */
/* */
/* Last Edited - 14 Jan 2003 */
/* */
/* This Block shows the last 10 topics where a message was posted, */
/* along with the username of the last poster and the day and time */
/* of the post. */
/* It will also show smileys in the topic titles thanks to the */
/* smileys.php file found in Leo Tan Block Forums version */
/* (http://www.cybercomp.d2g.com). */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/

if (eregi("block-Forums.php", $PHP_SELF)) {
Header("Location: index.php");
die();
}

include_once ('blocks/smileys.php');

global $prefix, $dbi, $sitename, $user, $cookie, $group_id;
$count = 1;
$content = "<A name= \"scrollingCode\"></A>";
$content .="<MARQUEE behavior= \"scroll\" align= \"center\" direction= \"up\" height=\"220\" scrollamount= \"2\" scrolldelay= \"20\" onmouseover='this.stop()' onmouseout='this.start()'>";
$content .="<center> <STYLE=\"text-decoration: none\">Last 20 Forum Messages</center>";
$result1 = sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where t.forum_id=f.forum_id and f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT 20", $dbi);
$content .= " ";
while(list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id) = sql_fetch_row($result1, $dbi)) {
$result2 = sql_query("SELECT topic_id, poster_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %T') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);
list($topic_id, $poster_id, $post_time)=sql_fetch_row($result2, $dbi);

$result3 = sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$poster_id'", $dbi);
list($username, $user_id)=sql_fetch_row($result3, $dbi);

$topic_title=parseEmoticons($topic_title);
// Remove the comment below to add the counter
//$content .="<STYLE=\"text-decoration: none\">Message: $count ";

$content .= "<img src=\"modules/Forums/templates/subSilver/images/icon_mini_message.gif\" border=\"0\" alt=\"\"><a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\"> $topic_title </a> Last post by <A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"STYLE=\"text-decoration: none\"> $username </a> in <a href=\"modules.php?name=Forums&file=viewforum&f=$forum_id\">$forum_name</a> on $post_time ";
$count = $count + 1;
}
$content .= " <center>[ <a href=\"modules.php?name=Forums\"STYLE=\"text-decoration: none\">$sitename ]</center>";
?>

Joined: Jan 31, 2004 Posts: -88

change this bit:

Code:

$result1 = sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where t.forum_id=f.forum_id and f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT 20", $dbi);

to

Code:

$result1 = sql_query("SELECT t.topic_id, t.topic_last_post_id, t.topic_title, f.forum_name, f.forum_id FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where (t.forum_id=f.forum_id and f.forum_id<> [insert spam forum id here]) and f.auth_view=0 ORDER BY t.topic_last_post_id DESC LIMIT 20", $dbi);

AI

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

YES YES YES !!! Thank you..

I don't want to sound to L7ish here... But, what exactly did you do? I can see the difference in the scripts, but what does it do?

If you have time to help a rookie out, thanks... If not, thanks just the same for satisfying the request. Wink

Joined: Jan 31, 2004 Posts: -88

ok this bit here:

Code:

(t.forum_id=f.forum_id and f.forum_id<> [insert spam forum id here])

tells it what forums to look @

the bit that says "f.forum_id <> bla bla bla" is the same as f.forum_id != bla bla bla or where the forum id isn't equal to bla bla bla

ok?

AI

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

gotit... thanks much!

Razz