cleanup.php

通达OA部分源代码

mysql_query("delete from sbbleads_messages where sb_fid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_messages where sb_f_del='yes' && sb_t_del='yes'");
mysql_query("delete from sbbleads_contacts where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_blocked where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_blocked_countries where sb_uid in ($sbmem_id_list)");

mysql_query("delete from sbbleads_offers where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_offers_buy where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_products where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_companyprofiles where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_search_results where sb_uid in ($sbmem_id_list)");
mysql_query("delete from sbbleads_favorites where sb_uid in ($sbmem_id_list)");
//////////------added by micx
mysql_query("delete from sbbleads_fav_cats where mid in ($sbmem_id_list)");
///////---------------------
 //////////////----------------------------------------------------
//$sql="delete from sbbleads_members where DATE_ADD(sb_lastlogin,INTERVAL 90 DAY)<now() ";
//die($sql);
//mysql_query($sql);
mysql_query("delete from sbbleads_members where sb_id in ($sbmem_id_list)");
	
	$cnt=mysql_affected_rows();
	$msg .= ($cnt==1)?"$cnt Member":"$cnt Members"; 
	$msg .= " Removed <br>";

//$msg.= mysql_affected_rows() . " Members Removed <br>";
}// End if...Members to delete?


////////////////////////////////////////////////////////////////
/////////////////NON ACTIVE Member Deletion Done///////////////
///////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////
//Mail NoN Active OLD Members///////////////////////////////////////
////////////////////////////////////////////////////////////////////

