"; $Count_Topics = 0; $Topic_Buffer = ""; $result = $db->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"); while( list( $topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_poster, $topic_views, $topic_replies, $topic_moved_id ) = $db->sql_fetchrow($result) ) { $skip_display = 0; if( $HideViewReadOnly == 1 ) { $result2 = $db->sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'"); list( $auth_view, $auth_read ) = $db->sql_fetchrow( $result2 ); if( ( $auth_view != 0 ) or ( $auth_read != 0 ) ) { $skip_display = 1; } } if( $topic_moved_id != 0 ) { $skip_display = 1; } if( $skip_display == 0 ) { $Count_Topics += 1; $result2 = $db->sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$topic_poster'"); list($username, $user_id)=$db->sql_fetchrow($result2); $avtor=$username; $sifra=$user_id; $result3 = $db->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'"); list($poster_id, $post_time)=$db->sql_fetchrow($result3); $result4 = $db->sql_query("SELECT username, user_id FROM ".$prefix."_users where user_id='$poster_id'"); list($username, $user_id)=$db->sql_fetchrow($result4); $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