public static function GetNormalRaidsOneBoss($CharacterGUID, $Expansion, $Instance, $Bosses, $Criteria, $Heroic) { if (is_array($Criteria)) { $ParametersIDs = ':id_' . implode(',:id_', array_keys($Criteria)); $IDsAndValues = array_combine(explode(",", $ParametersIDs), $Criteria); $IDsAndValues = String::UnshiftAssoc($IDsAndValues, ':guid', $CharacterGUID); } else { $ParametersIDs = $Criteria; $IDsAndValues = array(); $IDsAndValues = String::UnshiftAssoc($IDsAndValues, ':guid', $CharacterGUID); } $HTML = ""; $RaidData = array(); $CharactersSQL = "SELECT * FROM character_achievement_progress WHERE guid = :guid AND criteria IN (" . $ParametersIDs . ")"; $CharactersData = Characters::$CharConnection->prepare($CharactersSQL); $CharactersData->execute($IDsAndValues); $Result = $CharactersData->fetchAll(PDO::FETCH_ASSOC); $CountResults = count($Result); $BossKills = 0; if (empty($Result)) { $HTML .= Raids::CreateSimpleHTML($Instance, 'incomplete') . PHP_EOL; $RaidData = Raids::CreateOneBossRaid($CharacterGUID, $Instance, $Expansion, $Bosses, 0); } else { foreach ($Result as $InstanceData) { $BossKills = $BossKills + $InstanceData['counter']; } $HTML .= Raids::CreateSimpleHTML($Instance, 'completed') . PHP_EOL; $RaidData = Raids::CreateOneBossRaid($CharacterGUID, $Instance, $Expansion, $Bosses, $BossKills); } return array('data' => $RaidData, 'html' => $HTML); }