modul posledni prispevky z fora

<?xml version="1.0" encoding="utf-8"?>
<extension type="module" version="3.1.0" client="site" method="upgrade">
    <name>Forum</name>
    <author>Tydou</author>
    <version>1.0.0</version>
    <description>Forum news topic</description>
    <files>
        <filename>mod_forum.xml</filename>
        <filename module="mod_forum">mod_forum.php</filename>
        <filename>index.html</filename>
        <filename>helper.php</filename>
        <filename>tmpl/default.php</filename>
        <filename>tmpl/index.html</filename>
    </files>
    <config>
    </config>
</extension>

<?php 

	class ModForumHelper 
	{
		function TADY NEVIM CO() {
			
			
			return;
		}
		
		function getlastmessages($numofmessages = 8) {
			// How Many Topics you want to display?
			$topicnumber = $numofmessages;
			// Change this to your phpBB path
			$urlPath = "forum";
			// Database Configuration (Where your phpBB config.php file is located)
			include $urlPath.'/config.php';
		 
			$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Could not connect");
			mysql_select_db($dbname) or die("Could not select database");
		 
			// Get 5 Latest Posts.
			$qry = mysql_query("SELECT * FROM `phpbb_posts` ORDER BY `post_id` DESC LIMIT 8");
			while($row=mysql_fetch_array($qry)) {
					
				// Get Author Name.
				$author1 = mysql_query("SELECT * FROM `phpbb_users` WHERE `user_id` = '".$row['poster_id']."'");
				$author2 = mysql_fetch_array($author1);
				$author = $author2['username'];
					
				// Get the Topic Name.
				$topic1 = mysql_query("SELECT * FROM `phpbb_topics` WHERE `topic_id` = '".$row['topic_id']."'");
				$topic2 = mysql_fetch_array($topic1);
				$topic = $topic2['topic_title'];
					
				printf("<a href=\"".$urlPath."/viewforum.php?f=%s\" target=\"_BLANK\">%s</a> <b>></b> <a href=\"".$urlPath."/viewtopic.php?f=%s&t=%s&p=%s#%s\" target=\"_BLANK\">%s</a> <b>by</b> <a href=\"".$urlPath."/profile.php?mode=viewprofile&u=%s\" TARGET=\"_blank\">%s</a><br />", $row['forum_id'], $forum, $row['forum_id'], $row['topic_id'], $row['post_id'], $row['post_id'], $topic, $row['poster_id'], $author);
			}
		}
	}

<?php

defined('_JEXEC') or die; ?>

<?
		$forum = new foruminfo();
		$forum->getlastmessages(8);
					?>

<?php


defined('_JEXEC') or die;

// Include the syndicate functions only once
require_once __FILE__ . '/helper.php';

             $forum = new foruminfo();
	     $forum->getlastmessages(8);
					?>

// Database Configuration (Where your phpBB config.php file is located)
			include $urlPath.'/config.php';
		 
			$link = mysql_connect($dbhost, $dbuser, $dbpasswd) or die("Could not connect");
			mysql_select_db($dbname) or die("Could not select database");