-- 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
-- L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2XmassTreeInstance.java
UPDATE npc SET type='L2XmassTree' WHERE id IN (13006, 13007) AND type='L2Npc';
-- kotatsu
-- L2J_Server/java/com/l2jserver/gameserver/model/actor/instance/L2KotatsuInstance.java
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: PriestOfBlessing.java Priest of Blessing (spawn Orc,DE,Elf)
DELETE FROM spawnlist WHERE npc_templateid=32783;
-- High Five ToIVortex
UPDATE spawnlist SET locx=114205,locy=13425,locz=-5096 WHERE npc_templateid=30949 AND locx=110831 AND locy=15973 AND locz=-4368;
UPDATE spawnlist SET locx=114180,locy=13340,locz=-5096 WHERE npc_templateid=30952 AND locx=110828 AND locy=15934 AND locz=-4384;

-- FIX: Breath of Halisha. fighter/mage
-- L2J_DataPack/data/scripts/ai/individual/Frintezza.java
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;

-- FIX: Victim
-- core support L2AttackableAI#thinkAttack
UPDATE npcaidata SET clan='victim',clan_range=0 WHERE npc_id IN (18150,18151,18152,18153,18154,18155,18156,18157);

-- FIX: Squash
-- L2J_DataPack/data/scripts/events/SquashEvent/SquashEvent.java
-- http://www.l2jserver.com/forum/viewtopic.php?f=46&t=15594
DELETE FROM npcskills              WHERE npcid IN (12774,12775,12776,12777,12778,12779,13016,13017);
-- DELETE FROM npcAIData             WHERE npc_id IN (12774,12775,12776,12777,12778,12779,13016,13017);
UPDATE npc SET type='L2ChronoMonster' WHERE id IN (12774,12775,12776,12777,12778,12779,13016,13017);

UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12774; -- 幼いポモナ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12775; -- 良質なポモナ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12776; -- 不良なポモナ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=13016; -- 超良質なポモナ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12777; -- 幼い大きなポモナ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12778; -- 良質な大きなポモナ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=12779; -- 不良な大きなポモナ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=9,pdef=15,matk=0,mdef=32 WHERE id=13017; -- 超良質な大きなポモナ

-- FIX: Watermelon
-- L2J_DataPack/data/scripts/events/Watermelon/Watermelon.java
DELETE FROM npcskills             WHERE  npcid IN (13271,13272,13273,13274,13275,13276,13277,13278);
-- DELETE FROM npcAIData             WHERE npc_id IN (13271,13272,13273,13274,13275,13276,13277,13278);
UPDATE npc SET type='L2ChronoMonster' WHERE id IN (13271,13272,13273,13274,13275,13276,13277,13278);

UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13271; -- 幼い大きなスイカ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13272; -- 不良な大きなスイカ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13273; -- 良質な大きなスイカ
UPDATE npc SET level=1,hp=300 ,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13274; -- 超良質な大きなスイカ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13275; -- 幼い大きな甘いスイカ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13276; -- 不良な大きな甘いスイカ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13277; -- 良質な大きな甘いスイカ
UPDATE npc SET level=1,hp=3000,mp=0,hpreg=0,mpreg=0,str=10,con=10,dex=10,`int`=10,wit=10,men=10,patk=0,pdef=15,matk=0,mdef=32 WHERE id=13278; -- 超良質な大きな甘いスイカ
