// GET GROUP FIELDS $groupcat_info = $database->database_fetch_assoc($database->database_query("SELECT t1.groupcat_id AS subcat_id, t1.groupcat_title AS subcat_title, t1.groupcat_dependency AS subcat_dependency, t2.groupcat_id AS cat_id, t2.groupcat_title AS cat_title FROM se_groupcats AS t1 LEFT JOIN se_groupcats AS t2 ON t1.groupcat_dependency=t2.groupcat_id WHERE t1.groupcat_id='{$group->group_info['group_groupcat_id']}'")); if ($groupcat_info['subcat_dependency'] == 0) { $cat_where = "groupcat_id='{$group->group_info['group_groupcat_id']}'"; } else { $cat_where = "groupcat_id='{$groupcat_info['subcat_dependency']}'"; } $field = new se_field("group", $group->groupvalue_info); $field->cat_list(0, 1, 0, $cat_where, "groupcat_id='0'", ""); // SET WHERE CLAUSE FOR MEMBER LIST $where[] = "(se_groupmembers.groupmember_status='1')"; if ($search != "") { $where[] = "(se_users.user_username LIKE '%{$search}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search}%' OR se_users.user_email LIKE '%{$search}%')"; } // GET TOTAL MEMBERS $total_members = $group->group_member_total(implode(" AND ", $where), 1); // MAKE MEMBER PAGES AND GET MEMBER ARRAY $members_per_page = 10; if ($v == "members") { $p_members = $p; } else { $p_members = 1; } $page_vars_members = make_page($total_members, $members_per_page, $p_members); $members = $group->group_member_list($page_vars_members[0], $members_per_page, "is_viewers_friend DESC, se_users.user_username", implode(" AND ", $where)); // GET MASTER TOTAL OF MEMBERS $total_members_all = $group->group_member_total("(se_groupmembers.groupmember_status='1')"); // GET OFFICERS $where_officers = "se_groupmembers.groupmember_rank<>'0' AND se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'"; $total_officers = $group->group_member_total($where_officers, 0); $officers = $group->group_member_list(0, $total_officers, "se_groupmembers.groupmember_rank DESC, se_users.user_username", $where_officers);
case "2": $where_clause[] = "se_groupmembers.groupmember_status='0' AND se_groupmembers.groupmember_approved='1'"; break; case "3": $where_clause[] = "se_groupmembers.groupmember_approved='0'"; break; default: $where_clause[] = "se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'"; break; } if ($search != "") { $where_clause[] = "(se_users.user_username LIKE '%{$search}%' OR se_users.user_email LIKE '%{$search}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search}%')"; } $where = implode(" AND ", $where_clause); // GET TOTAL MEMBERS $total_members = $group->group_member_total($where, 1); // MAKE MEMBER PAGES $members_per_page = 10; $page_vars = make_page($total_members, $members_per_page, $p); // GET MEMBER ARRAY $members = $group->group_member_list($page_vars[0], $members_per_page, $sort, $where); // ASSIGN VARIABLES AND SHOW USER EDIT GROUP MEMBERS PAGE $smarty->assign('group', $group); $smarty->assign('total_members', $total_members); $smarty->assign('members', $members); $smarty->assign('search', $search); $smarty->assign('s', $s); $smarty->assign('v', $v); $smarty->assign('p', $page_vars[1]); $smarty->assign('maxpage', $page_vars[2]); $smarty->assign('p_start', $page_vars[0] + 1);