$conditions[] = "News.title like '%" . trim($_GET['q']) . "%'";
}
if (!empty($_GET['typeid'])) {
$conditions[] = "News.type_id=" . $_GET['typeid'];
}
if (isset($_GET['topicid'])) {
setvar("Items", $pdb->GetArray("SELECT n.* FROM {$tb_prefix}topicnews tn RIGHT JOIN {$tb_prefix}newses n ON tn.news_id=n.id WHERE tn.topic_id=" . intval($_GET['topicid'])));
setvar("Newstypes", $newstype->getCacheTypes());
template($tpl_file);
exit;
}
}
if ($do == "del" && !empty($id)) {
$sql = "SELECT picture FROM {$tb_prefix}newses WHERE id=" . $id;
$attach_filename = $pdb->GetOne($sql);
$news->del($id);
$attachment->deleteBySource($attach_filename);
}
if ($do == "edit") {
$news_info = null;
include CACHE_PATH . "cache_area.php";
include CACHE_PATH . "cache_industry.php";
setvar("CacheAreas", $_PB_CACHE['area']);
setvar("CacheIndustries", $_PB_CACHE['industry']);
$result = $membertype->findAll("id,name", null, $conditions, " id desc");
$user_types = array();
foreach ($result as $key => $val) {
$user_types[$val['id']] = $val['name'];
}
setvar("Membertypes", $user_types);
setvar("NewstypeOptions", $newstype->getTypeOptions());
