level_info['level_group_allow'] & 2 ) { /*header("Location: user_home.php"); exit();*/ } // INITIALIZE GROUP OBJECT $group = new se_group($user->user_info['user_id'], $group_id); if($group->group_exists == 0) { header("Location: user_group.php"); exit(); } if($group->user_rank == 0 || $group->user_rank == -1) { header("Location: user_group.php"); exit(); } // APPROVE MEMBERSHIP REQUEST if($task == "approve") { $member_query = $database->database_query("SELECT * FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_approved=0 AND groupmember_group_id='{$group->group_info['group_id']}'"); if( $database->database_num_rows($member_query) ) { $member_info = $database->database_fetch_assoc($member_query); $database->database_query("UPDATE se_groupmembers SET groupmember_status=1, groupmember_approved=1 WHERE groupmember_id='{$groupmember_id}' AND groupmember_group_id='{$group->group_info['group_id']}'"); $database->database_query("INSERT INTO se_groupsubscribes (groupsubscribe_group_id, groupsubscribe_user_id, groupsubscribe_time) VALUES ('{$group->group_info['group_id']}', '{$member_info['groupmember_user_id']}', '".time()."')"); $database->database_query("UPDATE se_groups SET group_totalmembers=group_totalmembers+1 WHERE group_id='{$group->group_info['group_id']}' LIMIT 1"); // $database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupmemberrequest' AND notify_object_id='{$member_info['groupmember_user_id']}' AND notify_urlvars='".serialize(Array('', $group->group_info['group_id']))."'"); $database->database_query("UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupmemberrequest' AND notify_object_id='{$member_info['groupmember_user_id']}' AND notify_urlvars='".serialize(Array('', $group->group_info['group_id']))."'"); } } // REJECT MEMBERSHIP REQUEST elseif($task == "reject") { $member_query = $database->database_query("SELECT * FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_approved=0 AND groupmember_group_id='{$group->group_info['group_id']}'"); if( $database->database_num_rows($member_query) ) { $member_info = $database->database_fetch_assoc($member_query); $database->database_query("DELETE FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_group_id='{$group->group_info['group_id']}'"); //$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupmemberrequest' AND notify_object_id='{$member_info['groupmember_user_id']}' AND notify_urlvars='".serialize(Array('', $group->group_info['group_id']))."'"); $database->database_query("UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$group->group_info['group_user_id']}' AND se_notifytypes.notifytype_name='groupmemberrequest' AND notify_object_id='{$member_info['groupmember_user_id']}' AND notify_urlvars='".serialize(Array('', $group->group_info['group_id']))."'"); } } // CANCEL INVITATION elseif($task == "cancel") { $member_query = $database->database_query("SELECT * FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_approved=1 AND groupmember_status=0 AND groupmember_group_id='{$group->group_info['group_id']}'"); if( $database->database_num_rows($member_query) ) { $member_info = $database->database_fetch_assoc($member_query); $database->database_query("DELETE FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_group_id='{$group->group_info['group_id']}'"); //$database->database_query("DELETE FROM se_notifys USING se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id WHERE se_notifys.notify_user_id='{$member_info['groupmember_user_id']}' AND se_notifytypes.notifytype_name='groupinvite' AND notify_object_id='{$group->group_info['group_id']}'"); $database->database_query("UPDATE se_notifys LEFT JOIN se_notifytypes ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id SET isread=1 WHERE se_notifys.notify_user_id='{$member_info['groupmember_user_id']}' AND se_notifytypes.notifytype_name='groupinvite' AND notify_object_id='{$group->group_info['group_id']}'"); } } // REMOVE MEMBER elseif($task == "remove") { $member_query = $database->database_query("SELECT * FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_approved=1 AND groupmember_status=1 AND groupmember_group_id='{$group->group_info['group_id']}'"); if($database->database_num_rows($member_query) == 1) { $groupmember = $database->database_fetch_assoc($member_query); if(($group->user_rank == 2 || $group->user_rank > $groupmember['groupmember_rank']) && $groupmember['groupmember_user_id'] != $user->user_info['user_id']) { $database->database_query("DELETE FROM se_groupmembers WHERE groupmember_id='{$groupmember_id}' AND groupmember_group_id='{$group->group_info['group_id']}'"); $database->database_query("UPDATE se_groups SET group_totalmembers=group_totalmembers-1 WHERE group_id='{$group->group_info['group_id']}' LIMIT 1"); $database->database_query("DELETE FROM se_groupsubscribes WHERE groupsubscribe_group_id='{$group->group_info['group_id']}' AND groupsubscribe_user_id='{$groupmember['groupmember_user_id']}'"); } } } // SET SORT VARIABLE FOR DATABASE QUERY if($s == "ud") { $sort = "se_users.user_dateupdated DESC"; } elseif($s == "ld") { $sort = "se_users.user_lastlogindate DESC"; } elseif($s == "t") { $sort = "se_groupmembers.groupmember_title"; } elseif($s == "r") { $sort = "se_groupmembers.groupmember_rank DESC"; } else { $sort = "se_users.user_dateupdated DESC"; } // SET WHERE CLAUSE $where_clause = Array(); switch($v) { case "1": $where_clause[] = "se_groupmembers.groupmember_rank<>'0' AND se_groupmembers.groupmember_status='1' AND se_groupmembers.groupmember_approved='1'"; break; 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 = 20; $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); for($x=$page_vars[1]; $x<=$page_vars[2]; $x++) { if(($page_vars[1]+20)==$x) {break;} $for[$y]=$x; $y++; } $smarty->assign('for', $for); // 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); $smarty->assign('p_end', $page_vars[0]+count($members)); include "footer.php"; ?>