public static function get_all_categories() { if (!self::$_categories_loaded) { $db = cmsms()->GetDb(); $query = "SELECT * FROM " . cms_db_prefix() . "module_news_categories ORDER BY hierarchy"; $dbresult = $db->GetArray($query); if ($dbresult) { self::$_cached_categories = $dbresult; } self::$_categories_loaded = TRUE; } return self::$_cached_categories; }
public static function get_category_list() { if (!is_array(self::$_cached_categories)) { $db = cmsms()->GetDb(); $query = "SELECT * FROM " . cms_db_prefix() . "module_news_categories ORDER BY hierarchy"; $dbresult = $db->GetArray($query); if ($dbresult) { self::$_cached_categories = $dbresult; } } $categorylist = array(); for ($i = 0; $i < count(self::$_cached_categories); $i++) { $row = self::$_cached_categories[$i]; $categorylist[$row['long_name']] = $row['news_category_id']; } return $categorylist; }