-- Update Npc
UPDATE npc SET `type` = 'L2GrandBoss', rhand = 8208 WHERE id = 29062;	-- Andreas Van Halter
UPDATE npc SET rhand = 8208 WHERE id = 29063;	-- Andreas' Acolyte
UPDATE npc SET rhand = 8207, lhand = 8207 WHERE id = 29064;	-- Andreas' Acolyte
UPDATE npcaidata SET clan = "VANHALTER", clanRange = 1800 WHERE npcId IN (22191,22192,22193,29062);
UPDATE npc SET `type` = 'L2Monster', walkspd = 0 ,runspd = 0 WHERE id IN (32051,32058,32059,32060,32061,32062,32063,32064,32065,32066,32067,32068);	-- Altar Gatekeeper & Triol's Revelation
UPDATE npc SET collision_radius = 8, collision_height = 22, walkspd = 0 ,runspd = 0 WHERE id = 29059; -- camera dummy

UPDATE npcaidata SET aggro = 0 WHERE npcId = 29062;	-- Andreas Van Halter (aggro=500)
UPDATE npcaidata SET aggro = 0 WHERE npcId = 29063;	-- Andreas' Acolyte (aggro=0)
UPDATE npcaidata SET aggro = 0 WHERE npcId = 29064;	-- Andreas' Acolyte(aggro=0)
UPDATE npcaidata SET aggro = 500 WHERE npcId IN (32051,32058,32059,32060,32061,32062,32063,32064,32065,32066,32067,32068);	-- Altar Gatekeeper & Triol's Revelation (aggro=0)
UPDATE npcaidata SET canMove = 0, aggro = 0 WHERE npcId = 29059; -- camera dummy

-- Update minions
DELETE FROM minions WHERE boss_id IN (29062, 22188, 22191);
INSERT INTO minions
  (boss_id, minion_id, amount_min, amount_max)
VALUES
  (29062, 29063, 1, 1),
  (29062, 29064, 3, 3),
  (22188, 22189, 4, 4),
  (22188, 22190, 1, 1),
  (22191, 22192, 1, 1),
  (22191, 22193, 1, 1);

-- Update spawnlist
DELETE FROM raidboss_spawnlist WHERE boss_id = 29062;
DELETE FROM spawnlist WHERE npc_templateId IN
 (22175,22176,22188,22189,22190,22191,22192,22193,22195,29062,29063,29064,32038,32051,32058,32059,32060,32061,32062,32063,32064,32065,32066,32067,32068);
