summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-12-22 00:29:06 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-12-22 00:29:06 +0100
commit1f3dda4623ce6fe083b59992ac721bbde6c020b4 (patch)
tree0e61bac3b22168e38380232ea2ff3aefae664f8d
parent2a16362eed204dde33e5b0638373d67d1c6828ee (diff)
downloadhercules-1f3dda4623ce6fe083b59992ac721bbde6c020b4.tar.gz
hercules-1f3dda4623ce6fe083b59992ac721bbde6c020b4.tar.bz2
hercules-1f3dda4623ce6fe083b59992ac721bbde6c020b4.tar.xz
hercules-1f3dda4623ce6fe083b59992ac721bbde6c020b4.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
-rw-r--r--sql-files/item_db_re.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 5507cb5e3..65562d6be 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -1246,7 +1246,7 @@ REPLACE INTO `item_db` VALUES ('2017','Divine_Cross_','Divine Cross','4','20','1
REPLACE INTO `item_db` VALUES ('2018','Metal_Staff','Metal Staff','4','20','10','0','50','70','0','1','1','8487701','63','2','34','3','0',NULL,'1','23','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; if(BaseJob==Job_Wizard) bonus bMatk,15; else if(BaseJob==Job_Sage) bonus bMatk,10; bonus bMatk,(getrefine()*5); .@val = min(BaseLevel/10, 12); if (.@val > 2) { bonus bMatk,((.@val-2)*5); }','','');
REPLACE INTO `item_db` VALUES ('2019','TE_Woe_Two_Hand_Staff','TE Woe Two Hand Staff','4','20','10','0','50','130','0','1','0','8487701','63','2','34','3','40',NULL,'0','23','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Player,20; bonus bHealPower,5; bonus2 bAddEff,Eff_Stun,1000;','','');
REPLACE INTO `item_db` VALUES ('2020','Jormungand','Jormungand','5','20','10','3000','200','280','0','1','0','8454656','63','2','34','4','90',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,20; bonus bAtkEle,Ele_Poison; bonus3 bAddEff,Eff_Poison,300,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Poison,100; bonus bUnbreakableWeapon,0;','','');
-REPLACE INTO `item_db` VALUES ('2021','Ganbantein','Ganbantein','5','20','10','2000','100','320','0','1','0','512','56','2','34','4','100',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,25; bonus bDex,25; bonus5 bAutoSpell,\"AB_SILENTIUM\",1,100,BF_MAGIC,1; bonus3 bAddEff,Eff_Poison,100,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Silence,10000; bonus bUnbreakableWeapon,0;','','');
+REPLACE INTO `item_db` VALUES ('2021','Ganbantein','Ganbantein','5','20','10','2000','100','320','0','1','0','512','56','2','34','4','100',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,25; bonus bDex,25; bonus5 bAutoSpell,AB_SILENTIUM,1,100,BF_MAGIC,1; bonus3 bAddEff,Eff_Poison,100,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Silence,10000; bonus bUnbreakableWeapon,0;','','');
REPLACE INTO `item_db` VALUES ('2022','Staff_Of_Geffen','Staff Of Geffen','5','20','10','1000','100','300','0','0','1','512','56','2','34','1','150',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,20;','','');
REPLACE INTO `item_db` VALUES ('2023','Thanatos_Two-Handed_Staff','Thanatos Two-Handed Staff','4','20','10','1400','120','250','0','1','1','99092','56','2','34','4','120',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,6; bonus bVit,6; bonus bLuk,-6; bonus2 bSPDrainRate,10,5; bonus2 bHPDrainRate,10,5; bonus2 bHPLossRate,100,10000; bonus bHealPower,18;','','heal -1000,0;');
REPLACE INTO `item_db` VALUES ('2024','Infinity_Staff','Infinity Staff','5','20','10','500','30','170','0','0','1','8454656','56','2','34','4','100',NULL,'1','23','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -1333,7 +1333,7 @@ REPLACE INTO `item_db` VALUES ('2178','TE_WoE_Buckler','TE WoE Buckler','5','0',
REPLACE INTO `item_db` VALUES ('2179','TE_WoE_Shield','TE WoE Shield','5','0','0','0','0','0','25','0','0','16514','63','2','32','0','40',NULL,'0','3','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus bMaxHP,200; bonus2 bSubRace,RC_Player,20;','','');
REPLACE INTO `item_db` VALUES ('2180','TE_WoE_Magic_Guard','TE WoE Magic Guard','5','0','0','0','0','0','5','0','0','8487701','63','2','32','0','40',NULL,'0','3','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,25; bonus bMaxSP,200; bonus2 bSubRace,RC_Player,10;','','');
REPLACE INTO `item_db` VALUES ('2181','Hervor','Hervor','5','20','10','1500','0','0','100','0','0','4294967295','63','2','32','0','90',NULL,'0','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bSubRace,RC_All,30; bonus bUnbreakableShield,1;','','');
-REPLACE INTO `item_db` VALUES ('2182','Hervor_Alvitr','Hervor Alvitr','5','20','10','3000','0','0','150','0','0','4294967295','56','2','32','0','100',NULL,'0','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,20; bonus bMdef,10; bonus2 bAddRaceTolerance,RC_All,30; bonus3 bAutoSpellWhenHit,\"ALL_RAY_OF_PROTECTION\",1,50; bonus bUnbreakableShield,1;','','');
+REPLACE INTO `item_db` VALUES ('2182','Hervor_Alvitr','Hervor Alvitr','5','20','10','3000','0','0','150','0','0','4294967295','56','2','32','0','100',NULL,'0','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,20; bonus bMdef,10; bonus2 bAddRaceTolerance,RC_All,30; /* TODO: bonus3 bAutoSpellWhenHit,\"ALL_RAY_OF_PROTECTION\",1,50; */ bonus bUnbreakableShield,1;','','');
REPLACE INTO `item_db` VALUES ('2183','Adv_Angel\'s_Safeguard','Advanced Angelic Guard','5','10000','5000','400','0','0','30','0','1','1','47','2','32','0','99',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRaceTolerance,RC_Demon,5; bonus2 bSubEle,Ele_Water,5; bonus2 bSubEle,Ele_Earth,5; bonus2 bSubEle,Ele_Fire,5; bonus2 bSubEle,Ele_Wind,5; bonus2 bSubEle,Ele_Poison,5; bonus2 bSubEle,Ele_Ghost,5; bonus2 bSubEle,Ele_Holy,5; bonus2 bSubEle,Ele_Dark,5; bonus2 bSubEle,Ele_Undead,5;','','');
REPLACE INTO `item_db` VALUES ('2185','Magic_Reflector','Magic Reflector','5','20','10','1000','0','0','50','0','1','4294967295','63','2','32','0','99',NULL,'0','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bMagicDamageReturn,3+((getrefine()>=9)?3:0);','','');
REPLACE INTO `item_db` VALUES ('2186','Revised_Encyclopedia','Revised Encyclopedia','5','20','10','1000','0','0','50','0','1','4260096','63','2','32','0','99',NULL,'1','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,5; bonus bInt,3; bonus bDex,2; bonus bCritical,3; if (getrefine()>6) bonus bCritical,2; if (getrefine()>8) bonus bMatk,5;','','');
@@ -2071,7 +2071,7 @@ REPLACE INTO `item_db` VALUES ('2944','TE_Ring_of_Protection','TE Ring of Protec
REPLACE INTO `item_db` VALUES ('2945','TE_Ring_Of_Rage','TE Rage Of Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,5; bonus2 bMagicAddRace,RC_Player,5;','','');
REPLACE INTO `item_db` VALUES ('2946','TE_Ring_Of_Defiance','TE Ring Of Defiance','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bAddRaceTolerance,RC_Player,5;','','');
REPLACE INTO `item_db` VALUES ('2950','Rune_Ring','Rune Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','1','100','0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace, RC_All, 10;','','');
-REPLACE INTO `item_db` VALUES ('2951','Kvasir_Ring_Blue','Kvasir Ring Blue','5','20000','10000','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,30; skill \"ECL_SNOWFLIP\",1;','','');
+REPLACE INTO `item_db` VALUES ('2951','Kvasir_Ring_Blue','Kvasir Ring Blue','5','20000','10000','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,30; skill ECL_SNOWFLIP,1;','','');
REPLACE INTO `item_db` VALUES ('2952','Kvasir_Ring_Red','Kvasir Ring Red','5','20000','10000','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,30; skill \"ECL_PEONYMAMY\",1;','','');
REPLACE INTO `item_db` VALUES ('2953','Kvasir_Ring_Green','Kvasir Ring Green','5','20000','10000','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,100; skill \"ECL_SADAGUI\",1;','','');
REPLACE INTO `item_db` VALUES ('2954','Kvasir_Ring_Brown','Kvasir Ring Brown','5','20000','10000','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,100; skill \"ECL_SEQUOIADUST\",1;','','');