You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 307 guest(s) and 19 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Where can I find this block? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Divvy
Lieutenant
Lieutenant


Joined: Jul 25, 2004
Posts: 218


PostPosted: Mon Aug 04, 2008 8:39 am Reply with quoteBack to top

Hi friends,

Where can I find a block that allow me to show the last 10 recent posts in a specific forums...
The idea is only to show the last posts of only 5 forum sections.

Any ideia where I can find? Smile


Or any ideia how to make that in this block?
Code:
<?php

########################################################################
# PHP-Nuke Block: fiblack Center Forum Block v.2              #
# Made for PHP-Nuke 6.5 and up                       #
#                                                                      #
# Made by mikem http://www.nukecops.com                                #
########################################################################
# This block is made only to match the phpib2 Theme pack               #
# This program is free software. You can redistribute it and/or modify #
# it under the terms of the GNU General Public License as published by #
# the Free Software Foundation; either version 2 of the License.       #
# If you modify this, let me know for fun. =)                          #
########################################################################

if (eregi("block-fiblack-Forum.php",$PHP_SELF)) {
    Header("Location: index.php");
    die();
}
   
global $prefix, $dbi, $sitename, $admin;

$HideViewReadOnly = 0;
          
$Last_New_Topics  = 5;
$show = "  <tr>
    <td height=\"28\" colspan=\"6\" align=\"center\" class=\"catbottom\" background=\"modules/Forums/templates/arkanian/images/cellpic3.gif\">&nbsp;</td>
  </tr>
</table></td>
        </tr>
      </table></td>
  </tr>
</table><br>";

$Count_Topics = 0;
$Topic_Buffer = "";
$result = sql_query( "SELECT t.topic_id, f.forum_name, f.forum_id, t.topic_last_post_id, t.topic_title, t.topic_poster, t.topic_views, t.topic_replies, t.topic_moved_id FROM ".$prefix."_bbtopics t, ".$prefix."_bbforums f where t.forum_id=f.forum_id ORDER BY topic_last_post_id DESC", $dbi );
while( list( $topic_id, $forum_name, $forum_id, $topic_last_post_id, $topic_title, $topic_poster, $topic_views, $topic_replies, $topic_moved_id ) = sql_fetch_row( $result, $dbi ) )

{
   $skip_display = 0;
   if( $HideViewReadOnly == 1 )
   {
      $result1 = sql_query( "SELECT auth_view, auth_read FROM ".$prefix."_bbforums where forum_id = '$forum_id'", $dbi );
      list( $auth_view, $auth_read ) = sql_fetch_row( $result1, $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 username, user_id, user_color_gc FROM ".$prefix."_users where user_id='$topic_poster'", $dbi);
list($username, $user_id, $user_color_gc)=sql_fetch_row($result2, $dbi);
$avtor= UsernameColor($user_color_gc, $username);
$sifra=$user_id;

$result3 = sql_query("SELECT poster_id, FROM_UNIXTIME(post_time,'%m/%d/%Y às %H:%i') as post_time FROM ".$prefix."_bbposts where post_id='$topic_last_post_id'", $dbi);
list($poster_id, $post_time)=sql_fetch_row($result3, $dbi);

$result4 = sql_query("SELECT username, user_id, user_color_gc FROM ".$prefix."_users where user_id='$poster_id'", $dbi);
list($username, $user_id, $user_color_gc)=sql_fetch_row($result4, $dbi);
$username= UsernameColor($user_color_gc, $username);

                         $viewlast .="  <tr>
    <td height=\"34\" bgcolor=\"#0D0E0E\" class=\"row1\"><img src=\"modules/Forums/templates/arkanian/images/folder_new.gif\" border=\"0\" /></td>
    <td width=\"100%\" bgcolor=\"#272727\" class=\"row1\">&nbsp;<b>$forum_name</b><br>&nbsp;&nbsp;<a href=\"modules.php?name=Forums&file=viewtopic&t=$topic_id#$topic_last_post_id\">$topic_title</a></td>
    <td align=\"center\" bgcolor=\"#303030\" class=\"row2\">$topic_replies</td>
    <td align=\"center\" bgcolor=\"#303030\" class=\"row2\">$topic_views</td>
    <td align=\"center\" nowrap bgcolor=\"#414141\" class=\"row3\"><font size=\"-2\"><i>&nbsp;&nbsp;$post_time&nbsp;</i></font><br>
      <a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$user_id\">$username</a>&nbsp;<a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"><img src=\"modules/Forums/templates/arkanian/images/icon_latest_reply.gif\" border=\"0\" alt=\"Último Post\"></a></td>
  </tr>";
}
   
   if( $Last_New_Topics == $Count_Topics ) { break 1; }
   
}

    $content .= "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
  <tr>
    <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
        <tr>
          <td bgcolor=\"#010101\"><table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"1\">
  <tr>
    <th height=\"28\" colspan=\"2\" align=\"center\" nowrap class=\"thcornerl\"><font color=\"#D77700\"><strong>Forum/Tópico</strong></font></th>
    <th width=\"25\" align=\"center\" nowrap class=\"thtop\"><font color=\"#D77700\"><strong>&nbsp;Posts&nbsp;</strong></font></th>
    <th width=\"50\" align=\"center\" nowrap class=\"thtop\"><font color=\"#D77700\"><strong>&nbsp;Visto&nbsp;</strong></font></th>
    <th align=\"center\" nowrap class=\"thcornerr\"><font color=\"#D77700\"><strong>&nbsp;Último Post&nbsp;</strong></font></th>
  </tr><br>";
    $content .= "$viewlast";

 $content .= "$show";

?>


I only want to show this forums id´s: 10, 12, 15, 18, 21

_________________
Sexo - Thongs - Legendas Divx
Find all posts by DivvyView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.094 Seconds - 292 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::