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; } }