cleanup.php

通达OA部分源代码

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

function main()
{

$config=mysql_fetch_array(mysql_query("select * from sbbleads_config where sb_id=1"));

?>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="10">
  <tr> 
    <td  valign="top"> 
      <?

$errcnt=0;
$showform="";
$msg="";
$selected=0;
if ( count($_POST)!=0 )
{
////////===================Delete Icons
if(isset($_REQUEST["deleteicons"]))
{
	$selected=1;
	$cnt=0;
	$dir = opendir("sbbleads_icons");
	while($item = readdir($dir))
	{
		$used=0;
		$icon_query=mysql_query("select * from sbbleads_icons");
		while ( $icon=mysql_fetch_array($icon_query))
		{
			//print_r($icon);die();
			
			for($i=2;$i<=18;$i++)
			{
				//echo $icon[$i]."==".$item."<br>";
				if ($icon[$i]==$item)
				{
				$used=1;
				}
			}
		}
///////////---------------
//USED IN site logo 
$sql1="select * from sbbleads_config where 1";
$rs_query=mysql_query($sql1);
while ( $rs=mysql_fetch_array($rs_query))
{
if ($rs["sb_logo"]==$item )
{
	$used=1;
}
}
/////////////-------------
		if ($used==0 && $item!="." && $item!=".."  )
		{
		//echo "-$item-";
		unlink("sbbleads_icons/".$item);
		$cnt++;
		}
	}// end while
	closedir($dir);
	$msg .= ($cnt==1)?"$cnt Icon":"$cnt Icons"; 
	$msg .= " Removed <br>";
}
///////////////-----------------
if (  isset( $_REQUEST["deleteimages"])  )
{
	$selected=1;

$cnt=0;
$dir = opendir("../uploadedimages");
while($item = readdir($dir)){
       //if(strchr($item,".")) continue;
$used=0;


//USED AS LOGO
$sql1="select sb_logo from sbbleads_companyprofiles where 1";
$rs_query=mysql_query($sql1);
while ( $rs=mysql_fetch_array($rs_query))
{
if ($rs["sb_logo"]==$item)
{
$used=1;
}
}
//USED IN SELL ADD
$sql1="select * from sbbleads_offer_images where 1";
$rs_query=mysql_query($sql1);
while ( $rs=mysql_fetch_array($rs_query))
{
if ($rs["sb_img_url"]==$item )
{
	$used=1;
}
}
//USED IN SELL ADD
$sql1="select * from sbbleads_product_images where 1";
$rs_query=mysql_query($sql1);
while ( $rs=mysql_fetch_array($rs_query))
{
if ($rs["sb_img_url"]==$item )
{
	$used=1;
}
}

if ( ($used==0) && ($item!=".") && ($item!="..") )
{
//echo "-$item-";
unlink("../uploadedimages/".$item);
$cnt++;
}
else
{
//echo "[[$item]]";

}

}
closedir($dir);

	$msg .= ($cnt==1)?"$cnt File":"$cnt Files"; 
	$msg .= " Removed <br>";

}
//////////////////////////////////////////////////////////////
//Delete All expired favorites///////////////////////////////
//////////////////////////////////////////////////////////////
if (  isset( $_REQUEST["deletefav"])  )
{
	$selected=1;
$sql1="select * from sbbleads_favorites where 1";
//echo $sql1;
$rs_query=mysql_query($sql1);
$to_delete="";
$items_removed=0;

while ( $rs=mysql_fetch_array($rs_query))
{
switch($rs["sb_type"])
{
/*
case 4:  //Company profile 					//		how can a comapny profile gets expired 
		$rs_t=mysql_query("select * from sbbleads_companyprofiles where mid=" . $rs["addid"] );
        if (!($rs_t=mysql_fetch_array($rs_t)))
		{
		if ($to_delete!="") { $to_delete.="," ; }  //To insert comma??
		$to_delete.= $rs["id"];  //Add another item to delete
		$items_removed++;
		}

		break;  
*/
/*
case 3:  //Product Catalog		//same here these are forever probably
		$rs_t=mysql_query("select * from b2b_selloffers where DATE_ADD(postedon,INTERVAL ".$config["sell_duration"]." MONTH)>=now() and id=" . $rs["addid"] );
        if (!($rs_t=mysql_fetch_array($rs_t)))
		{
		if ($to_delete!="") { $to_delete.="," ; }  //To insert comma??
		$to_delete.= $rs["id"];  //Add another item to delete
		$items_removed++;
		}

		break;  
*/
case "buy":  //buy 
		$rs_t=mysql_query("select * from sbbleads_offers_buy where DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_buy"]." MONTH)>=now() and sb_id=" . $rs["sb_offer_id"] );
        if (!($rs_t=mysql_fetch_array($rs_t)))
		{
		if ($to_delete!="") { $to_delete.="," ; }  //To insert comma??
		$to_delete.= $rs["sb_id"];  //Add another item to delete
		$items_removed++;
		}

		break;  

case "sell":  //sell 
		$rs_t=mysql_query("select * from sbbleads_offers where DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_sell"]." MONTH)>=now() and sb_id=" . $rs["sb_offer_id"] );
        if (!($rs_t=mysql_fetch_array($rs_t)))
		{
		if ($to_delete!="") { $to_delete.="," ; }  //To insert comma??
		$to_delete.= $rs["sb_id"];  //Add another item to delete
		$items_removed++;
		}

		break;  


}//End of Switch
}//End of while

if ($items_removed !=0)
{
$sql="delete from sbbleads_favorites where sb_id IN (" .$to_delete. ")";
//echo $sql; 
mysql_query($sql);
}

$msg .= ($items_removed==1)?"$items_removed Favorite":"$items_removed Favorites";
$msg .=" Removed <br>";

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

//////////////////////////////////////////////////////////////
/////////////////FAVORITES Deletion Done//////////////////////
//////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////
//////////////////Delete NoN Active Members//////////////////
/////////////////////////////////////////////////////////////

if (  isset( $_REQUEST["deleteoldusers"])  )
{
	$selected=1;
$items_removed =0;
/*				///what is this ??????????????
$sql1="select count(*) from sbbleads_members where DATE_ADD(postedon,INTERVAL ".$config["sell_duration"]." MONTH)<now() ";
$rs_query=mysql_query($sql1);
$rs=mysql_fetch_array($rs_query);
$items_removed =$rs[0];
*/
$sbq_mem="select * from sbbleads_members where DATE_ADD(sb_lastlogin,INTERVAL 90 DAY)<now() ";
//die($sql);
$sbrs_mem=mysql_query($sbq_mem);
$sbmem_id_list='-1';
while($sbrow_mem=mysql_fetch_array($sbrs_mem))
{
	$sbmem_id_list.=",".$sbrow_mem["sb_id"];
}
/////////////////---------------------deleteing all the belonings
$rs_query=mysql_query("select * from sbbleads_offers where sb_uid in ($sbmem_id_list)");
while($rst=mysql_fetch_array($rs_query))
{
mysql_query("delete from sbbleads_offer_cats where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_offer_images where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_favorites where sb_type='sell' and sb_offer_id=".$rst["sb_id"]);
}

$rs_query=mysql_query("select * from sbbleads_offers_buy where sb_uid in ($sbmem_id_list)");
while($rst=mysql_fetch_array($rs_query))
{
mysql_query("delete from sbbleads_offer_cats_buy where sb_offer_id=".$rst["sb_id"]);
//mysql_query("delete from sbbleads_offer_images where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_favorites where sb_type='buy' and sb_offer_id=".$rst["sb_id"]);
}

$rs_query=mysql_query("select * from sbbleads_products where sb_uid in ($sbmem_id_list)");
while($rst=mysql_fetch_array($rs_query))
{
mysql_query("delete from sbbleads_product_cats where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_product_images where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_favorites where sb_type='product' and sb_offer_id=".$rst["sb_id"]);
}

$rs_query=mysql_query("select * from sbbleads_companyprofiles where sb_uid in ($sbmem_id_list)");
while($rst=mysql_fetch_array($rs_query))
{
mysql_query("delete from sbbleads_profile_cats where sb_profile_id=".$rst["sb_id"]);
//mysql_query("delete from sbbleads_product_images where sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_favorites where sb_type='profile' and sb_offer_id=".$rst["sb_id"]);
mysql_query("delete from sbbleads_profile_markets where sb_profile_id=".$rst["sb_id"]);
}


mysql_query("update sbbleads_messages set sb_t_del='yes' where sb_tid in ($sbmem_id_list)");