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