private static function LoadCategoryInfo()
{
if (self::GetCategoryId() > 0) {
$category = DB::WoW()->selectRow("\n SELECT `a`.`title_%s` AS `title`, `a`.`parent_cat`,\n IF(`a`.`parent_cat` != -1, (SELECT `title_%s` FROM `DBPREFIX_forum_category` WHERE `cat_id` = `a`.`parent_cat`), NULL) AS `category_group` \n FROM `DBPREFIX_forum_category` AS `a`\n WHERE `a`.`cat_id` = %d AND `a`.`header` = 0", WoW_Locale::GetLocale(), WoW_Locale::GetLocale(), self::GetCategoryId());
} elseif (self::GetThreadId() > 0) {
$category = DB::WoW()->selectRow("\n SELECT `a`.`cat_id`, `a`.`title_%s` AS `title`, `a`.`parent_cat`, `b`.`title` AS `threadTitle`,\n IF(`a`.`parent_cat` != -1, (SELECT `title_%s` FROM `DBPREFIX_forum_category` WHERE `cat_id` = `a`.`parent_cat`), NULL) AS `category_group` \n FROM `DBPREFIX_forum_category` AS `a`\n LEFT JOIN `DBPREFIX_forum_threads` AS `b`\n ON `b`.`cat_id` = `a`.`cat_id` AND `b`.`thread_id` = %d\n WHERE `a`.`cat_id` = (SELECT `cat_id` FROM `DBPREFIX_forum_threads` WHERE `thread_id` = %d) AND `a`.`header` = 0", WoW_Locale::GetLocale(), WoW_Locale::GetLocale(), self::GetThreadId(), self::GetThreadId());
self::$active_thread_title = $category['threadTitle'];
self::SetCategoryId($category['cat_id']);
} else {
$category = false;
}
if (!$category) {
return false;
}
self::$active_category_title = $category['title'];
self::$active_global_category_id = $category['parent_cat'];
self::$active_global_category_title = $category['category_group'];
return true;
}
