function listitems($option, $pkg)
{
global $database;
$database = JFactory::getDBO();
$database->setQuery(
"select distinct package as name ".
"from #__facileforms_forms ".
"where package is not null and package!='' ".
"order by name"
);
$pkgs = $database->loadObjectList();
if ($database->getErrorNum()) { echo $database->stderr(); return false; }
$pkgok = $pkg=='';
if (!$pkgok && count($pkgs)) foreach ($pkgs as $p) if ($p->name==$pkg) { $pkgok = true; break; }
if (!$pkgok) $pkg = '';
$pkglist = array();
$pkglist[] = array($pkg=='', '');
if (count($pkgs)) foreach ($pkgs as $p) $pkglist[] = array($p->name==$pkg, $p->name);
$database->setQuery(
"select * from #__facileforms_forms ".
"where package = ".$database->Quote($pkg)." ".
"order by ordering, id"
);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
} // if
HTML_facileFormsForm::listitems($option, $rows, $pkglist);
} // listitems
static function listitems($option, $pkg)
{
global $database;
$database = JFactory::getDBO();
$database->setQuery("select distinct package as name " . "from #__facileforms_forms " . "where package is not null and package!='' " . "order by name");
$pkgs = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$pkgok = $pkg == '';
if (!$pkgok && count($pkgs)) {
foreach ($pkgs as $p) {
if ($p->name == $pkg) {
$pkgok = true;
break;
}
}
}
if (!$pkgok) {
$pkg = '';
}
$pkglist = array();
$pkglist[] = array($pkg == '', '');
if (count($pkgs)) {
foreach ($pkgs as $p) {
$pkglist[] = array($p->name == $pkg, $p->name);
}
}
$limit = JFactory::getApplication()->getUserStateFromRequest('global.list.limit', 'limit', JFactory::getApplication()->getCfg('list_limit'), 'int');
$limitstart = 0;
if (isset($_REQUEST['limit']) && isset($_REQUEST['limitstart'])) {
$limit = intval($_REQUEST['limit']);
$limitstart = intval($_REQUEST['limitstart']);
}
$database->setQuery("select SQL_CALC_FOUND_ROWS * from #__facileforms_forms " . "where package = " . $database->Quote($pkg) . " " . "order by ordering, id", $limitstart, $limit);
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// if
$database->setQuery('SELECT FOUND_ROWS();');
$total = $database->loadResult();
HTML_facileFormsForm::listitems($option, $rows, $pkglist, $total);
}
