[jwalsh8888]

I was wondering how hard would it be to restrict the Forums Scroller block from showing certain private Forums. I'm sure this wouldn't be too hard. I basically want it to query only certain "forum ids" ?

Any help would be appreciated as I'm learning, but it's slow due to serious time constraints.

[mikem]

Glad we covered this before :wink:
http://www.nukemods.com/modules.php?...ewtopic&t=1539

mikem

[jwalsh8888]

thanks, I did searches on 3 different sites and didn't find anything but as usual if you don't know what was already discussed it's sometimes hard to find it.

Thx man.

[mikem]

Originally Posted by jwalsh8888

thanks, I did searches on 3 different sites and didn't find anything but as usual if you don't know what was already discussed it's sometimes hard to find it.

Thx man.

you are exactly right there :wink:

[jwalsh8888]

well this won't be easy as I thought, maybe I will download your center block so I can see what it's doing so I guess at what needs to be done one this specific block. Will ask for help when I fail :wink:

[jwalsh8888]

sorry should have maybe clarified that I wasn't use the Center Forums Block that comes with some themes. I'm using this small code below

......

include_once ('blocks/smileys.php');

global $prefix, $dbi, $sitename, $user, $cookie, $group_id, $user_prefix;
$count = 1;
$content = "<A name= \"scrollingCode\"></A>";
$content .="<MARQUEE behavior= \"scroll\" align= \"center\" direction= \"up\" height=\"200\" scrollamount= \"1.9\" scrolldelay= \"20\" onmouseover='this.stop()' onmouseout='this.start()'>";
$content .="<center> <STYLE=\"text-decoration: none\"><font color=\"#666666\">Last 10 Forum Messages</center>";
$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC LIMIT 10", $dbi);
$content .= "
";
while(list($topic_id, $topic_last_post_id, $topic_title) = 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\"><font color=\"#666666\">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>
<font color=\"#666666\">Last post by <A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"STYLE=\"text-decoration: none\"> $username </a> on $post_time</font>

";
$count = $count + 1;
}
$content .= "
<center>[ <a href=\"modules.php?name=Forums\"STYLE=\"text-decoration: none\">$sitename ]</center>";
$content .= "<center><img src=\"images/banners/logosmall.gif\" border=\"0\"></center>
</a>";
cookiedecode($user);
$username = $cookie[1];
$result = sql_query("select user_new_privmsg from ".$user_prefix."_users where username='$username'", $dbi);
list($numrow) = sql_fetch_row($result, $dbi);
......
}

[jwalsh8888]

nevermind I suck... If I knew anything about programming for databases this would have been easier for me. All I did was change the code:

$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC LIMIT 10", $dbi);

to

$result1 = sql_query("SELECT topic_id, topic_last_post_id, topic_title FROM ".$prefix."_bbtopics where forum_id=1 ORDER BY topic_last_post_id DESC LIMIT 10", $dbi);

obviously forum_id=(whatever forum you want displayed)

[mikem]

:wink: