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; }
$env['basepath'] = __DIR__; // DEFINE SLIM-ERROR HANDLING $app->error(function (\Exception $e) use($app, $logger) { $logger->error($e->getMessage()); $data = array(); HeaderViewHelper::parseCurrentUser($data); $app->render('error.twig', $data); }); $app->notFound(function () use($app) { $data = array(); HeaderViewHelper::parseCurrentUser($data); $app->render('404.twig', $data); }); // INIT DB-CONNECTION try { Model\DataBase\SQLCommands::init(); } catch (Exceptions\DataSourceException $e) { $logger->fatal($e->getMessage()); $app->render('error.twig'); die; } // DEFINE GET ROUTES include_once __DIR__ . DIRECTORY_SEPARATOR . 'php' . DIRECTORY_SEPARATOR . 'routes' . DIRECTORY_SEPARATOR . 'get.php'; // DEFINE POST ROUTES include_once __DIR__ . DIRECTORY_SEPARATOR . 'php' . DIRECTORY_SEPARATOR . 'routes' . DIRECTORY_SEPARATOR . 'post.php'; // DEFINE CONTENT ROUTES include_once __DIR__ . DIRECTORY_SEPARATOR . 'php' . DIRECTORY_SEPARATOR . 'routes' . DIRECTORY_SEPARATOR . 'content.php'; // SET GLOBAL VARS $app->view->setData(array('debug' => $debug, 'nomerge' => $nomerge, 'absRefPrefix' => ABS_REF_PREFIX)); Tools\CheckSessions::checkCookies(); Tools\CheckSessions::checkCurrentGame();
/** * creates the start move for user, and returns the id of the new move * * @param $id_game int * @param $id_user int * @return int */ private static function createSelectStartMove($id_user, $id_game) { SQLCommands::init(intval($id_game)); $query = 'create_move'; $dict = array(); $dict[':id_user'] = intval($id_user); $dict[':id_phase'] = PHASE_SELECTSTART; $dict[':round'] = 0; DataSource::Singleton()->epp($query, $dict); $id_move = DataSource::getInstance()->getLastInsertId(); return (int) $id_move; }
/** * 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 static function setGameSpecificQueries($id_game) { SQLCommands::init($id_game); }
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); }
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); }
/** * @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; }
/** * 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]); }