reject_profile_new.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_offers where sb_id=$sb_id";
//		$sbrow_res=mysql_fetch_array(mysql_query($sbq_res));

			$sbmsg_part="rejected";
//			$sb_approved='yes';
			$sbfail_msg='reject';

		$sbq_res="select * from sbbleads_companyprofiles where sb_id=$sb_id";
		$sbrow_res=mysql_fetch_array(mysql_query($sbq_res));

		$query_ope="delete from sbbleads_companyprofiles where sb_id=$sb_id";
//		die($query_ope);
		$rs_ope=mysql_query($query_ope);
		if(mysql_affected_rows() == 1)
		{
	/////-----removing from categories
		$query="delete from sbbleads_profile_cats where 1 and sb_profile_id=$sb_id";
		mysql_query($query);
	/////------removing images
//		$query1="delete from sbbleads_offer_images where 1 and sb_offer_id=$sb_id";
//		mysql_query($query1);

			//SENDING MAIL TO MEMBER////////////////////////
		$sbq_mem="select * from sbbleads_members where sb_id=".$sbrow_res["sb_uid"];
		$sbrow_mem=mysql_fetch_array(mysql_query($sbq_mem));
				
		$rs_con=mysql_fetch_array(mysql_query("select * from sbbleads_config where sb_id=1"));
		$sb_null_char=$rs_con["sb_null_char"];
		$login_url=$rs_con["sb_site_root"]."/signin.php";
//		$sb_offer_url=$rs_con["sb_site_root"]."/view_offer?id=$sb_id";

//Reads email to be sebt
		$sbq_mail="SELECT * FROM sbbleads_mails where sb_mailid=3";
		$sbrs_mail=mysql_query($sbq_mail);
		if ( $sbrow_mail=mysql_fetch_array($sbrs_mail)  )
  		{
			$from =$sbrow_mail["sb_fromid"];
			$to = $sbrow_mem["sb_email"];
			$subject =$sbrow_mail["sb_subject"];
		    $header="From:" . $from . "\r\n" ."Reply-To:". $from  ;

			$body=str_replace("%email%", $sbrow_mem["sb_email"],str_replace("%password%",$sbrow_mem["sb_password"],str_replace("%lname%", $sbrow_mem["sb_lastname"],str_replace("%fname%",$sbrow_mem["sb_firstname"],str_replace("%username%",$sbrow_mem["sb_username"], $sbrow_mail["sb_mail"]) )))); 
				
			$body=str_replace("%signup_url%",$sb_null_char,str_replace("%login_url%",$login_url,$body));

		 	$body=str_replace("%message_text%",$sb_null_char,str_replace("%message_title%",$sb_null_char,str_replace("%sender_username%",$sb_null_char,str_replace("%message_date%",$sb_null_char,$body))));	
 
 			$body=str_replace("%visitor_name%",$sb_null_char,$body);
		
			$body=str_replace("%offer_title%",$sbrow_res["sb_companyname"],str_replace("%offer_url%",$sb_null_char,str_replace("%offer_id%",$sb_id,$body)));
	
			$body=str_replace("%category%",$sb_null_char,$body);
		

	 	if(isset($sbrow_mail["sb_html_format"])&&($sbrow_mail["sb_html_format"]=="yes"))
		{
			$header .= "\r\nMIME-Version: 1.0";
			$header .= "\r\nContent-type: text/html; charset=iso-8859-1\r\n";
//			$body=str_replace("\n","<br>",$body);
		}
	 
// 	echo "--from:-$from----to:-$to---sub:-$subject----head:-$header----";
//	echo "<pre>$body</pre>";
//	 die();
	if( $sbrow_mail["sb_status"]=='yes')
 		mail($to,$subject,$body,$header);
  }
			header ("Location: profiles.php?msg=".urlencode("Comapny profile has been $sbmsg_part"));
			die();	
		}	
		else	
		{		
			header("Location: profiles.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();

?>