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
}
