public function getById($id = 0)
{
$query = $this->connection->query("SELECT " . allColumns("account") . " FROM " . table("account") . " WHERE " . column("account", "id") . " = ?", array($id));
if ($query->num_rows() > 0) {
$result = $query->result_array();
return $result[0];
} else {
return false;
}
}
/**
* Get the character stats that belongs to the character
*/
public function getStats()
{
$this->connect();
$query = $this->connection->query("SELECT " . allColumns("character_stats", $this->realmId) . " FROM " . table("character_stats", $this->realmId) . " WHERE " . column("character_stats", "guid", false, $this->realmId) . "= ?", array($this->id));
if ($query && $query->num_rows() > 0) {
$row = $query->result_array();
return $row[0];
} else {
return false;
}
}
function printAll($size)
{
global $sizes;
foreach (allColumns($size) as $k => $v) {
echo ".{$v} > div, .{$v} > .col1, .{$v} > .{$size}-col1 { width: " . 1 / $k * 100 . "%; }";
for ($i = 2; $i <= $k; $i++) {
echo ".{$v} > .col{$i}, .{$v} > .{$size}-col{$i} { width: " . 1 / $k * 100 * $i . "%; }";
}
echo ".{$size}-hidden { display: none!important; }";
echo ".{$size}-visible { display: inline-block; }";
}
}
/**
* Get a specific ticket
* @param Object $realm
* @param Int $ticketId
* @return Array
*/
public function getTicket($realm, $ticketId = false)
{
if ($ticketId && $realm) {
//Connect to the realm
$realm->getCharacters()->connect();
//Do the query
$query = $realm->getCharacters()->getConnection()->query("SELECT " . allColumns("gm_tickets", $realm->getId()) . " FROM " . table("gm_tickets", $realm->getId()) . " WHERE " . column("gm_tickets", "ticketId", false, $realm->getId()) . " = ?", array($ticketId));
if ($realm->getCharacters()->getConnection()->_error_message()) {
die($realm->getCharacters()->getConnection()->_error_message());
}
if ($query->num_rows() > 0) {
$result = $query->result_array();
return $result[0];
} else {
return false;
}
} else {
return false;
}
}
