<meta http-equiv="Content-type" content="text/html; charset=windows-1250" />
<table>
<center><b>Menu</b></center>
<tr>
<td><center><b>Nadchodzące Imprezy</b></center></td>
<td><center><b>Nowości</b></center></td>
<td><center><b>Inne</b></center></td>
<td><center><b>Forum</b></center></td>
<td><center><b>Najnowsze posty na forum</b></center></td>
</tr>
<tr>
<td><center>Mission To Trance</br>Prague Sessions with PvD</br>Soundtropolis</center></td>
<td><center>Foto Relacja z Beach Party</br>Polak nominowany do Ibiza DJ Awards</br>Rusza plebiscyt DJ MAG TOP 100 DJ's<center></td>
<td><center>Sylwetki Artystów</br>Polecane Wydawnictwa</br>Tutoriale</center></td>
<td><center>Regulamin</br>Informacje techniczne</br>Kontakt</center></td>
<td><center><?
/**
* newest_posts - raw dump of newest posts from forum
*
* @copyright (c) 2008 ameeck / Vojtech Vondra - phpBB.cz
* @license
http://opensource.org/licenses/gpl-license.php GNU Public License
*/
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// Number of posts and grabbing permissions
// Počet příspěvků pro zobrazení a oprávnění
$topic_limit = request_var('topic_limit', 5);
$forums = array_unique(array_keys($auth->acl_getf('f_read', true)));
// Select the last topics to which we have permissions
// Vybrat poslední témata ke kterým máme oprávnění
$sql = 'SELECT p.post_id, p.topic_id, p.forum_id, p.post_subject, p.post_time, u.username
FROM ' . POSTS_TABLE . ' p , ' . USERS_TABLE . ' u
WHERE post_approved = 1
AND ' . $db->sql_in_set('forum_id', $forums) . '
AND u.user_id = p.poster_id
ORDER BY post_time DESC
LIMIT 0,' . $topic_limit;
$result = $db->sql_query($sql);
// Now let's output the content
// A teď vypsat obsah
echo '<div id="post_content" align="left"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><ul>';
while ($row = $db->sql_fetchrow($result))
{
$url = generate_board_url() . "/viewtopic.{$phpEx}?f={$row['forum_id']}&t={$row['topic_id']}&p={$row['post_id']}#p{$row['post_id']}";
echo '<li><a target="_top" href="' . $url . '">' . $row['post_subject'] . '</a><br /> </li>';
}
echo '</ul></div>';
?></center></td>
</tr>
</table>