From 883bf494656473ac23f3e7087bbfa58a36b7ae3f Mon Sep 17 00:00:00 2001 From: euphyy Date: Sat, 8 Sep 2012 19:58:00 +0000 Subject: * Updated Renewal 'Mjolnir' item (bugreport:6646) * Updated slots on RWC 2008 Dragon Helms (bugreport:6645) * Other minor changes... git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16765 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/item_db.sql | 6 +++--- sql-files/item_db_re.sql | 8 ++++---- 2 files changed, 7 insertions(+), 7 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 2311a9d0f..8e9e4d263 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -2649,9 +2649,9 @@ REPLACE INTO `item_db` VALUES (5447,'Frog_Cap','Frog Hat',5,20,NULL,500,NULL,3,N REPLACE INTO `item_db` VALUES (5448,'Solo_Play_Box1','Soloplay Box1',5,NULL,NULL,300,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,769,NULL,NULL,1,449,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (5449,'Solo_Play_Box2','Soloplay Box2',5,NULL,NULL,300,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,769,NULL,NULL,1,450,NULL,NULL,NULL); REPLACE INTO `item_db` VALUES (5450,'Sun_Cap','Solar Hat',5,20,NULL,1000,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,20,1,451,NULL,NULL,NULL); -REPLACE INTO `item_db` VALUES (5451,'Dragonhelm_Gold','RWC 2008 Dragon Helm Gold',5,20,NULL,2500,NULL,7,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,1,NULL,452,'bonus bAspdRate,10; bonus bAllStats,3; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); -REPLACE INTO `item_db` VALUES (5452,'Dragonhelm_Silver','RWC 2008 Dragon Helm Silver',5,20,NULL,2500,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,1,NULL,453,'bonus bAspdRate,7; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,3;',NULL,NULL); -REPLACE INTO `item_db` VALUES (5453,'Dragonhelm_Copper','RWC 2008 Dragon Helm Copper',5,20,NULL,2500,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,1,NULL,454,'bonus bAspdRate,5; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,1;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5451,'Dragonhelm_Gold','RWC 2008 Dragon Helm Gold',5,20,NULL,2500,NULL,7,NULL,1,0xFFFFFFFF,7,2,256,NULL,1,NULL,452,'bonus bAspdRate,10; bonus bAllStats,3; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5452,'Dragonhelm_Silver','RWC 2008 Dragon Helm Silver',5,20,NULL,2500,NULL,5,NULL,1,0xFFFFFFFF,7,2,256,NULL,1,NULL,453,'bonus bAspdRate,7; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,3;',NULL,NULL); +REPLACE INTO `item_db` VALUES (5453,'Dragonhelm_Copper','RWC 2008 Dragon Helm Copper',5,20,NULL,2500,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,256,NULL,1,NULL,454,'bonus bAspdRate,5; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,1;',NULL,NULL); REPLACE INTO `item_db` VALUES (5454,'Dog_Cap_','Puppy Hat',5,20,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,234,'bonus bStr,1; bonus bInt,1; autobonus "{bonus bCritical,100;}",10,3000,BF_WEAPON,"{specialeffect2 EF_ENHANCE;}"; autobonus "{bonus bIgnoreMdefRate,100;}",10,3000,BF_MAGIC,"{specialeffect2 EF_MAGICALATTHIT;}";',NULL,NULL); REPLACE INTO `item_db` VALUES (5455,'Geographer_Band_','Decorative Geographer',5,20,NULL,500,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,238,'bonus bInt,1; bonus3 bAutoSpell,"AL_HEAL",5,50; bonus3 bAutoSpellWhenHit,"AL_HEAL",5,30;',NULL,NULL); REPLACE INTO `item_db` VALUES (5456,'Vacation_Hat_','Summer Hat',5,20,NULL,200,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,315,'bonus bVit,5; bonus bHPrecovRate,20; bonus bSPrecovRate,15;',NULL,NULL); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 20f1f7f8b..a2fdc148e 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -857,7 +857,7 @@ REPLACE INTO `item_db_re` VALUES (1526,'Slash','Slash',4,20,NULL,1000,'145',NULL REPLACE INTO `item_db_re` VALUES (1527,'Quadrille','Quadrille',4,20,NULL,900,'165',NULL,1,NULL,0x00008110,7,2,2,4,'40',1,8,'bonus2 bAddRace,RC_Undead,10; bonus2 bAddRace,RC_DemiHuman,10; bonus2 bAddEle,Ele_Earth,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1528,'Grand_Cross','Grand Cross',4,20,NULL,1500,'140',NULL,1,NULL,0x00008110,7,2,2,4,'40',1,8,'bonus bAtkEle,Ele_Holy; skill "PR_TURNUNDEAD",3; bonus3 bAutoSpell,"PR_TURNUNDEAD",3,100; bonus2 bSPDrainValueRace,RC_Undead,1; bonus2 bSPGainRace,RC_Undead,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1529,'Iron_Driver','Iron Driver',4,20,NULL,3000,'155',NULL,2,NULL,0x00008100,7,2,2,3,'78',1,8,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1530,'Mjolnir','Mjolnir',4,20,NULL,6000,'250',NULL,1,NULL,0x000444A2,7,2,2,4,'95',NULL,8,'bonus bAtkEle,Ele_Wind; bonus bDex,40; bonus bStr,15; bonus bAspdRate,10; bonus bUnbreakableWeapon,0;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1530,'Mjolnir','Mjolnir',4,20,NULL,6000,'350',NULL,1,NULL,0x000444A2,7,2,2,4,'95',NULL,8,'bonus bAtkEle,Ele_Wind; bonus bDex,50; bonus bStr,20; bonus bAspdRate,10; autobonus "{bonus bSplashRange,1;}",50,10000;}',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1531,'Spanner','Wrench',4,20,NULL,2500,'115',NULL,1,NULL,0x00008110,7,2,2,3,'55',1,8,'bonus2 bAddEff,Eff_Blind,100; bonus2 bAddEff,Eff_Stun,100; bonus2 bAddEff,Eff_Poison,100; bonus2 bAddEff,Eff_Freeze,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1532,'Stunner_','Stunner',4,60000,NULL,2000,'140',NULL,1,2,0x00008110,7,2,2,3,'27',1,8,'bonus2 bAddEff,Eff_Stun,1000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1533,'Warrior_Balmung','Warrior\'s Balmung',4,20,NULL,1000,'170',NULL,1,NULL,0xFFFFFFFF,7,2,2,4,'48',1,8,'bonus bAllStats,5;',NULL,NULL); @@ -3059,9 +3059,9 @@ REPLACE INTO `item_db_re` VALUES (5447,'Frog_Cap','Frog Hat',5,20,NULL,500,NULL, REPLACE INTO `item_db_re` VALUES (5448,'Solo_Play_Box1','Soloplay Box1',5,NULL,NULL,300,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,769,NULL,NULL,1,449,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5449,'Solo_Play_Box2','Soloplay Box2',5,NULL,NULL,300,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,769,NULL,NULL,1,450,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5450,'Sun_Cap','Solar Hat',5,20,NULL,1000,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'20',1,451,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5451,'Dragonhelm_Gold','RWC 2008 Dragon Helm Gold',5,20,NULL,2500,NULL,7,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',NULL,452,'bonus bAspdRate,10; bonus bAllStats,3; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5452,'Dragonhelm_Silver','RWC 2008 Dragon Helm Silver',5,20,NULL,2500,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',NULL,453,'bonus bAspdRate,7; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5453,'Dragonhelm_Copper','RWC 2008 Dragon Helm Copper',5,20,NULL,2500,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',NULL,454,'bonus bAspdRate,5; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5451,'Dragonhelm_Gold','RWC 2008 Dragon Helm Gold',5,20,NULL,2500,NULL,7,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',NULL,452,'bonus bAspdRate,10; bonus bAllStats,3; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5452,'Dragonhelm_Silver','RWC 2008 Dragon Helm Silver',5,20,NULL,2500,NULL,5,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',NULL,453,'bonus bAspdRate,7; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,3;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5453,'Dragonhelm_Copper','RWC 2008 Dragon Helm Copper',5,20,NULL,2500,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',NULL,454,'bonus bAspdRate,5; bonus bAllStats,2; bonus2 bAddRace,RC_DemiHuman,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5454,'Dog_Cap_','Puppy Hat',5,20,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,234,'bonus bStr,1; bonus bInt,1; autobonus "{bonus bCritical,100;}",10,3000,BF_WEAPON,"{specialeffect2 EF_ENHANCE;}"; autobonus "{bonus bIgnoreMdefRate,100;}",10,3000,BF_MAGIC,"{specialeffect2 EF_MAGICALATTHIT;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5455,'Geographer_Band_','Decorative Geographer',5,20,NULL,500,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,238,'bonus bInt,1; bonus3 bAutoSpell,"AL_HEAL",5,50; bonus3 bAutoSpellWhenHit,"AL_HEAL",5,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5456,'Vacation_Hat_','Summer Hat',5,20,NULL,200,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,315,'bonus bVit,5; bonus bHPrecovRate,20; bonus bSPrecovRate,15;',NULL,NULL); -- cgit v1.2.3-70-g09d2