$rulesFids['enter_link'] = intval($newArray['enter']['enter_link']);
$rulesFids['enter_title'] = intval($newArray['enter']['enter_title']);
$rulesFids['enter_body'] = intval($newArray['enter']['enter_body']);
$rulesFids['enter_body_page'] = intval($newArray['page']['page_enter_page']);
$rulesFids['enter_body_page_link'] = intval($newArray['page']['page_enter_next']);
$rulesFids['enter_author'] = intval($newArray['enter']['enter_author']);
$rulesFids['enter_from'] = intval($newArray['enter']['enter_from']);
$rulesFids['enter_intro'] = intval($newArray['enter']['enter_intro']);
$rulesFids['link_num'] = 0;
$rulesFids['import_num'] = 0;
$rulesFids['date'] = strtotime(date('Y-m-d'));
$rulesFids['body_page_type'] = intval($newArray['page']['page_type']);
$sql = $NBS->add($rulesFids);
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$db->query($sql);
$NBS->setTable(TB_FILTER);
$ruleID = $db->lastid();
if ($newArray['filter_list']['filter']) {
if ($newArray['filter_list']['filter'][0]) {
foreach ($newArray['filter_list']['filter'] as $val) {
$tmpFilterFids['filter_multi'] = intval($val['filter_multi']);
$tmpFilterFids['filter_enter'] = intval($val['filter_enter']);
$tmpFilterFids['filter_rule'] = addslashes(encodestring($val['filter_area']));
$tmpFilterFids['filter_name'] = addslashes($val['filter_name']);
$tmpFilterFids['rule_id'] = $ruleID;
$sql = $NBS->add($tmpFilterFids);
$db->query($sql);
}
} else {
$tmpFilterFids['filter_multi'] = intval($newArray['filter_list']['filter']['filter_multi']);
$tmpFilterFids['filter_enter'] = intval($newArray['filter_list']['filter']['filter_enter']);
$rs = $NDB->query($sql);
if (!$rs->next_record()) {
error('没找到您要清空的采集器');
}
$tp->set_templatefile('templates/rules_clear.html');
$tp->assign('id', $rs->get('id'));
$tp->assign('ruleName', $rs->get('name'));
$tp->assign('cateName', $rs->get('cateName'));
$tp->assign('linkNum', $rs->get('link_num'));
$tp->assign('importNum', $rs->get('import_num'));
$moduleTemplate = $tp->result();
$moduleTitle = '清空采集器数据';
} else {
$NBS = new NEATBulidSql(TB_LINKS);
if ($_POST['link']) {
$NBS->setTable(TB_LINKS);
$linkFids['rules'] = $_GET['ID'];
$sql = $NBS->del($linkFids);
$NDB->query($sql);
$NBS->setTable(TB_RULES);
$conditionFids['id'] = $_GET['ID'];
$rulesFids['link_num'] = 0;
$sql = $NBS->update($rulesFids, $conditionFids);
$NDB->update($sql);
}
if ($_POST['data']) {
$NBS->setTable(TB_DATA);
$dataFids['rules'] = $_GET['ID'];
$sql = $NBS->del($dataFids);
$NDB->query($sql);
$NBS->setTable(TB_RULES);
}
if (!is_numeric($_GET['ID'])) {
error('采集器编号只能是数字!');
}
$sql = 'SELECT * ';
$sql .= 'FROM ' . TB_RULES . ' ';
$sql .= 'WHERE id = ' . $_GET['ID'];
$db = new MySQL(DB_SERVER, DB_USER, DB_PASSWORD, DB_DATABASE);
$rs = $db->query($sql);
if (!$rs->next_record()) {
error('找不到编号为' . $_GET['ID'] . '的采集器规则!');
}
$NBS = new NEATBulidSql(TB_RULES);
$rulesFids['id'] = $_GET['ID'];
$sql = $NBS->del($rulesFids);
$db->query($sql);
$NBS->setTable(TB_FILTER);
$filterFids['rule_id'] = $_GET['ID'];
$sql = $NBS->del($filterFids);
$db->query($sql);
$NBS->setTable(TB_LINKS);
$linksFids['rules'] = $_GET['ID'];
$sql = $NBS->del($linksFids);
$db->query($sql);
$NBS->setTable(TB_DATA);
$dataFids['rules'] = $_GET['ID'];
$sql = $NBS->del($dataFids);
$db->query($sql);
$db->disconnect();
showloading('?module=listRules', '删除成功', '编号为 ' . $_GET['ID'] . ' 的采集器删除成功,现在返回采集器列表.');
$tpShowBody = false;
}
++$i;
}
if ($checkSqlCondition) {
$checkSqlCondition = 'WHERE ' . $checkSqlCondition;
}
$checkSql .= $checkSqlCondition;
if ($tableKey == 0 and $filtrate) {
$rs_check = $TDB->Execute($checkSql);
if ($rs_check) {
$rsNum = $rs_check->RecordCount();
$rs_check->Close();
}
}
if ($rsNum == 0) {
$NBS->setTable($tableName);
$sql = $NBS->add($importData);
$TDB->Execute($sql);
if ($dbAllList['handle'][$tableName]['get']) {
$rsNewRow = array();
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$rsNew = $TDB->Execute($checkSql);
if ($rsNew) {
$rsNewRow = $rsNew->fields;
$rsNew->Close();
}
foreach ($dbAllList['handle'][$tableName]['get'] as $getValue) {
$putArray[$getValue['targetTable']][$getValue['targetField']] = $rsNewRow[$getValue['field']];
}
continue;
}
