echo "<h2>Park Map</h2>";
$KingdomDetails = $kingdom->GetKingdomDetails(array('KingdomId' => $KingdomId));
$park = new APIModel('Park');
$parks->clear();
$park_map = array();
$parks->find();
do {
echo "<h3 style='display: inline-block; margin: auto 20px;'>{$parks->name}</h3>";
$parktitleid = $KingdomDetails['ParkTitles'][0]['ParkTitleId'];
foreach ($KingdomDetails['ParkTitles'] as $ParkTitle) {
if ($ParkTitle['Title'] == $parks->title) {
$parktitleid = $ParkTitle['ParkTitleId'];
}
}
if ($parks->local == 1 || true) {
$p = $park->CreatePark(array('Token' => $Token, 'Name' => $parks->name, 'Abbreviation' => $parks->abbreviation, 'KingdomId' => $KingdomId, 'ParkTitleId' => $parktitleid));
$park_map[$parks->parkpk] = $p['Detail'];
if ($parks->retired == 1) {
echo "Retire";
$r = $park->RetirePark(array('Token' => $Token, 'ParkId' => $park_map[$parks->parkpk]));
}
}
} while ($parks->next());
unset($parks);
pre_print_r($park_map);
echo "<h2>Award Init & Map</h2>";
/**
SELECT ifnull(concat("'", awardnames.awardname, "' => '", award.name, "'"), concat("'", awardnames.awardname, "' => ''")) FROM `orkrecords_wlimport`.`awardnames` awardnames left join `orkrecords_dev`.`orkdev_award` award on award.name like concat('%',awardnames.awardname) order by awardnames.awardnamepk
'Tsunami' => ''
function ImportKingdomParks($number = 20)
{
global $STATES;
echo "<h2>Import Kingdom Parks</h2>";
list($chapterID, $detail) = $this->LastStatus('chapters', array("69", "149", "161", "175", "176", "178", "240", "264", "297", "298", "299", "342", "344", "345"));
$sql = "select * from chapters where chapterID > {$chapterID} and (principID is null or principID = 0) and kingdomID != 14 order by chapterID limit {$number}";
$chapters = $this->ORK2->query($sql);
$Park = new APIModel('Park');
echo $sql . "<p>";
if ($chapters->size() > 0) {
do {
set_time_limit(120);
if ($chapters->kingdomID == 2) {
continue;
}
echo "Create Kingdom Park {$chapters->name}<br />";
list($tmp, $kingdom_id) = $this->CacheMap('kingdoms', $chapters->kingdomID);
$park = $Park->CreatePark(array('Token' => $this->token, 'Name' => $chapters->name, 'Abbreviation' => $chapters->abbre, 'KingdomId' => $kingdom_id, 'ParkTitleId' => 0));
$Park->SetParkDetails(array('Token' => $this->token, 'ParkId' => $park['Detail'], 'Heraldry' => '', 'HeraldryMimeType' => '', 'Url' => $chapters->URL, 'Address' => $chapters->ParkAddress, 'City' => $chapters->ParkCity, 'Province' => $STATES[$chapters->ParkStateID], 'PostalCode' => $chapters->ParkZip, 'MapUrl' => '', 'Directions' => str_replace("'", ""e;", str_replace("\n", "<br>", str_replace("\r", "", $chapters->ParkInfo))), 'GeoCode' => $chapters->GeoCode));
$this->RecordTransfer('chapters', 'Park', $chapters->chapterID, $park['Detail'], array());
} while ($chapters->next());
}
echo "<h3>Import Kingdom Parks Complete</h3>";
}
