query to create block

imhotepp · **query to create block -** 11-21-2002, 02:01 PM

Hi, I extracted this from the recent posts block, but I can't get it to work, I am using php-nuke 5.5 with phpbb2.0.3 port.

Code:

<?php

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

global $prefix, $dbi, $sitename, $admin;

$HideViewReadOnly = 1;

$Last_New_Topics  = 5;

$Count_Topics = 0;
$Topic_Buffer = "";
$result = sql_query( "SELECT topic_id, forum_id, topic_title, topic_moved_id FROM ".$prefix."_bbtopics ORDER BY topic_last_post_id DESC", $dbi );
while( list( $topic_id, $forum_id, $topic_title, $topic_moved_id ) = sql_fetch_row( $result, $dbi ) )

{
   $skip_display = 0;


   if( $topic_moved_id != 0 )
   {
          // Shadow Topic !!
      $skip_display = 1;
   }

   if( $skip_display == 0 )
   {
          $Count_Topics += 1;
          $content = "";
          $viewlast .="  <tr>
    <td height=\"34\" nowrap bgcolor=\"#272727\" class=\"row1\"><img src=\"modules/Forums/templates/DesertStorm/images/folder_new.gif\" width=\"33\" height=\"25\" border=\"0\" /></td>
    <td width=\"100%\" bgcolor=\"#272727\" class=\"row1\"><a href=\"modules.php?name=Forums&file=viewtopic&t=$topic_id#$topic_last_post_id\">$topic_title</a></td>
    <a href=\"modules.php?name=Forums&file=profile&mode=viewprofile&u=$uid\">$uname</a><a href=\"modules.php?name=Forums&file=viewtopic&p=$topic_last_post_id#$topic_last_post_id\"></a><img src=\"modules/Forums/templates/fiblack/images/icon_minipost_new.gif\"></td>
  </tr>";

 if( $Last_New_Topics == $Count_Topics ) { break 1; }
 
   $content .= "$viewlast";
   
   ?>

I could use some help

Thanks

coldblooded · 11-21-2002, 05:27 PM

There were changes made to the table names in the new phpbb2 port. To use that block with an older verison of the port you need to change:

Code:

$prefix."_bbtopics

to

Code:

$prefix."_topicsbb

ReNeGaDe · 11-21-2002, 06:04 PM

yes that caused me problems as well, had to dig through the code. took me a while to actually realize the error. except this wasnt for the recent posts block, this was for the converter.