$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); // CHECK TO SEE IF USER IS SUBSCRIBED TO GROUP AND UPDATE VIEW TIME if ($database->database_num_rows($database->database_query("SELECT NULL FROM se_groupsubscribes WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}' LIMIT 1")) == 1) { $is_subscribed = 1; $database->database_query("UPDATE se_groupsubscribes SET groupsubscribe_time='" . time() . "' WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$user->user_info['user_id']}'"); } else { $is_subscribed = 0; } // GET TOTAL DISCUSSION TOPICS $total_topics = $group->group_topic_total(); // MAKE TOPIC PAGES AND GET TOPIC ARRAY $topics_per_page = 10; if ($v == "discussions") { $p_topics = $p; } else { $p_topics = 1; } $page_vars_topics = make_page($total_topics, $topics_per_page, $p_topics); $topics = $group->group_topic_list($page_vars_topics[0], $topics_per_page, "grouptopic_sticky DESC, grouppost_date DESC"); //$topics = $group->group_topic_list($page_vars_topics[0], $topics_per_page, "grouptopic_sticky DESC, grouptopic_date DESC"); // GET CUSTOM GROUP STYLE IF ALLOWED if ($group->groupowner_level_info['level_group_style'] && !$is_group_private) { $groupstyle_info = $database->database_fetch_assoc($database->database_query("SELECT groupstyle_css FROM se_groupstyles WHERE groupstyle_group_id='{$group->group_info['group_id']}' LIMIT 1")); $global_css = $groupstyle_info['groupstyle_css']; }