sort.php

mv 具体不是很清楚

<?php
require_once("global.php");


if($IS_BIZ && !table_field("{$pre}mv_sort",'list_html'))
{
	$db->query("ALTER TABLE `{$pre}mv_sort` ADD `list_html` VARCHAR( 255 ) NOT NULL ,ADD `bencandy_html` VARCHAR( 255 ) NOT NULL");
}

$linkdb=array(
			  "栏目管理"=>"sort.php?job=listsort",
			  "修复出错栏目"=>"sort.php?job=save",
			  "合并栏目"=>"sort.php?job=toget"
			);

if($job=="listsort")
{
	$fid=intval($fid);

	$sortdb=array();
	list_allsort($fid,"mv_sort");

	if($fid){
		$rsdb=$db->get_one(" SELECT * FROM {$pre}mv_sort WHERE fid='$fid' ");
	}
	$sort_fup=$Guidedb->Select("{$pre}mv_sort","fup",$fid);

	require("head.php");
	require("template/sort/sort.htm");
	require("foot.php");
}
elseif($action=="addsort")
{
	if($fup){
		$rs=$db->get_one("SELECT name,class FROM {$pre}mv_sort WHERE fid='$fup' ");
		$class=$rs['class'];
		$db->query("UPDATE {$pre}mv_sort SET sons=sons+1 WHERE fid='$fup'");
		$type=0;
	}else{
		$type=1;	/*分类标志*/
		$class=0;
	}
	$class++;
	$db->query("INSERT INTO {$pre}mv_sort (name,fup,class,type,allowcomment) VALUES ('$name','$fup','$class','$Type',1) ");
	@extract($db->get_one("SELECT fid FROM {$pre}mv_sort ORDER BY fid DESC LIMIT 0,1"));
	
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("?lfj=$lfj&job=editsort&fid=$fid","创建成功");
}

