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..
- <?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 = " <img src=\"$IconPath\" border=\"0\" alt=\"\">";
- $TopicTitleShow = "<a href=\"modules.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 = 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> <b>|</b> "._BBFORUM_TOTPOSTS."<b>$Amount_Of_Posts</b> <b>|</b> "._BBFORUM_TOTVIEWS."<b>$Amount_Of_Topic_Views</b> <b>|</b> "._BBFORUM_TOTREPLIES."<b>$Amount_Of_Topic_Replies</b> <b>|</b> <a href=\"modules.php?name=Members_List\">"._BBFORUM_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;
- 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 .= " <a href=\"modules.php?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=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\"><img alt src=\"modules/Forums/images/avatars/$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://udesign.me.uk>©</a></p>";
- ?>