database_num_rows($database->database_query("SELECT group_id FROM se_groups WHERE group_id='$group_id'")) ) { $group->group_delete($group_id); } } // SET USER GROUP SORT-BY VARIABLES FOR HEADING LINKS $i = "id"; // GROUP_ID $t = "t"; // GROUP_TITLE $o = "o"; // OWNER OF GROUP $m = "m"; // MEMBERS IN GROUP $d = "d"; // CREATION DATE OF GROUP // SET SORT VARIABLE FOR DATABASE QUERY if($s == "i") { $sort = "se_groups.group_id"; $i = "id"; } elseif($s == "id") { $sort = "se_groups.group_id DESC"; $i = "i"; } elseif($s == "t") { $sort = "se_groups.group_title"; $t = "td"; } elseif($s == "td") { $sort = "se_groups.group_title DESC"; $t = "t"; } elseif($s == "o") { $sort = "se_users.user_username"; $o = "od"; } elseif($s == "od") { $sort = "se_users.user_username DESC"; $o = "o"; } elseif($s == "m") { $sort = "num_members"; $m = "md"; } elseif($s == "md") { $sort = "num_members DESC"; $m = "m"; } elseif($s == "d") { $sort = "se_groups.group_datecreated"; $d = "dd"; } elseif($s == "dd") { $sort = "se_groups.group_datecreated DESC"; $d = "d"; } else { $sort = "se_groups.group_id DESC"; $i = "i"; } // ADD CRITERIA FOR FILTER $where_clause = Array(); if($f_owner != "") { $where_clause[] = "(se_users.user_username LIKE '%$f_owner%' OR se_users.user_fname LIKE '%$f_owner%' OR se_users.user_lname LIKE '%$f_owner%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%$f_owner%')"; } if($f_title != "") { $where_clause[] = "se_groups.group_title LIKE '%$f_title%'"; } if(count($where_clause) != 0) { $where = "(".implode(" AND ", $where_clause).")"; } // DELETE NECESSARY GROUPS $start = ($p - 1) * $groups_per_page; if($task == "delete") { $group->group_delete_selected($start, $groups_per_page, $sort, $where); } // GET TOTAL GROUPS $total_groups = $group->group_total($where, 1); // MAKE GROUP PAGES $page_vars = make_page($total_groups, $groups_per_page, $p); $page_array = Array(); for($x=0;$x<=$page_vars[2]-1;$x++) { if($x+1 == $page_vars[1]) { $link = "1"; } else { $link = "0"; } $page_array[$x] = Array('page' => $x+1, 'link' => $link); } // GET GROUP ARRAY $groups = $group->group_list($page_vars[0], $groups_per_page, $sort, $where, 1); // ASSIGN VARIABLES AND SHOW VIEW GROUPS PAGE $smarty->assign('total_groups', $total_groups); $smarty->assign('pages', $page_array); $smarty->assign('groups', $groups); $smarty->assign('f_title', $f_title); $smarty->assign('f_owner', $f_owner); $smarty->assign('i', $i); $smarty->assign('t', $t); $smarty->assign('o', $o); $smarty->assign('m', $m); $smarty->assign('d', $d); $smarty->assign('p', $page_vars[1]); $smarty->assign('s', $s); include "admin_footer.php"; ?>