$subnode = $domnode->getElementsByTagName($element); if ($subnode->length < 1) { return ''; } else { return $subnode->item(0)->nodeValue; } } function GetNodeAttribute(&$domnode, $element, $attr) { $subnode = $domnode->getElementsByTagName($element); if ($subnode->length < 1) { return ''; } else { return $subnode->item(0)->getAttribute($attr); } } } $importcaches = new importCaches(); //$valid_ocnodes = array(1,/*2,3,6,*/7,8); // do not import caches from local oc server // Temporarily disable import from NO due to unknown problems on the other side. // This leaves import from DE only. $valid_ocnodes = array(1); // do not import caches from local oc server // iterate through all valid Opencaching nodes foreach ($valid_ocnodes as $valid_ocnode) { if ($importcaches->run($valid_ocnode) == false) { echo "Caches from opencaching." . $importcaches->getCountryFromNodeId($valid_ocnode) . " update FAILED.<br/>\n"; } else { //echo "Caches from opencaching.".$importcaches->getCountryFromNodeId($valid_ocnode)." updated SUCCESSFULLY.<br/>\n"; } }
$ocwaypoint = addslashes($this->GetNodeAttribute($element, 'waypoints', 'oc')); $gcwaypoint = addslashes($this->GetNodeAttribute($element, 'waypoints', 'gccom')); $ncwaypoint = addslashes($this->GetNodeAttribute($element, 'waypoints', 'nccom')); $datehidden = addslashes($this->GetNodeValue($element, 'datehidden')); $datecreated = addslashes($this->GetNodeValue($element, 'datecreated')); $lastmodified = addslashes($this->GetNodeValue($element, 'lastmodified')); echo $sql = "REPLACE INTO foreign_caches (cache_id, user_id, username, name, longitude, latitude, last_modified, date_created, type, status, country, date_hidden, desc_languages, size, difficulty, terrain, uuid, search_time, way_length, wp_gc, wp_nc, wp_oc, default_desclang, node) VALUES ({$id}, {$userid}, '{$username}', '{$name}', {$longitude}, {$latitude}, '{$lastmodified}', '{$datecreated}', {$typeid}, {$statusid}, '{$countryid}', '{$datehidden}', '{$desclanguages}', {$sizeid}, {$difficulty}, {$terrain}, '{$useruuid}', {$needtime}, {$waylength}, '{$gcwaypoint}', '{$ncwaypoint}', '{$ocwaypoint}', UCASE('" . $oc_country . "'), {$node_id});" . "<br />"; // mysql_query($sql); } function GetNodeValue(&$domnode, $element) { $subnode = $domnode->getElementsByTagName($element); if ($subnode->length < 1) { return ''; } else { return $subnode->item(0)->nodeValue; } } function GetNodeAttribute(&$domnode, $element, $attr) { $subnode = $domnode->getElementsByTagName($element); if ($subnode->length < 1) { return ''; } else { return $subnode->item(0)->getAttribute($attr); } } } $importcaches = new importCaches(); $importcaches->run();