send_alerts.php

通达OA部分源代码

<?php
function send_mail_alerts()
{
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
if(($config["sb_image_magik"]=="enable"))
{
$img_path="thumbs1/";
$img_pmt="";
}
else
{
$img_path="uploadedimages/";
$img_pmt="width=".$config["sb_th_width"]." height=".$config["sb_th_width"];
}

$mem_q=mysql_query("select * from sbbleads_members where sb_suspended<>'yes'");
while($mem=mysql_fetch_array($mem_q))
{
//-----------------------------------------sell cids
$group_q=mysql_query("select * from sbbleads_fav_cats where mid=".$mem["sb_id"]." and sb_type='sell'");
$sell_cid="-1";
while($group=mysql_fetch_array($group_q))
{
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid=".$group["cid"] );
$clist=$group["cid"];
while ( $rst=mysql_fetch_array($rst_query) )
{
	$clist.="," . $rst["sb_id"];
	$thislist="-1," . $rst["sb_id"];
	while ( $rst=mysql_fetch_array($rst_query) )
	{ 
		$clist.="," . $rst["sb_id"];
		$thislist.="," . $rst["sb_id"];
		//echo $rst["sbcat_id"];
	}
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid in (" . $thislist . ")" );
}// end of collecting childeren
$sell_cid.=",".$clist;
}
//---------------------------------------------buy cids
$group_q=mysql_query("select * from sbbleads_fav_cats where mid=".$mem["sb_id"]." and sb_type='buy'");
$buy_cid="-1";
while($group=mysql_fetch_array($group_q))
{
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid=".$group["cid"] );
$clist=$group["cid"];
while ( $rst=mysql_fetch_array($rst_query) )
{
	$clist.="," . $rst["sb_id"];
	$thislist="-1," . $rst["sb_id"];
	while ( $rst=mysql_fetch_array($rst_query) )
	{ 
		$clist.="," . $rst["sb_id"];
		$thislist.="," . $rst["sb_id"];
		//echo $rst["sbcat_id"];
	}
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid in (" . $thislist . ")" );
}// end of collecting childeren
$buy_cid.=",".$clist;
}
//--------------------------------------------------products cids
$group_q=mysql_query("select * from sbbleads_fav_cats where mid=".$mem["sb_id"]." and sb_type='product'");
$product_cid="-1";
while($group=mysql_fetch_array($group_q))
{
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid=".$group["cid"] );
$clist=$group["cid"];
while ( $rst=mysql_fetch_array($rst_query) )
{
	$clist.="," . $rst["sb_id"];
	$thislist="-1," . $rst["sb_id"];
	while ( $rst=mysql_fetch_array($rst_query) )
	{ 
		$clist.="," . $rst["sb_id"];
		$thislist.="," . $rst["sb_id"];
		//echo $rst["sbcat_id"];
	}
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid in (" . $thislist . ")" );
}// end of collecting childeren
$product_cid.=",".$clist;
}
//------------------------------------------------profile
$group_q=mysql_query("select * from sbbleads_fav_cats where mid=".$mem["sb_id"]." and sb_type='profile'");
$profile_cid="-1";
while($group=mysql_fetch_array($group_q))
{
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid=".$group["cid"] );
$clist=$group["cid"];
while ( $rst=mysql_fetch_array($rst_query) )
{
	$clist.="," . $rst["sb_id"];
	$thislist="-1," . $rst["sb_id"];
	while ( $rst=mysql_fetch_array($rst_query) )
	{ 
		$clist.="," . $rst["sb_id"];
		$thislist.="," . $rst["sb_id"];
		//echo $rst["sbcat_id"];
	}
$rst_query=mysql_query("Select * from sbbleads_categories where sb_pid in (" . $thislist . ")" );
}// end of collecting childeren
$profile_cid.=",".$clist;
}
////------------------------------------end of collecting cids
$sell_str="";
$buy_str="";
$profile_str="";
$product_str="";

$sell_cnt=0;
$buy_cnt=0;
$profile_cnt=0;
$product_cnt=0;

//----------------------------generating sell strings
		$off_sql="select sbbleads_offers.sb_id,sb_title from sbbleads_offers,
		sbbleads_offer_cats	where TO_DAYS(NOW())-TO_DAYS(sb_postedon)<=1 and 
		sb_approved='yes' and sbbleads_offers.sb_id=sbbleads_offer_cats.sb_offer_id ";
		$off_sql.=" and sb_cid in ($sell_cid) and sb_uid<>".$mem["sb_id"]." group by sbbleads_offers.sb_id";
		$off_q=mysql_query($off_sql);
		while($off=mysql_fetch_array($off_q))
		{
		 	$image_str="";
			$image=mysql_fetch_array(mysql_query("select * from sbbleads_offer_images 
			where sb_offer_id=".$off["sb_id"]));
			if($image)
			$image_str="<img src='".$config["sb_site_root"]."/$img_path".$image["sb_img_url"]."' border='0' hspace='5' align='absmiddle' $img_pmt>";
		 	$sell_cnt++; 
			$path=$config["sb_site_root"]."/"."view_offer.php?id=".$off["sb_id"];
			$sell_str.=$sell_cnt."$image_str <a href='".$path."'>".$off["sb_title"]."</a><br><br>";
		}//end off
//----------------------------generating buy strings
		$off_sql="select sbbleads_offers_buy.sb_id,sb_title from sbbleads_offers_buy,
		sbbleads_offer_cats_buy	where TO_DAYS(NOW())-TO_DAYS(sb_postedon)<=1 and 
		sb_approved='yes' and sbbleads_offers_buy.sb_id=sbbleads_offer_cats_buy.sb_offer_id ";
		$off_sql.=" and sb_cid in ($buy_cid) and sb_uid<>".$mem["sb_id"]." group by sbbleads_offers_buy.sb_id";
		$off_q=mysql_query($off_sql);
		while($off=mysql_fetch_array($off_q))
		{
		 	$buy_cnt++; 
			$path=$config["sb_site_root"]."/"."view_offer_buy.php?id=".$off["sb_id"];
			$buy_str.=$buy_cnt." <a href='".$path."'>".$off["sb_title"]."</a><br><br>";
		}//end off
//----------------------------generating product strings
		$off_sql="select sbbleads_products.sb_id,sb_title from sbbleads_products,
		sbbleads_product_cats where TO_DAYS(NOW())-TO_DAYS(sb_postedon)<=1 and 
		sb_approved='yes' and sbbleads_products.sb_id=sbbleads_product_cats.sb_offer_id ";
		$off_sql.=" and sb_cid in ($buy_cid) and sb_uid<>".$mem["sb_id"]." group by sbbleads_products.sb_id";
		$off_q=mysql_query($off_sql);
		while($off=mysql_fetch_array($off_q))
		{
		 	$image_str="";
			$image=mysql_fetch_array(mysql_query("select * from sbbleads_product_images 
			where sb_offer_id=".$off["sb_id"]));
			if($image)
			$image_str="<img src='".$config["sb_site_root"]."/$img_path".$image["sb_img_url"]."' border='0' hspace='5' align='absmiddle' $img_pmt>";
		 	$product_cnt++; 
			$path=$config["sb_site_root"]."/"."view_product.php?id=".$off["sb_id"];
			$product_str.=$product_cnt."$image_str  <a href='".$path."'>".$off["sb_title"]."</a><br><br>";
		}//end off

//****----------------------------generating profile strings
		$off_sql="select sbbleads_companyprofiles.sb_id,sb_companyname,sb_logo from sbbleads_companyprofiles,sbbleads_profile_cats where TO_DAYS(NOW())-TO_DAYS(sb_postedon)<=1 and 
		sb_approved='yes' and 
		sbbleads_companyprofiles.sb_id=sbbleads_profile_cats.sb_profile_id ";
		$off_sql.=" and sb_cid in ($profile_cid) and sb_uid<>".$mem["sb_id"]." group by sbbleads_companyprofiles.sb_id";
		$off_q=mysql_query($off_sql);
		while($off=mysql_fetch_array($off_q))
		{
		 	$image_str="";
			if($off["sb_logo"])
			$image_str="<img src='".$config["sb_site_root"]."/$img_path".$off["sb_logo"]."' border='0' hspace='5' align='absmiddle' $img_pmt>";
		 	$profile_cnt++; 
			$path=$config["sb_site_root"]."/"."view_profile.php?id=".$off["sb_id"];
			$profile_str.=$profile_cnt."$image_str <a href='".$path."'>".$off["sb_companyname"]."</a><br><br>";
		}//end off

$offer_str="";

if($sell_cnt<>0)
{
$offer_str.="Sell Offers Posted - $sell_cnt<br>$sell_str";
}
if($buy_cnt<>0)
{
$offer_str.="Buy Offers Posted - $buy_cnt<br>$buy_str";
}
if($product_cnt<>0)
{
$offer_str.="Products Posted - $product_cnt<br>$product_str";
}
if($profile_cnt<>0)
{
$offer_str.="Company Profiles Posted - $profile_cnt<br>$profile_str";
}
//echo $offer_str;
if($offer_str<>"")
{
	//sending mail to seeker
		$sb_null_char=$config["sb_null_char"];
		$email=$mem["sb_email"];
		$fname=$mem["sb_firstname"];
		$lname=$mem["sb_lastname"];
		$sql = "SELECT * FROM sbbleads_mails where sb_mailid=24";
		$rs_query=mysql_query($sql);

		if ( $rs=mysql_fetch_array($rs_query)  )
  		{
			 $from =$rs["sb_fromid"];
			 $to = $email;
			 $subject =$rs["sb_subject"];
		     $header="From:" . $from . "\r\n" ."Reply-To:". $from  ;

			 $body=str_replace("%email%", $sb_null_char,
			 str_replace("%password%",$sb_null_char, str_replace("%lname%", $lname,
			 str_replace("%fname%", $fname, str_replace("%username%",$sb_null_char, $rs["sb_mail"]))))); 
				
			 $body=str_replace("%signup_url%",$sb_null_char,str_replace("%login_url%",$sb_null_char,$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("%offer_str%",$offer_str,$body);
			if(isset($rs["sb_html_format"])&&($rs["sb_html_format"]=="yes"))
			{
				$header .= "\r\nMIME-Version: 1.0";
				$header .= "\r\nContent-type: text/html; charset=iso-8859-1\r\n";
			}
 
 //echo "--from:-$from----to:-$to---sub:-$subject----head:-$header----";
	 //echo "<pre>$body</pre>";	
	// die();
	if( $rs["sb_status"]=='yes')
	 	@mail($to,$subject,$body,$header);
  	}
	}
}// end members 
}//end function
?>