Making Recent Topics Show On External Page

[MakeItWork]

Greets,

Basically I want to get the 10 last topics that were replied to from phpBB 2 and display them on a page outside of phpBB.

I know there is a lot of information about how to do this for phpBB 3 but there seems to be none for phpBB 2. Is it possible? If so can you point me in the right direction?

I have tied doing it before but constantly get the following:

Code: Select all

Call to a member function sql_query() on a non-object

referring to this line:

Code: Select all

$result = $db->sql_query( "SELECT ....

Even though I do have the global $db as in:

Code: Select all

global $prefix, $db, $sitename, $admin;

$HideViewReadOnly = 1;
    		
$Last_New_Topics  = 10;
$show = "  <tr> 
    <td height=\"10\" colspan=\"6\" align=\"center\">&nbsp;</td>
  </tr>
</table></td>
        </tr>
      </table></td>
  </tr>
</table>";

$Count_Topics = 0;
$Topic_Buffer = "";

$result = $db->sql_query( "SELECT 

[Patrick]

Hello and welcome, MakeItWork.

Check out this hack: http://www.phpbbhacks.com/download/2057

Thanks,

Patrick

[MakeItWork]

Thanks for your reply. I did try that before, it is based on javascript. I have come to realize that it is not possible when phpBB is a module in phpNuke so I had to create another work around.

[Patrick]

Thanks for sharing that, MakeItWork. That definitely impacts the suggestions that people can make. Hopefully someone else has a thought.

Thanks,

Patrick

[MakeItWork]

Yes, originally I thought it was just PhpBB behaving badly but in bridges it is not the same.