summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-04-26 03:09:55 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-04-26 03:09:55 +0200
commit6c06e4ca6ee546414bfc078622b872f078e1a5d5 (patch)
treed0142e64ee470c4c82153cfb7f41f8690bf67535
parente4767041e80ee0b8ec567524f578ae49689b7938 (diff)
downloadhercules-6c06e4ca6ee546414bfc078622b872f078e1a5d5.tar.gz
hercules-6c06e4ca6ee546414bfc078622b872f078e1a5d5.tar.bz2
hercules-6c06e4ca6ee546414bfc078622b872f078e1a5d5.tar.xz
hercules-6c06e4ca6ee546414bfc078622b872f078e1a5d5.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
-rw-r--r--sql-files/item_db.sql14
-rw-r--r--sql-files/item_db_re.sql14
2 files changed, 14 insertions, 14 deletions
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;','','');