Suche

[MrASS]

Is it not possible to let the center block only show topics/postings from a private forum ??

Im hosting a clansite, and our center block is only visible to the members of the clan !

But in order to keep uptodate all the time, id like only to show posts/replyes from the private forum, is this possible ?

Http://www.darkrebels.dk

[Editiert am 12/5/2003 von MrASS]

[tequila]

Hi Mrass,

for this you have to modify line 201 in "blocks/block-eBoard_Center.php" from:


$query = mysql_query("SELECT tid, views, subject, lastpost, dateline, replies, author, icon, fid FROM $table_threads ORDER BY lastpost Desc LIMIT 0, $posts") or die(mysql_error());


to


$query = mysql_query("SELECT tid, views, subject, lastpost, dateline, replies, author, icon, fid FROM $table_threads WHERE fid='12' ORDER BY lastpost Desc LIMIT 0, $posts") or die(mysql_error());


For "WHERE fid='12' " you have to set the forums-id of the desired, private forum.
If you don´t know this forums-id (fid), get into this forum and watch the browser-URL. There you can see an entry called &fid=xx
XX ist the fid of the actuall visited forum.

[MrASS]

Hi, thx very much for the fast reply !

However, im getting an error when I use it, sounds like this :
"You have an error in your SQL syntax near '& nbsp;dateline, replies, author, icon, fid FROM&nbs p;nuke_xmb_threads WHERE fi' at line 1"

I only changed the 12 till a 9 which hold the private forum !

[MrASS]

Hi again ..

Fixed it myself, I just took the original code from above, and added : WHERE fid='XX' after $table_threads so it all lokked like this  :

<?

$query = mysql_query("SELECT tid, views, subject, lastpost, dateline, replies, author, icon, fid FROM $table_threads WHERE fid='9' ORDER BY lastpost Desc LIMIT 0, $posts") or die(mysql_error());

?>