//修改栏目信息
elseif($job=="editsort")
{
	$postdb[fid] && $fid=$postdb[fid];
	$rsdb=$db->get_one("SELECT * FROM {$pre}mv_sort WHERE fid='$fid'");
	$rsdb[config]=unserialize($rsdb[config]);
	$sort_fid=$Guidedb->Select("{$pre}mv_sort","postdb[fid]",$fid,"?lfj=$lfj&job=$job");
	$sort_fup=$Guidedb->Select("{$pre}mv_sort","postdb[fup]",$rsdb[fup]);
	$group_post=group_box("postdb[allowpost]",explode(",",$rsdb[allowpost]),array(2));
	$group_viewtitle=group_box("postdb[allowviewtitle]",explode(",",$rsdb[allowviewtitle]));
	$group_viewcontent=group_box("postdb[allowviewcontent]",explode(",",$rsdb[allowviewcontent]));
	$group_download=group_box("postdb[allowdownload]",explode(",",$rsdb[allowdownload]));
	$typedb[$rsdb[type]]=" checked ";
	$index_show[$rsdb[index_show]]=" checked ";

	$forbidshow[intval($rsdb[forbidshow])]=" checked ";
	$allowcomment[intval($rsdb[allowcomment])]=" checked ";

	$tpl=unserialize($rsdb[template]);

	$listorder[$rsdb[listorder]]=" selected ";


	$sonListorder[$rsdb[config][sonListorder]]=" selected ";

	$rsC=$db->get_one("SELECT * FROM {$pre}channel WHERE id=1 ");
	if(in_array($fid,explode(",",$rsC[fids]))){
		$index_showtitle[1]=' checked ';
		$_index_showtitle=1;
	}else{
		$index_showtitle[0]=' checked ';
		$_index_showtitle=0;
	}
	require_once(PHP168_PATH."inc/pinyin.php");
	$htmldirname=change2pinyin($rsdb[name],1);
	require("head.php");
	require("template/sort/editsort.htm");
	require("foot.php");
}
elseif($action=="editsort")
{
	//检查父栏目是否有问题
	check_fup("{$pre}mv_sort",$postdb[fid],$postdb[fup]);
	$postdb[allowpost]=@implode(",",$postdb[allowpost]);
	$postdb[allowviewtitle]=@implode(",",$postdb[allowviewtitle]);
	$postdb[allowviewcontent]=@implode(",",$postdb[allowviewcontent]);
	$postdb[allowdownload]=@implode(",",$postdb[allowdownload]);
	$postdb[template]=@serialize($postdb[tpl]);
	unset($SQL);

	$rs_fid=$db->get_one("SELECT * FROM {$pre}mv_sort WHERE fid='$postdb[fid]'");
	//这样处理是其他地方也修改过这个值.比如标签里
	$rs_fid[config]=unserialize($rs_fid[config]);
	$rs_fid[config][sonTitleRow]=$sonTitleRow;
	$rs_fid[config][sonTitleLeng]=$sonTitleLeng;
	$rs_fid[config][cachetime]=$cachetime;
	$rs_fid[config][sonListorder]=$sonListorder;
	$postdb[config]=addslashes( serialize($rs_fid[config]) );

	if($rs_fid[fup]!=$postdb[fup])
	{
		$rs_fup=$db->get_one("SELECT class FROM {$pre}mv_sort WHERE fup='$postdb[fup]' ");
		$newclass=$rs_fup['class']+1;
		$db->query("UPDATE {$pre}mv_sort SET sons=sons+1 WHERE fup='$postdb[fup]' ");
		$db->query("UPDATE {$pre}mv_sort SET sons=sons-1 WHERE fup='$rs_fid[fup]' ");
		$SQL=",class=$newclass";
	}
	/*缺少对版主有效用户名的检测*/
	$postdb[admin]=str_Replace("，",",",$postdb[admin]);

	$db->query("UPDATE {$pre}mv_sort SET fup='$postdb[fup]',name='$postdb[name]',type='$postdb[type]',admin='$postdb[admin]',passwd='$postdb[passwd]',logo='$postdb[logo]',descrip='$postdb[descrip]',style='$postdb[style]',template='$postdb[template]',jumpurl='$postdb[jumpurl]',listorder='$postdb[listorder]',maxperpage='$postdb[maxperpage]',allowcomment='$postdb[allowcomment]',allowpost='$postdb[allowpost]',allowviewtitle='$postdb[allowviewtitle]',allowviewcontent='$postdb[allowviewcontent]',allowdownload='$postdb[allowdownload]',forbidshow='$postdb[forbidshow]',config='$postdb[config]',index_show='$postdb[index_show]',list_html='$postdb[list_html]',bencandy_html='$postdb[bencandy_html]'$SQL WHERE fid='$postdb[fid]' ");

	//修改栏目名称之后,文章的也要跟着修改
	if($rs_fid[name]!=$postdb[name])
	{
		$db->query(" UPDATE {$pre}mv_video SET fname='$postdb[name]' WHERE fid='$postdb[fid]' ");
	}
	
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	get_htmltype();
	refreshto("$FROMURL","修改成功");
}
elseif($job=='batch_edit')
{
	if(!$fiddb){
		showerr("请选择一个栏目");
	}
	$sort_fup=$Guidedb->Select("{$pre}mv_sort","postdb[fup]",$rsdb[fup]);
	$group_post=group_box("postdb[allowpost]",explode(",",$rsdb[allowpost]));
	$group_viewtitle=group_box("postdb[allowviewtitle]",explode(",",$rsdb[allowviewtitle]));
	$group_viewcontent=group_box("postdb[allowviewcontent]",explode(",",$rsdb[allowviewcontent]));
	$group_download=group_box("postdb[allowdownload]",explode(",",$rsdb[allowdownload]));
	$typedb[$rsdb[type]]=" checked ";

	$forbidshow[intval($rsdb[forbidshow])]=" checked ";

	$tpl=unserialize($rsdb[template]);
	//$tpl_head=select_template("postdb[tpl][head]",7,$tpl[head]);
	//$tpl_foot=select_template("postdb[tpl][foot]",8,$tpl[foot]);
	//$tpl_list=select_template("postdb[tpl][list]",2,$tpl['list']);
	//$tpl_bencandy=select_template("postdb[tpl][bencandy]",3,$tpl[bencandy]);

	$listorder[$rsdb[listorder]]=" selected ";

	require("head.php");
	require("template/sort/batch_edit.htm");
	require("foot.php");	
}
elseif($action=='batch_edit')
{
	if(!$ifchang&&!$db_index_showtitle&&!$db_sonTitleRow&&!$db_sonTitleLeng&&!$db_cachetime){
		showerr("请选择要修改哪个属性");
	}
	$postdb[allowpost]=@implode(",",$postdb[allowpost]);
	$postdb[allowviewtitle]=@implode(",",$postdb[allowviewtitle]);
	$postdb[allowviewcontent]=@implode(",",$postdb[allowviewcontent]);
	$postdb[allowdownload]=@implode(",",$postdb[allowdownload]);
	$postdb[template]=@serialize($postdb[tpl]);

	/*缺少对版主有效用户名的检测*/
	$postdb[admin]=str_Replace("，",",",$postdb[admin]);
	
	foreach( $fiddb AS $fid=>$name){
		
		unset($SQL);
		$postdb[fid]=$fid;
		//检查父栏目是否有问题
		$ifchang[fup] && check_fup("{$pre}mv_sort",$postdb[fid],$postdb[fup]);
		$ifchang[fup] && $rs_fid=$db->get_one("SELECT * FROM {$pre}mv_sort WHERE fid='$postdb[fid]'");
		if($ifchang[fup] && $rs_fid[fup]!=$postdb[fup])
		{
			$rs_fup=$db->get_one("SELECT class FROM {$pre}mv_sort WHERE fup='$postdb[fup]' ");
			$newclass=$rs_fup['class']+1;
			$db->query("UPDATE {$pre}mv_sort SET sons=sons+1 WHERE fup='$postdb[fup]' ");
			$db->query("UPDATE {$pre}mv_sort SET sons=sons-1 WHERE fup='$rs_fid[fup]' ");
			$SQL=",class=$newclass";
		}

		if($db_sonTitleRow||$db_sonTitleLeng||$db_cachetime){
			$rs_fid=$db->get_one("SELECT config FROM {$pre}mv_sort WHERE fid='$postdb[fid]'");

			//这样处理是其他地方也修改过这个值.比如标签里
			$rs_fid[config]=unserialize($rs_fid[config]);
			$db_sonTitleRow && $rs_fid[config][sonTitleRow]=$sonTitleRow;
			$db_sonTitleLeng && $rs_fid[config][sonTitleLeng]=$sonTitleLeng;
			$db_cachetime && $rs_fid[config][cachetime]=$cachetime;
			$postdb[config]=addslashes( serialize($rs_fid[config]) );
			$ifchang[config]=1;
		}
		
		foreach( $ifchang AS $key=>$value){
			$SQL.=",$key='{$postdb[$key]}'";
		}
		$SQL && $db->query("UPDATE {$pre}mv_sort SET fid='$postdb[fid]'$SQL WHERE fid='$postdb[fid]' ");
	}
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("?lfj=$lfj&job=listsort","修改成功");
}
elseif($action=="delete")
{
	$db->query(" DELETE FROM `{$pre}mv_sort` WHERE fid='$fid' ");
	$db->query(" DELETE FROM `{$pre}mv_video` WHERE fid='$fid' ");
	
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("?lfj=sort&job=listsort","删除成功");
}
elseif($action=="editlist")
{
	foreach( $order AS $key=>$value){
		$db->query("UPDATE {$pre}mv_sort SET list='$value' WHERE fid='$key' ");
	}
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("$FROMURL","修改成功",1);
}
/**
*修复网站栏目
**/
elseif($job=='save')
{
	$errsort=sort_error("{$pre}mv_sort",'fid');
 	$sort_fup=$Guidedb->Select("{$pre}mv_sort","fup",$rsdb[fup]);
	require("head.php");
	require("template/sort/save.htm");
	require("foot.php");
}

