/** * 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; }