Next Generation CMS :: Форум поддержки

$sql = "select c.*, u.avatar from ".prefix."_comments c left join ".uprefix."_users u on c.author_id = u.id where c.post=".db_squote($newsID).($commID?(" and c.id=".db_squote($commID)):'')." order by c.id".($config['reverse_comments']?' desc':'');

$sql = "select c.*, u.avatar, u.status from ".prefix."_comments c left join ".uprefix."_users u on c.author_id = u.id where c.post=".db_squote($newsID).($commID?(" and c.id=".db_squote($commID)):'')." order by c.id".($config['reverse_comments']?' desc':'');

foreach ($mysql->select($sql) as $row) {

switch ($row['status']) {
			case 1: $status = 'Администратор';	break;
			case 2: $status = 'Редактор';			break;
			case 3: $status = 'Журналист';		break;
			case 4: $status = 'Комментатор';		break;
}
$tvars['vars']['status']	=	$status;

$sql = "select c.*, u.avatar, u.com, u.news from ".prefix."_comments c left join ".uprefix."_users u on c.author_id = u.id where c.post=".db_squote($newsID).($commID?(" and c.id=".db_squote($commID)):'')." order by c.id".($config['reverse_comments']?' desc':'');

$sql = "select c.*, u.avatar, u.com, u.news, u.reg from ".prefix."_comments c left join ".uprefix."_users u on c.author_id = u.id where c.post=".db_squote($newsID).($commID?(" and c.id=".db_squote($commID)):'')." order by c.id".($config['reverse_comments']?' desc':'');