Forum

{
global $Sql;
 
define('NUM_COMS', 5);
define('NUM_CHAR', 20);
$level = array(0 => '', 1 => ' class="modo"', 2 => ' class="admin"');
 
$tpl = new Template('menus/lastcoms/lastcoms.tpl');
    import('core/menu_service');
    MenuService::assign_positions_conditions($tpl, $block);
import('util/url');
 
$result = $Sql->query_while("SELECT c.idcom, c.user_id, c.login, c.contents, c.timestamp, c.path, m.level
FROM " . DB_TABLE_COM . " AS c
LEFT JOIN " . DB_TABLE_MEMBER . " AS m ON c.user_id = m.user_id
ORDER BY c.timestamp DESC" . $Sql->limit(0, NUM_COMS), __LINE__, __FILE__);
 
while ($row = $Sql->fetch_assoc($result))
{
$url = new Url($row['path']);
 
$parse = parse_url($url->absolute());
$query = htmlspecialchars_decode($parse['query']);
parse_str($query, $str);
 
$get = array();
foreach ($str as $attr => $value)
if (isset($value) && $attr != 'token')
$get[$attr] = $value;
 
$contents = strip_tags(second_parse($row['contents']));
 
$tpl->assign_block_vars('coms', array(
'LOGIN' => $row['login'],
'PROFIL' => $row['user_id'] > 0 ? '../member/member' . url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php') : 0,
'LEVEL' => $level[(!empty($row['level']) ? $row['level'] : '0')],
'ETC' => strlen($contents) > NUM_CHAR ? '...' : '',
'CONTENTS' => trim(substr($contents, 0, NUM_CHAR)),
'DATE' => gmdate_format('d/m à H:i', $row['timestamp']),
'PATH' => $parse['scheme'] . '://' . $parse['host'] . (!empty($parse['port']) ? ':' . $parse['port'] : '') . $parse['path'] . '?' . http_build_query($get, '', '&') . '#m' . $row['idcom']
));
}
 
    $tpl->assign_vars(array(
    'L_LAST_COMS' => 'Derniers commentaires',
    ));
 
    return $tpl->parse(TEMPLATE_STRING_MODE);
}
 
?>