/**
* Compiles a list of installed or defined modules
*/
function viewMambots($option, $client)
{
global $database, $mainframe, $mosConfig_list_limit;
global $mosConfig_absolute_path;
if ($client == 'admin') {
$where = "client_id='1'";
} else {
$where = "client_id='0'";
}
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
// get the total number of records
$query = "SELECT count(*) FROM #__mambots WHERE {$where}";
$database->setQuery($query);
$total = $database->loadResult();
require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
$pageNav = new mosPageNav($total, $limitstart, $limit);
$query = "SELECT m.*, u.name AS editor, g.name AS groupname" . "\n FROM #__mambots AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n LEFT JOIN #__groups AS g ON g.id = m.access" . "\n WHERE {$where}" . "\n GROUP BY m.id" . "\n ORDER BY m.folder ASC, m.ordering ASC, m.name ASC" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit}";
$database->setQuery($query);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
HTML_modules::showMambots($rows, $client, $pageNav, $option);
}
/**
* Compiles a list of installed or defined modules
*/
function viewMambots($option, $client)
{
global $database, $mainframe, $mosConfig_list_limit;
global $mosConfig_absolute_path;
$limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
$limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
$filter_type = $mainframe->getUserStateFromRequest("filter_type{$option}{$client}", 'filter_type', 0);
$search = $mainframe->getUserStateFromRequest("search{$option}{$client}", 'search', '');
$search = $database->getEscaped(trim(strtolower($search)));
if ($client == 'admin') {
$where[] = "m.client_id = '1'";
$client_id = 1;
} else {
$where[] = "m.client_id = '0'";
$client_id = 0;
}
// used by filter
if ($filter_type) {
$where[] = "m.folder = '{$filter_type}'";
}
if ($search) {
$where[] = "LOWER( m.name ) LIKE '%{$search}%'";
}
// get the total number of records
$query = "SELECT count(*) FROM #__mambots As m " . (count($where) ? "\n WHERE " . implode(' AND ', $where) : '');
$database->setQuery($query);
$total = $database->loadResult();
require_once $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php';
$pageNav = new mosPageNav($total, $limitstart, $limit);
$query = "SELECT m.*, u.name AS editor, g.name AS groupname" . "\n FROM #__mambots AS m" . "\n LEFT JOIN #__users AS u ON u.id = m.checked_out" . "\n LEFT JOIN #__groups AS g ON g.id = m.access" . (count($where) ? "\n WHERE " . implode(' AND ', $where) : '') . "\n GROUP BY m.id" . "\n ORDER BY m.folder ASC, m.ordering ASC, m.name ASC" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit}";
$database->setQuery($query);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// get list of Positions for dropdown filter
$query = "SELECT folder AS value, folder AS text" . "\n FROM #__mambots" . "\n WHERE client_id = '{$client_id}'" . "\n GROUP BY folder" . "\n ORDER BY folder";
$types[] = mosHTML::makeOption('0', T_('- All Types -'));
$database->setQuery($query);
$types = array_merge($types, $database->loadObjectList());
$lists['type'] = mosHTML::selectList($types, 'filter_type', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "{$filter_type}");
HTML_modules::showMambots($rows, $client, $pageNav, $option, $lists, $search);
}
