/**
* Get some {@link XoopsConfigCategory}s
*
* @param object $criteria {@link CriteriaElement}
* @param bool $id_as_key Use the IDs as keys to the array?
*
* @return array Array of {@link XoopsConfigCategory}s
*/
function getObjects($criteria = null, $id_as_key = false)
{
$ret = array();
$limit = $start = 0;
$sql = 'SELECT * FROM ' . $this->db->prefix('configcategory');
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
$sql .= ' ' . $criteria->renderWhere();
$sort = !in_array($criteria->getSort(), array('confcat_id', 'confcat_name', 'confcat_order')) ? 'confcat_order' : $criteria->getSort();
$sql .= ' ORDER BY ' . $sort . ' ' . $criteria->getOrder();
$limit = $criteria->getLimit();
$start = $criteria->getStart();
}
$result = $this->db->query($sql, $limit, $start);
if (!$result) {
return $ret;
}
while ($myrow = $this->db->fetchArray($result)) {
$confcat = new XoopsConfigCategory();
$confcat->assignVars($myrow, false);
if (!$id_as_key) {
$ret[] =& $confcat;
} else {
$ret[$myrow['confcat_id']] =& $confcat;
}
unset($confcat);
}
return $ret;
}
