/**
* read the object information from the db
*/
private function load($id)
{
$db = new DB();
$sql = "SELECT pa.idgame, pa.action, pa.params, pa.idtable, pa.idplayer, UNIX_TIMESTAMP(pa.timestamp) AS timestamp\n FROM poker_actions AS pa \n WHERE pa.idaction = '{$id}'";
$result = $db->query($sql);
if ($result->length() > 0) {
// general information
$this->info = array("action" => $result->action, 'params' => unserialize($result->params), 'player' => $result->idplayer != '' && $result->idplayer != 0 ? PokerPlayer::getInstance($result->idplayer) : false, 'game' => Poker::getInstance($result->idgame), 'table' => PokerTable::getInstance($result->idtable), 'time' => $result->timestamp);
$this->id = $id;
return true;
}
return false;
}
/**
* read the object information from the db
*/
private function load($id)
{
$db = new DB();
$sql = "SELECT pt.idgame, pt.title, pp.idplayer, pt.d, pt.sb, pt.bb, pt.seats, pt.blind, pt.iduser, pt.idspot\n FROM poker_tables AS pt\n LEFT JOIN poker_players AS pp ON (pp.idtable = pt.idtable AND pp.pactive = 1)\n WHERE pt.idtable = '{$id}'\n ORDER BY pp.position";
$result = $db->query($sql);
if ($result->length() > 0) {
$players = array();
if ($result->idplayer != '') {
$prev = false;
do {
$player = PokerPlayer::getInstance($result->idplayer);
$player->prev = $prev;
if (is_object($prev)) {
$prev->next = $player;
}
$players[$player->position] = $player;
$prev = $player;
} while ($result->next());
$first = reset($players);
$first->prev = $prev;
$prev->next = $first;
}
// general information
$this->info = array("game" => $result->idgame != 0 && $result->idgame != '' ? Poker::getInstance($result->idgame) : FALSE, "spot" => $result->idspot != 0 && $result->idspot != '' ? PokerSpot::getInstance($result->idspot) : FALSE, 'title' => $result->title, 'players' => $players, 'positions' => array('smallblind' => $result->sb, 'bigblind' => $result->bb, 'dealer' => $result->d), 'blinds' => array('big' => 2 * $result->blind, 'small' => $result->blind), 'seats' => $result->seats, 'user' => $result->iduser);
$this->info['free'] = $this->info['seats'] - count($this->info['players']);
$this->id = $id;
return true;
}
return false;
}
/**
* Build site content depending on requested action.
*/
protected function buildSite()
{
switch ($this->s->action) {
case 'debug':
$range = '99+, AQs+, 74s-73s, Th6h, Tc6c, Qh5h, 9s5s, 9c5c, Qh4h, 9d4d, 9h4h, 8s4s, 8c4c, 8d3d, 8h3h, Kc2c, 4d2d, 4s2s, AQo+, Ad4s, Ah4s, As4d, As4h, As4c, Ac4s, Ad3c, Ah3c, As3c, Ac3d, Ac3h, Ac3s, Ad2h, Ad2s, Ad2c, Ah2d, As2d, Ac2d, Jd7s, Jh7s, Js7d, Js7h, 9d6s, 9h6s, 9s6d, 9s6h, 8d6c, 8h6d, 8s6h, 8c6d, 7h5d, 7h5c, 7s5c, 7c5s, 6d5s, 6h5s, 6s5d, 6c5d';
$content = '<h2>' . $range . '</h2>';
$range = explode(',', $range);
$objDeck = new PokerDeck();
$objDeck->shuffle();
$range = new PokerRange($range, $objDeck);
$cards = $range->getRandomPair();
$content .= '<p>Expanded: ' . implode(', ', $range->range) . '</p>';
$content .= '<p>Pairs: ' . implode(', ', $range->pairs) . '</p>';
$content .= '<p>Cards: ' . $cards[0]->shortname() . ' / ' . $cards[1]->shortname() . '</p>';
parent::buildSite($content);
break;
case 'play':
$tpl = new Template('poker');
$tables = PokerTable::getAll();
foreach ($tables as $key => $table) {
$table->active = PokerPlayer::getActivePlayer($key) !== FALSE ? TRUE : FALSE;
$table->free = $table->seats - count($table->players);
}
if (count($tables) == 0) {
$content = '<h2>Keine Pokertische vorhanden. <a href="poker/poker_table-list">Pokertisch anlegen</a>?</h2>';
} else {
$tpl->assign('tables', $tables);
$tpl->assign('current', '');
//current($tables));
$content = $tpl->fetch('games.html');
}
parent::buildSite($content);
break;
case 'show':
if ($this->s->params[0] != '') {
$tpl = new Template('poker');
$tpl->assign('idtable', $this->s->params[0]);
$content = $tpl->fetch('game.html');
} else {
$content = 'Es wurde kein Pokertisch ausgewählt, der angezeigt werden könnte!';
}
parent::buildSite($content, true);
break;
case 'save':
if ($this->s->params[0] == 'table' && $this->s->params[2] != 0) {
$new_actions = PokerTable::getTableActions($this->s->params[2], $this->s->params[1]);
$actions = $this->getActionLog($new_actions);
} elseif (is_array($this->s->post['games'])) {
$actions = array();
foreach ($this->s->post['games'] as $key => $idgame) {
$game = Poker::getInstance($idgame);
$actions = array_merge($actions, $this->getActionLog($game->actions));
}
}
if (is_array($actions)) {
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: text/plain; charset=utf-8");
header("Content-Description: File Transfer");
header("Content-Disposition: attachment; filename=poker_log.txt");
header("Content-Transfer-Encoding: binary");
foreach ($actions as $key => $value) {
echo $value . "\r\n";
}
}
break;
case 'archive':
if ($this->s->params[0] == '') {
$table = FALSE;
$content = '<h2>Spiele für ' . $this->s->user->realname . '</h2><h3>Um die Liste der Spiele auf einem bestimmten Tisch anzuzeigen, wähle „Spiele anzeigen“ in der <a href="poker/poker_table-list">Liste der Tische</a> aus.</h3>';
} else {
$table = PokerTable::getInstance($this->s->params[0]);
$content = '<h2>Spiele am Tisch „' . $table->title . '“.</h2>';
}
$content .= $this->listGames($table);
parent::buildSite($content);
break;
}
}
