// tutaj podaj adres forum
$forum='./forum/';
// tutaj napisz ile ostatnich tematów ma być wyciąganych
$ile='10';
$db_config=$forum.'config.php';
  if (file_exists($db_config)) {
include($db_config);
$sql=mysql_connect ($db_host,$db_username,$db_password);
mysql_select_db($db_name);

$pobierz_najnowsze="SELECT
                        subject,
                        last_post,
                        id
                    FROM
                        punbb_topics
                    WHERE
                        last_post <= ".time()."
                    ORDER BY
                        last_post DESC
                    LIMIT
                        0,".$ile;
$wykonaj_najnowsze=mysql_query($pobierz_najnowsze);
while ($tematy = mysql_fetch_array($wykonaj_najnowsze)):
echo "<a href=\"".$forum."viewtopic.php?id=".$tematy["id"]."\">".$tematy["subject"]."</a><br />";
endwhile;

mysql_close($sql);
  }

// tutaj podaj adres forum
$forum='./forum/';
// tutaj napisz ile ostatnich tematów ma być wyciąganych
$ile='10';
// id forum z którego pobierać newsy
$forum_id='1';
$db_config=$forum.'config.php';
  if (file_exists($db_config)) {
include($db_config);
$sql=mysql_connect ($db_host,$db_username,$db_password);
mysql_select_db($db_name);
$pobierz_news="SELECT
                        t.id AS tid,
                        t.poster,
                        t.subject,
                        t.num_replies,
                        p.message,
                        u.id AS uid,
                FROM
                        punbb_topics t,
                        punbb_posts p,
                        punbb_users u
                WHERE
                        forum_id = ".$forum_id."
                AND
                        p.topic_id = t.id
                AND
                        u.username = t.poster
                AND
                        p.posted = (select min(c.posted) from punbb_posts c where c.topic_id = p.topic_id)
                ORDER BY
                        p.posted DESC
                LIMIT
                        0,".$ile.";";
$wykonaj_news=mysql_query($pobierz_news);
while ($news=mysql_fetch_array($wykonaj_news)):
$text=$news["message"];
echo (".$news["subject"]."
<br />
".$text."
<br />
<a href=\"".$forum."viewtopic.php?id=".$news["tid"]."\">ilo?ć komentarzy: ".$news["num_replies"]."</a>
 | <a href=\"".$orum."post.php?tid=".$news["tid"]."\" >dodaj komentarz</a>
");
endwhile;
mysql_close($sql);