public function getAgentsByCity($cityID) { $query = 'SELECT id FROM game.agent WHERE city=' . $cityID; $this->db->setQuery($query); $this->db->query(); return $this->db->loadObjectList(); }
/** * @return array */ private function getAllDeadClans() { $clans = []; $query = "SELECT id FROM clan WHERE population=0;"; $this->db->setQuery($query); $queryObj = $this->db->loadObjectList(); foreach ($queryObj as $k => $v) { $id = $v->id; $clan = new Clan($id); $clan->setDb($this->db); $clan->load(); $clans[] = $clan; } return $clans; }
/** @return Array */ public function getAllClanIDs() { $query = 'SELECT id FROM clan;'; $this->db->setQuery($query); $this->db->query(); $loadObj = $this->db->loadObjectList(); $clans = []; foreach ($loadObj as $obj) { $clan = new Clan($obj->id); $clan->setDb($this->db); $clan->load(); $clans[] = $clan; } return $clans; }
/** * @param Mapzone $mz * @return Array|TradegoodToken */ public function searchZoneForTradegoodTokens(Mapzone $mz) { $tokens = []; $query = 'SELECT id FROM tradegoodtoken WHERE mapzone=' . $mz->getId() . ';'; $this->db->setQuery($query); $this->db->query(); $loadObj = $this->db->loadObjectList(); foreach ($loadObj as $obj) { $tgt = new TradegoodToken($obj->id); $tgt->setDb($this->db); $tgt->load(); $tokens[] = $tgt; } return $tokens; }
/** * @param City $city * @return array */ public function getClansByCity(City $city) { $query = "SELECT * FROM game.clan WHERE city=" . $city->getId() . ';'; $this->db->setQuery($query); $this->db->query(); $objList = $this->db->loadObjectList(); $clans = null; foreach ($objList as $obj) { $clan = new Clan($obj->id); $clan->setDb($this->db); $clan->load(); $clans[] = $clan; } return $clans; }
/** * getAllTribes() * * Outputs an array of packaged Tribe objects representing all the tribes currently found in the db. * * @return array */ function getAllTribes() { $tribes = []; $query = "SELECT id FROM tribe;"; $this->db->setQuery($query); $objRows = $this->db->loadObjectList(); foreach ($objRows as $objRow) { $tribe = new Tribe($objRow->id); $tribe->setDb($this->db); $tribe->load(); array_push($tribes, $tribe); } return $tribes; }