public function GetKingdomAuthorizations($request) {
        $sql = "select authorization_id, username, a.mundane_id, role from ".DB_PREFIX."authorization a left join ".DB_PREFIX."mundane m on a.mundane_id = m.mundane_id where a.kingdom_id = '" . mysql_real_escape_string($request['KingdomId']) . "'";
        $r = $this->db->query($sql);
        $response = array();
        $response['Authorizations'] = array();