public static Task <IEnumerable <ListedMember> > QueryMemberList(this IPKConnection conn, SystemId system, MemberListQueryOptions opts)
{
StringBuilder query = new StringBuilder("select * from member_list where system = @system");
if (opts.PrivacyFilter != null)
{
query.Append($" and member_visibility = {(int) opts.PrivacyFilter}");
}
if (opts.Search != null)
{
public static Task <IEnumerable <ListedMember> > QueryMemberList(this IPKConnection conn, SystemId system, MemberListQueryOptions opts)
{
StringBuilder query;
if (opts.GroupFilter == null)
{
query = new StringBuilder("select * from member_list where system = @system");
}
else
{
query = new StringBuilder("select member_list.* from group_members inner join member_list on member_list.id = group_members.member_id where group_id = @groupFilter");
}
if (opts.PrivacyFilter != null)
{
query.Append($" and member_visibility = {(int) opts.PrivacyFilter}");
}
if (opts.Search != null)
{
