protected function initSQL($stmt, $values, $create = false) { $stmt->addColumnValue("id_target", intval($values["id_target"])); $stmt->addColumnValue("enabled", $values["source_enabled"]); $stmt->addColumnValue("name", $values["source_name"]); $stmt->addColumnValue("name_sort", strtolower(remove_leading_empty_words(remove_accents($values["source_name"])))); $stmt->addColumnValue("country", $values["source_country"]); $stmt->addColumnValue("language", $values["source_language"]); $stmt->addColumnValueDate("updatetime"); $stmt->addColumnValue("collection", $this->normalizeTagsCollections($values["source_collection"])); $stmt->addColumnValue("tag", $this->normalizeTagsCollections($values["source_tag"])); $stmt->addColumnValue("crawl_minimal_period", $values["crawl_minimal_period"]); if ($create) { $stmt->addColumnValue("crawl_priority", "2"); } // Remove Param element $stmt->addColumnValue('language_detection_list', $values["source_language_detection_list"]); $stmt->addColumnValue('crawl_maxdepth', $values["source_crawl_max_depth"]); $stmt->addColumnValue('crawl_url_concurrency', $values["source_crawl_url_concurrency"]); $stmt->addColumnValue('crawl_url_per_minute', $values["source_crawl_url_per_minute"]); $stmt->addColumnValue('automatic_cleaning', $values["source_automatic_cleaning"]); // crawl_schedule $schedules = new SimpleXMLElement($values["source_schedule_xml"]); $stmt->addColumnValue('crawl_schedule', $schedules->asXML()); // crawl_filtering_rules $rules = new SimpleXMLElement($values["source_crawl_filtering_rules_xml"]); $stmt->addColumnValue('crawl_filtering_rules', $rules->asXML()); $stmt->addColumnValue('metadata', $values["source_metadata"]); $stmt->addColumnValue('contact', $values["source_contact"]); $stmt->addColumnValue('comment', $values["source_comment"]); return $stmt; }
if (!update_field($name, $import_update_fields)) { continue; } if (!in_array($name, $ignore)) { $d = (string) $data; if (empty(trim($d)) && in_array($name, $xml_items)) { $x = $data->children(); $d = $x[0]->asXML(); $stmt->addColumnValue($name, $d); } else { $d = (string) $data; if ($name == 'params') { $stmt->addColumnValue($name, base64_decode($d)); } else { if ($name == 'name') { $stmt->addColumnValue('name_sort', strtolower(remove_leading_empty_words(remove_accents($d)))); } $stmt->addColumnValue($name, $d); } } } } if ($mode == 'insert' && !$stmt->checkNotNull($mg_source_not_null)) { $arr = array('status' => 'error'); //echo json_encode($arr); //exit(); } else { $rs = $stmt->execute(); } } }