Release Scarlet Hold Dungeon!

[svedin]

Scarlet Hold is the last defensive of the Scarlet Crusade


So the leaders of the Scarlet Hold is the High Commander Wrynn and he is the half brother to King Varian Wrynn.
And then we got hes wife Cleric Demetria Proudmoore that are related to Lady Jaina Proudmoore

They got a other Commander to there aid, Lord Mataus Shadowbreaker.

Here is some [S]creen[S]hot from the Dungeon.



Lord Mataus Shadowbreaker





High Commander Wrynn And Cleric Demetria Proudmoore



A movie of the last boss fight

[YT]<object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/qNOh4sg7P5I&hl=sv&fs=1"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/v/qNOh4sg7P5I&hl=sv&fs=1" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object>[/YT]

This is a 5 - man Dungeon (I Think) and i used the "unused Scarlet Monastery"

And here is the scripts for the instance with spawns and the other things.

Lua;

Scarlet Hold Units

function Scarlet_Hold_Centurion_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "Kill the intruders!")
Unit:RegisterEvent("Scarlet_Hold_Centurion_Sunder_armor", 43000, 0)
Unit:RegisterEvent("Scarlet_Hold_Centurion_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_Centurion_Cleave", 61000, 0)
end

function Scarlet_Hold_Centurion_Sunder_armor(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59608, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Centurion_Cleave(pUnit, Event) 
pUnit:CastSpell(26350, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Centurion_Sunder_armor(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59608, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Centurion_Cleave(pUnit, Event) 
pUnit:CastSpell(26350, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Centurion_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Centurion_Sunder_armor", 43000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Centurion_Cleave", 61000, 0)
end 
end

function Scarlet_Hold_Centurion_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "...") 
end

function Scarlet_Hold_Centurion_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This... is... not over...") 
end

RegisterUnitEvent(940802, 1, "Scarlet_Hold_Centurion_OnCombat")
RegisterUnitEvent(940802, 2, "Scarlet_Hold_Centurion_OnLeaveCombat")
RegisterUnitEvent(940802, 3, "Scarlet_Hold_Centurion_OnDied")


function Scarlet_Hold_Magician_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "Kill them!")
Unit:RegisterEvent("Scarlet_Hold_Magician_Fire_bolt", 24000, 0)
Unit:RegisterEvent("Scarlet_Hold_Magician_phase",1000,0)
end

function Scarlet_Hold_Magician_Fire_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(39022, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Magician_Fire_shield(pUnit, Event) 
pUnit:CastSpell(35265, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Magician_Fire_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(39022, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Magician_Fire_shield(pUnit, Event) 
pUnit:CastSpell(35265, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Magician_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Magician_Fire_bolt", 24000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Magician_Fire_shield", 100, 1)
end 
end

function Scarlet_Hold_Magician_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "The Fire always win") 
end

function Scarlet_Hold_Magician_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This... can't be") 
end

RegisterUnitEvent(940801, 1, "Scarlet_Hold_Magician_OnCombat")
RegisterUnitEvent(940801, 2, "Scarlet_Hold_Magician_OnLeaveCombat")
RegisterUnitEvent(940801, 3, "Scarlet_Hold_Magician_OnDied")


function Scarlet_Hold_Abbot_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "The light will take you down")
Unit:RegisterEvent("Scarlet_Hold_Abbot_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_Abbot_Smite", 32000, 0)
Unit:RegisterEvent("Scarlet_Hold_Abbot_Renew", 76000, 0)
end

function Scarlet_Hold_Abbot_Smite(pUnit, Event) 
pUnit:FullCastSpellOnTarget(41370, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Abbot_Renew(pUnit, Event) 
pUnit:CastSpell(37260, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Abbot_Smite(pUnit, Event) 
pUnit:FullCastSpellOnTarget(41370, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Abbot_Renew(pUnit, Event) 
pUnit:CastSpell(37260, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Abbot_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Abbot_Smite", 32000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Abbot_Renew", 76000, 0)
end 
end

function Scarlet_Hold_Abbot_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Like i say the light always win") 
end

function Scarlet_Hold_Abbot_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "What... is.. this... for power?") 
end

RegisterUnitEvent(940803, 1, "Scarlet_Hold_Abbot_OnCombat")
RegisterUnitEvent(940803, 2, "Scarlet_Hold_Abbot_OnLeaveCombat")
RegisterUnitEvent(940803, 3, "Scarlet_Hold_Abbot_OnDied")


function Scarlet_Hold_General_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "To arms!")
Unit:RegisterEvent("Scarlet_Hold_General_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_General_shout", 43000, 0)
Unit:RegisterEvent("Scarlet_Hold_General_Thunder", 32000, 0)
end

function Scarlet_Hold_General_shout(pUnit, Event) 
pUnit:CastSpell(59613, pUnit:GetMainTank()) 
end

function Scarlet_Hold_General_Thunder(pUnit, Event) 
pUnit:CastSpell(57832, pUnit:GetMainTank()) 
end

function Scarlet_Hold_General_shout(pUnit, Event) 
pUnit:CastSpell(59613, pUnit:GetMainTank()) 
end

function Scarlet_Hold_General_Thunder(pUnit, Event) 
pUnit:CastSpell(57832, pUnit:GetMainTank()) 
end

function Scarlet_Hold_General_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_General_shout", 43000, 0)
pUnit:RegisterEvent("Scarlet_Hold_General_Thunder", 32000, 0)
end 
end

function Scarlet_Hold_General_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Good my soldiers!") 
end

function Scarlet_Hold_General_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Ah! I have fail the Scarlet Crusade!") 
end

RegisterUnitEvent(940804, 1, "Scarlet_Hold_General_OnCombat")
RegisterUnitEvent(940804, 2, "Scarlet_Hold_General_OnLeaveCombat")
RegisterUnitEvent(940804, 3, "Scarlet_Hold_General_OnDied")


function Scarlet_Hold_Guard_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "Stand back!")
Unit:RegisterEvent("Scarlet_Hold_Guard_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_Guard_shield", 32000, 0)
Unit:RegisterEvent("Scarlet_Hold_Guard_knock", 54000, 0)
end

function Scarlet_Hold_Guard_shield(pUnit, Event) 
pUnit:CastSpell(47488, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Guard_knock(pUnit, Event) 
pUnit:CastSpell(29711, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Guard_shield(pUnit, Event) 
pUnit:CastSpell(47488, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Guard_knock(pUnit, Event) 
pUnit:CastSpell(29711, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Guard_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Guard_shield", 32000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Guard_knock", 54000, 0)
end 
end

function Scarlet_Hold_Guard_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "I serv the Scarlet Crusade!") 
end

function Scarlet_Hold_Guard_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "A have fail you my lord!") 
end

RegisterUnitEvent(940812, 1, "Scarlet_Hold_Guard_OnCombat")
RegisterUnitEvent(940812, 2, "Scarlet_Hold_Guard_OnLeaveCombat")
RegisterUnitEvent(940812, 3, "Scarlet_Hold_Guard_OnDied")


function Scarlet_Hold_Disciple_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "The Scarlet Crusade will never give up!")
Unit:RegisterEvent("Scarlet_Hold_Disciple_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_Disciple_shadow_bolt", 24000, 0)
end

function Scarlet_Hold_Disciple_shadow_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59351, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Disciple_Fel_armor(pUnit, Event) 
pUnit:CastSpell(44520, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Disciple_shadow_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59351, pUnit:GetRandomPlayer(0)) 
end

function Scarlet_Hold_Disciple_Fel_armor(pUnit, Event) 
pUnit:CastSpell(44520, pUnit:GetClosestPlayer()) 
end

function Scarlet_Hold_Disciple_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Disciple_shadow_bolt", 24000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Disciple_Fel_armor", 100, 1)
end 
end

function Scarlet_Hold_Disciple_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This was easy!") 
end

function Scarlet_Hold_Disciple_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This... is not over!") 
end

RegisterUnitEvent(940813, 1, "Scarlet_Hold_Disciple_OnCombat")
RegisterUnitEvent(940813, 2, "Scarlet_Hold_Disciple_OnLeaveCombat")
RegisterUnitEvent(940813, 3, "Scarlet_Hold_Disciple_OnDied")



function Scarlet_Hold_Champion_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "Death to the intruders!")
Unit:RegisterEvent("Scarlet_Hold_Champion_phase",1000,0)
Unit:RegisterEvent("Scarlet_Hold_Champion_strike", 45000, 0)
Unit:RegisterEvent("Scarlet_Hold_Champion_rend", 67000, 0)
end

