function DelFreeFile($userid, $username) { global $empire, $dbtbpre; //操作权限 CheckLevel($userid, $username, $classid, "file"); //清理信息附件 DelFileAllTable("cjid<>0 and (id=0 or cjid=id)"); //会员附件 DelFileOtherTable("cjid<>0 and (id=0 or cjid=id)", "member"); //其他附件 DelFileOtherTable("cjid<>0 and (id=0 or cjid=id)", "other"); //操作日志 insert_dolog(""); printerror("DelFreeFileSuccess", $_SERVER['HTTP_REFERER']); }
function DelAd($adid, $userid, $username) { global $empire, $time, $public_r, $dbtbpre; $adid = (int) $adid; if (!$adid) { printerror("NotDelAdid", "history.go(-1)"); } //验证权限 CheckLevel($userid, $username, $classid, "ad"); $r = $empire->fetch1("select title from {$dbtbpre}enewsad where adid='{$adid}'"); $sql = $empire->query("delete from {$dbtbpre}enewsad where adid='{$adid}'"); $file = "../../../d/js/acmsd/" . $public_r[adfile] . $adid . ".js"; DelFiletext($file); //删除附件 DelFileOtherTable("modtype=3 and id='{$adid}'"); if ($sql) { //操作日志 insert_dolog("adid=" . $adid . "<br>title=" . $r[title]); printerror("DelAdSuccess", "ListAd.php?time={$time}" . hReturnEcmsHashStrHref2(0)); } else { printerror("DbError", "history.go(-1)"); } }
function DelClass1($classid) { global $empire, $class_r, $dbtbpre; $r = $empire->fetch1("select * from {$dbtbpre}enewsclass where classid='{$classid}'"); //外部栏目 if ($r[wburl]) { $sql = $empire->query("delete from {$dbtbpre}enewsclass where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclassadd where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclass_stats where classid='{$classid}'"); //删除栏目附件 DelFileOtherTable("modtype=1 and id='{$classid}'"); //删除缓存 DelListEnews(); return ""; } //删除终极栏目 if ($r[islast]) { //删除主表信息 $indexsql = $empire->query("delete from {$dbtbpre}ecms_" . $r[tbname] . "_index where classid='{$classid}'"); $sql = $empire->query("delete from {$dbtbpre}ecms_" . $r[tbname] . " where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}ecms_" . $r[tbname] . "_check where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}ecms_" . $r[tbname] . "_doc where classid='{$classid}'"); //删除副表信息 DelAllDataTbInfo($r['tbname'], "classid='{$classid}'", 1, 1); //删除存文本文件 DelInfoSaveTxtfile($r['modid'], $r['tbname'], "classid='{$classid}'"); //删除信息附加表与附件 DelMoreInfoOtherData($classid, 0, 0); $filepath = "../../data/" . $r[classpath]; $delf = DelPath($filepath); DelFileOtherTable("modtype=1 and id='{$classid}'"); //删除栏目本身 $sql1 = $empire->query("delete from {$dbtbpre}enewsclass where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclassadd where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclass_stats where classid='{$classid}'"); $delpath = "../../" . $r[classpath]; $del = DelPath($delpath); //更新大栏目的子栏目 $where = ReturnClass($r[featherclass]); if (empty($where)) { $where = "classid=0"; } $bsql = $empire->query("select sonclass,classid from {$dbtbpre}enewsclass where " . $where); while ($br = $empire->fetch($bsql)) { $newsonclass = str_replace("|" . $classid . "|", "|", $br[sonclass]); $usql = $empire->query("update {$dbtbpre}enewsclass set sonclass='{$newsonclass}' where classid='{$br['classid']}'"); } } else { //删除栏目 $where = ReturnClass($r[sonclass]); if (empty($where)) { $where = "classid=0"; } $delcr = explode("|", $r[sonclass]); $count = count($delcr); for ($i = 1; $i < $count - 1; $i++) { $delcid = $delcr[$i]; //删除主表信息 $indexsql = $empire->query("delete from {$dbtbpre}ecms_" . $class_r[$delcid][tbname] . "_index where classid='{$delcid}'"); $sql = $empire->query("delete from {$dbtbpre}ecms_" . $class_r[$delcid][tbname] . " where classid='{$delcid}'"); $empire->query("delete from {$dbtbpre}ecms_" . $class_r[$delcid][tbname] . "_check where classid='{$delcid}'"); $empire->query("delete from {$dbtbpre}ecms_" . $class_r[$delcid][tbname] . "_doc where classid='{$delcid}'"); //删除副表信息 DelAllDataTbInfo($class_r[$delcid][tbname], "classid='{$delcid}'", 1, 1); //删除存文本文件 DelInfoSaveTxtfile($class_r[$delcid][modid], $class_r[$delcid][tbname], "classid='{$delcid}'"); //删除信息附加表与附件 DelMoreInfoOtherData($delcid, 0, 0); } //删除附件 $filepath = "../../data/" . $r[classpath]; $delf = DelPath($filepath); if ($where != 'classid=0') { DelFileOtherTable("modtype=1 and (" . str_replace('classid', 'id', $where) . ")"); } //删除子栏目副表 $fcsql = $empire->query("select classid from {$dbtbpre}enewsclass where featherclass like '%|" . $classid . "|%'"); while ($fcr = $empire->fetch($fcsql)) { $empire->query("delete from {$dbtbpre}enewsclassadd where classid='{$fcr['classid']}'"); $empire->query("delete from {$dbtbpre}enewsclass_stats where classid='{$fcr['classid']}'"); } //删除子栏目 $sql1 = $empire->query("delete from {$dbtbpre}enewsclass where featherclass like '%|" . $classid . "|%'"); //改变父栏目的子类 $where = ReturnClass($r[featherclass]); if (empty($where)) { $where = "classid=0"; } $bbsql = $empire->query("select classid,sonclass from {$dbtbpre}enewsclass where " . $where); while ($bbr = $empire->fetch($bbsql)) { $newsonclass = str_replace($r[sonclass], "|", $bbr[sonclass]); $usql = $empire->query("update {$dbtbpre}enewsclass set sonclass='{$newsonclass}' where classid='{$bbr['classid']}'"); } //删除栏目本身 $sql2 = $empire->query("delete from {$dbtbpre}enewsclass where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclassadd where classid='{$classid}'"); $empire->query("delete from {$dbtbpre}enewsclass_stats where classid='{$classid}'"); //删除栏目附件 DelFileOtherTable("modtype=1 and id='{$classid}'"); $delpath = "../../" . $r[classpath]; $del = DelPath($delpath); } //删除缓存 DelListEnews(); }
function DelSp($add, $userid, $username) { global $empire, $dbtbpre; $spid = (int) $add[spid]; if (!$spid) { printerror("NotDelSpid", "history.go(-1)"); } //验证权限 CheckLevel($userid, $username, $classid, "sp"); $r = $empire->fetch1("select spname,sptype,refile,spfile from {$dbtbpre}enewssp where spid='{$spid}'"); $sql = $empire->query("delete from {$dbtbpre}enewssp where spid='{$spid}'"); if ($r[sptype] == 1) { $empire->query("delete from {$dbtbpre}enewssp_1 where spid='{$spid}'"); } elseif ($r[sptype] == 2) { $empire->query("delete from {$dbtbpre}enewssp_2 where spid='{$spid}'"); } if ($r[sptype] == 3) { $empire->query("delete from {$dbtbpre}enewssp_3 where spid='{$spid}'"); $empire->query("delete from {$dbtbpre}enewssp_3_bak where spid='{$spid}'"); } //删除碎片文件 if ($r['refile']) { DelSpReFile($r['spfile']); } //删除附件 DelFileOtherTable("modtype=7 and id='{$spid}'"); if ($sql) { //操作日志 insert_dolog("spid=" . $spid . "<br>spname=" . $r[spname]); printerror("DelSpSuccess", "ListSp.php?cid={$add['fcid']}&fclassid={$add['fclassid']}&fsptype={$add['fsptype']}" . hReturnEcmsHashStrHref2(0)); } else { printerror("DbError", "history.go(-1)"); } }