function group_read($from_where, $order_by) { global $db, $main_smarty, $view, $user, $rows, $page_size, $offset; // figure out what "page" of the results we're on $offset = (get_current_page() - 1) * $page_size; // pagesize set in the admin panel $search->pagesize = $page_size; if ($order_by == "") { $order_by = "group_date DESC"; } include_once mnminclude . 'smartyvariables.php'; global $db, $main_smarty; $rows = $db->get_var("SELECT count(*) FROM " . table_groups . " WHERE " . $from_where . " "); $group = $db->get_results("SELECT distinct(group_id) as group_id FROM " . table_groups . " WHERE " . $from_where . " ORDER BY group_status DESC, " . $order_by . " LIMIT {$offset},{$page_size} "); if ($group) { foreach ($group as $groupid) { $group_display .= group_print_summary($groupid->group_id); } $main_smarty->assign('group_display', $group_display); } if (Auto_scroll == 2 || Auto_scroll == 3) { $main_smarty->assign("scrollpageSize", $page_size); } else { $main_smarty->assign('group_pagination', do_pages($rows, $page_size, "groups", true)); } return true; }
<?php include_once 'internal/Smarty.class.php'; $main_smarty = new Smarty(); include 'config.php'; include mnminclude . 'html1.php'; include mnminclude . 'link.php'; include mnminclude . 'group.php'; include mnminclude . 'smartyvariables.php'; $group_display = ""; $start_up = isset($_REQUEST['start_up']) ? $_REQUEST['start_up'] : ""; $page_size = isset($_REQUEST['pagesize']) ? $_REQUEST['pagesize'] : ""; $group = $db->get_results("SELECT * FROM " . table_groups . " WHERE group_status='Enable' ORDER BY group_status, group_date DESC LIMIT {$start_up}, {$page_size}"); if ($group) { foreach ($group as $groupid) { $group_display .= group_print_summary($groupid->group_id); } echo $group_display; }
function do_member_groups() { global $db, $main_smarty, $rows, $user, $offset, $page_size; //print_r(get_groupid_user($user->id)); $ids = get_groupid_user($user->id); if ($ids) { foreach ($ids as $groupid) { //print_r($groupid); //echo $groupid->group_id; $output .= group_print_summary($groupid->group_id); $main_smarty->assign('user_page', $output); } } }