"; $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 .="  $topic_title $topic_replies $avtor $topic_views   $post_time 
$username  "; } if( $Last_New_Topics == $Count_Topics ) { break 1; } } $content .= "

"; $content .= "$viewlast"; $content .= "$show"; ?> Topics  Replies   Author   Views   Last Post