groups.php

<?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');
include mnminclude.'extra_fields_smarty.php';

$from_where = "1";
if (!checklevel('admin')) {
    $from_where .= " AND group_status = 'Enable' ";
} elseif ($_REQUEST["approve"] && is_numeric($_REQUEST["approve"])) {
    $db->query("UPDATE ".table_groups." SET group_status='Enable' WHERE group_id=".$db->escape(sanitize($_REQUEST["approve"], 3)));
}


    $keyword = $db->escape(sanitize(trim($_REQUEST['keyword']), 3));
    if ($keyword) {
        $from_where .= " AND (group_name LIKE '%$keyword%' OR group_description LIKE '%$keyword%')";
        $main_smarty->assign('search', $keyword);
    }

if ($_REQUEST["sortby"]) {
    $sortby  = $_REQUEST["sortby"];
    if ($sortby == 'newest') {
        $order_by = "group_date DESC";
    }
    if ($sortby == 'oldest') {
        $order_by = "group_date ASC";
    }
    if ($sortby == 'members') {
        $order_by = "group_members DESC";
    }
    if ($sortby == 'name') {
        $order_by = "group_name Asc";
    }
    $main_smarty->assign('sortby', $sortby);
}

$rows = $db->get_var("SELECT count(*) FROM ".table_groups." WHERE group_status='Enable'");
$main_smarty->assign('total_row_for_group', $rows);




// pagename
define('pagename', 'groups');
$main_smarty->assign('pagename', pagename);
$main_smarty = do_sidebar($main_smarty);

group_read($from_where, $order_by);

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;
}


//$main_smarty->assign("scrollpageSize", "1");
//For Infinit scrolling and continue reading option

   $main_smarty->assign('link_pagination', do_pages($rows, $page_size, "published", true));


// show the template
$main_smarty->assign('tpl_center', $the_template.'/group_center');
$main_smarty->display($the_template.'/pligg.tpl');