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