Example #1
0
 /**
  * Get some {@link icms_config_category_Object}s
  *
  * @param	object  $criteria   {@link icms_db_criteria_Element}
  * @param	bool    $id_as_key  Use the IDs as keys to the array?
  *
  * @return	array   Array of {@link icms_config_category_Object}s
  */
 public 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, 'icms_db_criteria_Element')) {
         $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 icms_config_category_Object();
         $confcat->assignVars($myrow, false);
         if (!$id_as_key) {
             $ret[] =& $confcat;
         } else {
             $ret[$myrow['confcat_id']] =& $confcat;
         }
         unset($confcat);
     }
     return $ret;
 }
 /**
  * Constructor
  *
  */
 function XoopsConfigCategory()
 {
     parent::__construct();
     $this->_deprecated = icms_core_Debug::setDeprecated('icms_config_category_Object', sprintf(_CORE_REMOVE_IN_VERISON, '1.4'));
 }