openside("Co na forum");

$dbms = 'mysql';

$adr = 'forum/';

$dbhost = 'localhost';

$dbname = 'xxx;

$dbuser = 'xxx';

$dbpasswd = 'xxx';



$table_prefix = 'phpbb_';



define('PHPBB_INSTALLED', true);



mysql_connect($dbhost, $dbuser, $dbpasswd) or

die('Nie moglem polaczyc sie z baza danych, sprobuj pozniej');



mysql_select_db($dbname) or

die('Mam problemy z wyborem bazy danych');



$zapytanie = "

SELECT t.topic_id, t.topic_title, t.topic_replies, t.topic_last_post_id,

p.poster_id, p.post_time, u.username, u.user_id

FROM ".$table_prefix."topics t, ".$table_prefix."posts p, ".$table_prefix."users u

WHERE p.post_id = t.topic_last_post_id

AND u.user_id = p.poster_id

ORDER BY t.topic_id DESC

LIMIT 5";



$wykonanie = mysql_query($zapytanie);



echo '<table class="forum" cellspacing="0" cellpadding="2" width="95%">';





$i = 2;

while( $row = mysql_fetch_array($wykonanie, MYSQL_ASSOC) )

{

// usuwamy ukośniki

$row['topic_title'] = stripslashes($row['topic_title']);

$row['username'] = stripslashes($row['username']);



// ucinamy przydługie tematy

$row['topictitle'] = ( strlen($row['topic_title']) > 26 ) ? substr($row['topic_title'], 0, 23) . "..." : $row['topictitle'];



// dobieramy kolor wiersza

$i % 2 == 1 ? $r = '' : $r = ' bgcolor=""';



// ustawiamy format daty

$data = date("d-m-Y H:i", $row['post_time']);



// link do ostatniego postu w temacie

$p = 'p=' . $row['topic_last_post_id'] . '#' . $row['topic_last_post_id'];



// link do tematu

$t = 't=' . $row['topic_id'];





echo'<tr> <td valign="middle" height="10">

<a href="'.$adr.'viewtopic.php?' . $p . '" target="_blank">' . $row['topic_title'] . '</a>

</td></tr>';







$i++;

}

echo '</table>';

dbconnect($db_host, $db_user, $db_pass, $db_name);

closeside();