Файл: CMS/comm/comm_cats.php
Строк: 42
<?php
if (!defined('CMS')) { die('Access Denied!'); }
if (!empty($id) && array_key_exists($id,$categories)) {
$rows = $db->selectPage($total, "SELECT `cc`.*, `ct`.`cats_name`
FROM ?_comm_comm `cc` LEFT JOIN ?_comm_category `ct`
ON `cc`.`comm_cats_id` = `ct`.`cats_id`
WHERE `cc`.`comm_cats_id` = ?
ORDER BY `cc`.`comm_create` DESC
LIMIT ?d, ?d", $id, $from, $onpage);
$show_title = !empty($rows[0]['cats_name']) ? 'Сообщества - ' . $rows[0]['cats_name'] : 'Сообщества';
$show_pages = show_pages(gen_uri('cats', $id, RND));
}
else if (!empty($mod) && $mod == 'open') {
$rows = $db->selectPage($total, "SELECT ?_comm_comm.*, ?_comm_category.*
FROM ?_comm_comm LEFT JOIN ?_comm_category
ON ?_comm_comm.`comm_cats_id` = ?_comm_category.`cats_id`
WHERE `comm_status` = '0'
ORDER BY `comm_create` DESC
LIMIT ?d, ?d", $from, $onpage);
$show_title = 'Открытые сообщества';
$show_pages = show_pages('open', RND, 'p');
}
else if (!empty($mod) && $mod == 'top') {
$rows = $db->selectPage($total, "SELECT ?_comm_comm.*, ?_comm_category.*
FROM ?_comm_comm LEFT JOIN ?_comm_category
ON ?_comm_comm.`comm_cats_id` = ?_comm_category.`cats_id`
ORDER BY `comm_count` DESC
LIMIT ?d, ?d", $from, $onpage);
$show_title = 'Популярные сообщества';
$show_pages = show_pages('top', RND, 'p');
}
else {
$rows = $db->selectPage($total, "SELECT ?_comm_comm.*, ?_comm_category.*
FROM ?_comm_comm LEFT JOIN ?_comm_category
ON ?_comm_comm.`comm_cats_id` = ?_comm_category.`cats_id`
ORDER BY `comm_create` DESC
LIMIT ?d, ?d", $from, $onpage);
$show_title = 'Новые сообщества';
$show_pages = show_pages('new', RND, 'p');
}
if (!empty($rows) && $total > 0) {
show_header($show_title);
echo '<div class="b"><a href="#down">' . icon('down.png') . '</a>';
echo '<a href="' . gen_uri('new', '', RND) . '">Новые</a> | ';
echo '<a href="' . gen_uri('top', '', RND) . '">Популярные</a> | ';
echo '<a href="' . gen_uri('open', '', RND) . '">Открытые</a>';
if ($is_logged) {
echo ' | <a href="' . gen_users($log, 'soo', '', RND) . '">Мои сообщества</a>';
}
echo '</div>';
foreach($rows as $row) {
$icon = ($row['comm_status'] == 1) ? 'com_closed.gif' : 'com_open.gif';
echo '<div class="b">' . icon($icon, 'icons');
echo '<a href="' . $row['comm_url'] . DS . gen_uri('comm', '', RND) . '">' . $row['comm_name'] . '</a> (' . $row['comm_count'] . ')<br />';
echo format_text($row['comm_about']);
echo '</div>';
}
echo $show_pages;
echo '<div class="b"><a href="#up">' . icon('up.png') . '</a>';
echo '<a href="' . gen_uri('add', $id, RND) . '">Создать сообщество</a> | ';
echo '<a href="' . gen_uri('index', '', RND) . '">Категории</a> | ';
echo '<a href="' . gen_uri('search', '', RND) . '">Поиск</a><br /></div>';
}
else {
$inSes->addMessage('Ошибка! Сообщества не найдены или ссылка неверна!');
gen_red('index', '', RND);
}
?>