<?php

/********************************************************/
/* Center Forum Block for PHP-Nuke                      */
/* By: Telli (telli@codezwiz.com)                       */
/* http://codezwiz.com/                                 */
/* Copyright © 2000-2003 by Codezwiz                    */
/********************************************************/

// Center block Forums
define("_CZCENTERFORUM_NEWTOPICS","New Topics");
define("_CZCENTERFORUM_POSTER","Poster");
define("_CZCENTERFORUM_VIEWS","Views");
define("_CZCENTERFORUM_REPLIES","Replies");
define("_CZCENTERFORUM_LASTPOSTER","Last Poster");
define("_CZCENTERFORUM_TOTTOPICS","Topics: ");
define("_CZCENTERFORUM_TOTPOSTS","Posts: ");
define("_CZCENTERFORUM_TOTVIEWS","Views: ");
define("_CZCENTERFORUM_TOTREPLIES","Replies: ");
define("_CZCENTERFORUM_TOTMEMBERS","Members:");
define("_CZCENTERFORUM_FORUM","Enter Forum");
define("_CZCENTERFORUM_SEARCH","Search Forum");
define("_CZCENTERFORUM_TITLE","Latest from");

if( eregi( "block-CZenterforums.php", $_SERVER['PHP_SELF'])) {
   Header("Location: index.php");
   die();
}
global $prefix, $user_prefix, $db, $dbi, $sitename, $bgcolor1, $bgcolor2, $bgcolor3, $ThemeSel;



/****************************/
/* Main Block Configuration */
/****************************/
// background color for block
$mainblock_bgcolor = $bgcolor1;

// When set to 1 then Forums permissions will apply.
$permissionstoread = 0;

// # Of Topics
$Lastest_posts  = 5;

// Spacing                           
$cellspacing      = 0;

// Padding
$cellpadding      = 3;

// Nice Borders :-)
$cellstyle2       = "BORDER-TOP:1px solid;BORDER-BOTTOM:1px solid;BORDER-LEFT:1px solid;BORDER-RIGHT:1px solid;border-collapse:collapse;border-color:$borders";

/***************************/
/* Add Your Themes Here    */
/***************************/
$mainblock_bgcolor = $bgcolor1; /* background color for block */

switch($ThemeSel)
{
case "ClanMtS" :
   $table_topbg = "themes/ClanMtS/forums/images/top_center2.gif";
   $Iconimagepath = "themes/ClanMtS/forums/images/folder_new.gif";
   $borders  = "#444444 #777777 #444444 #777777";
    break;

}
/**********************/
/* Don't Edit Below ! */
/**********************/
/* Total Amount of Topics */
$result = $db->sql_query( "SELECT * FROM ".$prefix."_bbtopics" );
$Amount_Of_Topics = $db->sql_numrows( $result );

/* Total Amount of Posts */
$result = $db->sql_query( "SELECT * FROM ".$prefix."_bbposts" );
$Amount_Of_Posts = $db->sql_numrows( $result );

/* Total Amount of Topic Views */
$Amount_Of_Topic_Views = 0;
$result = $db->sql_query( "SELECT topic_views FROM ".$prefix."_bbtopics" );
while( list( $topic_views ) = $db->sql_fetchrow( $result ) )
{
   $Amount_Of_Topic_Views = $Amount_Of_Topic_Views + $topic_views;
}

/* Total Amount of Topic Replies */
$Amount_Of_Topic_Replies = 0;
$result = $db->sql_query( "SELECT topic_replies FROM ".$prefix."_bbtopics" );
while( list( $topic_replies ) = $db->sql_fetchrow( $result ) )
{
   $Amount_Of_Topic_Replies = $Amount_Of_Topic_Replies + $topic_replies;
}

/* Total Amount of Members */
$result = $db->sql_query( "SELECT * FROM ".$user_prefix."_users" );
$Amount_Of_Members = $db->sql_numrows( $result ) - 1;