if (  isset( $_REQUEST["mailold"])  )
{
	$selected=1;

$items_removed =0;
$to_mail="";
$sql1="select * from sbbleads_members where  DATE_ADD(sb_lastlogin,INTERVAL 60 DAY)<now() ";
$rs_query=mysql_query($sql1);
while ( $rs=mysql_fetch_array($rs_query))
{
		if ($to_mail!="") { $to_mail.="," ; }  //To insert comma??
		$to_mail.= $rs["sb_email"];  //Add another item to delete
///////////////////////////////////////////////////////////////////////
///////////////////////////// SEND EMAIL //////////////////////////////
$link="";
$sql = "SELECT * FROM sbbleads_mails where sb_mailid=26";
$rs_query1=mysql_query($sql);

if ( $rs1=mysql_fetch_array($rs_query1)  )
  {
			 $from =$rs1["sb_fromid"];

			 $to = $rs["sb_email"];

			 $subject =$rs1["sb_subject"];

		     $header="From:" . $from . "\r\n" ."Reply-To:". $from  ;

		 	 $body=str_replace("%link%", $link,str_replace("%email%", $rs["sb_email"],str_replace("%password%",  $rs["sb_password"],str_replace("%lname%", $rs["sb_lastname"],str_replace("%fname%", $rs["sb_firstname"],str_replace("%username%", $rs["sb_username"], $rs1["sb_mail"]) ))))); 

	 	if( isset($rs1["sb_html_format"]) && ($rs1["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);
		}

	if( $rs1["sb_status"]=='yes')
		 mail($to,$subject,$body,$header);

//echo "<p align=\"left\">";
//echo nl2br("To: $to <br>From: $from <br>Subject: $subject <br>Body: $body");
//echo "</p>";

}
//////////////////////////////// CONFIRMATION SENT//////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////

		$items_removed++;
}
//echo $to_mail;
	$msg.= "Mail Sent to ";
	$msg .= ($items_removed==1)?"$items_removed Member<br>":"$items_removed Members<br>"; 
//	$msg .= " Removed <br>";

//$msg.= "Mail Sent to " .$items_removed . " Members <br>";
}// End if...Members to Mail?


///////////////////////////////////////////////////////////////////////////////////////
/////////////////Mail NON ACTIVE Member Done///////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////

//////////////////////////////////////////////////////////////
//////////////////Delete Expired ADDS ///////////////////////
/////////////////////////////////////////////////////////////

if (  isset( $_REQUEST["deleteexpiredadds"])  )
{
	$selected=1;

//$items_removed =0;
/*			why ???????????
$sql1="select count(*) from sbbleads_offers where  DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_sell"]+3." MONTH)<now()";
$rs_query=mysql_query($sql1);
$rs=mysql_fetch_array($rs_query);
$items_removed =$rs[0];
*/
$sbduration=$config["sb_expiry_sell"]+3;
$sbq1_off="select * from  sbbleads_offers where  DATE_ADD(sb_postedon,INTERVAL ".$sbduration." MONTH)<now()";
$sbrs1_off=mysql_query($sbq1_off);
$sboffer_id_list='-1';
while($sbrow1_off=mysql_fetch_array($sbrs1_off))
{
	$sboffer_id_list.=",".$sbrow1_off["sb_id"];
}

	mysql_query("delete from sbbleads_offer_cats where sb_offer_id in ($sboffer_id_list)");
	mysql_query("delete from sbbleads_offer_images where sb_offer_id in ($sboffer_id_list)");
	mysql_query("delete from sbbleads_favorites where sb_type='sell' and sb_offer_id in ($sboffer_id_list)");

$sql="delete from  sbbleads_offers where sb_id in ($sboffer_id_list)";
mysql_query($sql);
	$items_removed=mysql_affected_rows();
	$msg .= ($items_removed==1)?"$items_removed Sell Offer":"$items_removed Sell Offers"; 
	$msg .= " Removed <br>";

//$msg.= mysql_affected_rows() . " Sell Offers Removed <br>";


/*$items_removed =0;
$sql1="select count(*) from b2b_buyoffers where  DATE_ADD(postedon,INTERVAL ".$config["buy_duration"]." MONTH)<now() ";
$rs_query=mysql_query($sql1);
$rs=mysql_fetch_array($rs_query);
$items_removed =$rs[0];
*/
$sbduration=$config["sb_expiry_buy"]+3;
$sbq1_off="select * from  sbbleads_offers_buy where  DATE_ADD(sb_postedon,INTERVAL ".$sbduration." MONTH)<now()";
$sbrs1_off=mysql_query($sbq1_off);
$sboffer_id_list='-1';
while($sbrow1_off=mysql_fetch_array($sbrs1_off))
{
	$sboffer_id_list.=",".$sbrow1_off["sb_id"];
}

	mysql_query("delete from sbbleads_offer_cats_buy where sb_offer_id in ($sboffer_id_list)");
//	mysql_query("delete from sbbleads_offer_images where sb_offer_id in ($sboffer_id_list)");
	mysql_query("delete from sbbleads_favorites where sb_type='buy' and sb_offer_id in ($sboffer_id_list)");

$sql="delete from  sbbleads_offers_buy where sb_id in ($sboffer_id_list)";
mysql_query($sql);

	$items_removed=mysql_affected_rows();
	$msg .= ($items_removed==1)?"$items_removed Buy Offer":"$items_removed Buy Offers"; 
	$msg .= " Removed <br>";


//$msg.= mysql_affected_rows() . " Sell buy Removed <br>";

}// End if...Members to delete?


////////////////////////////////////////////////////////////////
/////////////////EXPIRED ADS Deletion Done ////////////////////
///////////////////////////////////////////////////////////////


///////================================
} //IF form was posted

if  (count($_POST)<>0)
{
?>
      <font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif"> 
      <?php if($selected<>0)
	  {
	  ?>
      Cleanup has been completed<br>
      <?
	  }
	  else
	  { 
	  	echo "Please select the option.";
	  }
		if (isset($msg) )
		{
		echo $msg;
		}
		?>
      </font> 
      <?
}
?>
    </td>
  </tr>
  <tr> 
    <td height="25" bgcolor="#004080"><font color="#FFFFFF" size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;Cleanup</strong></font></td>
  </tr>
  <script language="JavaScript">
  function validate_form(frm)
  {
  	if(frm.deleteicons.checked==false && frm.deleteexpiredadds.checked==false && frm.deleteimages.checked==false && frm.mailold.checked==false && frm.deleteoldusers.checked==false && frm.deletefav.checked==false)
	{
		alert('Please select some option');
		frm.deleteicons.focus();
		return false;
	}
	return true;
  }
  </script>
  <form name="form1" method="post" action="cleanup.php" onSubmit="return validate_form(this);">
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"> <font size="2" face="Arial, Helvetica, sans-serif"> 
        <input name="deleteicons" type="checkbox" id="deleteicons" value="Yes">
        Remove all unused icons. </font> </td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="deleteexpiredadds" value="Yes">
        Delete offers that have expired 3 months ago and not relisted. </font></td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="deleteimages" value="Yes">
        Delete any images not being used offers/product catalogs/company profiles. 
        </font></td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="mailold" value="Yes">
        Send email to members that have not logged for last 2 months</font></td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="deleteoldusers" value="Yes">
        Delete members that have not logged in for last 3 months</font></td>
    </tr>
    <tr> 
      <td valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="deletefav" value="Yes">
        Delete expired favorites from all member accounts. </font></td>
    </tr>
    <!--<tr> 
      <td align="left" valign="top" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif"> 
        <input name="deleteicons" type="checkbox" id="deleteexp" value="Yes">
        Delete all icons not being used in the site. </font></td>
    </tr>-->
    <tr> 
      <td align="right" valign="top" bgcolor="#F5F5F5"><div align="left"> 
          <p><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">This 
            operation is non reversible. Once removed, information can't be retrieved.<br>
            </font><font size="2" face="Arial, Helvetica, sans-serif"><br>
            <input type="submit" name="Submit2" value="Start the Cleanup">
            </font></p>
        </div></td>
    </tr>
  </form>
</table>
<?
}  //End of main
include_once("template.php");
?>