mais rien ne s'affiche dorénavant..
- Code: Tout sélectionner
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './../phpBB3/';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
$user->session_begin();
$auth->acl($user->data);
$user->setup();
$forum_id = 35;
$where = ($forum_id) ? " WHERE t.forum_id=$forum_id" : '';
$sql = 'SELECT t.forum_id,t.topic_id, t.topic_time, t.topic_title, t.topic_replies, t.topic_poster, t.topic_first_poster_name, t.topic_first_poster_colour, p.post_text, p.bbcode_bitfield, p.bbcode_uid
FROM ' . TOPICS_TABLE . ' t JOIN ' . POSTS_TABLE . ' p ON p.topic_id = t.topic_first_post_id ' .
$where .
' ORDER BY topic_time DESC ' .
' LIMIT 0 , 10 ';
$result = $db->sql_query($sql);
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>Les dernières news</title>
<style type="text/css">
th{
background-color: #0066FF;
color: #FFFF99;
}
</style>
</head>
<body>
<?php
$i=0;
while($row = $db->sql_fetchrow($result))
{
$topic_id = $row['t.topic_id'];
$view_topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . (($row['t.forum_id']) ? $row['t.forum_id'] : $forum_id) . '&t=' . $topic_id);
$row_colour = ($i % 2) ? '#FFFFCC' : '#99FFFF';
echo '' . $row_colour .'';
echo '<a href="' . $view_topic_url . '">' . censor_text($row['t.topic_title']) . '</a><br />';
echo $user->lang['POST_BY_AUTHOR'] . ' ' . get_username_string('full', $row['t.topic_poster'], $row['t.topic_first_poster_name'], $row['t.topic_first_poster_colour']);
echo ' ' . $user->lang['POSTED_ON_DATE'] . ' ' . $user->format_date($row['t.topic_time']) . '';
echo '<br />' . $row['t.topic_replies'] . '';
echo '<br />';
echo '' . $row['p.post_text'] . '';
$i++;
}
?>
</body>
</html>
Encore désolé ça doit être embêtant pour toi
Flux RSS