summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <dev@herc.ws>2016-11-02 10:48:37 +0100
committerHerculesWSAPI <dev@herc.ws>2016-11-02 10:48:37 +0100
commit423d148f614c2f8fa91d669c8d5361ee6e01ac27 (patch)
tree34e9931f3b34a2b6d5e9bfca3ae978c513364b60 /sql-files
parentb1041fbf2baca8b4e215991180ea59517ae070d9 (diff)
downloadhercules-423d148f614c2f8fa91d669c8d5361ee6e01ac27.tar.gz
hercules-423d148f614c2f8fa91d669c8d5361ee6e01ac27.tar.bz2
hercules-423d148f614c2f8fa91d669c8d5361ee6e01ac27.tar.xz
hercules-423d148f614c2f8fa91d669c8d5361ee6e01ac27.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 1ee78f4bd..9ce737181 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -8061,7 +8061,7 @@ REPLACE INTO `item_db` VALUES ('16006','Tourist_Mace','Traveler\'s Mace','4','0'
REPLACE INTO `item_db` VALUES ('16007','Mjolnir_C','Ephemeral Mjolnir','4','20','10','0','250','0','0','1','0','279714','63','2','2','4','95',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Wind; bonus bStr,15; bonus bDex,40;','','');
REPLACE INTO `item_db` VALUES ('16008','F_Spanner_C','Rental Wrench','4','2','1','0','150','0','0','1','0','33040','63','2','2','3','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('16009','E_Spanner_C','E Spanner C','4','2','1','0','150','0','0','1','0','33040','63','2','2','3','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('16010','Red_Ether_Bag','Red Ether Bag','4','20','10','1000','15','100','0','1','1','262144','56','2','2','3','102',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(getrefine()>=6) { bonus2 bSkillAtk,GN_CRAZYWEED,20+((getrefine()-5)*2); bonus2 bSkillAtk,GN_DEMONIC_FIRE,20+((getrefine()-5)*2); } else { bonus2 bSkillAtk,GN_CRAZYWEED,20; bonus2 bSkillAtk,GN_DEMONIC_FIRE,20; }','','');
+REPLACE INTO `item_db` VALUES ('16010','Red_Ether_Bag','Red Ether Bag','4','20','10','1000','15','100','0','1','1','262144','56','2','2','3','102',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (getrefine() >= 6) { bonus2 bSkillAtk, GN_CRAZYWEED_ATK, 20 + ((getrefine()-5)*2); bonus2 bSkillAtk, GN_DEMONIC_FIRE, 20 + ((getrefine()-5)*2); } else { bonus2 bSkillAtk, GN_CRAZYWEED_ATK, 20; bonus2 bSkillAtk, GN_DEMONIC_FIRE, 20; }','','');
REPLACE INTO `item_db` VALUES ('16011','Adventure_Mace','Adventure Mace','4','0','0','0','60','0','0','1','0','33040','63','2','2','1','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('16012','Academy_Mace','Academy Mace','4','0','0','1000','110','0','0','1','1','33040','63','2','2','1','0',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('16013','Mace_Of_Judgement','Mace Of Judgement','4','20','10','1200','140','180','0','1','2','256','56','2','2','3','100',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; autobonus \"{ bonus2 bMagicAddRace,RC_Demon,20; }\",30,7000,BF_MAGIC,\"{ specialeffect2 EF_SPELLBREAKER; }\"; autobonus \"{ bonus2 bAddRace,RC_Demon,20; }\",5,7000,BF_WEAPON,\"{ specialeffect2 EF_ENHANCE; }\";','','');
@@ -8762,7 +8762,7 @@ REPLACE INTO `item_db` VALUES ('18790','Rainbow_Poring_Hat','Rainbow Poring Hat'
REPLACE INTO `item_db` VALUES ('18791','Shrine_Maiden_Hat','Shrine Maiden Hat','5','0','0','200','0','0','30','0','1','256','56','2','256','0','100',NULL,'1','908','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,PR_MAGNUS,30; bonus2 bSkillAtk,PR_MAGNUS,(getrefine()/2)*5; if(getrefine()>6) { bonus3 bAutoSpellWhenHit,AL_HEAL,max(getskilllv(AL_HEAL),1),50; } if(getrefine()>8) { bonus bFixedCastrate,-1; }','','');
REPLACE INTO `item_db` VALUES ('18792','Indonesian_Id_Sakkat','Indonesian Id Sakkat','5','0','0','400','0','0','1','0','0','18446744073709551614','63','2','256','0','45',NULL,'1','901','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,10; bonus2 bAddRaceTolerance,RC_DemiPlayer,10; bonus bMatkRate,5; bonus bAtkRate,5;','','');
REPLACE INTO `item_db` VALUES ('18793','Sorc_Night_Cap','Sorc Night Cap','5','0','0','200','0','0','25','0','1','65536','56','2','256','0','100',NULL,'1','911','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus2 bSkillAtk,MG_FIREBOLT,50; bonus2 bSkillAtk,MG_LIGHTNINGBOLT,50; bonus2 bSkillAtk,MG_COLDBOLT,50; if(getrefine()>6) { bonus2 bSkillAtk,SO_SPELLFIST,25; } if(getrefine()>8) { bonus bAspd,5; }','','');
-REPLACE INTO `item_db` VALUES ('18794','Plain_Black_Mage_Hat','Plain Black Mage Hat','5','0','0','200','0','0','15','0','1','512','56','2','256','0','100',NULL,'1','912','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,WL_CRIMSONROCK,5; bonus2 bSkillAtk,WL_JACKFROST,5; bonus2 bSkillAtk,WL_EARTHSTRAIN,5; bonus2 bSkillAtk,WL_CHAINLIGHTNING,5; bonus2 bIgnoreMdefRate,RC_NonBoss,10; bonus2 bIgnoreMdefRate,RC_NonBoss,getrefine()*2; if(getrefine()>6) { bonus2 bSkillAtk,WL_CRIMSONROCK,5; bonus2 bSkillAtk,WL_JACKFROST,5; bonus2 bSkillAtk,WL_EARTHSTRAIN,5; bonus2 bSkillAtk,WL_CHAINLIGHTNING,5; } if(getrefine()>8) { bonus bMatkRate,5; }','','');
+REPLACE INTO `item_db` VALUES ('18794','Plain_Black_Mage_Hat','Plain Black Mage Hat','5','0','0','200','0','0','15','0','1','512','56','2','256','0','100',NULL,'1','912','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk, WL_CRIMSONROCK, 5; bonus2 bSkillAtk, WL_JACKFROST, 5; bonus2 bSkillAtk, WL_EARTHSTRAIN, 5; bonus2 bSkillAtk, WL_CHAINLIGHTNING_ATK, 5; bonus2 bIgnoreMdefRate, RC_NonBoss, 10; bonus2 bIgnoreMdefRate, RC_NonBoss, getrefine() * 2; if (getrefine() > 6) { bonus2 bSkillAtk, WL_CRIMSONROCK, 5; bonus2 bSkillAtk, WL_JACKFROST, 5; bonus2 bSkillAtk, WL_EARTHSTRAIN, 5; bonus2 bSkillAtk, WL_CHAINLIGHTNING_ATK, 5; } if (getrefine() > 8) { bonus bMatkRate, 5; }','','');
REPLACE INTO `item_db` VALUES ('18795','Night_Sparrow_Hat','Night Sparrow Hat','5','0','0','200','0','0','15','0','0','524288','56','2','256','0','100',NULL,'1','913','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFixedCastrate,-(getskilllv(BA_MUSICALLESSON)*5); if(getrefine()>6) { bonus2 bSkillAtk,WM_SEVERE_RAINSTORM_MELEE,25; } if(getrefine()>8) { bonus bMaxSP,200; }','','');
REPLACE INTO `item_db` VALUES ('18796','RWC_Crown_Of_Victory(8th)','RWC Crown Of Victory(8th)','5','0','0','500','0','0','12','0','1','18446744073709551615','63','2','256','0','0',NULL,'1','914','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,2; bonus2 bResEff,Eff_Curse,10000; bonus bUnbreakableHelm,0;','','');
REPLACE INTO `item_db` VALUES ('18797','Deep_Angel_Hairband','Deep Angel Hairband','5','0','0','100','0','0','4','0','1','18446744073709551614','63','2','256','0','0',NULL,'1','915','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bLuk,1; bonus bMdef,3; bonus2 bAddRaceTolerance,RC_Demon,3;','','');