<?php //require_once(dirname(__FILE__)."./../include/config_base.php"); require_once(dirname(__FILE__)."./../member/config.php"); $dsql = new DedeSql(false); $areas = $sectors = $topsectors = $subsectors = array(); $dsql->setquery("select id, name, reid from #@__sectors order by disorder desc,id asc"); $dsql->Execute(); while($row = $dsql->GetArray()) { if($row['reid'] == 0){ $topsectors[] = $row; }else{ $subsectors[] = $row; } } foreach($topsectors as $topsector){ $sectors[] = $topsector; foreach($subsectors as $key => $subsector){ if($subsector['reid'] == $topsector['id']){ $sectors[] = $subsector; unset($subsectors[$key]); } } } //////////////////////地区数据处理s///////////////////////////// $sql = "select * from #@__area order by disorder asc,id asc"; $dsql->SetQuery($sql); $dsql->Execute();
} $dsql->SetQuery($q1); $dsql->Execute(); $rownum = $dsql->GetTotalRow(); if($rownum<2) continue; $i = 1; while($row = $dsql->GetObject()){ $i++; $naid = $row->ID; $ntitle = $row->title; if($i > $rownum){ continue; } $totalarc++; DelArc($naid); } } $dsql->executenonequery("OPTIMIZE TABLE `$maintable`"); $dsql->Close(); ShowMsg("一共删除了[{$totalarc}]篇重复的文档!","javascript:;"); exit(); } $channelinfos = array(); $dsql->setquery("select ID,typename,maintable,addtable from #@__channeltype"); $dsql->execute(); while($row = $dsql->getarray()) { $channelinfos[] = $row; } require_once(dirname(__FILE__)."/templets/article_test_same.htm"); ClearAllLink(); ?>
if(empty($areaid)) $areaid = 0; if(empty($areaid2)) $areaid2 = 0; if(!isset($sectorid)) $sectorid = 0; if(!isset($sectorid2)) $sectorid2 = 0; if(empty($page)) $page = 1; $areaid = intval($areaid); $areaid2 = intval($areaid2); $sectorid = intval($sectorid); $sectorid2 = intval($sectorid2); $page = intval($page); isset($comname) || $comname = ''; $comname = trim($comname); $allsectors = $areas = array(); $dsql->setquery("select id, name from #@__sectors order by disorder desc,id asc"); $dsql->Execute(); while($row = $dsql->getarray()) { $allsectors[$row['id']] = $row['name']; } //////////////////////地区数据处理s///////////////////////////// $sql = "select * from #@__area order by disorder desc,id asc"; $dsql->SetQuery($sql); $dsql->Execute(); $toparea = $subarea = array(); while($sector = $dsql->GetArray()) { $areas[$sector['id']] = $sector['name'];
<?php require_once(dirname(__FILE__)."/config.php"); require_once(dirname(__FILE__)."/../include/inc_typelink.php"); require_once(dirname(__FILE__)."/inc/inc_batchup.php"); CheckPurview('sys_ArcBatch'); @set_time_limit(0); $dsql = new DedeSql(false); if($action=='modddpic') { $query = "select ID,maintable from #@__channeltype"; $dsql->setquery($query); $dsql->execute(); $channels = array(); while($row = $dsql->getarray()) { $channels[$row['ID']] = $row['maintable']; } $query = "select aid, litpic,channelid from #@__full_search where litpic<>''"; $dsql->setquery($query); $dsql->execute('litpic'); while($row = $dsql->getarray('litpic')) { if(!preg_match("/^http:\/\//i",$row['litpic'])){ if(!file_exists($row['litpic'])){ $query = "update #@__full_search set litpic='' where aid=".$row['aid']." limit 1"; $dsql->executenonequery($query); $maintable = $channels[$row['channelid']]; $query = "update ".$maintable." set litpic='' where aid=".$row['aid']." limit 1"; $dsql->executenonequery($query); } }