private static function load_option_types()
{
$query = 'get_option_types';
$result = DataSource::getInstance()->epp($query);
foreach ($result as $type) {
self::$types[$type['id']] = new ModelOptionType($type['id'], $type['units'], $type['countries']);
}
}
/**
* returns iterator for all land units
*
* @return ModelIterator
*/
public static function iterator()
{
$models = array();
$query = 'get_all_land_units';
// query units
$result = DataSource::Singleton()->epp($query);
foreach ($result as $unit) {
$id_unit = $unit['id'];
$models[] = self::getModelById($id_unit);
}
return new ModelIterator($models);
}
/**
* returns all startregions for the given set
*
* @param $id_set int
* @throws NullPointerException
* @return array(int id_opttype => array(int option_number => array(int id_area => ModelStartRegion)))
*/
public static function getRegionsForSet($id_set)
{
$id_set = intval($id_set);
if (isset(self::$regions[$id_set])) {
return self::$regions[$id_set];
}
$query = 'get_startregions_for_set';
$dict[':id_set'] = $id_set;
$result = DataSource::getInstance()->epp($query, $dict);
if (empty($result)) {
throw new NullPointerException('Set not found.');
}
foreach ($result as $region) {
self::$regions[$id_set][$region['id_optiontype']][$region['options']][$region['id_area']] = new ModelStartRegion($region['id'], $region['id_area'], $region['id_optiontype'], $region['id_set'], $region['options']);
}
return self::$regions[$id_set];
}
/**
* returns the specific model
*
* @param $players int
* @return ModelStartShips
* @throws NullPointerException
*/
public static function getStartShipsForPlayers($players)
{
$players = (int) $players;
if (isset(self::$models[$players])) {
return self::$models[$players];
}
// check if there is a game
$query = 'get_start_ships_for_players';
$dict = array(':players' => $players);
$result = DataSource::Singleton()->epp($query, $dict);
if (empty($result)) {
throw new NullPointerException('No startships for ' . $players . ' players found.');
}
$ships = array();
foreach ($result as $line) {
$ships[(int) $line['id_unit']] = (int) $line['numberof'];
}
return self::$models[$players] = new ModelStartShips($players, $ships);
}
/**
* returns an iterator for economy models
* @param $economy_type string/enum
* @param $random_order boolean - set true to get random order
* @throws DataSourceException
* @return ModelIterator
*/
public static function iterator($economy_type, $random_order = true)
{
$models = array();
$query = 'get_resource_allocation';
$dict = array();
$dict[':economy'] = $economy_type;
// query phases
$result = DataSource::Singleton()->epp($query, $dict);
foreach ($result as $alloc) {
$id_res = $alloc['id_resource'];
$res_pow = $alloc['res_power'];
$count = $alloc['count'];
for ($x = 0; $x < $count; $x++) {
$models[] = new ModelEconomy($id_res, $res_pow);
}
}
if ($random_order) {
shuffle($models);
}
return new ModelIterator($models);
}
private static function createModel($id_game, $id_zarea, $id_user, $id_unit)
{
SQLCommands::init($id_game);
$query = 'create_unit_for_zarea_user';
$dict = array();
$dict[':id_user'] = $id_user;
$dict[':id_zarea'] = $id_zarea;
$dict[':id_unit'] = $id_unit;
$dict[':count'] = 0;
DataSource::getInstance()->epp($query, $dict);
$id = DataSource::getInstance()->getLastInsertId();
self::$units[$id_game][$id_zarea][$id_user][$id_unit] = new ModelInGameLandUnit($id, $id_unit, $id_user, $id_zarea, 0, $id_game);
}
private function create_info($id_phase)
{
$query = 'set_new_game_phase_info';
$dict = array();
$dict[':id_user'] = $this->id_user;
$dict[':id_game'] = $this->id_game;
$dict[':id_phase'] = $id_phase;
if ($this->id_game === 0) {
$dict[':rule'] = true;
$dict[':is_ready'] = false;
} else {
$_Rule = ModelInGamePhaseInfo::getInGamePhaseInfo($this->id_user);
$dict[':rule'] = $_Rule->getNotificationRuleForPhase($id_phase);
$dict[':is_ready'] = $_Rule->getIsReadyForPhase($id_phase);
}
DataSource::getInstance()->epp($query, $dict);
$this->notification_rules[$id_phase] = $dict[':rule'];
$this->is_ready[$id_phase] = $dict[':is_ready'];
}
/**
* permenantly remove move (and corresponding ship) from database
*
* @param ModelSetShipsMove $move
* @throws NullPointerException
*/
public static function deleteSetShipsMove(ModelSetShipsMove $move)
{
$id_game = $move->getIdGame();
$id_move = $move->getId();
SQLCommands::init($id_game);
// 1. delete ship from DB
ModelInGameShip::deleteShip($id_game, $move->getIdZunit());
// 2. delete ship for move
$query = 'delete_units_for_move';
$dict = array();
$dict[':id_move'] = $id_move;
DataSource::Singleton()->epp($query, $dict);
// 3. delete areas for move
$query = 'delete_move_areas_for_move';
DataSource::Singleton()->epp($query, $dict);
// 4. delete move
$query = 'delete_move';
DataSource::Singleton()->epp($query, $dict);
unset(self::$moves[$id_game][$id_move]);
}
private function fill_member_vars()
{
// check if there is a game
$result = DataSource::Singleton()->epp('get_all_area_info', array(':id_area' => $this->id));
if (empty($result)) {
return false;
}
$data = $result[0];
$this->name = $data['name'];
$this->number = $data['number'];
$this->coords_small = $data['coords_small'];
$this->x = (int) $data['x'];
$this->y = (int) $data['y'];
$this->x2 = (int) $data['x2'];
$this->y2 = (int) $data['y2'];
$this->xres = (int) $data['xres'];
$this->yres = (int) $data['yres'];
$this->height = (int) $data['height'];
$this->width = (int) $data['width'];
$this->tanksize = (int) $data['tanksize'];
$this->id_type = (int) $data['id_type'];
$this->zone = (int) $data['zone'];
$this->economy = $data['economy'];
return true;
}
private function fill_member_vars()
{
// check if there is a game
$result = DataSource::Singleton()->epp('get_color', array(':id_color' => $this->id));
if (empty($result)) {
return false;
}
$data = $result[0];
$this->name = $data['name'];
$this->color = $data['color'];
return true;
}
public function run(array &$data)
{
$game = ModelGame::getCurrentGame();
$id_game = $game->getId();
SQLCommands::init($id_game);
// running game (or newly started but countries are already picked)
if ($game->getStatus() === GAME_STATUS_RUNNING || $game->getStatus() === GAME_STATUS_STARTED && $game->getIdPhase() === PHASE_SETSHIPS) {
$query = 'get_map_for_running_game';
} else {
if ($game->getStatus() === GAME_STATUS_STARTED && $game->getIdPhase() === PHASE_SELECTSTART) {
$query = 'get_map_for_new_game';
} else {
throw new MapException('invalid game selected: ' . $id_game);
}
}
$result = DataSource::getInstance()->epp($query);
$countryData = array();
foreach ($result as $country) {
// newly started game countries have to be picked -> no landunits/ships available
if (array_key_exists('countrySelectOption', $country)) {
$countryData[] = $country;
continue;
}
// running game (or newly started but countries are already picked)
// check landunits
$unitCount = 0;
$id_user = (int) $country['id_user'];
if ($id_user <= 0) {
$id_user = NEUTRAL_COUNTRY;
}
$units = ModelInGameLandUnit::getUnitsByIdZAreaUser($id_game, (int) $country['id'], $id_user);
$unitsViewData = array();
/* @var $unit ModelInGameLandUnit */
foreach ($units as $unit) {
$unitCount += $unit->getCount();
$landUnit = ModelLandUnit::getModelById($unit->getIdUnit());
$unitViewData = array('name' => $landUnit->getName(), 'count' => $unit->getCount());
$unitsViewData[] = $unitViewData;
}
if ($unitCount > 0) {
$country['units'] = $unitsViewData;
}
$country['unitCount'] = $unitCount;
// check ships
$shipCount = 0;
$shipViewData = array();
if ((int) $country['area_type'] === TYPE_LAND) {
$ships = ModelInGameShip::getShipsInPort($id_game, (int) $country['id_zarea']);
} else {
$ships = ModelInGameShip::getShipsInAreaNotInPort($id_game, (int) $country['id_zarea']);
}
while ($ships->hasNext()) {
/* @var $ship ModelInGameShip */
$ship = $ships->next();
$id_ship_owner = $ship->getIdUser();
if (!isset($shipViewData[$id_ship_owner])) {
$shipViewData[$id_ship_owner] = array('username' => ModelUser::getUser($id_ship_owner)->getLogin(), 'ships' => array());
}
$shipType = ModelShip::getModelById($ship->getIdUnit());
$currShipViewData = array('name' => $ship->getName(), 'type' => $shipType->getName(), 'diveStatus' => $ship->getDiveStatus(), 'experience' => $ship->getExperience());
if ((int) $country['area_type'] === TYPE_LAND) {
$portToArea = ModelGameArea::getGameArea($id_game, $ship->getIdZArea());
$currShipViewData['port'] = $portToArea->getName();
$currShipViewData['portNumber'] = $portToArea->getNumber();
}
$shipViewData[$id_ship_owner]['ships'][] = $currShipViewData;
++$shipCount;
}
if ($shipCount > 0) {
$country['ships'] = $shipViewData;
}
$country['shipCount'] = $shipCount;
$countryData[] = $country;
}
$data['countryData'] = $countryData;
return $data;
}
/**
* creates land move for user
*
* @param $id_user int
* @param $id_game int
* @param $round int
* @param $id_zarea int id_zarea
* @param $units array(int id_unit => count)
* @throws NullPointerException
* @throws ModelException
* @return ModelProductionMove
*/
public static function createProductionMove($id_user, $id_game, $round, $id_zarea, $units)
{
SQLCommands::init(intval($id_game));
// CREATE MOVE
$query = 'create_move';
$dict = array();
$dict[':id_user'] = intval($id_user);
$dict[':id_phase'] = PHASE_PRODUCTION;
$dict[':round'] = $round;
DataSource::Singleton()->epp($query, $dict);
$id_move = DataSource::getInstance()->getLastInsertId();
try {
// INSERT MOVE STEPS
ModelGameArea::getGameArea((int) $id_game, (int) $id_zarea);
$query = 'insert_area_for_move';
$dict = array();
$dict[':id_move'] = intval($id_move);
$dict[':step'] = intval(1);
$dict[':id_zarea'] = intval($id_zarea);
DataSource::Singleton()->epp($query, $dict);
// INSERT UNITS
foreach ($units as $id_unit => $count) {
ModelLandUnit::getModelById($id_unit);
$zUnit = ModelInGameLandUnit::getModelByIdZAreaUserUnit((int) $id_game, $id_zarea, (int) $id_user, (int) $id_unit);
$query = 'insert_land_units_for_move';
$dict = array();
$dict[':id_zunit'] = $zUnit->getId();
$dict[':id_move'] = intval($id_move);
$dict[':count'] = intval($count);
DataSource::Singleton()->epp($query, $dict);
}
} catch (ModelException $ex) {
self::flagMoveDeleted();
throw $ex;
} catch (NullPointerException $ex) {
self::flagMoveDeleted();
throw $ex;
}
return self::$moves[$id_game][$id_move] = new ModelProductionMove((int) $id_user, (int) $id_game, PHASE_PRODUCTION, (int) $id_move, (int) $round, false, $id_zarea, $units);
}
private function fill_member_vars()
{
$result = DataSource::Singleton()->epp('get_all_user_data', array(':id_user' => $this->id));
if (empty($result)) {
return false;
}
$data = $result[0];
$this->given_name = $data['name'];
$this->last_name = $data['lastname'];
$this->login = $data['login'];
$this->email = $data['email'];
$this->status = $data['status'];
$this->verify = $data['verify'];
$this->token = $data['token'];
return true;
}
/**
* @param int $id_zarea_in_port
* @throws ModelException
*/
public function setIdZareaInPort($id_zarea_in_port = null)
{
if ($id_zarea_in_port !== null) {
$id_zarea_in_port = intval($id_zarea_in_port);
$port_zarea = ModelGameArea::getGameArea($this->id_game, $id_zarea_in_port);
$sea_zarea = ModelGameArea::getGameArea($this->id_game, $this->id_zarea);
if (!in_array($port_zarea->getIdArea(), $sea_zarea->getAdjecents())) {
throw new ModelException('Invalid port -> not adjacent to current area.');
}
}
SQLCommands::init($this->id_game);
$query = 'set_ship_in_port';
$dict = array(':id_zunit' => $this->id, ':id_zarea_in_port' => $id_zarea_in_port);
DataSource::getInstance()->epp($query, $dict);
$this->id_zarea_in_port = $id_zarea_in_port;
}
/**
* flag move as deleted
* @return void
*/
public function flagMoveDeleted()
{
SQLCommands::init(intval($this->id_game));
$query = 'flag_move_deleted';
$dict = array(':id_move' => $this->id);
DataSource::getInstance()->epp($query, $dict);
$this->deleted = true;
}
/**
* updates selected areas if necessary
*
* @param $option_number int
* @param $zareas array(int id_zarea)
* @return void
*/
public function setRegions($option_number, $zareas)
{
$option_number = intval($option_number);
// check if areas are already set
if (isset($this->regions[$option_number])) {
$found_all = true;
foreach ($zareas as $id_zarea) {
if (!in_array($id_zarea, $this->regions[$option_number])) {
$found_all = false;
}
}
if ($found_all) {
return;
}
}
$dict = array();
$dict[':id_move'] = $this->id;
$dict[':step'] = $option_number;
if (isset($this->regions[$option_number])) {
unset($this->regions[$option_number]);
$query = 'delete_move_areas_for_step';
DataSource::Singleton()->epp($query, $dict);
}
// insert areas
$query = 'insert_area_for_move';
foreach ($zareas as $id_zarea) {
$dict[':id_zarea'] = $id_zarea;
DataSource::getInstance()->epp($query, $dict);
}
$this->regions[$option_number] = $zareas;
}
/**
* creates land move for user
*
* @param $id_user int
* @param $id_game int
* @param $round int
* @param $steps array(int step_nr => int id_zarea) -> step_nr counting from 1 to x
* @param $units array(int id_unit => count)
* @throws NullPointerException
* @throws ModelException
* @return ModelLandMove
*/
public static function createLandMove($id_user, $id_game, $round, $steps, $units)
{
SQLCommands::init(intval($id_game));
// CREATE MOVE
$query = 'create_move';
$dict = array();
$dict[':id_user'] = intval($id_user);
$dict[':id_phase'] = PHASE_LANDMOVE;
$dict[':round'] = $round;
DataSource::Singleton()->epp($query, $dict);
$id_move = DataSource::getInstance()->getLastInsertId();
try {
// INSERT MOVE STEPS
$x = 0;
foreach ($steps as $step => $id_zarea) {
++$x;
ModelGameArea::getGameArea((int) $id_game, (int) $id_zarea);
if (!isset($steps[$x])) {
throw new ModelException('Cannot create landmove, steps not consistent.');
}
$query = 'insert_area_for_move';
$dict = array();
$dict[':id_move'] = intval($id_move);
$dict[':step'] = intval($step);
$dict[':id_zarea'] = intval($id_zarea);
DataSource::Singleton()->epp($query, $dict);
}
$id_zarea_start = (int) $steps[1];
// INSERT UNITS
foreach ($units as $id_unit => $count) {
ModelLandUnit::getModelById($id_unit);
$zUnit = ModelInGameLandUnit::getModelByIdZAreaUserUnit((int) $id_game, $id_zarea_start, (int) $id_user, (int) $id_unit);
$query = 'insert_land_units_for_move';
$dict = array();
$dict[':id_zunit'] = $zUnit->getId();
$dict[':id_move'] = intval($id_move);
$dict[':count'] = intval($count);
DataSource::Singleton()->epp($query, $dict);
}
} catch (ModelException $ex) {
self::flagMoveDeleted();
throw $ex;
} catch (NullPointerException $ex) {
self::flagMoveDeleted();
throw $ex;
}
return self::$moves[$id_game][$id_move] = new ModelLandMove((int) $id_user, (int) $id_game, PHASE_LANDMOVE, (int) $id_move, (int) $round, false, $steps, $units);
}
private function nextRound()
{
++$this->round;
$query = 'set_game_round';
$dict = array();
$dict[':id_game'] = $this->id;
$dict[':round'] = $this->round;
DataSource::getInstance()->epp($query, $dict);
}
private function fill_member_vars()
{
SQLCommands::init($this->id_game);
// check if there is a game
$result = DataSource::Singleton()->epp('get_all_zarea_info', array(':id_zarea' => $this->id));
if (empty($result)) {
return false;
}
$data = $result[0];
$this->tank = (int) $data['tank'];
$this->id_user = (int) $data['id_user'];
$this->id_area = (int) $data['id_area'];
$this->id_resource = (int) $data['id_resource'];
$this->productivity = (int) $data['productivity'];
return true;
}
private function fill_member_vars()
{
// check if there is a game
$result = DataSource::Singleton()->epp('get_phase_info', array(':id_phase' => $this->id));
if (empty($result)) {
return false;
}
$data = $result[0];
$this->name = $data['name'];
$this->label = $data['label'];
$this->id_type = $data['id_type'];
return true;
}
protected function rollback()
{
// something went wrong, rollback
DataSource::getInstance()->rollBack();
}
private function fill_member_vars()
{
$query = 'get_iig_info_for_user_in_game';
$dict = array();
$dict[':id_user'] = $this->id_user;
$dict[':id_game'] = $this->id_game;
$result = DataSource::getInstance()->epp($query, $dict);
if (empty($result)) {
throw new NullPointerException('User is not in this game!');
}
$data = $result[0];
$this->id_color = $data['id_color'];
$this->money = $data['money'];
$this->id_set = $data['id_set'];
}
