delbiz.php

城市分类信息,门户网站,我做为地方信息网

<?php



if(!defined('IN_FLY')) {
	exit('Access Denied');
}

cpheader();


if ($do == 'yes') {
	
	$DB->query("DELETE FROM {$tablepre}bizboss WHERE bizid='$bizid' AND ischeck='1'");
	
	$DB->query("DELETE FROM {$tablepre}bizcard WHERE bizid='$bizid'");
	
	$DB->query("DELETE FROM {$tablepre}bizpoint WHERE bizid='$bizid'");
	
	$DB->query("DELETE FROM {$tablepre}bizuser WHERE bizid='$bizid'");
	
	
	//鍒犻櫎鐐硅瘎
	$query = $DB->query("SELECT * FROM {$tablepre}comment WHERE bizid='$bizid'");
	while ($rs = $DB->fetch_array($query)) {
		$DB->query("DELETE FROM {$tablepre}commentdp WHERE cmtid='$rs[cmtid]'");
	}
	$DB->query("DELETE FROM {$tablepre}comment WHERE bizid='$bizid'");
	
	
	//鍒犻櫎淇冮攢
	$query = $DB->query("SELECT * FROM {$tablepre}bizcoupon WHERE bizid='$bizid'");
	while ($rs = $DB->fetch_array($query)) {
		$rs['cpimg'] = FLY_ROOT . '/webdata/biz_coupon/' . $rs['cpimg'];
		
		if (file_exists($rs['cpimg'])) {
			@unlink($rs['cpimg']);
		}
		
		$DB->query("DELETE FROM {$tablepre}allcomment WHERE fid='$rs[cpid]' AND typeid='1'");
	}
	$DB->query("DELETE FROM {$tablepre}bizcoupon WHERE bizid='$bizid'");
	
	//鍒犻櫎鍟嗗搧
	$query = $DB->query("SELECT * FROM {$tablepre}bizproduct WHERE bizid='$bizid'");
	while ($rs = $DB->fetch_array($query)) {
		$rs['imgsrc'] = FLY_ROOT . '/webdata/biz_product/' . $rs['imgsrc'];
		
		if (file_exists($rs['imgsrc'])) {
			@unlink($rs['imgsrc']);
		}		
	}
	$DB->query("DELETE FROM {$tablepre}bizproduct WHERE bizid='$bizid'");
	
	//鍒犻櫎鍥剧墖
	$query = $DB->query("SELECT * FROM {$tablepre}bizphoto WHERE bizid='$bizid'");
	while ($rs = $DB->fetch_array($query)) {
		$rs['imgsrc'] = FLY_ROOT . '/webdata/biz_images/' . $rs['imgsrc'];
		
		$t = explode('.', $rs['imgsrc']);
		$rs['imgsrc_s'] =  $t[0] . '_s.' . $t[1];
			
		if (file_exists($rs['imgsrc'])) {
			@unlink($rs['imgsrc']);
		}		
		
		if (file_exists($rs['imgsrc_s'])) {
			@unlink($rs['imgsrc_s']);
		}			
	}	
	$DB->query("DELETE FROM {$tablepre}bizphoto WHERE bizid='$bizid'");
	
	$DB->query("DELETE FROM {$tablepre}bizinfo WHERE bizid='$bizid'");
	$DB->query("DELETE FROM {$tablepre}bizinfomore WHERE bmid='$bizid'");
	 
	cpmsg('鍒犻櫎鎴愬姛', 'admincp.php?action=biz_list');
}

cpmsg('璇ユ搷浣滀細鍒犻櫎璺熸