|
also pmd you floppy
| Code:
|
<?php
if( eregi("block-Forums_Center.php",$PHP_SELF ) )
{
Header("Location: index.php");
die();
}
$server = 'localhost';
$username = ;
$password = '';
$database = 'weaser31_forum';
$link = mysql_connect($server,$username,$password) OR DIE("BAD 1");
mysql_select_db($database) OR DIE("BAD 2");
//Language Defines
define("_phpbb_forums_TOTTHREAD","Thread :: Post");
define("_phpbb_forums_TOTTOPICS","Topics");
define("_phpbb_forums_TOTPOSTS","Posts");
define("_phpbb_forums_TOTVIEWS","Views");
define("_phpbb_forums_TOTREPLIES","Total Replies");
define("_phpbb_forums_TOTMEMBERS","Members");
define("_phpbb_forums_POSTER","Posted by");
define("_phpbb_forums_VIEWS","Views");
define("_phpbb_forums_REPLIES","Replies");
define("_phpbb_forums_LASTPOSTER","Last Post");
//End Language
// When set to 1 then Forums permissions which View and/or Read are NOT set to 'ALL' will NOT be displayed in the center block
$HideViewReadOnly = 'ALL';
// Show only 5 last new topics
$Last_New_Topics = 5;
// Icon that is displayed in Center Block in front of Topic
$IconPath ="images/msg.png";
//size of the outer border
$border = 1;
//cell spacing around the tables
$cellspacing = 0;
/* Total Amount of Topics */
$result = mysql_query("SELECT * FROM phpbb_topics");
echo mysql_error();
$Amount_Of_Topics = mysql_num_rows( $result );
/* Total Amount of Posts */
$result = mysql_query ("SELECT * FROM phpbb_posts");
echo mysql_error();
$Amount_Of_Posts = mysql_num_rows( $result );
/* Total Amount of Topic Views */
$Amount_Of_Topic_Views = 0;
$result = mysql_query("SELECT topic_views FROM phpbb_topics");
echo mysql_error();
while( list( $topic_views ) = mysql_fetch_row($result) )
{
$Amount_Of_Topic_Views = $Amount_Of_Topic_Views + $topic_views;
}
/* Total Amount of Topic Replies */
$Amount_Of_Topic_Replies = 0;
$result = mysql_query("SELECT topic_replies FROM phpbb_topics");
echo mysql_error();
while( list( $topic_replies ) = mysql_fetch_row( $result ) )
{
$Amount_Of_Topic_Replies = $Amount_Of_Topic_Replies + $topic_replies;
}
/* Total Amount of Members */
$result = mysql_query("SELECT * FROM phpbb_users");
echo mysql_error();
$Amount_Of_Members = mysql_num_rows ( $result );
/* Last X New Topics */
$Count_Topics = 0;
$Topic_Buffer ="";
$result1 = mysql_query("SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_poster, topic_views, topic_replies, topic_moved_id FROM phpbb_topics ORDER BY topic_last_post_id DESC");
echo mysql_error();
while( list( $topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_poster, $topic_views, $topic_replies, $topic_moved_id ) = mysql_fetch_row( $result1 ) )
{
$skip_display = 0;
if( $HideViewReadOnly == 1 )
{
$result5 = mysql_query("SELECT auth_view, auth_read FROM phpbb_forums where forum_id = '$forum_id'");
echo mysql_error();
list( $auth_view, $auth_read ) = mysql_fetch_row( $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 = mysql_query("SELECT topic_id, poster_id, FROM_UNIXTIME( post_time,'%b %d, %Y at %T') as post_time FROM phpbb_posts where post_id = '$topic_last_post_id'");
echo mysql_error();
list( $topic_id, $poster_id, $post_time ) = mysql_fetch_row( $result2 );
$result3 = mysql_query("SELECT username, user_id FROM phpbb_users where user_id='$poster_id'");
echo mysql_error();
list( $username, $user_id ) = mysql_fetch_row( $result3 );
$LastPoster ="<a href=\"forum-userprofile-.html$user_id\">$username</a>";
$result4 = mysql_query("SELECT username, user_id FROM phpbb_users where user_id='$topic_poster'");
echo mysql_error();
list( $username, $user_id ) = mysql_fetch_row( $result4 );
$OrigPoster ="<A HREF=\"forum-userprofile-.html$user_id\"STYLE=\"text-decoration: none\"> $username </a>";
$TopicImage =" <img src=\"$IconPath\" border=\"0\" alt=\"\">";
$TopicTitleShow ="<a href=\"phpBB3/viewtopic.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"STYLE=\"text-decoration: none\">$topic_title</a>";
$Topic_Buffer .="<tr><td>$TopicImage $TopicTitleShow</td><td><div align=\"center\">$OrigPoster</div></td><td><div align=\"center\"><b>$topic_views</b></div></td><td><div align=\"center\"><b>$topic_replies</b></div></td><td align=\"center\">$LastPoster <a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"><img src=\"images/icon_latest_reply.gif\" border=\"0\"></a><br><font size=\"-2\"><i>$post_time</i></font></td></tr>";
}
if( $Last_New_Topics == $Count_Topics ) { break 1; }
}
//$cat = mysql_query("SELECT * FROM phpbb_bbcategories");
//echo mysql_error();
//$content ="";
/* Write Table to Screen */
$content .="<center><table width=\"100%\" border=\"$border\" cellspacing=\"$cellspacing\" bordercolor=\"#292929\">";
$content .="<td width=\"100%\" height=\"21\" colspan=\"6\" align=\"center\"><STRONG>Last 5 Forum Posts</STRONG></td></tr>";
$content .="<td rowspan=\"0\" >";
$content .="<table width=\"100%\" cellpadding=\"$cellspacing\" bordercolor=\"$bgcolor1\" cellspacing=\"1\" border=\"$border\" vAlign=\"top\">";
$forum_id = $forum_row[0];
$forum_title = $forum_row[5];
$for_count ++;
$content .="</table>";
$content .="<tr><td align=\"center\" >"._phpbb_forums_TOTTHREAD."</td><td align=\"center\">"._BBFORUM_POSTER."</td><td align=\"center\">"._phpbb_forums_VIEWS."</td><td align=\"center\">"._BBFORUM_REPLIES."</td><td align=\"center\">"._phpbb_forums_LASTPOSTER."</td></tr>";
$content .="$Topic_Buffer";
$content .="<tr><td align=\"center\" colspan=\"6\">"._phpbb_forums_TOTTOPICS."<b>$Amount_Of_Topics</b> <b>|</b>"._phpbb_forums_TOTPOSTS."<b>$Amount_Of_Posts</b> <b>|</b>"._BBFORUM_TOTVIEWS."<b>$Amount_Of_Topic_Views</b> <b>|</b>"._phpbb_forums_TOTREPLIES."<b>$Amount_Of_Topic_Replies</b> <b>|</b> <a href=\"modules.php?name=Members_List\">"._phpbb_forums_TOTMEMBERS."</a> <b>$Amount_Of_Members</b></center></td></tr>";
$content .="<tr><td colspan=\"6\">";
$content .="<table width=\"100%\" cellpadding=\"0\" bordercolor=\"$bgcolor1\" cellspacing=\"$cellspacing\" border=\"0\" vAlign=\"top\" height=\"32\">";
$content .="<tr>";
$a = 1;
$result=mysql_query("SELECT user_id, username, user_posts, user_avatar FROM phpbb_users ORDER BY user_posts DESC LIMIT 0,5");
echo mysql_error();
while(list($user_id, $username, $user_posts, $user_avatar) = mysql_fetch_row($result)) {
$content .="<td width=\"32\" vAlign=\"middle\">";
if (eregi("http://", $user_avatar)) {
$content .=" <a href=\"phpBB3/images/avatars?name=Forums&file=profile&mode=viewprofile&u=$user_id\"><img alt src=\"$user_avatar\" border =\"0\" width=\"32\" height=\"32\"></a></td>";
}
else
{
$content .=" <a href=\"phpBB3/images/avatars/upload?name=Forums&file=profile&mode=viewprofile&u=$user_id\"><img alt src=\"phpBB3/images/avatars/upload/$user_avatar\" border =\"0\" width=\"32\" height=\"32\"></a></td>";
$content .="<td vAlign=\"middle\"> <a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"><b>$username</b></a> <br> <a href=\"modules.php?name=Forums&file=search&search_author=$username\">Posts:</a> ";
$content .=" <a href=\"modules.php?name=Forums&file=search&search_author=$username\">$user_posts</a> </td>";
}
}
$content .="</tr></table>";
$content .="</td><tr>";
$content .="</table>";
//Please leave the following link in place so other people can also share this block !!
$content .= "<p align=right><a href='http://www.clan-themes.co.uk'>Clan Themes ©</a></p>";
mysql_close($link);
?>
|
|
|
|
