-- delete from spawnlist where npc_templateid = 29019;	-- Antharas
-- delete from spawnlist where npc_templateid = 29025;	-- Baium
-- delete from spawnlist where npc_templateid = 29066;	-- Antharas
-- delete from spawnlist where npc_templateid = 29067;	-- Antharas
-- delete from spawnlist where npc_templateid = 29068;	-- Antharas
-- delete from spawnlist where npc_templateid = 29020;	-- Baium
-- delete from spawnlist where npc_templateid = 29028;	-- Valakas
-- delete from spawnlist where npc_templateid = 29021;	-- Archangel
-- delete from spawnlist where npc_templateid = 31759;	-- Teleportation Cubic
-- delete from spawnlist where npc_templateid = 31859;	-- Teleportation Cubic
-- 
update npc set aggro = 500 where id = 29014 and aggro = 0;	-- Orfen (aggro=500)
update npc set aggro = 500 where id = 29020 and aggro = 0;	-- Baium (aggro=0)
update npc set aggro = 500 where id = 29021 and aggro = 0;	-- Archangel (aggro=0)
update npc set aggro = 500 where id = 29022 and aggro = 0;	-- Zaken (aggro=1000)
update npc set aggro = 800 where id = 29028;              	-- Valakas (aggro=4096)

Delete From teleport where id in (20001,20002);
INSERT INTO teleport
  (Description, id, loc_x, loc_y, loc_z, price, fornoble)
VALUES
  ("Lair of Baium -> Town of Aden", 20001, 146331, 25762, -2018, 0, 0),
  ("Lair of Valakas -> Town of Goddard", 20002, 147928, -55273, -2734, 0, 0);

-- update npc Set `type` = "L2Teleporter" Where idTemplate = 31759;
