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;