suspend_member.php

通达OA部分源代码

<?php 
include_once"logincheck.php";
include_once"myconnect.php";

if( isset($_REQUEST["sb_id"]) && ($_REQUEST["sb_id"] != 0) )//&& isset($_REQUEST["sbapp"]) )
{		
	$sb_id=$_REQUEST["sb_id"];
	
		$sbq_res="select * from sbbleads_members where sb_id=$sb_id";
		$sbrow_res=mysql_fetch_array(mysql_query($sbq_res));

		if($sbrow_res["sb_suspended"] == 'no')
		{
			$sbmsg_part="suspended";
			$sb_approved='yes';
			$sbfail_msg='suspend';
		}
		else
		{
			$sbmsg_part="unsuspended";
			$sb_approved='no';
			$sbfail_msg='unsuspend';
		}
		$query_ope="update sbbleads_members set sb_suspended='$sb_approved' where sb_id=$sb_id";
		//die($query_ope);
		$rs_ope=mysql_query($query_ope);
		if(mysql_affected_rows() == 1)
		{
			header("Location: members.php?msg=".urlencode("Member has been $sbmsg_part"));
			die();	
		}	
		else	
		{		
			header("Location: members.php?msg=".urlencode("Unable to $sbfail_msg, please try again"));
			die();
		}
}		//end if top most
	//if nothing came
	header("Location: adminhome.php?msg=".urlencode("Invalid operation, denied"));
	die();

?>