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