/* Last X New Topics */
$Count_Topics = 0;
$Topic_Buffer = "";
$result1 = $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 ) = sql_fetch_row( $result1, $dbi ) )
{
   $skip_display = 0;
   if( $permissionstoread == 1 )
   {
      $result5 = $db->sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'" );
      list( $auth_view, $auth_read ) = $db->sql_fetchrow( $result5 );
      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 = $db->sql_query( "SELECT topic_id, poster_id, FROM_UNIXTIME( post_time,'%b %d, %Y at %T') as post_time FROM ".$prefix."_bbposts where post_id = '$topic_last_post_id'" );
      list( $topic_id, $poster_id, $post_time ) = $db->sql_fetchrow( $result2 );

      $result3 = $db->sql_query( "SELECT username, user_id FROM ".$user_prefix."_users where user_id='$poster_id'" );
      list( $uname, $uid ) = $db->sql_fetchrow( $result3 );
      $LastPoster = "<A HREF=\"forum-userprofile-.html$uid\"STYLE=\"text-decoration: none\"> $uname </a>";
     
      $result4 = $db->sql_query( "SELECT username, user_id FROM ".$user_prefix."_users where user_id='$topic_poster'" );
      list( $uname, $uid ) = $db->sql_fetchrow( $result4 );
      $OrigPoster = "<A HREF=\"forum-userprofile-.html$uid\"STYLE=\"text-decoration: none\"> $uname </a>";
   
      $TopicImage = "<img src=\"\" border=\"0\" alt=\"\">";
      $TopicTitleShow = "<a href=\"modules.php?name=Forums&amp;file=viewtopic&amp;p=$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\">$topic_title</a>";

      $Topic_Buffer .= "<tr height=20><td style=\"$cellstyle2\" align=\"center\">$TopicImage</td><td style=\"$cellstyle2\"> $TopicTitleShow</td><td style=\"$cellstyle2\"><div align=\"center\">$OrigPoster</div></td><td style=\"$cellstyle2\"><div align=\"center\"><b>$topic_views</b></div></td><td style=\"$cellstyle2\"><div align=\"center\"><b>$topic_replies</b></div></td><td $cellstyle align=\"center\"style=\"$cellstyle2\">$LastPoster<br><font size=\"-2\"><i>$post_time</i></font></td></tr>";
   }
   
   if( $Lastest_posts == $Count_Topics ) { break 1; }
   /* Write Table to Screen */
$content  = "<table width=\"100%\" cellspacing=\"$cellspacing\" bgcolor=\"$mainblock_bgcolor\" style=\"$cellstyle2\"><tr><tr><table width=\"100%\" cellpadding=\"$cellpadding\" cellspacing=\"$cellspacing\" bgcolor=\"$mainblock_bgcolor\" style=\"$cellstyle2\">";

$content .= "<tr><td width=\"100%\" height=\"24\" colspan=\"6\" align=\"center\" background=\"$table_topbg\" style=\"$cellstyle2\"><font class=\"boxtitle\"><b>Forum Categories</b></font></td></tr>";

$content .= "<tr><td width=\"100%\" height=\"21\" colspan=\"6\" align=\"left\" bgcolor=\"$mainblock_bgcolor\" style=\"$cellstyle2\">";

{
      $forum_id = $forum_row[0];
      $forum_title = $forum_row[2];
      $for_count ++;
      $content .= "&nbsp&nbsp&nbsp&nbsp<a href=\"modules.php?name=Forums&file=viewforum&f=$forum_id\">$forum_title</a>";
   }

}
$content .= "</td></tr>";

$content .= "<tr><td width=\"100%\" height=\"24\" colspan=\"6\" align=\"center\" background=\"$table_topbg\" style=\"$cellstyle2\"><font class=\"boxtitle\"><b>Lastest Posts</b></font></td></tr>";

$content .= "<tr bgcolor=$bgcolor1><td style=\"$cellstyle2\">   </td><td align=\"center\" style=\"$cellstyle2\">"._CZCENTERFORUM_NEWTOPICS."</td><td align=\"center\" style=\"$cellstyle2\">"._CZCENTERFORUM_POSTER."</td><td align=\"center\" style=\"$cellstyle2\">"._CZCENTERFORUM_VIEWS."</td><td align=\"center\" style=\"$cellstyle2\">"._CZCENTERFORUM_REPLIES."</td><td align=\"center\" style=\"$cellstyle2\">"._CZCENTERFORUM_LASTPOSTER."</td></tr>";
$content .= "$Topic_Buffer";
$content .= "<tr><td align=\"center\" colspan=\"6\" style=\"$cellstyle2\"><font class=\"tiny\">"._CZCENTERFORUM_TOTTOPICS."<b>$Amount_Of_Topics</b> <b>|</b> "._CZCENTERFORUM_TOTPOSTS."<b>$Amount_Of_Posts</b> <b>|</b> "._CZCENTERFORUM_TOTVIEWS."<b>$Amount_Of_Topic_Views</b> <b>|</b> "._CZCENTERFORUM_TOTREPLIES."<b>$Amount_Of_Topic_Replies</b> <b>|</b> <a href=\"modules.php?name=Members_List\">"._CZCENTERFORUM_TOTMEMBERS."</a> <b>$Amount_Of_Members</b></center></td></tr>";
$content .= "<tr><td align=\"center\" colspan=\"6\" style=\"$cellstyle2\">[ <a href=\"forums.html\">"._CZCENTERFORUM_FORUM."</a> ]   [ <a href=\"modules.php?op=modload&name=Forums&file=search\">"._CZCENTERFORUM_SEARCH."</a> ]</center></font></td></tr></td></tr>";
$content .= $table_bottom;
$content .= "</table>";

?>