Les archives de FluxBB.fr
Vous n'êtes pas identifié(e).
Pages : 1
bonjour à tous
voila mon probleme
je voudrai afficher une un forum ( ?id=138 ) pour voir les dernier poste sur se forum en question sur mon portail
voici le code pour tous afficher
// RECUPERATION DES 15 DERNIERS POSTS
$result = $db->query('SELECT[color=#FC1B02] t.id[/color], t.subject, t.last_poster, t.last_post FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=132 AND fp.group_id='.$pun_user['group_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY last_post DESC LIMIT 15') or error('Impossible de retrouver la liste des discussions', __FILE__, __LINE__, $db->error());
while ($cur_topic = $db->fetch_assoc($result)) {
if ($pun_config['o_censoring'] == '1')
$cur_topic['subject'] = censor_words($cur_topic['subject']);
$subject_truncated = pun_htmlspecialchars(trim(($cur_topic['subject'])));
$echo[] = '<li><a href="'.$pun_config['o_base_url'].'/viewtopic2.php?id='.$cur_topic['id'].'&action=new" title="'.pun_htmlspecialchars($cur_topic['subject']).'">'.$subject_truncated.'</a></li><ul><li>'.format_time($cur_topic['last_post']).' '.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['last_poster']).'</li></ul>'."\n";
}j'ai essayer de changer t.id en d'id de la base de donné du forum en question mais sa marche pas
quelqun à une idé ??
jutilise sa
<?php
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';
require PUN_ROOT.'include/parser.php';
require PUN_ROOT.'cache/cache_portail.php';
// Load the index.php language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/index.php';
$page_title = pun_htmlspecialchars($pun_config['o_board_title']).", Accueil";
// Récupération des NEWS
$result = $db->query('SELECT COUNT(*) FROM '.$db->prefix.'topics WHERE forum_id='.$cache_portail['id_forum']);
$qte = $db->result($result);
$result = $db->query('SELECT id AS topic_id, subject, poster AS poster, posted, num_replies FROM '.$db->prefix.'topics WHERE forum_id='.$cache_portail["id_forum"].' ORDER BY posted DESC, id DESC LIMIT '.(isset($_GET['p']) ? ($_GET['p'])*ceil($pun_config['o_disp_topics_default']/5) : 0).', '.ceil($pun_config['o_disp_topics_default']/5));
$news = $ids = array();
$id = null;
while ($tab = $db->fetch_assoc($result)){
if($id!=$tab['topic_id']){
$id = $tab['topic_id'];
$ids[] = $id;
$news[$id] = $tab;
$news[$id]['subject'] = pun_htmlspecialchars($tab['subject']);
$news[$id]['qte'] = 0;
}
}
$db->free_result($result);
$result = $db->query('SELECT topic_id, message FROM '.$db->prefix.'posts WHERE topic_id IN ('.implode(',', $ids).') ORDER BY topic_id DESC, id ASC');
$id = null;
while ($tab = $db->fetch_assoc($result)){
if($id!=$tab['topic_id']){
$id = $tab['topic_id'];
$news[$id]['message'] = parse_message($tab['message'], false);
}else
$news[$id]['qte']++;
}
// RECUPERATION DES 15 DERNIERS POSTS
$result = $db->query('SELECT t.id=132, t.subject, t.last_poster, t.last_post FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=132 AND fp.group_id='.$pun_user['group_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY last_post DESC LIMIT 15') or error('Impossible de retrouver la liste des discussions', __FILE__, __LINE__, $db->error());
while ($cur_topic = $db->fetch_assoc($result)) {
if ($pun_config['o_censoring'] == '1')
$cur_topic['subject'] = censor_words($cur_topic['subject']);
$subject_truncated = pun_htmlspecialchars(trim(($cur_topic['subject'])));
$echo[] = '<li><a href="'.$pun_config['o_base_url'].'/viewtopic2.php?id='.$cur_topic['id'].'&action=new" title="'.pun_htmlspecialchars($cur_topic['subject']).'">'.$subject_truncated.'</a></li><ul><li>'.format_time($cur_topic['last_post']).' '.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['last_poster']).'</li></ul>'."\n";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="shortcut icon" href="icon.ico" />
<meta name="ROBOTS" content="NOINDEX, FOLLOW" />
<title><?php echo $page_title; ?></title>
<link rel="stylesheet" type="text/css" href="style/<?php echo $pun_user['style'].'.css' ?>" />
<link rel="stylesheet" type="text/css" href="style/imports/accueil.css" />
<link rel="stylesheet" type="text/css" href="syn/syn.css" />
<link rel="stylesheet" type="text/css" href="style/imports/slideshow.css" media="screen" />
<script type="text/javascript" src="js/mootools.js"></script>
<script type="text/javascript" src="js/slideshow.js"></script>
<script type="text/javascript">
//<![CDATA[
window.addEvent('domready', function(){
var data = {
<?php echo "'".implode("': { 'caption': '' },\n\t'", $cache_portail["slideshow"])."': { 'caption': '' }\n" ?>
}
var myShow = new Slideshow('slideshow', data, { captions: false, duration: 3000, random: true, controller: false, hu: 'img/slide_accueil/' });
});
//]]>
</script>
</head>
<body>
<div id="punwrap">
<div id="punindex" class="pun">
<div id="brdheader" class="acc_header block">
<div class="box">
<div id="brdtitle" class="inbox">
<h1><span></span></h1>
<p><span></span></p>
</div>
<div id="brdmenu" class="acc_menu inbox">
<?php echo generate_navlinks(); ?>
</div>
<?php
if ($pun_user['is_guest']){
echo "\t\t\t\t".'<div id="brdwelcome" class="inbox">'."\n\t\t\t".'<p>'.$lang_common['Not logged in'].'</p>'."\n\t\t".'</div>';
}else{
echo '<div id="brdwelcome" class="inbox">'."\n\t\t\t".'<ul class="conl" style="width:auto;">'."\n\t\t\t\t".'<li>'.$lang_common['Logged in as'].' <strong>'.pun_htmlspecialchars($pun_user['username']).'</strong></li>'."\n\t\t\t\t".'<li>'.$lang_common['Last visit'].': '.format_time($pun_user['last_visit']).'</li>';
echo "\n\t\t\t".'</ul>'."\n\t\t\t".'<ul class="conr" style="width:auto;">'."\n\t\t\t\t".'<li><a href="search.php?action=show_new">'.$lang_common['Show new posts'].'</a></li>'.'</ul>'."\n\t\t\t".'<div class="clearer"></div>'."\n\t\t".'</div>';
}
?>
</div>
</div>
<div class="block">
<div id="slideshow" class="acc_pictures box slideshow">
<img src="<?php echo PUN_ROOT.'img/slideshow/'.$cache_portail["slideshow"][mt_rand(0, count($cache_portail["slideshow"])-1)]; ?>" width="758" height="380" alt="" />
</div>
</div>
<div class="block">
<div class="acc_news pun box">
<ul>
<?php
if (count($news)){
$j = 0;
foreach($news as $i => $new){
echo "\t\t\t".'<h2 style="margin-top:5px;cursor:pointer" onclick="if(document.getElementById(\'contenu'.$i.'\').style.display==\'none\') { document.getElementById(\'contenu'.$i.'\').style.display=\'block\' }else{ document.getElementById(\'contenu'.$i.'\').style.display = \'none\' } ">'.$new['subject'].'<span class="news_date"> le '.date($pun_config["o_date_format"].' '.$pun_config["o_time_format"], $new["posted"]).'</span></h2><div id="contenu'.$i.'" style="margin-bottom:5px;'.($j++>=2 ? 'display:none;' : '').'"><p class="news_chapo">'.$new['message'].'</p><p style="text-align:center;"><a href="viewtopic.php?id='.$new['topic_id'].'">Réagir'.(($new['qte']) ? ' - Voir l'.($new['qte']>1 ? 'es'.' '.$new['qte'].' réactions' : 'a réaction') : '').'</a></p></div>'."\n";
}
if (ceil($qte/ceil($pun_config['o_disp_topics_default']/5))>1){
echo '<h2 style="margin-top:10px;text-align:right;">Page : ';
for ($i=0;$i<ceil($qte/ceil($pun_config['o_disp_topics_default']/5));$i++)
echo "\t\t\t".'<a href="index.php?p='.$i.'">'.($i+1).'</a>'."\n";
echo '</h2>';
}
}else
echo "\t\t\t".'<li>Aucune actualité pour le moment</li>'."\n";
?>
</ul>
</div>
</div>
<div class="block">
<div class="acc_presentation pun box">
<?php echo $cache_portail['text']; ?>
</div>
</div>
<div class="block">
<div class="acc_last_posts pub box">
<h2 style="margin-bottom:5px;">Presentation</h2>
<?php echo implode("\n", $echo); ?>
</div>
</div>
<div style="margin-bottom:10px;clear:both"></div>
</div>
</div>
</body>
</html>merci d'avance
Hors ligne
Pages : 1