flash(); } $cache->updateTypes(); } if (isset($_GET['do'])) { $do = trim($_GET['do']); if (!empty($_GET['id'])) { $id = intval($_GET['id']); } if ($do == 'search') { if (isset($_GET['newstype']['name'])) { $conditions[] = "Newstype.name like '%" . trim($_GET['newstype']['name']) . "%'"; } } if ($do == "del" && !empty($id)) { $newstype->del($id); } if ($do == "edit") { setvar("NewstypeOptions", $newstype->getTypeOptions()); if (!empty($id)) { $res = $newstype->read("*", $id); setvar("item", $res); } $tpl_file = "newstype.edit"; template($tpl_file); exit; } } $amount = $newstype->findCount(null, $conditions); $page->setPagenav($amount); $sql = "SELECT nt.*,(SELECT count(n.id)) AS news_amount FROM " . $tb_prefix . "newstypes nt LEFT JOIN " . $tb_prefix . "newses n ON n.type_id=nt.id GROUP BY nt.id ORDER BY nt.id DESC LIMIT {$page->firstcount},{$page->displaypg}";