control.php

来自「通达网络办公 - Office Anywhere 2008 增强版100％源码(」· PHP 代码 · 共 286 行

<?php

include_once( "myauth.php" );
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $TAB != "" )
{
	$pieces = explode( " ", $TAB );
	$tag_str = "";
	$COUNT = 0;
	$I = 0;
	for ( ;	$I < count( $pieces );	++$I	)
	{
		if ( $pieces[$I] != "" )
		{
			++$COUNT;
			if ( 5 < $COUNT )
			{
				break;
			}
			$tag_str .= $pieces[$I]." ";
		}
	}
}
switch ( $action )
{
case "plus" :
	$query = "insert into CATEGORIES_TYPE(CATEGORIE_NAME,PEARENT_ID,ORDER_ID,MANAGER) values ('".$CATEGORIE_NAME."','{$PEARENT_ID}','{$ORDER_ID}','{$MANAGER}')";
	exequery( $connection, $query );
	if ( $PEARENT_ID != 0 )
	{
		$query = "SELECT MANAGER from CATEGORIES_TYPE where CATEGORIE_ID='".$PEARENT_ID."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$MANAGER_OLD = $ROW['MANAGER'];
		}
		$MANAGER_NEW = "";
		if ( $MANAGER_OLD != "" )
		{
			$MANAGER_ARRAY = explode( ",", $MANAGER );
			$I = 0;
			for ( ;	do
	{
	$I < count( $MANAGER_ARRAY );	++$I	)
				{
					if ( !find_id( $MANAGER_OLD, $MANAGER_ARRAY[$I] ) )
					{
						if ( substr( trim( $MANAGER_OLD ), -1, 1 ) == "," )
						{
							$MANAGER_NEW = $MANAGER_OLD.$MANAGER_ARRAY[$I];
						}
						else
						{
							$MANAGER_NEW = $MANAGER_OLD.",".$MANAGER_ARRAY[$I];
						}
					}
					else
					{
						$MANAGER_NEW = $MANAGER_OLD;
					}
					break;
				}
			} while ( 1 );
		}
		else
		{
			$MANAGER_NEW = $MANAGER;
		}
		$query = "UPDATE CATEGORIES_TYPE SET MANAGER = '".$MANAGER_NEW."' WHERE CATEGORIE_ID='{$PEARENT_ID}'";
		exequery( $connection, $query );
	}
	message( "提示", "保存成功!" );
	button_back( -1 );
	break;
case "update" :
	$query = "UPDATE CATEGORIES_TYPE SET PEARENT_ID = '".$PEARENT_ID."',ORDER_ID = '{$ORDER_ID}',CATEGORIE_NAME = '{$CATEGORIE_NAME}',MANAGER = '{$MANAGER}' WHERE CATEGORIE_ID='{$CATEGORIE_ID}'";
	exequery( $connection, $query );
	if ( $PEARENT_ID != 0 )
	{
		$query = "SELECT MANAGER from CATEGORIES_TYPE where CATEGORIE_ID='".$PEARENT_ID."'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$MANAGER_OLD = $ROW['MANAGER'];
		}
		$MANAGER_NEW = "";
		if ( $MANAGER_OLD != "" )
		{
			$MANAGER_ARRAY = explode( ",", $MANAGER );
			$MANAGER_ARRAY_COUNT = count( $MANAGER_ARRAY );
			if ( $MANAGER_ARRAY[$MANAGER_ARRAY_COUNT - 1] == "" )
			{
				--$MANAGER_ARRAY_COUNT;
			}
			$I = 0;
			for ( ;	do
	{
	$I < $MANAGER_ARRAY_COUNT;	++$I	)
				{
					if ( !find_id( $MANAGER_OLD, $MANAGER_ARRAY[$I] ) )
					{
						if ( substr( trim( $MANAGER_OLD ), -1, 1 ) == "," )
						{
							$MANAGER_NEW = $MANAGER_OLD.$MANAGER_ARRAY[$I];
						}
						else
						{
							$MANAGER_NEW = $MANAGER_OLD.",".$MANAGER_ARRAY[$I];
						}
					}
					else
					{
						$MANAGER_NEW = $MANAGER_OLD;
					}
					break;
				}
			} while ( 1 );
		}
		else
		{
			$MANAGER_NEW = $MANAGER;
		}
		$query = "UPDATE CATEGORIES_TYPE SET MANAGER = '".$MANAGER_NEW."' WHERE CATEGORIE_ID='{$PEARENT_ID}'";
		exequery( $connection, $query );
	}
	message( "提示", "修改成功!" );
	button_back( -1 );
	break;
