public function get_players() { $players = array(); // Nume, posy, posx foreach (ModelDB::get_players($this->game->game_id()) as $row) { $players[$row['player_id']] = array($row['fullname'], $row['posx'], $row['posy'], $row['ch_id'], $row['vision']); } return $players; }
/** * Métodos que permiten interactuar a los modelos entre ellos. * ModelDB es un modelo que interactúa con la mayoría de modelos al ser el que trabaja sobre la base de datos. */ public function getModelDB() { if (!class_exists('ModelDB')) { require_once CORE_ROOT . MODELS . DIRECTORY_SEPARATOR . 'ModelDB.php'; } if (!is_object($this->db)) { $this->db = ModelDB::getInstance(); } }
public function get_go_pos($game_id) { // Get places vers $places_ver = ModelDB::get_places_ver($game_id); //$go = $this->_go_places(); $go_pos = array(); // TODO: Nu suporta versionarea parcelelor $go_pos[1] = array(array(4, 1), array(7, 0), array(8, 0), array(10, 0), array(12, 0)); $go_pos[2] = array(array(0, 13), array(0, 15), array(1, 14), array(2, 15), array(0, 17)); return $go_pos; }
<?php session_start(); // Includes include '../config.php'; require_once '../libraries/ModelDB.php'; if (!isset($_SESSION['game_id']) || !isset($_SESSION['user_id'])) { die("0"); } // Parse GET parameters $game_id = $_SESSION['game_id']; $user_id = $_SESSION['user_id']; $posx = (int) $_GET['posx']; $posy = (int) $_GET['posy']; // Working with Db ModelDB::init(); $player_id = ModelDB::get_player_id($game_id, $user_id); // Check if pos is free $free = ModelDB::pos_is_free($game_id, $posx, $posy); if ($free) { ModelDB::update_player_pos($player_id, $posx, $posy); echo '1'; } else { echo '0'; }
<div id="play_page"> <header> <ul class="players"> <?php $players_db = ModelDB::get_players($platform->game->game_id()); $teams = array(); foreach ($players_db as $row) { $teams[$row['team']][] = $row; } foreach ($teams as $team => $users) { ?> <li class=""> <ul class="profiles"> <!--<div class="mask slow"></div>--> <?php foreach ($users as $user) { ?> <li><div class="img ch<?php echo $user['ch_id']; ?> "></div></li> <?php } ?> <?php if (count($users) <= 1) { echo '<li><div class="img ch"></div></li>'; } ?> </ul> <ul id="spells-player-<?php
<?php session_start(); // Includes include '../config.php'; require_once '../libraries/ModelDB.php'; if (!isset($_SESSION['game_id']) || !isset($_SESSION['user_id'])) { die("0"); } // Parse GET parameters $game_id = (int) $_SESSION['game_id']; $user_id = (int) $_SESSION['user_id']; $spell_key = (string) $_GET['spell_key']; $time = (int) $_GET['time']; // Working with Db ModelDB::init(); $player_id = ModelDB::get_player_id($game_id, $user_id); $spell_id = ModelDB::get_spell_id($spell_key); ModelDB::add_spell($game_id, $player_id, $spell_id, $time);
public function get_map() { // Get map places version $places_ver = ModelDB::get_places_ver($this->game_id()); return $this->map->get_map($places_ver); }
<?php session_start(); // Includes include '../config.php'; require_once '../libraries/ModelDB.php'; if (!isset($_SESSION['game_id'])) { die("0"); } // Parse GET parameters $game_id = (int) $_SESSION['game_id']; // Working with Db ModelDB::init(); $players = ModelDB::get_players($game_id); $players_spells = ModelDB::get_players_spells($game_id); $prepare = array(); foreach ($players as $row) { $spells = isset($players_spells[$row['player_id']]) ? $players_spells[$row['player_id']] : array(); $prepare[] = array('player_id' => $row['player_id'], 'posx' => $row['posx'], 'posy' => $row['posy'], 'image' => $row['image'], 'vision' => $row['vision'], 'team' => $row['team'], 'fullname' => $row['fullname'], 'ch_id' => $row['ch_id'], 'finished' => $row['finished'], 'spells' => $spells); } echo json_encode($prepare);
public function save_player($game_id, $name, $character) { ModelDB::change_player($this->user_id(), $game_id, $name, $character); $this->save_player_in_sess($name, $character); }
public static function init() { ModelDB::$conn = new PDO('mysql:host=' . DB_SERVER . ';dbname=' . DB_DB . '', DB_USER, DB_PASS); }
<?php // Includes include '../config.php'; require_once '../libraries/ModelDB.php'; // Parse GET parameters $game_id = (int) $_GET['game_id']; // Working with Db ModelDB::init(); $players = ModelDB::get_players($game_id); $prepare = array(); foreach ($players as $row) { $prepare[] = array('player_id' => $row['player_id'], 'fullname' => $row['fullname'], 'chid' => $row['ch_id'], 'finished' => $row['finished']); } echo json_encode($prepare);
session_start(); // Includes include '../config.php'; require_once '../libraries/Platform.php'; if (!isset($_SESSION['game_id']) && !isset($_SESSION['user_id'])) { die("game_id or user_id key SESSION is not sets."); } // Init the platform instance $platform = new Platform(); // Parse GET parameters $posx = (int) $_GET['posx']; $posy = (int) $_GET['posy']; $game_id = $_SESSION['game_id']; $user_id = $_SESSION['user_id']; // Get start/finish pos $finish_pos = $platform->game->map->get_finish_pos($game_id); $finishx = $finish_pos[0]; $finishy = $finish_pos[1]; ModelDB::init(); $player_id = ModelDB::get_player_id($game_id, $user_id); if ($posx == $finishx && $posy == $finishy) { // Working with Db ModelDB::init(); ModelDB::update_player_pos($player_id, $posx, $posy); ModelDB::update_player_finished($player_id); echo 1; } else { echo 0; // #Error }