Code:
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.