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;
}