function Scarlet_Hold_Champion_strike(pUnit, Event) 
pUnit:CastSpell(13953, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Champion_rend(pUnit, Event) 
pUnit:FullCastSpellOnTarget(14331, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Champion_strike(pUnit, Event) 
pUnit:CastSpell(13953, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Champion_rend(pUnit, Event) 
pUnit:FullCastSpellOnTarget(14331, pUnit:GetMainTank()) 
end

function Scarlet_Hold_Champion_phase(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Scarlet_Hold_Champion_strike", 45000, 0)
pUnit:RegisterEvent("Scarlet_Hold_Champion_rend", 67000, 0)
end 
end

function Scarlet_Hold_Champion_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Haha! they were easy!") 
end

function Scarlet_Hold_Champion_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "The intruders... comming my lord!") 
end

RegisterUnitEvent(940800, 1, "Scarlet_Hold_Champion_OnCombat")
RegisterUnitEvent(940800, 2, "Scarlet_Hold_Champion_OnLeaveCombat")
RegisterUnitEvent(940800, 4, "Scarlet_Hold_Champion_OnDied")

Lord Mataus Shadowbreaker

function Lord_Mataus_Shadowbreaker_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "I am the greatest of my father's sons! Your end has come!")
Unit:PlaySoundToSet(14149)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_cleave", 32000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_spell_reflect", 56000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_screem", 76000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_banish", 34000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_spin", 64000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_mini", 81000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_sunder", 47000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_mortal", 12000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_Ironform", 90000, 0)
Unit:RegisterEvent("Lord_Mataus_Shadowbreaker_phaseone",1000,0)
end

function Lord_Mataus_Shadowbreaker_battle_aura(pUnit, Event) 
pUnit:CastSpell(41106, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_battle_stand(pUnit, Event) 
pUnit:CastSpell(53792, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_cleave(pUnit, Event) 
pUnit:CastSpell(15284, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_spell_reflect(pUnit, Event) 
pUnit:CastSpell(36096, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_screem(pUnit, Event) 
pUnit:CastSpell(32421, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_banish(pUnit, Event) 
pUnit:FullCastSpellOnTarget(38791, pUnit:GetRandomPlayer(0)) 
end

function Lord_Mataus_Shadowbreaker_spin(pUnit, Event) 
pUnit:CastSpell(60030, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_berserker_aura(pUnit, Event) 
pUnit:CastSpell(41107, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_berserker_stand(pUnit, Event) 
pUnit:CastSpell(53791, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_battle_aura(pUnit, Event) 
pUnit:CastSpell(41106, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_cleave(pUnit, Event) 
pUnit:FullCastSpellOnTarget(15284, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_spin(pUnit, Event) 
pUnit:CastSpell(60030, pUnit:GetRandomPlayer(0)) 
end

function Lord_Mataus_Shadowbreaker_screem(pUnit, Event) 
pUnit:CastSpell(76000, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_banish(pUnit, Event) 
pUnit:FullCastSpellOnTarget(38791, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_berserker_aura(pUnit, Event) 
pUnit:CastSpell(41107, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_berserker_stand(pUnit, Event) 
pUnit:CastSpell(53791, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_sunder(pUnit, Event) 
pUnit:FullCastSpellOnTarget(43243, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_mortal(pUnit, Event) 
pUnit:FullCastSpellOnTarget(16856, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_Ironform(pUnit, Event) 
pUnit:CastSpell(52022, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_sunder(pUnit, Event) 
pUnit:FullCastSpellOnTarget(43243, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_mortal(pUnit, Event) 
pUnit:FullCastSpellOnTarget(16856, pUnit:GetMainTank()) 
end

function Lord_Mataus_Shadowbreaker_Ironform(pUnit, Event) 
pUnit:CastSpell(52022, pUnit:GetClosestPlayer()) 
end

function Lord_Mataus_Shadowbreaker_phaseone(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_battle_aura", 100, 1)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_battle_stand", 100, 1)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_cleave", 32000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_spin", 64000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_screem", 76000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_spell_reflect", 56000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_sunder", 47000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_phasetwo",1000,0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_berserker_aura", 100, 1)
end 
end

function Lord_Mataus_Shadowbreaker_phasetwo(pUnit, Event) 
if pUnit:GetHealthPct() < 50 then 
pUnit:RemoveEvents(); 
pUnit:PlaySoundToSet(14152)
pUnit:SendChatMessage(12, 0, "GRAAAAAH! Behold the fury of iron and steel!") 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_cleave", 32000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_spin", 64000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_screem", 76000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_berserker_stand", 100, 1)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_banish", 34000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_mini", 81000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_sunder", 47000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_mortal", 12000, 0)
pUnit:RegisterEvent("Lord_Mataus_Shadowbreaker_Ironform", 90000, 0)
end 
end

function Lord_Mataus_Shadowbreaker_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Flesh... is... weak! ") 
Unit:PlaySoundToSet(14154)
end

function Lord_Mataus_Shadowbreaker_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "How can it be!? Flesh is not.. stronger!") 
Unit:PlaySoundToSet(14156)
end

function Lord_Mataus_Shadowbreaker_OnKilledTarget(Unit, Event) 
Unit:SendChatMessage(12, 0, "So ends your curse!") 
Unit:PlaySoundToSet(14153)
end

RegisterUnitEvent(940806, 1, "Lord_Mataus_Shadowbreaker_OnCombat")
RegisterUnitEvent(940806, 2, "Lord_Mataus_Shadowbreaker_OnLeaveCombat")
RegisterUnitEvent(940806, 3, "Lord_Mataus_Shadowbreaker_OnKilledTarget")
RegisterUnitEvent(940806, 4, "Lord_Mataus_Shadowbreaker_OnDied")

High Commander Wrynn

function High_Commander_Wrynn_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "You invade my home and then dare to challenge me? I will tear the hearts from your chests and offer them as gifts to the death god! Rualg nja gaborr!")
Unit:PlaySoundToSet(13609)
Unit:RegisterEvent("High_Commander_Wrynn_Shout", 43000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_bloodstrike", 13000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_bonebarrier", 76000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_unholyaura", 100, 1)
Unit:RegisterEvent("High_Commander_Wrynn_wound", 17000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_Seethe", 56000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_Strike", 50000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_Silence", 49000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_PlagueStrike", 37000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_Battleshout", 87000, 0)
Unit:RegisterEvent("High_Commander_Wrynn_phaseone",1000,0)
end

function High_Commander_Wrynn_Shout(pUnit, Event) 
pUnit:CastSpell(29107, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_bloodstrike(pUnit, Event) 
pUnit:CastSpell(61696, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_bonebarrier(pUnit, Event) 
pUnit:CastSpell(29061, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_unholyaura(pUnit, Event) 
pUnit:CastSpell(55608, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_wound(pUnit, Event) 
pUnit:FullCastSpellOnTarget(40481, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_Seethe(pUnit, Event) 
pUnit:CastSpell(41520, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_Strike(pUnit, Event) 
pUnit:CastSpell(33813, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_Silence(pUnit, Event) 
pUnit:CastSpell(36297, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_PlagueStrike(pUnit, Event) 
pUnit:CastSpell(61600, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_Battleshout(pUnit, Event) 
pUnit:CastSpell(29584, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_wound(pUnit, Event) 
pUnit:FullCastSpellOnTarget(40481, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_bonebarrier(pUnit, Event) 
pUnit:CastSpell(29061, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_bloodstrike(pUnit, Event) 
pUnit:CastSpell(61696, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_Seethe(pUnit, Event) 
pUnit:CastSpell(41520, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_Shout(pUnit, Event) 
pUnit:CastSpell(29107, pUnit:GetClosestPlayer()) 
end

function High_Commander_Wrynn_PlagueStrike(pUnit, Event) 
pUnit:CastSpell(61600, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_Battleshout(pUnit, Event) 
pUnit:CastSpell(29584, pUnit:GetMainTank()) 
end

function High_Commander_Wrynn_Strike(pUnit, Event) 
pUnit:CastSpell(33813, pUnit:GetMainTank()) 
end


function High_Commander_Wrynn_phaseone(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("High_Commander_Wrynn_phasetwo",1000,0)
pUnit:RegisterEvent("High_Commander_Wrynn_unholyaura", 100, 1)
pUnit:RegisterEvent("High_Commander_Wrynn_bonebarrier", 76000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_bloodstrike", 13000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Silence", 50000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Battleshout", 87000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Shout", 43000, 0)
end 
end

function High_Commander_Wrynn_phasetwo(pUnit, Event) 
if pUnit:GetHealthPct() < 65 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:SendChatMessage(12, 0, "There is a reason I am king!") 
pUnit:PlaySoundToSet(13616)
pUnit:RegisterEvent("High_Commander_Wrynn_bonebarrier", 76000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Seethe", 56000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_PlagueStrike", 37000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Battleshout", 87000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_wound", 17000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_phasethree",1000,0)
end 
end

function High_Commander_Wrynn_phasethree(pUnit, Event) 
if pUnit:GetHealthPct() < 45 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(0)
pUnit:RegisterEvent("High_Commander_Wrynn_bonebarrier", 76000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_wound", 17000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Strike", 50000, 0)
pUnit:RegisterEvent("High_Commander_Wrynn_Shout", 43000, 0)
end 
end

function High_Commander_Wrynn_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This was weaker then the Scourge!") 
end

function High_Commander_Wrynn_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "What.. awaits me.. now..") 
Unit:PlaySoundToSet(13618)
end

function High_Commander_Wrynn_OnKilledTarget(Unit, Event) 
Choice=math.random(1,3)
if Choice == 1 then
pUnit:SendChatMessage(14, 0, "Your death is only the beginning!")
pUnit:PlaySoundToSet(13614)
end
if Choice == 2 then
pUnit:SendChatMessage(12, 0, "Breath no more!")
pUnit:PlaySoundToSet(13617)
end
if Choice == 3 then
pUnit:SendChatMessage(12, 0, "You have failed your people!")
pUnit:PlaySoundToSet(13615)  
end
end

RegisterUnitEvent(940810, 1, "High_Commander_Wrynn_OnCombat")
RegisterUnitEvent(940810, 2, "High_Commander_Wrynn_OnLeaveCombat")
RegisterUnitEvent(940810, 3, "High_Commander_Wrynn_OnKilledTarget")
RegisterUnitEvent(940810, 4, "High_Commander_Wrynn_OnDied")

Cleric Demetria Proudmoore

function Cleric_Demetria_Proudmoore_OnCombat(Unit, Event) 
Unit:SendChatMessage(12, 0, "I'll give you more than you can handle!")
Unit:PlaySoundToSet(13321)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Frostbolt", 21000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_ice_nova", 72000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_frost_shock", 54000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Blizzard", 76000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Anit_magic", 65000, 5)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_phaseone",1000,0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Arcane_volley", 57000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_bolt", 21000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Mind_blast", 43000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_nova", 72000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_word", 50000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_Unholy_shadow", 57000, 0)
Unit:RegisterEvent("Cleric_Demetria_Proudmoore_spell_reflection", 67000, 0)
end

function Cleric_Demetria_Proudmoore_shadowform(pUnit, Event) 
pUnit:CastSpell(22917, pUnit:GetClosestPlayer()) 
end

function Cleric_Demetria_Proudmoore_Frostbolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(28479, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_ice_nova(pUnit, Event) 
pUnit:FullCastSpellOnTarget(56935, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_frost_shock(pUnit, Event) 
pUnit:FullCastSpellOnTarget(38234, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Blizzard(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59854, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Anit_magic(pUnit, Event) 
pUnit:CastSpell(31662, pUnit:GetClosestPlayer()) 
end

function Cleric_Demetria_Proudmoore_Arcane_volley(pUnit, Event) 
pUnit:FullCastSpellOnTarget(40424, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Shadow_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59357, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Mind_blast(pUnit, Event) 
pUnit:FullCastSpellOnTarget(37531, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Shadow_nova(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59435, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Shadow_nova(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59435, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Frostbolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(28479, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_ice_nova(pUnit, Event) 
pUnit:FullCastSpellOnTarget(56935, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_frost_shock(pUnit, Event) 
pUnit:FullCastSpellOnTarget(38234, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Blizzard(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59854, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Arcane_volley(pUnit, Event) 
pUnit:FullCastSpellOnTarget(40424, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Shadow_bolt(pUnit, Event) 
pUnit:FullCastSpellOnTarget(59357, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Mind_blast(pUnit, Event) 
pUnit:FullCastSpellOnTarget(37531, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Shadow_word(pUnit, Event) 
pUnit:FullCastSpellOnTarget(37275, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Unholy_shadow(pUnit, Event) 
pUnit:FullCastSpellOnTarget(28882, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_spell_reflection(pUnit, Event) 
pUnit:FullCastSpellOnTarget(47981, pUnit:GetClosestPlayer()) 
end

function Cleric_Demetria_Proudmoore_Shadow_word(pUnit, Event) 
pUnit:FullCastSpellOnTarget(37275, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_Unholy_shadow(pUnit, Event) 
pUnit:FullCastSpellOnTarget(28882, pUnit:GetRandomPlayer(0)) 
end

function Cleric_Demetria_Proudmoore_spell_reflection(pUnit, Event) 
pUnit:FullCastSpellOnTarget(47981, pUnit:GetClosestPlayer()) 
end

function Cleric_Demetria_Proudmoore_phaseone(pUnit, Event) 
if pUnit:GetHealthPct() < 100 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(40424, 56935, 28479)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_phasetwo",1000,0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Frostbolt", 21000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_ice_nova", 72000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_frost_shock", 54000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Blizzard", 76000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Arcane_volley", 57000, 0)
end 
end

function Cleric_Demetria_Proudmoore_phasetwo(pUnit, Event) 
if pUnit:GetHealthPct() < 60 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(37531, 59357, 59435, 31662)
pUnit:SendChatMessage(12, 0, "Now to finish the job!") 
pUnit:PlaySoundToSet(13323)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_phasethree",1000,0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_shadowform", 100, 1)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_bolt", 21000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Mind_blast", 43000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_nova", 72000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_word", 50000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Anit_magic", 65000, 5)
end 
end

function Cleric_Demetria_Proudmoore_phasethree(pUnit, Event) 
if pUnit:GetHealthPct() < 35 then 
pUnit:RemoveEvents(); 
pUnit:FullCastSpell(47981, 37531, 59357)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_bolt", 21000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Mind_blast", 43000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Shadow_word", 50000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_Unholy_shadow", 57000, 0)
pUnit:RegisterEvent("Cleric_Demetria_Proudmoore_spell_reflection", 67000, 0)
end 
end

function Cleric_Demetria_Proudmoore_OnLeaveCombat(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "This was pathetic, Champions of Azeroth!") 
end

function Cleric_Demetria_Proudmoore_OnDied(Unit, Event) 
Unit:RemoveEvents() 
Unit:SendChatMessage(12, 0, "Damn the.. luck!") 
Unit:PlaySoundToSet(13320)
end

function Cleric_Demetria_Proudmoore_OnKilledTarget(Unit, Event) 
Unit:SendChatMessage(12, 0, "Death becomes you!")
Unit:PlaySoundToSet(13324)
end

RegisterUnitEvent(940811, 1, "Cleric_Demetria_Proudmoore_OnCombat")
RegisterUnitEvent(940811, 2, "Cleric_Demetria_Proudmoore_OnLeaveCombat")
RegisterUnitEvent(940811, 3, "Cleric_Demetria_Proudmoore_OnKilledTarget")
RegisterUnitEvent(940811, 4, "Cleric_Demetria_Proudmoore_OnDied")

If you want the mobs to walk around you need to add the way points by your self!

Download Link for the one that are too lazy to fix it by there own.

Scarlet Hold

Enjoy
//Svedin!

[svedin]

This Sucks i need to post the Sql in this one.

delete from gameobject_spawns where id = '182097';
delete from gameobject_spawns where id = '182098';

INSERT INTO `gameobject_spawns` VALUES ('182097', '101850', '44', '140.655', '10.9788', '18.6772', '0.0227765', '1.06537e+009', '0', '0', '0', '1', '0', '0', '1', '0');
INSERT INTO `gameobject_spawns` VALUES ('182098', '101850', '44', '140.436', '-12.8282', '18.6773', '6.28004', '1.06745e+009', '0', '0', '0', '1', '0', '0', '1', '0');

delete from creature_names where entry = '940810';
delete from creature_proto where entry = '940810';
delete from creature_spawns where id = '6167638';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940810', "High Commander Wrynn", "Ruler of Scarlet Hold", '', '0', '7', '0', '3', '0', '0', '25841', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940810', '80', '80', '14', '8400000', '8400000', '67000', '1.5', '0', '1500', '0', '10000', '14000', '0', '0', '0', '0', '0', '8000', '55', '0', '0', '0', '0', '55', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167638', '940810', '44', '373.852264', '-103.678558', '33.051121', '1.529162', '0', '25841', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '22691', '0', '0');

delete from creature_names where entry = '940811';
delete from creature_proto where entry = '940811';
delete from creature_spawns where id = '6167639';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940811', "Cleric Demetria Proudmoore", "Ruler of Scarlet Hold", '', '0', '7', '0', '3', '0', '0', '10507', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940811', '80', '80', '14', '7900000', '7900000', '67000', '1.5', '0', '1500', '0', '7000', '12000', '0', '0', '0', '0', '0', '8000', '55', '0', '0', '0', '0', '55', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167639', '940811', '44', '372.028046', '-104.260818', '33.051136', '1.645404', '0', '10507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31700', '0', '0');

delete from creature_names where entry = '940801';
delete from creature_proto where entry = '940801';
delete from creature_spawns where id = '6167640';
delete from creature_spawns where id = '6167641';
delete from creature_spawns where id = '6167642';
delete from creature_spawns where id = '6167643';
delete from creature_spawns where id = '6167644';
delete from creature_spawns where id = '6167645';
delete from creature_spawns where id = '6167646';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940801', "Scarlet Hold Magician", "", '', '0', '7', '1', '0', '0', '0', '2518', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940801', '81', '82', '14', '290990', '390990', '45630', '1', '0', '1400', '0', '3000', '9000', '0', '0', '0', '0', '0', '4000', '35', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167640', '940801', '44', '149.643127', '-67.592224', '18.007010', '1.446666', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167641', '940801', '44', '153.992783', '-67.900757', '18.007019', '1.725520', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167642', '940801', '44', '212.721481', '-53.773716', '18.677347', '4.581228', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167643', '940801', '44', '212.887970', '-105.428635', '18.677347', '1.672113', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167644', '940801', '44', '163.414581', '-104.697746', '18.677347', '0.781471', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167645', '940801', '44', '296.739471', '-110.982086', '30.823233', '1.452193', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167646', '940801', '44', '301.837158', '-110.713905', '30.823244', '1.443549', '0', '2518', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '812', '0', '0');

delete from creature_names where entry = '940802';
delete from creature_proto where entry = '940802';
delete from creature_spawns where id = '6167647';
delete from creature_spawns where id = '6167648';
delete from creature_spawns where id = '6167649';
delete from creature_spawns where id = '6167650';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940802', "Scarlet Hold Centurion", "", '', '0', '7', '0', '1', '0', '0', '2499', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940802', '82', '83', '14', '390990', '490990', '45630', '1', '0', '1400', '0', '7000', '13000', '0', '0', '0', '0', '0', '6000', '35', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167647', '940802', '44', '151.879532', '-64.856956', '18.007019', '1.597501', '0', '2499', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12584', '31200', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167648', '940802', '44', '174.700592', '-75.662643', '18.022833', '3.153373', '0', '2499', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12584', '31200', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167649', '940802', '44', '299.679779', '-107.107735', ' 30.823233', '1.573930', '0', '2499', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12584', '31200', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167650', '940802', '44', '192.472809', '-65.303391', ' 18.022829', '1.560586', '0', '2499', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '12584', '31200', '0');

delete from creature_names where entry = '940803';
delete from creature_proto where entry = '940803';
delete from creature_spawns where id = '6167651';
delete from creature_spawns where id = '6167652';
delete from creature_spawns where id = '6167653';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940803', "Scarlet Hold Abbot", "", '', '0', '7', '0', '1', '0', '0', '25545', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940803', '81', '82', '14', '290990', '340000', '45630', '1', '0', '1400', '0', '5000', '9000', '0', '0', '0', '0', '0', '6000', '35', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167651', '940803', '44', '214.636581', '-55.466461', ' 18.677347', '3.169867', '0', '25545', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '34337', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167652', '940803', '44', '214.173279', '-103.374598', ' 18.677347', '3.145520', '0', '25545', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '34337', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167653', '940803', '44', '166.049026', '-105.183327', ' 18.677347', '2.158274', '0', '25545', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '34337', '0', '0');

delete from creature_names where entry = '940804';
delete from creature_proto where entry = '940804';
delete from creature_spawns where id = '6167654';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940804', "Scarlet Hold General", "", '', '0', '7', '0', '1', '0', '0', '10341', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940804', '82', '83', '14', '490990', '540000', '6954', '1', '0', '1400', '0', '9000', '12000', '0', '0', '0', '0', '0', '6000', '55', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167654', '940804', '44', '165.751633', '-102.445297', ' 18.677347', '0.014137', '0', '10341', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '19364', '0', '0');

delete from creature_names where entry = '940805';
delete from creature_proto where entry = '940805';
delete from creature_spawns where id = '6167655';
delete from creature_spawns where id = '6167656';
delete from creature_spawns where id = '6167668';
delete from creature_spawns where id = '6167669';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940805', "Scarlet Hold Praetorian", "", '', '0', '7', '0', '1', '0', '0', '10395', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940805', '82', '83', '14', '390990', '430000', '6954', '1', '0', '1400', '0', '10000', '14000', '0', '0', '0', '0', '0', '6000', '55', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167655', '940805', '44', '184.014999', '-134.345001', ' 18.022800', '0.086708', '0', '10395', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31134', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167656', '940805', '44', '243.854431', '-100.098244', ' 18.677820', '3.188717', '0', '10395', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31134', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167668', '940805', '44', '311.790863', '-53.306725', ' 30.827284', '6.236859', '0', '10395', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31134', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167669', '940805', '44', '331.715881', '-9.186144', ' 30.829443', '3.107295', '0', '10395', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '31134', '0', '0');

delete from creature_names where entry = '940806';
delete from creature_proto where entry = '940806';
delete from creature_spawns where id = '6167657';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940806', "Lord Mataus Shadowbreaker", "Commander of the Scarlet Hold", '', '0', '7', '0', '3', '0', '0', '25808', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940806', '80', '80', '14', '7500000', '7500000', '69540', '1.5', '0', '1400', '0', '10000', '16000', '0', '0', '0', '0', '0', '8000', '0', '0', '0', '0', '55', '0', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167657', '940806', '44', '255.594543', '-99.949776', ' 18.677856', '3.144735', '0', '25808', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '30902', '0', '0');

delete from creature_names where entry = '940812';
delete from creature_proto where entry = '940812';
delete from creature_spawns where id = '6167658';
delete from creature_spawns where id = '6167659';
delete from creature_spawns where id = '6167663';
delete from creature_spawns where id = '6167664';
delete from creature_spawns where id = '6167665';
delete from creature_spawns where id = '6167666';
delete from creature_spawns where id = '6167667';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940812', "Scarlet Hold Guard", "", '', '0', '7', '0', '1', '0', '0', '2476', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940812', '81', '82', '14', '430000', '430000', '6954', '1', '0', '1400', '0', '9000', '12000', '0', '0', '0', '0', '0', '6000', '55', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167658', '940812', '44', '230.739746', '-95.420311', ' 18.007038', '3.196571', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167659', '940812', '44', '230.825058', '-104.178871', '18.007002', '3.196571', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167663', '940812', '44', '304.543854', '-79.715973', '30.823246', '3.301041', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167664', '940812', '44', '293.957977', '-58.682423', '30.823246', '6.166173', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167665', '940812', '44', '370.222504', '-14.819167', '30.824183', '1.600880', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167666', '940812', '44', '378.579803', '-15.128109', '30.824183', '1.626013', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167667', '940812', '44', '357.950867', '-3.628277', '30.824257', '4.746400', '0', '2476', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '32369', '43085', '0');

delete from creature_names where entry = '940813';
delete from creature_proto where entry = '940813';
delete from creature_spawns where id = '6167660';
delete from creature_spawns where id = '6167661';
delete from creature_spawns where id = '6167662';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940813', "Scarlet Hold Disciple", "", '', '0', '7', '0', '1', '0', '0', '2512', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940813', '81', '81', '14', '390990', '390990', '67832', '1', '0', '1500', '0', '6000', '9000', '0', '0', '0', '0', '0', '4000', '55', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167660', '940813', '44', '318.664307', '-42.390202', '30.011228', '3.011228', '0', '2512', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '873', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167661', '940813', '44', '325.561737', '-20.505125', '30.827946', '6.274808', '0', '2512', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '873', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167662', '940813', '44', '302.539001', '-27.416188', '32.370720', '1.432823', '0', '2512', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '873', '0', '0');

delete from creature_names where entry = '940800';
delete from creature_proto where entry = '940800';
delete from creature_spawns where id = '6167670';
delete from creature_spawns where id = '6167671';
delete from creature_spawns where id = '6167672';
delete from creature_spawns where id = '6167673';
delete from creature_spawns where id = '6167674';
delete from creature_spawns where id = '6167675';
delete from creature_spawns where id = '6167676';
delete from creature_spawns where id = '6167677';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) 
values ('940800', "Scarlet Hold Champion", "", '', '0', '7', '0', '0', '0', '0', '25507', '0', '0', '0', '1', '1', '0', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`) 
values ('940800', '81', '82', '14', '390990', '403000', '45630', '1', '0', '1400', '0', '7000', '10000', '0', '0', '0', '0', '0', '5000', '35', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167670', '940800', '44', '381.435455', '-38.552410', '30.828665', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167671', '940800', '44', '378.785461', '-38.539848', '30.828665', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167672', '940800', '44', '370.345551', '-38.499836', '30.828665', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167673', '940800', '44', '367.535553', '-38.486515', '30.828665', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167674', '940800', '44', '367.611542', '-56.863380', '30.829634', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167675', '940800', '44', '370.581543', '-56.877460', '30.829634', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167676', '940800', '44', '378.551453', '-56.915237', '30.829634', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

insert into `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`)
values ('6167677', '940800', '44', '381.511444', '-56.929272', '30.829634', '4.707648', '0', '25507', '14', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '28943', '0', '0');

The Sql for the teleporter.

##################################
# Gameobjects for svedin's repack#
#   -Only for MMOWNED users-     #
##################################

INSERT INTO gameobject_names(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES (892890, 22, 4396, "Alliance mall", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO gameobject_names(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14) VALUES (891890, 22, 4395, "Horde mall", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

and the Lua.

--[[Teleport to Horde Mall]]

function SMCombhorde_onUse (pUnit, Event, pMisc)
pMisc:Teleport (Map, X Y, Z)
end

RegisterGameObjectEvent (891890 ,4, "SMCombhorde_onUse")

--[[Teleport to alliance mall]]

function SMCombally_onUse (pUnit, Event, pMisc)
pMisc:Teleport (Map, X Y, Z)
end

RegisterGameObjectEvent (892890 ,4, "SMCombally_onUse")

[Appled]

Wow! Great job! +Rep2x!

[alj03]

Awsome +rep :P

[fastelf]

Very good release! +rep

[svedin]

Thanks for the comments :P

[aziz]

Good Job ... Will Try it on my Server :P +Rep x2

[Link_S]

Really nice ! +Rep

[sasoritail]

YESSS Been Wating for it all since the Video on YouTube.
Guys check it out!
[ame=http://www.youtube.com/watch?v=qNOh4sg7P5I]YouTube - Scarlet Hold Boss Fight[/ame]
Remember to watch in HQ!!!

+Rep Fro awesomme Work m8!

Edit: Have to spread sorry.

[Zudrik]

Finally someone did something with ths place, +Rep

[svedin]

Yes, i thought that some one want a blizz-like instance, at that place. so the bosses arent overpower.

[Thelordofsummon]

That's great, one of the best scripted istances I've never seen.
But...seriously...put some SERIOUS effort in that grammar.

EDIT: +rep, ofc.

[Gastricpenguin]

Imo the bosses have too much health for a 5 man instance.

[Aldun]

Stupid question: did I do it right ^^? And if so, where do I go to enter this instance? Just with a .recall port command?

Anyway, what I did, I copied the SQL from the second post and copied it into Navicat, it ran and said '' Affected rows: 1
Time: 0.000ms
''

What means, successfull =).
So, how do I enter it :O? Thanks

[aquariox]

thanks for the release....