[Jazket]

Hey guys, i need a little bit of help with this please...

I was looking around here but i didnt find anything related to my problem...

well, i got a center block called "fiapple-Forums" its a recent topics displayer for the index page.... it shows everything nice, like creator, last poster, time and all.... but it does not show latest topics made on hidden or private forums....

i wonder if you guys know how to fix that, i know you know lol. thats why im asking....

here is the code... somebody made that block to work well with the fiapple theme. i edited a few stuff like the images source so it could match with my theme, the fiblack3d. i edited it so it could show me 13 recent topics and match with the theme's images...

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

global $prefix, $dbi, $sitename, $admin;

$HideViewReadOnly = 1;

$Last_New_Topics  = 13;
$show = "  <tr>
    <td height=\"28\" colspan=\"6\" align=\"center\" class=\"catbottom\" background=\"themes/fiblack3d/forums/images/cat_bkg.gif\"></td>
  </tr>
</table></td>
        </tr>
      </table></td>
  </tr>
</table>";

$Count_Topics = 0;
$Topic_Buffer = "";
$result = sql_query( "SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_poster, topic_views, topic_replies, topic_moved_id FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC", $dbi );
while( list( $topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_poster, $topic_views, $topic_replies, $topic_moved_id ) = sql_fetch_row( $result, $dbi ) )

{
   $skip_display = 0;
   if( $HideViewReadOnly == 1 )
   {
      $result1 = sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'", $dbi );
      list( $auth_view, $auth_read ) = sql_fetch_row( $result1, $dbi );
      if( ( $auth_view != 0 ) or ( $auth_read != 0 ) ) { $skip_display = 1; }
   }

   if( $topic_moved_id != 0 )
   {
	  // Shadow Topic !!
      $skip_display = 1;
   }

   if( $skip_display == 0 )
   {
	  $Count_Topics += 1;

$result2 = sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$topic_poster'", $dbi);
list($username, $user_id)=sql_fetch_row($result2, $dbi);
$avtor=$username;
$sifra=$user_id;

$result3 = sql_query("SELECT poster_id, FROM_UNIXTIME(post_time,'%m/%d/%Y at %H:%i') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);
list($poster_id, $post_time)=sql_fetch_row($result3, $dbi);

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

            	          $viewlast .="  <tr>
    <td height=\"30\" nowrap bgcolor=\"#f5f5f5\" class=\"row1\"><img src=\"themes/fiblack3d/forums/images/folder_new.gif\" border=\"0\" /></td>
    <td width=\"100%\" bgcolor=\"#f5f5f5\" class=\"row1\"><a href=\"modules.php?name=Forums&file=viewtopic&t=$topic_id#$topic_last_post_id\">$topic_title</a></td>
    <td align=\"center\" bgcolor=\"#ececec\" class=\"row2\">$topic_replies</td>
    <td align=\"center\" bgcolor=\"#ececec\" class=\"row3\"><a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$sifra\">$avtor</a></td>
    <td align=\"center\" bgcolor=\"#f5f5f5\" class=\"row2\">$topic_views</td>
    <td align=\"center\" nowrap bgcolor=\"#ececec\" class=\"row3\"><font size=\"-2\">$post_time</font>

      <a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$username</a><a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"><img src=\"themes/fiblack3d/forums/images/icon_minipost_new.gif\" border=\"0\" alt=\"Latest Post\"></a></td>
  </tr>";
}

   if( $Last_New_Topics == $Count_Topics ) { break 1; }

}

    $content .= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
  <tr>
    <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
        <tr>
          <td bgcolor=\"#D1D7DC\"><table width=\"100%\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\">
  <tr>
    <th height=\"25\" colspan=\"2\" align=\"center\" nowrap background=\"themes/fiblack3d/forums/images/cat_bkg.gif\" class=\"thcornerl\"><font color=\"#D0A700\">Topics</font></th>
    <th width=\"50\" align=\"center\" nowrap background=\"themes/fiblack3d/forums/images/cat_bkg.gif\" class=\"thtop\"><font color=\"#D0A700\">Replies</font></th>
    <th width=\"100\" align=\"center\" nowrap background=\"themes/fiblack3d/forums/images/cat_bkg.gif\" class=\"thtop\"><font color=\"#D0A700\">Author</font></th>
    <th width=\"50\" align=\"center\" nowrap background=\"themes/fiblack3d/forums/images/cat_bkg.gif\" class=\"thtop\"><font color=\"#D0A700\">Views</font></th>
    <th align=\"center\" nowrap background=\"themes/fiblack3d/forums/images/cat_bkg.gif\" class=\"thcornerr\"><font color=\"#D0A700\">Last Post</font></th>
  </tr>";
    $content .= "$viewlast";

 $content .= "$show";

?>

i guess this is where it should be declared. but i dont know the syntax for that....

$Count_Topics = 0;
$Topic_Buffer = "";
$result = sql_query( "SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_poster, topic_views, topic_replies, topic_moved_id FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC", $dbi );
while( list( $topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_poster, $topic_views, $topic_replies, $topic_moved_id ) = sql_fetch_row( $result, $dbi ) )

{
   $skip_display = 0;
   if( $HideViewReadOnly == 1 )
   {
      $result1 = sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'", $dbi );
      list( $auth_view, $auth_read ) = sql_fetch_row( $result1, $dbi );
      if( ( $auth_view != 0 ) or ( $auth_read != 0 ) ) { $skip_display = 1; }

there is something there about the $HideViewReadOnly == 1... i havent tried settin that to 0, ill do that... anyways, if thats not it, and you guys know the answer, please let me know... thanks...

also, is there a way i could set Private forums with different color? to disguise those from the public ones? thanks again...

thankz lotz....