openside("Ostatnie posty z zewnetrznego forum phpBB");

[color=red][b]$dbms = 'mysql';

$adr = 'ADRES_STRONY/';

$dbhost = 'ADRES_BAZY';

$dbname = 'NAZWA_BAZY';

$dbuser = 'USER_BAZY';

$dbpasswd = 'HASŁO_USERA';



$table_prefix = 'phpbb_';[/b][/color]



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_last_post_id DESC

LIMIT 5";



$wykonanie = mysql_query($zapytanie);



$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'<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.$adr.'viewtopic.php?' . $p . '" target="_blank">' . $row['topic_title'] . '</a>

<br>';





$i++;

}

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

closeside();