To IP Developers - User Friendly Recent Forum Topics Block

Posts: 52

Sat 14 Mar, 2009 02:59

Subject: To IP Developers - User Friendly Recent Forum Topics Block

Hello,
In IP i add recent topics block for my IP index page.but thatone is not more user friendly.Can anyone please help me to develop a good & nice Recent topics block ? I saw in Php-nuke have their own nice looking forum information [recent forum topics] block .Can i customize it to IP?

Here is the Screenshot and the specific code for th php-nuke...Can anyone help me to develop this type of block to my IP..

Code: [Download] [Hide]

<?php
 
if( eregi( "block-Forums_Center.php",$PHP_SELF ) )
 
{
 
   Header("Location: index.php");
 
   die();
 
}
 
global $user, $cookie, $sitename, $prefix, $user_prefix, $dbi, $sitename, $admin, $module_name, $bgcolor1, $bgcolor2;
 
// 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 = sql_query( "SELECT * FROM ".$prefix."_bbtopics", $dbi );
 
$Amount_Of_Topics = sql_num_rows( $result );
 
/* Total Amount of Posts */
 
$result = sql_query( "SELECT * FROM ".$prefix."_bbposts", $dbi );
 
$Amount_Of_Posts = sql_num_rows( $result );
 
/* Total Amount of Topic Views */
 
$Amount_Of_Topic_Views = 0;
 
$result = sql_query( "SELECT topic_views FROM ".$prefix."_bbtopics", $dbi );
 
while( list( $topic_views ) = sql_fetch_row( $result, $dbi ) )
 
{
 
   $Amount_Of_Topic_Views = $Amount_Of_Topic_Views + $topic_views;
 
}
 
/* Total Amount of Topic Replies */
 
$Amount_Of_Topic_Replies = 0;
 
$result = sql_query( "SELECT topic_replies FROM ".$prefix."_bbtopics", $dbi );
 
while( list( $topic_replies ) = sql_fetch_row( $result, $dbi ) )
 
{
 
   $Amount_Of_Topic_Replies = $Amount_Of_Topic_Replies + $topic_replies;
 
}
 
/* Total Amount of Members */
 
$result = sql_query( "SELECT * FROM ".$prefix."_users", $dbi );
 
$Amount_Of_Members = sql_num_rows( $result );
 
/* Last X New Topics */
 
$Count_Topics = 0;
 
$Topic_Buffer = "";
 
$result1 = 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( $result1, $dbi ) )
 
{
 
   $skip_display = 0;
 
   if( $HideViewReadOnly == 1 )
 
   {
 
      $result5 = sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'", $dbi );
 
      list( $auth_view, $auth_read ) = sql_fetch_row( $result5, $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 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'", $dbi );
 
      list( $topic_id, $poster_id, $post_time ) = sql_fetch_row( $result2, $dbi );
 
      $result3 = sql_query( "SELECT username, user_id FROM ".$prefix."_users where user_id='$poster_id'", $dbi );
 
      list( $username, $user_id ) = sql_fetch_row( $result3, $dbi );
 
      $LastPoster = "<a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$username</a>";
 
      $result4 = sql_query( "SELECT username, user_id FROM ".$prefix."_users where user_id='$topic_poster'", $dbi );
 
      list( $username, $user_id ) = sql_fetch_row( $result4, $dbi );
 
      $OrigPoster = "<A HREF=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"STYLE=\"text-decoration: none\"> $username </a>";
 
      $TopicImage = "&nbsp;<img src=\"$IconPath\" 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><td>$TopicImage&nbsp;&nbsp;$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&nbsp;<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 = sql_query("SELECT * FROM ".$prefix."_bbcategories", $dbi);
 
$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\" >"._BBFORUM_TOTTHREAD."</td><td align=\"center\">"._BBFORUM_POSTER."</td><td align=\"center\">"._BBFORUM_VIEWS."</td><td align=\"center\">"._BBFORUM_REPLIES."</td><td align=\"center\">"._BBFORUM_LASTPOSTER."</td></tr>";
 
$content .= "$Topic_Buffer";
 
$content .= "<tr><td align=\"center\" colspan=\"6\">"._BBFORUM_TOTTOPICS."<b>$Amount_Of_Topics</b>&nbsp;<b>|</b>&nbsp;"._BBFORUM_TOTPOSTS."<b>$Amount_Of_Posts</b>&nbsp;<b>|</b>&nbsp;"._BBFORUM_TOTVIEWS."<b>$Amount_Of_Topic_Views</b>&nbsp;<b>|</b>&nbsp;"._BBFORUM_TOTREPLIES."<b>$Amount_Of_Topic_Replies</b>&nbsp;<b>|</b>&nbsp;<a href=\"modules.php?name=Members_List\">"._BBFORUM_TOTMEMBERS."</a>&nbsp;<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;
 
    global $user, $cookie, $sitename, $prefix, $user_prefix, $dbi, $admin, $module_name;
 
    $result=sql_query("SELECT user_id, username, user_posts, user_avatar FROM ".$user_prefix."_users ORDER BY user_posts DESC LIMIT 0,5", $dbi);
 
    while(list($user_id, $username, $user_posts, $user_avatar) = sql_fetch_row($result, $dbi)) {
 
$content .= "<td width=\"32\" vAlign=\"middle\">";
 
if (eregi("http://", $user_avatar)) {
 
$content .= "&nbsp;&nbsp;<a href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=$user_id\"><img alt src=\"$user_avatar\" border =\"0\" width=\"32\" height=\"32\"></a></td>";
 
}
 
else
 
$content .= "&nbsp;&nbsp;<a href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=$user_id\"><img alt src=\"modules/Forums/images/avatars/$user_avatar\" border =\"0\" width=\"32\" height=\"32\"></a></td>";
 
$content .= "<td vAlign=\"middle\">&nbsp;<a href=\"modules.php?name=Forums&amp;file=profile&amp;mode=viewprofile&amp;u=$user_id\"><b>$username</b></a>&nbsp;<br>&nbsp;<a href=\"modules.php?name=Forums&amp;file=search&amp;search_author=$username\">Posts:</a>&nbsp; ";
 
$content .= "&nbsp;<a href=\"modules.php?name=Forums&amp;file=search&amp;search_author=$username\">$user_posts</a>&nbsp;</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://udesign.me.uk>©</a></p>";
 
?>

Profile PM

DWho

Quote

Posts: 1307 Location: hampshire

Sat 14 Mar, 2009 13:32

Subject: Re: To IP Developers - User Friendly Recent Forum Topics Block

you can edit the block to add the extra information you need...

list what you want to show.. and I will have a look..

:mrgreen: :mrgreen:

Profile PM Website MSN

system

Quote

Posts: 52

Sat 14 Mar, 2009 16:58

Subject: Re: To IP Developers - User Friendly Recent Forum Topics Block

Profile PM

DWho

Quote

Posts: 1307 Location: hampshire

Mon 16 Mar, 2009 18:48

Subject: Re: To IP Developers - User Friendly Recent Forum Topics Block

Block released here

http://www.icyphoenix.com/viewtopic.php?f=2&p=37429#p37429

:mrgreen: :mrgreen:

Profile PM Website MSN

Reply to topic

Page 1 of 1

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.5253s (PHP: 3% SQL: 97%)
SQL queries: 29 - Debug Off - GZIP Enabled

Icy Phoenix

Icy Phoenix - Powering Communities

To IP Developers - User Friendly Recent Forum Topics Block