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