case "delete" :
	isinner( );
	$query = "DELETE FROM CATEGORIES_TYPE WHERE CATEGORIE_ID='".$CATEGORIE_ID."'";
	exequery( $connection, $query );
	message( "提示", "删除成功!" );
	header( "location:sysoperate/categories.php?CATEGORIES_ID=" );
	break;
case "commend" :
	isinner( );
	$query = "UPDATE WIKI_ASK SET COMMEND = '".$COMMEND_FLAG."' WHERE ASK_ID='{$ASK_ID}'";
	exequery( $connection, $query );
	$W = urlencode( stripslashes( $W ) );
	header( "location:sysoperate/allask.php?W=".$W."&STATUS={$STATUS}" );
	break;
case "discommend" :
	isinner( );
	$query = "UPDATE WIKI_ASK SET COMMEND = '".$COMMEND_FLAG."' WHERE ASK_ID='{$ASK_ID}'";
	exequery( $connection, $query );
	header( "location:../question/display.php?ASK_ID=".$ASK_ID );
	break;
case "deleteask" :
	if ( $FROM == 0 )
	{
		$query = "DELETE FROM WIKI_ASK WHERE ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$query = "DELETE from WIKI_COMMENT where ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$query = "DELETE FROM WIKI_ASK_ANSWER WHERE ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		header( "location:myoperate/myask.php?PAGE=".$PAGE );
	}
	else
	{
		isinner( );
		$query = "DELETE FROM WIKI_ASK WHERE ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$query = "DELETE from WIKI_COMMENT where ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$query = "DELETE FROM WIKI_ASK_ANSWER WHERE ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$W = urlencode( stripslashes( $W ) );
		header( "location:sysoperate/allask.php?W=".$W."&STATUS={$STATUS}&PAGE={$PAGE}" );
	}
	break;
case "askedit" :
	$query = "UPDATE WIKI_ASK SET ASK = '".$ASK."',ASK_CONTENT = '{$ASK_CONTENT}',RELATED_KEYWOED = '{$tag_str}',CATEGORIE_ID= '{$CATEGORIE_ID}' WHERE ASK_ID='{$ASK_ID}'";
	exequery( $connection, $query );
	if ( !( $FROM == 0 ) )
	{
		break;
	}
	header( "location:myoperate/myask.php?PAGE=".$PAGE );
	break;
case "deleteanswer" :
	isinner( );
	$query = "DELETE FROM WIKI_ASK_ANSWER WHERE ANSWER_ID='".$ANSWER_ID."'";
	exequery( $connection, $query );
	if ( $GOOD_ANSWER == 1 )
	{
		$query = "UPDATE WIKI_ASK SET ASK_STATUS = '0' WHERE ASK_ID='".$ASK_ID."'";
		exequery( $connection, $query );
		$query = "update USER set SCORE=SCORE-1 where USER_ID ='".$ANSWER_USER."' and SCORE > '0'";
		exequery( $connection, $query );
	}
	header( "location:sysoperate/display.php?ASK_ID=".$ASK_ID );
	break;
case "deleteping" :
	isinner( );
	$query = "DELETE from WIKI_COMMENT where COMMENT_ID='".$COMMENT_ID."'";
	exequery( $connection, $query );
	header( "location:sysoperate/display.php?ASK_ID=".$ASK_ID );
	break;
case "useredit" :
	isinner( );
	if ( $MEMBER == "admin" )
	{
		$TDER_FLAG = 1;
	}
	$query = "UPDATE USER SET SCORE = '".$SCORE."',TDER_FLAG = '{$TDER_FLAG}' WHERE USER_ID='{$MEMBER}'";
	exequery( $connection, $query );
	header( "location:sysoperate/useredit.php?MEMBER=".$MEMBER );
	break;
case "deleteuser" :
	isinner( );
	$query = "DELETE FROM USER WHERE USER_ID='".$MEMBER."'";
	exequery( $connection, $query );
	header( "location:sysoperate/muser.php?PAGE=".$PAGE );
	break;
