getRow("SELECT * FROM {$db_mymps}category WHERE catid = '$catid'"); $here = "编辑信息分类"; $cat['description'] = $cat['description'] ? de_textarea_post_change($cat['description']) : ''; include(mymps_tpl("category_edit")); } elseif($part == 'add') { include MYMPS_DATA.'/category_tpl.inc.php'; include MYMPS_DATA.'/information_tpl.inc.php'; chk_admin_purview("purview_添加分类"); $maxorder = $db->getOne("SELECT MAX(catorder) FROM {$db_mymps}category"); $maxorder = $maxorder + 1; $here = "添加信息分类"; include mymps_tpl("category_add"); } elseif($part == 'del') { empty($catid) && write_msg('没有选择记录'); mymps_delete("category","WHERE ".get_children($catid,'catid')); mymps_delete("information","WHERE ".get_children($catid,'catid')); clear_cache_files('category_option_static'); clear_cache_files('category_pid_releate'); clear_cache_files('category_tree'); clear_cache_files('category_dir'); write_msg("删除信息分类 $catid 成功","category.php?part=list","Mymps"); } } else { $part != 'list' && require_once dirname(__FILE__)."/include/pinyin.inc.php"; if($part == 'list' ){ if(is_array($catorder)){ foreach($catorder as $key => $value){ $db->query("UPDATE `{$db_mymps}category` SET catorder = '$value' WHERE catid = ".$key); } } if(is_array($if_viewids)){ $db->query("UPDATE `{$db_mymps}category` SET if_view = '1' "); foreach($if_viewids as $key){ $db->query("UPDATE `{$db_mymps}category` SET if_view = '2' WHERE catid = ".$key); } } else { $db->query("UPDATE `{$db_mymps}category` SET if_view = '1' "); } /*清除缓存*/ foreach(array('option_static','pid_releate','tree','dir') as $range){ clear_cache_files('category_'.$range); } write_msg('信息分类更新成功!','?part=list','record'); } elseif ($part == 'add'){ $catname = explode("\r\n",trim($catname)); $template = empty($template) ? 'list' : trim($template); $template_info = empty($template_info) ? 'info' : trim($template_info); $usecoin = isset($usecoin) ? intval($usecoin) : 0; $parentid = isset($parentid) ? intval($parentid) : 0; $gid = admin_get_gid('',$parentid); (empty($catname) || !is_array($catname)) && write_msg("请填写分类名称"); if(empty($catorder)){ $sql = "SELECT MAX(catorder) FROM {$db_mymps}category"; $maxorder = $db->getOne($sql); $catorder = $maxorder; } if(is_array($catname)){ foreach ($catname as $key => $value){ $value = trim($value); $catorder ++; $len = strlen($value); ($len < 2 || $len > 30) && write_msg("分类名必须在2个至30个字符之间"); $db->query("INSERT INTO {$db_mymps}category (catname,usecoin,if_view,gid,parentid,modid,catorder,if_upimg,if_mappoint,dir_type,template,template_info) VALUES ('$value','$usecoin','$isview','$gid','$parentid','$modid','$catorder','$if_upimg','$if_mappoint','$dir_type','$template','$template_info')"); $insert_id = $db -> insert_id(); //如果为一级栏目 if($parentid == 0){ if($dir_type == 1){ $html_dir = '/'.$insert_id.'/'; } elseif ($dir_type == 2) { $html_dir = '/'.GetPinyin($value).'/'; $dir_typename = GetPinyin($value); } elseif ($dir_type == 3) { $html_dir = '/'.GetPinyin($value,1).'/'; $dir_typename = GetPinyin($value,1); } } else { $row = $db -> getRow("SELECT * FROM `{$db_mymps}category` WHERE catid = '$parentid'"); if($dir_type == 1){ $html_dir = ($row['html_dir'] ? $row['html_dir'] : '/').$insert_id.'/'; } elseif ($dir_type == 2) { $html_dir = ($row['html_dir'] ? $row['html_dir'] : '/').GetPinyin($value).'/'; $dir_typename = GetPinyin($value); } elseif ($dir_type == 3) { $html_dir = ($row['html_dir'] ? $row['html_dir'] : '/').GetPinyin($value,1).'/'; $dir_typename = GetPinyin($value,1); } } $gidquery = $gid ? '' : " ,gid='$insert_id' "; $db->query("UPDATE `{$db_mymps}category` SET dir_typename='$dir_typename',html_dir = '$html_dir'{$gidquery} WHERE catid = '$insert_id'"); } /*清除缓存*/ foreach(array('option_static','pid_releate','tree','dir') as $range){ clear_cache_files('category_'.$range); } write_msg('成功增加信息分类','?part=list'); }else{ write_msg('信息分类添加失败,请按格式填写'); } } elseif ($part == 'edit') { $template = empty($template) ? 'list' : trim($template); $usecoin = isset($usecoin) ? intval($usecoin) : 0 ; empty($catname) && write_msg("请填写信息分类名称"); $catid == $parentid && write_msg("隶属信息分类不能为自己!"); $len = strlen($catname); ($len < 2 || $len > 30) && write_msg("信息分类名必须在2个至30个字符之间"); $gid = admin_get_gid($catid,$parentid); $description = $description ? textarea_post_change($description) : ''; //自定义目录名 if($dir_type == 4){ !$mydir && write_msg('请填写自定义目录名!'); $html_dir = '/'.$mydir.'/'; } else { //如果为父目录 if($parentid == 0){ if($dir_type == 1){ $html_dir = '/'.$catid.'/'; } elseif ($dir_type == 2) { $html_dir = '/'.GetPinyin($catname).'/'; } elseif ($dir_type == 3) { $html_dir = '/'.GetPinyin($catname,1).'/'; } } else { if($dir_type == 1){ $html_dir = $catid.'/'; } elseif ($dir_type == 2) { $html_dir = GetPinyin($catname).'/'; } elseif ($dir_type == 3) { $html_dir = GetPinyin($catname,1).'/'; } } } if($db -> getOne("SELECT COUNT(catid) FROM `{$db_mymps}category` WHERE dir_typename = '$mydir' AND dir_typename != ''") > 1){ write_msg("您指定的目录名".$mydir."已存在,请换一个名称!"); exit; } $sql = "UPDATE {$db_mymps}category SET gid='$gid',catname='$catname',icon='$icon',usecoin='$usecoin',if_view = '$isview',color='$fontcolor',title='$title',keywords='$keywords',description='$description',parentid='$parentid',modid='$modid',catorder='$catorder',dir_type = '$dir_type', dir_typename = '$mydir', html_dir = '$html_dir' ,if_upimg='$if_upimg',if_mappoint='$if_mappoint',template='$template',template_info='$template_info' WHERE catid = '$catid'"; $res = $db->query($sql); if($children_mod == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET modid = '$modid' WHERE ".get_children($catid,'catid')); } if($children_tpl == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET template = '$template' WHERE ".get_children($catid,'catid')); } if($children_tplinfo == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET template_info = '$template_info' WHERE ".get_children($catid,'catid')); } if($children_upload == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET if_upimg = '$if_upimg' WHERE ".get_children($catid,'catid')); } if($children_map == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET if_mappoint = '$if_mappoint' WHERE ".get_children($catid,'catid')); } if($children_des == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET description = '$description' WHERE ".get_children($catid,'catid')); } if($children_usecoin == '1'){ $db -> query("UPDATE `{$db_mymps}category` SET usecoin = '$usecoin' WHERE ".get_children($catid,'catid')); } /*清除缓存*/ foreach(array('option_static','pid_releate','tree','dir') as $range){ clear_cache_files('category_'.$range); } write_msg('成功编辑信息分类 ['.$catname.']','?part=edit&catid='.$catid); } } is_object($db) && $db->Close(); $db = $mymps_global = $part = $action = $here = NULL; function info_typemodels($modid=""){ global $db,$db_mymps; $sql = "SELECT id,name,displayorder FROM `{$db_mymps}info_typemodels` ORDER BY displayorder ASC"; $opt = $db->getAll($sql); foreach ($opt as $k => $value){ $mymps .= "