From 6c06e4ca6ee546414bfc078622b872f078e1a5d5 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Sun, 26 Apr 2015 03:09:55 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 14 +++++++------- sql-files/item_db_re.sql | 14 +++++++------- 2 files changed, 14 insertions(+), 14 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index f841cfb66..242816c00 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -1573,13 +1573,13 @@ REPLACE INTO `item_db` VALUES ('2761','Satanic_Ring','Satanic Ring','5','0','0', REPLACE INTO `item_db` VALUES ('2762','Dragoon_Ring','Dragon Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','1',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_Dragon,15;','',''); REPLACE INTO `item_db` VALUES ('2763','Skul_Ring_C','Neo Skull Ring','5','0','0','0','0','0','0','0','0','2147483646','2','2','136','0','95',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,5; bonus bMatkRate,5; bonus bMaxHPrate,5; bonus2 bSkillHeal,AL_HEAL,5; skill MG_SIGHT,1;','',''); REPLACE INTO `item_db` VALUES ('2764','Small_Fishing_Rod','Small Fishing Rod','5','10','5','250','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('2765','Novice_Figure','Novice Figure','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; if(Class==Job_Novice) bonus bMaxHP,30;','',''); -REPLACE INTO `item_db` VALUES ('2766','Swordman_Figure','Swordman Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; if(Class==Job_Swordman) bonus bDef,2;','',''); -REPLACE INTO `item_db` VALUES ('2767','Acolyte_Figure','Acolyte Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(Class==Job_Acolyte) bonus bMaxSP,50;','',''); -REPLACE INTO `item_db` VALUES ('2768','Mage_Figure','Mage Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(Class==Job_Mage) bonus bSPrecovRate,5;','',''); -REPLACE INTO `item_db` VALUES ('2769','Archer_Figure','Archer Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; if(Class==Job_Archer) bonus bBaseAtk,10;','',''); -REPLACE INTO `item_db` VALUES ('2770','Thief_Figure','Thief Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; if(Class==Job_Thief) bonus bAspdRate,3;','',''); -REPLACE INTO `item_db` VALUES ('2771','Merchant_Figure','Merchant Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; if(Class==Job_Merchant) bonus bCritical,5;','',''); +REPLACE INTO `item_db` VALUES ('2765','Novice_Figure','Novice Figure','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; if(Class==Job_Novice || Class==Job_Novice_High || Class==Job_SuperNovice) bonus bMaxHP,30;','',''); +REPLACE INTO `item_db` VALUES ('2766','Swordman_Figure','Swordman Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; if(BaseClass==Job_Swordman) bonus bDef,2;','',''); +REPLACE INTO `item_db` VALUES ('2767','Acolyte_Figure','Acolyte Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(BaseClass==Job_Acolyte) bonus bMaxSP,50;','',''); +REPLACE INTO `item_db` VALUES ('2768','Mage_Figure','Mage Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(BaseClass==Job_Mage) bonus bSPrecovRate,5;','',''); +REPLACE INTO `item_db` VALUES ('2769','Archer_Figure','Archer Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; if(BaseClass==Job_Archer) bonus bBaseAtk,10;','',''); +REPLACE INTO `item_db` VALUES ('2770','Thief_Figure','Thief Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; if(BaseClass==Job_Thief) bonus bAspdRate,3;','',''); +REPLACE INTO `item_db` VALUES ('2771','Merchant_Figure','Merchant Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; if(BaseClass==Job_Merchant) bonus bCritical,5;','',''); REPLACE INTO `item_db` VALUES ('2772','Krieger_Ring1','Glorious Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','81',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,300; bonus2 bSubEle,Ele_Water,10; bonus2 bSubEle,Ele_Wind,10; bonus2 bSubEle,Ele_Earth,10; bonus2 bSubEle,Ele_Fire,10; bonus bAspdRate,5; bonus bCastrate,-3; bonus bHealPower,5;','',''); REPLACE INTO `item_db` VALUES ('2773','Krieger_Ring2','Glorious Mass-Production Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','61',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,2;','',''); REPLACE INTO `item_db` VALUES ('2774','Krieger_Ring3','Glorious Popularized Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','0',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,1;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index efa182cc7..acaf170e1 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -1832,13 +1832,13 @@ REPLACE INTO `item_db` VALUES ('2761','Satanic_Ring','Satanic Ring','5','0','0', REPLACE INTO `item_db` VALUES ('2762','Dragoon_Ring','Dragon Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_Dragon,15;','',''); REPLACE INTO `item_db` VALUES ('2763','Skul_Ring_C','Neo Skull Ring','5','0','0','0','0','0','0','0','0','1040382','58','2','136','0','95',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkRate,5; bonus bMatkRate,5; bonus bMaxHPrate,5; bonus2 bSkillHeal,AL_HEAL,5; skill MG_SIGHT,1;','',''); REPLACE INTO `item_db` VALUES ('2764','Small_Fishing_Rod','Small Fishing Rod','5','10','5','250','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('2765','Novice_Figure','Novice Figure','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; if(Class==Job_Novice) bonus bMaxHP,30;','',''); -REPLACE INTO `item_db` VALUES ('2766','Swordman_Figure','Swordman Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; if(Class==Job_Swordman) bonus bDef,2;','',''); -REPLACE INTO `item_db` VALUES ('2767','Acolyte_Figure','Acolyte Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(Class==Job_Acolyte) bonus bMaxSP,50;','',''); -REPLACE INTO `item_db` VALUES ('2768','Mage_Figure','Mage Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(Class==Job_Mage) bonus bSPrecovRate,5;','',''); -REPLACE INTO `item_db` VALUES ('2769','Archer_Figure','Archer Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; if(Class==Job_Archer) bonus bBaseAtk,10;','',''); -REPLACE INTO `item_db` VALUES ('2770','Thief_Figure','Thief Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; if(Class==Job_Thief) bonus bAspdRate,3;','',''); -REPLACE INTO `item_db` VALUES ('2771','Merchant_Figure','Merchant Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; if(Class==Job_Merchant) bonus bCritical,5;','',''); +REPLACE INTO `item_db` VALUES ('2765','Novice_Figure','Novice Figure','5','0','0','100','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; if(Class==Job_Novice || Class==Job_Novice_High || Class==Job_SuperNovice) bonus bMaxHP,30;','',''); +REPLACE INTO `item_db` VALUES ('2766','Swordman_Figure','Swordman Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; if(BaseClass==Job_Swordman) bonus bDef,2;','',''); +REPLACE INTO `item_db` VALUES ('2767','Acolyte_Figure','Acolyte Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(BaseClass==Job_Acolyte) bonus bMaxSP,50;','',''); +REPLACE INTO `item_db` VALUES ('2768','Mage_Figure','Mage Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(BaseClass==Job_Mage) bonus bSPrecovRate,5;','',''); +REPLACE INTO `item_db` VALUES ('2769','Archer_Figure','Archer Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1; if(BaseClass==Job_Archer) bonus bBaseAtk,10;','',''); +REPLACE INTO `item_db` VALUES ('2770','Thief_Figure','Thief Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; if(BaseClass==Job_Thief) bonus bAspdRate,3;','',''); +REPLACE INTO `item_db` VALUES ('2771','Merchant_Figure','Merchant Figure','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; if(BaseClass==Job_Merchant) bonus bCritical,5;','',''); REPLACE INTO `item_db` VALUES ('2772','Krieger_Ring1','Glorious Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','81',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,300; bonus2 bSubEle,Ele_Water,10; bonus2 bSubEle,Ele_Wind,10; bonus2 bSubEle,Ele_Earth,10; bonus2 bSubEle,Ele_Fire,10; bonus bAspdRate,5; bonus bVariableCastrate,-3; bonus bHealPower,5;','',''); REPLACE INTO `item_db` VALUES ('2773','Krieger_Ring2','Glorious Popularized Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','61',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,2;','',''); REPLACE INTO `item_db` VALUES ('2774','Krieger_Ring3','Glorious Mass-Production Ring','5','20','10','0','0','0','0','0','0','2147483646','63','2','136','0','0',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,1;','',''); -- cgit v1.2.3-60-g2f50