delete_member.php

通达OA部分源代码

<?
include_once "logincheck.php";
include_once "myconnect.php";
$id=$_REQUEST["id"];

$rs_query=mysql_query("select * from sbbleads_offers where sb_uid=$id");
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=$id");
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=$id");
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=$id");
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 =".$id);
mysql_query("delete from sbbleads_messages where sb_fid =".$id);
mysql_query("delete from sbbleads_messages where sb_f_del='yes' && sb_t_del='yes'");
mysql_query("delete from sbbleads_contacts where sb_uid=$id");
mysql_query("delete from sbbleads_blocked where sb_uid=$id");
mysql_query("delete from sbbleads_blocked_countries where sb_uid=$id");

mysql_query("delete from sbbleads_offers where sb_uid=$id");
mysql_query("delete from sbbleads_offers_buy where sb_uid=$id");
mysql_query("delete from sbbleads_products where sb_uid=$id");
mysql_query("delete from sbbleads_companyprofiles where sb_uid=$id");
mysql_query("delete from sbbleads_favorites where sb_uid=$id");
mysql_query("delete from sbbleads_search_results where sb_uid=$id");
mysql_query("delete from sbbleads_members where sb_id=$id");
//////////------added by micx
mysql_query("delete from sbbleads_fav_cats where mid=$id");
///////---------------------
 
$msg=urlencode("Member has been deleted successfully");
header("Location:"."members.php?msg=$msg");
die();
?>