static function listitems($option, $pkg)
{
$database = JFactory::getDBO();
$database->setQuery("select distinct package as name " . "from #__facileforms_scripts " . "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_scripts " . "where package = " . $database->Quote($pkg) . " " . "order by type, name, id desc");
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
HTML_facileFormsScript::listitems($option, $rows, $pkglist);
}
