-- serverSideName, serverSideTitle
UPDATE custom_npc SET name='アンドロメダ',title='結婚管理人' WHERE id=50007;
UPDATE custom_npc SET name='カトリーナ',title='TvT イベント管理人' WHERE id=70010;
UPDATE custom_npc SET name='シエラ',title='NPCバッファ' WHERE id=1000003;
-- eventmod Elpies
UPDATE custom_npc SET name='エルピー',title='' WHERE id=900100;
-- eventmod Rabbits
UPDATE custom_npc SET name='スノー',title='イベント進行役' WHERE id=900101;
UPDATE custom_npc SET name='イベント宝箱',title='' WHERE id=900102;
-- eventmod Race
UPDATE custom_npc SET name='スタート',title='イベント進行役' WHERE id=900103;
UPDATE custom_npc SET name='ゴール',title='イベント進行役' WHERE id=900104;

-- xmass tree
UPDATE npc SET type='L2XmassTree' WHERE id IN (13006, 13007) AND type='L2Npc';
-- kotatsu
UPDATE npc SET type='L2Kotatsu' WHERE id=28 AND type='L2Npc';
UPDATE npc SET collision_height=0 WHERE id=28;

-- FIX: pig
UPDATE npc SET collision_height=18.3 WHERE id IN (13031, 13032, 13033, 13035);

-- FIX: Heart of Warding (spawn anthras)
UPDATE spawnlist SET heading=28764 WHERE npc_templateid=13001 AND locx=154695 AND locy=121097 AND heading=0;
-- FIX: Oren Castle Holy Artifact
UPDATE spawnlist SET heading=32768 WHERE npc_templateid=35189 AND locx=84014 AND locy=37184 AND heading=0;
-- FIX: Doctor Chaos' Secret Bookshelf
UPDATE spawnlist SET locx=96317,locy=-110427,locz=-3339 WHERE npc_templateid=32045 AND locx=96352 AND locy=-110320 AND locz=-3305;
-- FIX: Weathermaster (west)
UPDATE spawnlist SET locx=86096,locy=-105825,locz=-3313 WHERE npc_templateid=32044 AND locx=88625 AND locy=-106126 AND locz=-3327;
-- FIX: Mr. Cat (Town of Goddard)
UPDATE spawnlist SET locx=147233,locy=-56434,heading=15230 WHERE npc_templateid=31756 AND locx=147262 AND locy=-56450;

-- FIX: Corpse of Deadman
UPDATE npcAIData SET ai_type='corpse' WHERE npc_id=18119;

-- FIX: Breath of Halisha. fighter/mage
UPDATE npcaidata SET ai_type='fighter' WHERE npc_id=29050;
UPDATE npcaidata SET ai_type='mage'    WHERE npc_id=29051;
DELETE FROM npcskills WHERE npcid=29050 AND skillid=5010;
DELETE FROM npcskills WHERE npcid=29051 AND skillid=5009;
