private static function LoadAchievements() { self::$m_achievements = DB::World()->select("\n SELECT\n `a`.`id`,\n `a`.`factionFlag` AS `side`,\n `a`.`name_%s` AS `name`,\n `a`.`desc_%s` AS `desc`,\n `a`.`categoryId`,\n `a`.`points`,\n `a`.`iconID`,\n `a`.`titleReward_%s` AS `titleReward`,\n `b`.`icon`,\n `c`.`parentCategory`\n FROM `DBPREFIX_achievement` AS `a`\n LEFT JOIN `DBPREFIX_spell_icon` AS `b` ON `b`.`id` = `a`.`iconID`\n LEFT JOIN `DBPREFIX_achievement_category` AS `c` ON `c`.`id` = `a`.`categoryId`\n %s\n LIMIT 200", WoW_Locale::GetLocale(), WoW_Locale::GetLocale(), WoW_Locale::GetLocale(), self::$m_achievement_category > 0 ? 'WHERE `a`.`categoryId` = ' . self::$m_achievement_category : null); // Set count self::$m_count = DB::World()->selectCell("SELECT COUNT(*) FROM `DBPREFIX_achievement`%s", self::$m_achievement_category > 0 ? 'WHERE `categoryId` = ' . self::$m_achievement_category : null); }