function sitOnTable()
{
global $db;
if (!isset($this->hand_players[$this->request['request_position']])) {
$hp_id = 0;
$sql = " SELECT * FROM holdem_hand_palyer WHERE player_id='" . $this->request['request_player_id'] . "' ";
$pro = $db->mysqlFetchRow($sql);
if ($pro) {
if (intval($pro['table_id']) == 0) {
$hp_id = $pro['id'];
} else {
$this->setLastError("You are already playing on some table");
return;
}
}
$sql = " SELECT SUM(points) pts FROM points WHERE mid='" . $this->request['request_player_id'] . "' ";
$ro = $db->mysqlFetchRow($sql);
if (intval($ro['pts']) < $this->initial_stake) {
$this->setLastError("You do not have sufficient balance to play on this table");
return;
}
$sql = " SELECT * FROM members WHERE id='" . $this->request['request_player_id'] . "' ";
$ro = $db->mysqlFetchRow($sql);
if (!$ro) {
$this->setLastError("User not found. Please login and try again");
return;
}
$p = new pokerHoldemPlayer($this->request['table_id'], $this->request['request_player_id']);
$p->id = $hp_id;
$p->current_state = P_STATE_NEW;
$p->table_position = $this->request['request_position'];
$p->nick_name = $this->request['nick_name'];
$p->table_stack = $this->request['table_stack'];
if (intval($p->table_stack) == 0) {
$p->table_stack = $this->initial_stake;
}
if ($p->nick_name == "") {
$p->nick_name = $ro['First_Name'];
}
$p->last_request_time = time();
$p->savePlayer();
$this->hand_players[$this->request['request_position']] = $p;
$mp = array();
$mp['mid'] = $p->player_id;
$mp['edate'] = date("YmdHis");
$mp['points'] = 0 - $p->table_stack;
$mp['game'] = "T";
$db->mysqlAddUpdateRow('points ', $mp);
} else {
$p = $this->hand_players[$this->request['request_position']];
if ($this->request['request_player_id'] == $p->player_id && $p->current_state == P_STATE_SITTING_OUT) {
$p->current_state = P_STATE_NEW;
$p->savePlayer();
}
}
}
