public function getUserInventoryRecord($uid) { $result = parent::execQuery("with t as (select * from aspid_user_inventory where uid = ?) select s.*, t.* from aspid_inventory_items s full outer join t on t.item_id = s.id order by item_group_id, item_name ", array($uid)); return $result; }
public function getGroupMembersOrdered($id) { $query = "select * from aspid_users s, aspid_ranks a where a.id = s.rank_id and group_id = ? and s.nickname is not null and s.nickname <> '' and s.is_active = 1 order by a.hier_level, s.uid"; return parent::execQuery($query, array($id)); }
public function getPersonalInfo($uid) { $query = "with t as (select * from aspid_personal_info where uid = ?) select s.*, t.* from personal_info_type s full outer join t on t.type_id = s.id order by id"; return parent::execQuery($query, array($uid)); }