To kodzik:
<?PHP
error_reporting(E_ALL);
$db = mysql_connect('host', 'user', 'password') or die ("Nie mogę się połšczyć!.");
mysql_select_db('name_of_db', $db) or die("Brak bazy danych!");
mysql_query("SET CHARSET latin2", $db);
$query = "SELECT COUNT(*) FROM mybb_posts WHERE (fid = '20') AND (replyto = '0')";
$result = @mysql_query($query);
$row = mysql_fetch_array($result, MYSQL_NUM);
$count_rekords = $row[0];
//CONFIG!!
$podziel = '5'; //Ile newsów na stronie
$query = "SELECT tid, replyto, fid, subject, uid, username, dateline, message, visible FROM mybb_posts WHERE (fid = '20') AND (replyto = '0') ORDER BY tid DESC LIMIT {$podziel}";
$result = @mysql_query($query);
$num = mysql_num_rows ($result);
if ($num > 0)
{
while ($news = mysql_fetch_array($result, MYSQL_ASSOC ))
{
$autor = $news['username'];
$temat = $news['subject'];
$message = $news['message'];
$date_day = date("j", $news['dateline']);
$date_mounth = date("m", $news['dateline']);
$date_year = date("Y", $news['dateline']);
$time = date("H:i", $news['dateline']);
switch ($date_mounth) {
case '01': $date_mounth = 'Stycznia'; break;
case '02': $date_mounth = 'Lutego'; break;
case '03': $date_mounth = 'Marca'; break;
case '04': $date_mounth = 'Kwietnia'; break;
case '05': $date_mounth = 'Maja'; break;
case '06': $date_mounth = 'Czerwca'; break;
case '07': $date_mounth = 'Lipca'; break;
case '08': $date_mounth = 'Sierpnia'; break;
case '09': $date_mounth = 'Września'; break;
case '10': $date_mounth = 'Października'; break;
case '11': $date_mounth = 'Listopada'; break;
case '12': $date_mounth = 'Grudnia'; break;
default: $date_mounth = 'Błšd!!!'; break;
}
$main_content .= '
<div class=\'NewsHeadline\'>
<div class=\'NewsHeadlineBackground\' style=\'background-image:url(tibiacom/images/news/newsheadline_background.gif)\'>
<table border=0><tr><td>
</td><td><font color="'.$layout_ini['news_title_color'].'">'.$date_day.'.'.$date_mounth.'.'.$date_year.' - <b>'.stripslashes($temat).'</b></font></td></tr></table>
</div>
</div>
<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'><tr>
<td><img src="tibiacom/images/global/general/blank.gif" width=10 height=1 border=0 alt=\'\' /></td>
<td width="100%">'.stripslashes($message).'<br><h6><i>Posted by </i><font color="green">'.stripslashes($autor).'</font>';
}
mysql_free_result ($result);
}
?>
Oczywiście kodzik jest w wersji oryginalnej (pochodzi z linku w temacie) i nie jest przerobiony, ale za cholerę nie wyciąga danych z bazy.
Próbowałem rozkminić coś też
stąd, ale w PHP dopiero raczkuję
