private static function BossesForZone($MapID)
{
$Statement = Zones::$WConnection->prepare("\n SELECT\n ct.entry,\n\t c.modelid,\n\t c.curhealth,\n\t c.curmana,\n\t ct.name,\n ct.subname,\n ct.maxlevel,\n c.spawntimesecs\n FROM\n creature c\n LEFT JOIN creature_template ct ON\n c.id = ct.entry\n WHERE\n ct.rank BETWEEN 1 AND 3\n AND\n c.map = :mapid\n AND\n c.spawntimesecs BETWEEN 6380 AND 604801\n AND\n\t\t\t\t\tct.ScriptName LIKE '%boss_%'\n ");
$Statement->bindParam(':mapid', $MapID);
$Statement->execute();
$Result = $Statement->fetchAll(PDO::FETCH_ASSOC);
$ArrayIndex = 0;
foreach ($Result as $Boss) {
$Result[$ArrayIndex]['boss_link'] = strtolower(str_replace(' ', '-', str_replace("'", '', $Boss['name'])));
if (!Zones::DownloadBossIcon($Boss['entry'])) {
unset($Result[$ArrayIndex]);
}
$ArrayIndex++;
}
return $Result;
}
