} } while ($players->next()); unset($players); unset($reconciled); unset($reconcile); gc_enable(); gc_collect_cycles(); echo memory_get_usage(); set_time_limit(30); echo "<h2>Player Awards</h2>"; $awards->clear(); $awards->find(); $awardcount = 0; do { if (isset($player_map[$awards->mundanefk])) { $Player->AddAward(array('Token' => $Token, 'RecipientId' => $player_map[$awards->mundanefk], 'ParkId' => 0, 'KingdomId' => 0, 'EventId' => 0, 'KingdomAwardId' => $award_map[$awards->awardnamefk], 'Rank' => $awards->rank, 'Date' => $awards->date, 'GivenById' => 0, 'Note' => $awards->givenby)); $awardcount++; } if ($awardcount % 250 == 0) { set_time_limit(10); gc_enable(); gc_collect_cycles(); echo "{$awardcount} records processed ... " . memory_get_usage() . " ..."; } } while ($awards->next()); unset($awards); unset($Player); unset($mundanes); unset($parks); unset($personas); gc_enable();
function ImportAwards($number = 5) { set_time_limit(600); echo "<h2>Import Awards</h2>"; list($AID, $detail) = $this->LastStatus('awards'); $sql = "SELECT *\n FROM awards\n left join awardtypes on awards.awardID = awardtypes.awardID\n WHERE AID > {$AID} and playerID > 0 order by AID limit {$number}"; $awards = $this->ORK2->query($sql); $Player = new APIModel('Player'); echo $sql . "<p>"; $imported = 0; if ($awards->size() > 0) { do { list($tmp, $mundane_id) = $this->CacheMap('players', $awards->playerID); if ($mundane_id == 0) { continue; } $imported++; if ($imported % 10000) { set_time_limit(600); } $award = $Player->AddAward(array('Token' => $this->token, 'RecipientId' => $mundane_id, 'AwardId' => valid_id($awards->ork3_award_id) ? $awards->ork3_award_id : 94, 'Note' => $awards->given . '; ' . $awards->memo, 'Date' => $awards->date, 'CustomName' => $awards->award, 'Rank' => 0)); if ($date['Status'] == ServiceErrorIds::Success) { $this->RecordTransfer('awards', 'Player-Awards', $awards->AID, $award['Detail'], array($detail)); if ($imported % 500 == 0) { echo "A: {$awards->AID}, {$award['Detail']}; "; } } } while ($awards->next()); } echo "<h3>Import Awards Complete ({$imported})</h3>"; return $imported; }