[php:1:6ba2205afd]<?php
<?
//ustawienia:
$phpbb_db_host = 'localhost'; //host
$phpbb_db_user = 'truckswebb'; //uzytkownik
$phpbb_db_pass = 'trucksweb'; //haslo
$phpbb_db_name = 'truckswebb_uk_db'; //baza
$phpbb_db_prefix = 'phpbb_'; //prefix tabel
$phpbb_db_topics = '5'; //ile tematow pokazywac
$phpbb_db_limit = '15'; //do ilu znakow obcinac
$phpbb_folder = 'http://members.lycos.co.uk/truckswebb/'; //sciezka do phpbb (folder albo caly adres) ze slashem na koncu
$phpbb_punktor = '> '; //punktor
$phpbb_db_table = $phpbb_db_prefix.'topics'; //nie ruszaj tego
mysql_close();
if(!@mysql_connect($phpbb_db_host, $phpbb_db_user, $phpbb_db_pass)) echo 'Nie mogę połączyć się z serwerem phpBB.';
if(!@mysql_select_db($phpbb_db_name)) echo 'Nie mogę wybrać bazy danych phpBB.';
$query = "SELECT * FROM $phpbb_db_table ORDER BY topic_id DESC LIMIT $phpbb_db_topics";
$result = mysql_query($query);
while($r = mysql_fetch_array($result)) {
$id = $r['topic_id'];
$title = $r['topic_title'];
$len = strlen($title);
if ($len > $phpbb_db_limit) {
$title = substr($title, 0, $phpbb_db_limit-3);
$title = $title.'...';
}
echo $phpbb_punktor.'<a href="'.$phpbb_folder.'viewtopic?t='.$id.'">'.$title.'</a><br>';
}
@mysql_close();
mysql_connect($GLOBALS['db_host'], $GLOBALS['db_user'], $GLOBALS['db_pass']);
mysql_select_db($GLOBALS['db_name']);
?>
?>[/php:1:6ba2205afd][php:1:6ba2205afd]<?php
Cytat
?>[/php:1:6ba2205afd]