/**
*处理修复出错栏目
**/
elseif($action=='save'){
	if(!$fid){
		showerr("请选择一个栏目");
	}
	$db->query("UPDATE {$pre}mv_sort SET fup='$fup' WHERE fid='$fid' ");
	mod_sort_class("{$pre}mv_sort",0,0);			//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("$FROMURL","本栏目修正成功",1);
}

/**
*合拼网站栏目
**/
elseif($job=='toget')
{
	$selectname_1=$Guidedb->Select("{$pre}mv_sort",'ofid');
	$selectname_2=$Guidedb->Select("{$pre}mv_sort",'nfid');
	require("head.php");
	require("template/sort/toget.htm");
	require("foot.php");
}

/**
*合拼网站栏目
**/
elseif($action=='toget'){
	if(!$ofid){
		showerr("请选择一个源栏目");
	}elseif(!$nfid){
		showerr("请选择一个目标栏目");
	}
	if($ofid==$nfid){
		showerr("出错了，栏目本身不能合并为自己,请选择合并到其他栏目去吧");
	}
	$db->query("UPDATE {$pre}mv_video SET fid='$nfid' WHERE fid='$ofid'");
	$db->query("DELETE FROM {$pre}mv_sort WHERE fid='$ofid'");
	mod_sort_class("{$pre}mv_sort",0,0);		//更新class
	mod_sort_sons("{$pre}mv_sort",0);			//更新sons
	/*更新导航缓存*/
	cache_guide();
	refreshto("$FROMURL","操作完毕",1);
}

/**
*更新导航缓存
**/
function cache_guide(){
	global $Guidedb,$pre;
	//$Guidedb->FidSonCache("{$pre}mv_sort","../php168/fidson_menu.js",1);
	$Guidedb->GuideFidCache("{$pre}mv_sort","../php168/guide_fid.php",1);
	fid_cache();
}

/*栏目列表*/
function list_allsort($fid,$table='sort'){
	global $db,$pre,$sortdb;
	$query=$db->query("SELECT * FROM {$pre}$table where fup='$fid' ORDER BY list DESC");
	while( $rs=$db->fetch_array($query) ){
		$icon="";
		for($i=1;$i<$rs['class'];$i++){
			$icon.="&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;";
		}
		if($icon){
			$icon=substr($icon,0,-24);
			$icon.="--";
		}
		$rs[config]=unserialize($rs[config]);
		$rs[icon]=$icon;
		$sortdb[]=$rs;

		list_allsort($rs[fid],$table);
	}
}


function get_htmltype(){
	global $db,$pre;
	$query = $db->query("SELECT * FROM {$pre}mv_sort");
	while($rs = $db->fetch_array($query)){
		if($rs[list_html])
		{
			$show.="\$HtmlType['list'][{$rs[fid]}]='$rs[list_html]';\r\n";
		}
		if($rs[bencandy_html])
		{
			$show.="\$HtmlType['bencandy'][{$rs[fid]}]='$rs[bencandy_html]';\r\n";
		}
	}
	write_file("../php168/htmltype.php","<?php\r\n".$show.'?>');
}
?>