Forum

<?php
// modifier la valeur $idcat_trie = macat!!
$idcat_trie = '1' ; // 1 est un exemple !!
 
 
function menu_toppages_toppages($position, $block)
 
{
 
global $Sql;
 
 
 
 
$tpl = new Template('menus/toppages/toppages.tpl');
 
import('core/menu_service');
 
MenuService::assign_positions_conditions($tpl, $block);
 
 
 
$w = 1;
 
$resultw = $Sql->query_while("SELECT id, hits, title, encoded_title
, id_cat
FROM " . PREFIX . "pages  
 
WHERE id_cat = $idcat_trie
ORDER BY hits DESC
 
" . $Sql->limit(0, 3), __LINE__, __FILE__);
 
while ($roww = $Sql->fetch_assoc($resultw))
 
{
 
$tpl->assign_block_vars('top_pages', array(
 
'ID' => $w,
 
'LINK' => url('pages/pages.php?title=' . $roww['encoded_title']),
 
'TITLE' => $roww['title'],
 
'VIEW' => $roww['hits']
 
 ));
 
 $w++;
 
 
 
}
 
$Sql->query_close($resultw); 
 
 
 
    return $tpl->parse(TEMPLATE_STRING_MODE);
 
}
 
 
 
?>

$resultw = $Sql->query_while("SELECT id, hits, title, encoded_title, id_cat
FROM " . PREFIX . "pages  WHERE id_cat = $idcat_trie
ORDER BY hits DESC" . $Sql->limit(0, 5), __LINE__, __FILE__);