diff options
author | Hercules.ws <Hercules@efficiently.awesome> | 2016-01-05 17:31:48 +0100 |
---|---|---|
committer | HerculesWSAPI <Hercules@efficiently.awesome> | 2016-01-05 17:31:48 +0100 |
commit | e885415d2b6eb3678b084f78de8347a564801f61 (patch) | |
tree | 1193a412a1e0f107b72292dce516bf06dfeefa13 /sql-files | |
parent | f8bd660a8958da4fbf27fed954bde62eae28d0de (diff) | |
download | hercules-e885415d2b6eb3678b084f78de8347a564801f61.tar.gz hercules-e885415d2b6eb3678b084f78de8347a564801f61.tar.bz2 hercules-e885415d2b6eb3678b084f78de8347a564801f61.tar.xz hercules-e885415d2b6eb3678b084f78de8347a564801f61.zip |
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/item_db.sql | 2 | ||||
-rw-r--r-- | sql-files/item_db_re.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 055894300..5d9bc2c80 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -2070,7 +2070,7 @@ REPLACE INTO `item_db` VALUES ('4436','Ragged_Zombie_Card','Ragged Zombie Card', REPLACE INTO `item_db` VALUES ('4437','Hell_Poodle_Card','Hell Poodle Card','6','20','10','10','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 bHit,1; bonus2 bAddItemHealRate,517,100; bonus3 bAddEff,Eff_Bleeding,50,ATF_SHORT;','',''); REPLACE INTO `item_db` VALUES ('4438','Banshee_Card','Banshee Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(BaseClass==Job_Mage) { bonus bMaxSP,100; bonus bMaxHP,-100; bonus2 bSkillAtk,MG_NAPALMBEAT,20; bonus2 bSkillAtk,MG_SOULSTRIKE,20; bonus2 bSkillAtk,HW_NAPALMVULCAN,20; }','',''); REPLACE INTO `item_db` VALUES ('4439','Flame_Skull_Card','Flame Skull Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Blind,3000; bonus2 bResEff,Eff_Stun,3000; bonus2 bResEff,Eff_Curse,3000; bonus2 bResEff,Eff_Stone,3000; bonus2 bAddEffWhenHit,Eff_Blind,500; bonus2 bAddEffWhenHit,Eff_Stun,500; bonus2 bAddEffWhenHit,Eff_Curse,500; bonus2 bAddEffWhenHit,Eff_Stone,500;','',''); -REPLACE INTO `item_db` VALUES ('4440','Necromancer_Card','Necromancer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(getiteminfo(getequipid(EQI_HAND_R),11)==10) { bonus bInt,1; bonus bIgnoreMdefRate,2; }','',''); +REPLACE INTO `item_db` VALUES ('4440','Necromancer_Card','Necromancer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@i = getiteminfo(getequipid(EQI_HAND_R),11); if (.@i == 10 || .@i == 23) { bonus bInt,1; bonus bIgnoreMdefRate,2; }','',''); REPLACE INTO `item_db` VALUES ('4441','Fallen_Bishop_Card','Fallen Bishop Hibram Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,10; bonus bMaxSPrate,-50; bonus2 bMagicAddRace,RC_Angel,50; bonus2 bMagicAddRace,RC_DemiPlayer,50;','',''); REPLACE INTO `item_db` VALUES ('4442','Tatacho_Card','Tatacho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Neutral,20; bonus2 bAddEle,Ele_Neutral,5;','',''); REPLACE INTO `item_db` VALUES ('4443','Aqua_Elemental_Card','Aqua Elemental Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Water,20; bonus2 bAddEle,Ele_Water,5;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 786868025..8a8fcfeaf 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -2530,7 +2530,7 @@ REPLACE INTO `item_db` VALUES ('4436','Ragged_Zombie_Card','Ragged Zombie Card', REPLACE INTO `item_db` VALUES ('4437','Hell_Poodle_Card','Hell Poodle Card','6','20','10','10','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 bHit,1; bonus2 bAddItemHealRate,517,100; bonus3 bAddEff,Eff_Bleeding,50,ATF_SHORT;','',''); REPLACE INTO `item_db` VALUES ('4438','Banshee_Card','Banshee Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(BaseClass==Job_Mage) { bonus bMaxSP,100; bonus bMaxHP,-100; bonus2 bSkillAtk,MG_NAPALMBEAT,20; bonus2 bSkillAtk,MG_SOULSTRIKE,20; bonus2 bSkillAtk,HW_NAPALMVULCAN,20; }','',''); REPLACE INTO `item_db` VALUES ('4439','Flame_Skull_Card','Flame Skull Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Blind,3000; bonus2 bResEff,Eff_Stun,3000; bonus2 bResEff,Eff_Curse,3000; bonus2 bResEff,Eff_Stone,3000; bonus2 bAddEffWhenHit,Eff_Blind,500; bonus2 bAddEffWhenHit,Eff_Stun,500; bonus2 bAddEffWhenHit,Eff_Curse,500; bonus2 bAddEffWhenHit,Eff_Stone,500;','',''); -REPLACE INTO `item_db` VALUES ('4440','Necromancer_Card','Necromancer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(getiteminfo(getequipid(EQI_HAND_R),11)==10) { bonus bInt,1; bonus bIgnoreMdefRate,2; }','',''); +REPLACE INTO `item_db` VALUES ('4440','Necromancer_Card','Necromancer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@i = getiteminfo(getequipid(EQI_HAND_R),11); if (.@i == 10 || .@i == 23) { bonus bInt,1; bonus bIgnoreMdefRate,2; }','',''); REPLACE INTO `item_db` VALUES ('4441','Fallen_Bishop_Card','Fallen Bishop Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate,10; bonus bMaxSPrate,-50; bonus2 bMagicAddRace,RC_Angel,50; bonus2 bMagicAddRace,RC_DemiPlayer,50;','',''); REPLACE INTO `item_db` VALUES ('4442','Tatacho_Card','Tatacho Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Neutral,20; bonus2 bAddEle,Ele_Neutral,5;','',''); REPLACE INTO `item_db` VALUES ('4443','Aqua_Elemental_Card','Aqua Elemental Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Water,20; bonus2 bAddEle,Ele_Water,5;','',''); |