getRow('SELECT * FROM ' . $db_mymps . 'channel WHERE catid = \'' . $catid . '\'');
$here = '编辑新闻栏目';
include mymps_tpl('news_channel_edit');
} else {
if ($part == 'add') {
$maxorder = $db->getOne('SELECT MAX(catorder) FROM ' . $db_mymps . 'channel');
$maxorder = $maxorder + 1;
$here = '添加新闻栏目';
include mymps_tpl('news_channel_add');
} else {
if ($part == 'del') {
!$catid && write_msg('没有选择记录');
mymps_delete('channel', 'WHERE catid = \'' . $catid . '\'');
mymps_delete('channel', 'WHERE parentid = \'' . $catid . '\'');
mymps_delete('news', 'WHERE catid IN(' . get_cat_children($catid, 'channel') . ')');
foreach (array('option_static', 'pid_releate') as $range) {
clear_cache_files('channel_' . $range);
}
write_msg('删除新闻栏目 ' . $catid . ' 成功', 'channel.php?part=list', 'Mymps');
}
}
}
}
} else {
($part == 'add' || $part == 'edit') && (require_once dirname(__FILE__) . '/include/pinyin.inc.php');
if ($part == 'list') {
if (is_array($catorder)) {
$cur_action .= '排序 ';
foreach ($catorder as $key => $value) {
$db->query('UPDATE `' . $db_mymps . 'channel` SET catorder = \'' . $value . '\' WHERE catid = ' . $key);
}
}
if (is_array($if_viewids)) {
$cur_action .= '启用与否';
$db->query('UPDATE `' . $db_mymps . 'channel` SET if_view = \'1\' ');
foreach ($if_viewids as $k => $val) {
$db->query('UPDATE `' . $db_mymps . 'channel` SET if_view = \'2\' WHERE catid = ' . $val);
}
} else {
$db->query('UPDATE `' . $db_mymps . 'channel` SET if_view = \'1\' ');
}
foreach (array('option_static', 'pid_releate') as $range) {
clear_cache_files('channel_' . $range);
}
write_msg('新闻栏目 ' . $cur_action . ' 更新成功!', '?part=list', 'record');
} else {
if ($part == 'add') {
empty($catname) && write_msg('请填写新闻栏目名称!');
$len = strlen($catname);
$len < 2 && write_msg('新闻栏目名必须在2个字符以上');
$catname = explode('|', trim($catname));
if (empty($catorder)) {
$maxorder = $db->getOne('SELECT MAX(catorder) FROM ' . $db_mymps . 'channel');
$catorder = $catorder + 1;
}
if (is_array($catname)) {
foreach ($catname as $key => $value) {
$value = trim($value);
$catorder++;
$len = strlen($value);
($len < 2 || 30 < $len) && write_msg('分类名必须在2个至30个字符之间');
$db->query('INSERT INTO ' . $db_mymps . 'channel (catname,if_view,title,keywords,description,parentid,catorder,dir_type) VALUES (\'' . $value . '\',\'' . $isview . '\',\'' . $value . '\',\'' . $value . '\',\'' . $value . '\',\'' . $parentid . '\',\'' . $catorder . '\',\'' . $dir_type . '\')');
$insert_id = $db->insert_id();
if ($parentid == 0) {
if ($dir_type == 1) {
$html_dir = '/' . $insert_id . '/';
} else {
if ($dir_type == 2) {
$html_dir = '/' . GetPinyin($value) . '/';
} else {
if ($dir_type == 3) {
$html_dir = '/' . GetPinyin($value, 1) . '/';
}
}
}
} else {
$row = $db->getRow('SELECT * FROM `' . $db_mymps . 'channel` WHERE catid = \'' . $parentid . '\'');
if ($dir_type == 1) {
$html_dir = ($row['html_dir'] ? $row['html_dir'] : $row['html_dir']) . $insert_id . '/';
} else {
if ($dir_type == 2) {
$html_dir = ($row['html_dir'] ? $row['html_dir'] : $row['html_dir']) . GetPinyin($value) . '/';
} else {
if ($dir_type == 3) {
$html_dir = ($row['html_dir'] ? $row['html_dir'] : $row['html_dir']) . GetPinyin($value, 1) . '/';
}
}
}
}
$db->query('UPDATE `' . $db_mymps . 'channel` SET html_dir = \'' . $html_dir . '\' WHERE catid = \'' . $insert_id . '\'');
}
foreach (array('option_static', 'pid_releate') as $range) {
clear_cache_files('channel_' . $range);
}
write_msg('新闻分类添加成功!', '?part=list', 'record');
} else {
write_msg('新闻分类添加失败,请按格式填写!');
}
} else {
if ($part == 'edit') {
empty($catname) && write_msg('请填写新闻栏目名称!');
strlen($catname) < 2 && write_msg('新闻栏目名必须在2个字符以上');
$catid == $parentid && write_msg('隶属栏目不能为自己!');
$parentid != 0 && ($row = $db->getRow('SELECT catname,html_dir FROM `' . $db_mymps . 'channel` WHERE catid = \'' . $parentid . '\''));
if ($dir_type == 4) {
!$mydir && write_msg('请填写自定义目录名!');
if ($parentid == 0) {
$html_dir = '/' . $mydir . '/';
} else {
$html_dir = $row['html_dir'] . $mydir . '/';
}
} else {
if ($parentid == 0) {
if ($dir_type == 1) {
$html_dir = '/' . $catid . '/';
} else {
if ($dir_type == 2) {
$html_dir = '/' . GetPinyin($catname) . '/';
} else {
if ($dir_type == 3) {
$html_dir = '/' . GetPinyin($catname, 1) . '/';
}
}
}
} else {
if ($dir_type == 1) {
$html_dir = $row['html_dir'] . $catid . '/';
} else {
if ($dir_type == 2) {
$html_dir = $row['html_dir'] . GetPinyin($catname) . '/';
} else {
if ($dir_type == 3) {
$html_dir = $row['html_dir'] . GetPinyin($catname, 1) . '/';
}
}
}
}
}
$sql = 'UPDATE ' . $db_mymps . 'channel SET catname=\'' . $catname . '\',if_view=\'' . $isview . '\',title=\'' . $title . '\',color=\'' . $fontcolor . '\',keywords=\'' . $keywords . '\',description=\'' . $description . '\',parentid=\'' . $parentid . '\',catorder=\'' . $catorder . '\',dir_type = \'' . $dir_type . '\', dir_typename = \'' . $mydir . '\', html_dir = \'' . $html_dir . '\' WHERE catid = \'' . $catid . '\'';
$res = $db->query($sql);
$nav_path = '新闻栏目管理 » 编辑栏目';
$message = '成功编辑新闻栏目 ' . $catname;
$after_action = '继续增加栏目' . "\r\n\t\t" . ' 重新编辑该栏目 已增加栏目管理';
foreach (array('option_static', 'pid_releate') as $range) {
clear_cache_files('channel_' . $range);
}
write_msg($message, 'channel.php');
}
}
}
}
is_object($db) && $db->Close();
$db = $mymps_global = $part = $action = $here = NULL;