Example #1
0
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;
}
Example #3
0
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);
        }
    }
}