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]
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.
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 !
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());
?>