case "displaysave" :
	isinner( );
	$query = "update WIKI_ASK set ASK = '".$ASK."',ASK_CONTENT = '{$ASK_CONTENT}',RELATED_KEYWOED = '{$tag_str}',CATEGORIE_ID= '{$CATEGORIE_ID}' where ASK_ID='{$ASK_ID}'";
	exequery( $connection, $query );
	if ( $ANSWER_ID_STR != "" )
	{
		$ANSWER_ID_ARRAY = explode( ",", $ANSWER_ID_STR );
		$ANSWER_ID_COUNT = count( $ANSWER_ID_ARRAY );
		if ( $ANSWER_ID_ARRAY[$ANSWER_ID_COUNT] == "" )
		{
			--$ANSWER_ID_COUNT;
		}
		$I = 0;
		for ( ;	$I < $ANSWER_ID_COUNT;	++$I	)
		{
			$ANSWER_CONTENT = "AC_".$ANSWER_ID_ARRAY[$I];
			$ANSWER_CONTENT = $$ANSWER_CONTENT;
			echo $query = "update WIKI_ASK_ANSWER set ANSWER_CONTENT = '".$ANSWER_CONTENT."' where ANSWER_ID='{$ANSWER_ID_ARRAY[$I]}'";
			exequery( $connection, $query );
		}
	}
	header( "location:sysoperate/display.php?ASK_ID=".$ASK_ID );
	break;
case "set_answer" :
	isinner( );
	if ( $GOOD_ANSWER_ID != "" )
	{
		$query1 = "SELECT ANSWER_USER from WIKI_ASK_ANSWER where ANSWER_ID='".$GOOD_ANSWER_ID."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$GOOD_ANSWER_USER = $ROW1['ANSWER_USER'];
		}
		$query = "UPDATE WIKI_ASK_ANSWER SET GOOD_ANSWER = '0' WHERE ANSWER_ID ='".$GOOD_ANSWER_ID."'";
		if ( exequery( $connection, $query ) )
		{
			echo $query = "update USER set SCORE=SCORE-1 where USER_ID ='".$GOOD_ANSWER_USER."'";
			exequery( $connection, $query );
		}
	}
	$query = "update WIKI_ASK_ANSWER set GOOD_ANSWER = '1' where ANSWER_ID ='".$ANSWER_ID."'";
	if ( exequery( $connection, $query ) )
	{
		$query = "update USER set SCORE=SCORE+1 where USER_ID ='".$ANSWER_USER."'";
		exequery( $connection, $query );
	}
	$query = "update WIKI_ASK set ASK_STATUS = '1',RESOLUTION_TIME = '".$CUR_TIME."' where ASK_ID ='{$ASK_ID}'";
	exequery( $connection, $query );
	header( "location:sysoperate/display.php?ASK_ID=".$ASK_ID );
	break;
case "userinput" :
	isinner( );
	$query = "insert into WIKI_ASK (CREATOR,CREATE_TIME,ASK_CONTENT,ASK,ASK_REPLY_COUNT,RELATED_KEYWOED,ASK_STATUS,CATEGORIE_ID,RESOLUTION_TIME) values \r\n    ('".$LOGIN_USER_ID."','{$CUR_TIME}','{$ASK_CONTENT}','{$ASK}','1','{$tag_str}','1','{$CATEGORIE_ID}','{$CUR_TIME}')";
	exequery( $connection, $query );
	$INSERT_ID = mysql_insert_id( );
	$query = "insert into WIKI_ASK_ANSWER (ASK_ID,ANSWER_USER,ANSWER_TIME,ANSWER_CONTENT,GOOD_ANSWER) \r\n    values ('".$INSERT_ID."','{$LOGIN_USER_ID}','{$CUR_TIME}','{$ANSWER_CONTENT}','1')";
	exequery( $connection, $query );
	$query = "update USER set SCORE=SCORE+1 where USER_ID ='".$LOGIN_USER_ID."'";
	exequery( $connection, $query );
	header( "location:sysoperate/userinput.php" );
	break;
case "sysinfo" :
	echo $query = "update WIKI_INFO set SYS_NAME='".$EDIT_SYS_NAME."'";
	exequery( $connection, $query );
	header( "location:sysoperate/system.php" );
	break;
	echo "<script>history.go(-1);</script>";
}
?>