private static function GetAchievementPointsCategoryCap($c) { if ($c == 0) { return DB::WoW()->selectCell("SELECT SUM(`points`) FROM `DBPREFIX_achievement` WHERE `factionFlag` IN (%d, -1)", WoW_Characters::GetFactionID()); } $categories = array(ACHIEVEMENTS_CATEGORY_GENERAL => array(92), ACHIEVEMENTS_CATEGORY_QUESTS => array(14861, 14862, 14863), ACHIEVEMENTS_CATEGORY_EXPLORATION => array(14777, 14778, 14779, 14780), ACHIEVEMENTS_CATEGORY_PVP => array(165, 14801, 14802, 14803, 14804, 14881, 14901, 15003), ACHIEVEMENTS_CATEGORY_DUNGEONS => array(14808, 14805, 14806, 14921, 14922, 14923, 14961, 14962, 15001, 15002, 15041, 15042), ACHIEVEMENTS_CATEGORY_PROFESSIONS => array(170, 171, 172), ACHIEVEMENTS_CATEGORY_REPUTATION => array(14864, 14865, 14866), ACHIEVEMENTS_CATEGORY_EVENTS => array(160, 187, 159, 163, 161, 162, 158, 14981, 156, 14941), ACHIEVEMENTS_CATEGORY_FEATS => array(81)); if (!isset($categories[$c])) { return DB::WoW()->selectCell("SELECT SUM(`points`) FROM `DBPREFIX_achievement` WHERE `categoryId` = %d AND `factionFlag` IN (%d, -1)", $c, WoW_Characters::GetFactionID()); } $catids = array(); foreach ($categories[$c] as $category) { $catids[] = $category; } return DB::WoW()->selectCell("SELECT SUM(`points`) FROM `DBPREFIX_achievement` WHERE `categoryId` IN (%s) AND `factionFlag` IN (%d, -1)", $catids, WoW_Characters::GetFactionID()); }