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