$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";
}
}
$needtime = $this->GetNodeAttribute($element, 'rating', 'needtime') + 0;
$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();
