$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; }