summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2013-11-18 23:13:28 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2013-11-18 23:13:28 +0100
commitd764a30d9bdad187e2397b117b0c8f5a93341a78 (patch)
treee3f34ec9ce1eb1a3f7526e30e2d20baa98cc9ed5
parentfbf2cb2d341e7fbca38291583ac56c7a98989500 (diff)
downloadhercules-d764a30d9bdad187e2397b117b0c8f5a93341a78.tar.gz
hercules-d764a30d9bdad187e2397b117b0c8f5a93341a78.tar.bz2
hercules-d764a30d9bdad187e2397b117b0c8f5a93341a78.tar.xz
hercules-d764a30d9bdad187e2397b117b0c8f5a93341a78.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
-rw-r--r--sql-files/item_db_re.sql22
1 files changed, 11 insertions, 11 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index a32a2460f..3f3532b74 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -1838,12 +1838,12 @@ REPLACE INTO `item_db_re` VALUES ('2815','Th_Ring_Of_Water','Ring of Water','5',
REPLACE INTO `item_db_re` VALUES ('2816','Radar_Ring1','Radar Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','','','');
REPLACE INTO `item_db_re` VALUES ('2817','Radar_Ring2','Radar Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','','','');
REPLACE INTO `item_db_re` VALUES ('2818','Radar_Ring3','Radar Ring','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('2819','Swordman_Manual','Swordman Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill SM_BASH,1; skill SM_PROVOKE,1; skill SM_MAGNUM,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2820','Thief_Manual','Thief Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill TF_DOUBLE,3; bonus bDoubleRate,15; skill TF_STEAL,1; skill TF_HIDING,1; skill TF_POISON,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2821','Acolyte_Manual','Acolyte Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill AL_HEAL,1; skill AL_INCAGI,1; skill AL_BLESSING,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2822','Archer_Manual','Archer Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill AC_OWL,1; skill AC_CONCENTRATION,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2823','Merchant_Manual','Merchant Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill MC_DISCOUNT,1; skill MC_OVERCHARGE,10; skill MC_IDENTIFY,1; skill MC_MAMMONITE,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2824','Mage_Manual','Mage Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','bonus bMaxSP,100; skill MG_SRECOVERY,1; skill MG_COLDBOLT,1; skill MG_FIREWALL,1; skill MG_FIREBOLT,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2819','Swordman_Manual','Swordman Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill SM_BASH,1; skill SM_PROVOKE,1; skill SM_MAGNUM,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2820','Thief_Manual','Thief Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill TF_DOUBLE,3; bonus bDoubleRate,15; skill TF_STEAL,1; skill TF_HIDING,1; skill TF_POISON,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2821','Acolyte_Manual','Acolyte Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill AL_HEAL,1; skill AL_INCAGI,1; skill AL_BLESSING,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2822','Archer_Manual','Archer Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill AC_OWL,1; skill AC_CONCENTRATION,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2823','Merchant_Manual','Merchant Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill MC_DISCOUNT,1; skill MC_OVERCHARGE,10; skill MC_IDENTIFY,1; skill MC_MAMMONITE,1;','','');
+REPLACE INTO `item_db_re` VALUES ('2824','Mage_Manual','Mage Manual','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','bonus bMaxSP,100; skill MG_SRECOVERY,1; skill MG_COLDBOLT,1; skill MG_FIREWALL,1; skill MG_FIREBOLT,1;','','');
REPLACE INTO `item_db_re` VALUES ('2825','Shaman_EaringB','Shaman Earrings','5','20','10','100','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','bonus bInt,2;','','');
REPLACE INTO `item_db_re` VALUES ('2826','Dark_Knight_BeltB','Dark Knight Belt','5','20','10','500','0','0','1','0','0','4294967295','63','2','136','0','0','150','0','0','0','bonus bDex,2; bonus bAgi,1;','','');
REPLACE INTO `item_db_re` VALUES ('2827','Dark_Knight_GloveB','Dark Knight Glove','5','20','10','500','0','0','1','0','0','4294967295','63','2','136','0','0','150','0','0','0','autobonus \"{ bonus bMaxHPrate,10; }\",10,10000,0,\"{ specialeffect2 EF_POTION_BERSERK; }\";','','');
@@ -1904,7 +1904,7 @@ REPLACE INTO `item_db_re` VALUES ('2881','Orleans_Necklace','Orlean\'s Necklace'
REPLACE INTO `item_db_re` VALUES ('2882','Ecoro_Cardslip','Card Sleeves ECO ?RO','5','20','10','100','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','bonus bVit,1; bonus bLuk,1;','','');
REPLACE INTO `item_db_re` VALUES ('2883','Ur_Seal','Ur\'s Seal','5','20','10','200','0','0','4','0','1','16512','56','2','136','0','100','150','0','0','0','bonus bMaxHPrate,2; bonus2 bSkillUseSP,LK_SPIRALPIERCE,5; bonus2 bSkillUseSP,RK_HUNDREDSPEAR,5;','','');
REPLACE INTO `item_db_re` VALUES ('2884','Peuz_Seal','Peuz\'s Seal','5','20','10','200','0','0','3','0','1','16512','56','2','136','0','100','150','0','0','0','bonus bBaseAtk,20; bonus bMaxSP,20;','','');
-REPLACE INTO `item_db_re` VALUES ('2885','Mother_Heart','Mother\'s Heart','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','1','1','0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('2885','Mother_Heart','Mother\'s Heart','5','0','0','0','0','0','0','0','0','4294967295','63','2','136','0','1','60','0','0','0','','','');
REPLACE INTO `item_db_re` VALUES ('2886','Sabah_Ring','Sapha Ring','5','20','10','100','0','0','0','0','0','4096','56','2','136','0','100','150','0','0','0','bonus bCritical,3;','','');
REPLACE INTO `item_db_re` VALUES ('2887','Nab_Ring','Nab Ring','5','20','10','100','0','0','0','0','0','4096','56','2','136','0','100','150','0','0','0','bonus bBaseAtk,10; bonus bMatk,20;','','');
REPLACE INTO `item_db_re` VALUES ('2888','School_Bag','Attending School Back','5','20','10','1000','0','0','0','0','1','4294967295','63','2','136','0','0','150','0','0','0','','','');
@@ -1949,9 +1949,9 @@ REPLACE INTO `item_db_re` VALUES ('2926','Vit_Glove_','Vit Glove','5','75000','3
REPLACE INTO `item_db_re` VALUES ('2927','Dex_Glove_','Dex Glove','5','75000','37500','100','0','0','0','0','1','4294967295','63','2','136','0','100','150','0','0','0','bonus bMaxHP,100; bonus bMaxSP,20; bonus bHit,(readparam(bDex)/10); if(readparam(bDex)>=110) bonus bLongAtkRate,1;','','');
REPLACE INTO `item_db_re` VALUES ('2928','Luk_Glove_','Luk Glove','5','75000','37500','100','0','0','0','0','1','4294967295','63','2','136','0','100','150','0','0','0','bonus bMaxHP,100; bonus bMaxSP,20; bonus bCritical,(readparam(bLuk)/10); if(readparam(bLuk)>=110) bonus bCritAtkRate,1;','','');
REPLACE INTO `item_db_re` VALUES ('2936','Recovery_Ring','Rings of Recovery','5','20','10','100','0','0','5','0','1','4294967295','63','2','136','0','10','150','0','0','0','bonus bVit,1;','','');
-REPLACE INTO `item_db_re` VALUES ('2940','Ninja_Manual','Ninja Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('2941','Gunslinger_Manual','Gunslinger Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('2942','Taekwon_Manual','Taekwon Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','1','0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('2940','Ninja_Manual','Ninja Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('2941','Gunslinger_Manual','Gunslinger Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('2942','Taekwon_Manual','Taekwon Tutorial','5','0','0','100','0','0','0','0','0','1','47','2','136','0','1','12','0','0','0','','','');
REPLACE INTO `item_db_re` VALUES ('2959','Fidelity_Necklace','Fidelity Necklace','5','20','10','300','0','0','0','0','1','4294967295','63','2','136','0','50','150','0','0','0','bonus bAgi,2;','','');
REPLACE INTO `item_db_re` VALUES ('2960','Badge_Of_Manny','Badge Of Manny','5','20','10','200','0','0','0','0','1','4294967295','63','2','136','0','0','150','0','0','0','bonus bAllStats,1;','','');
REPLACE INTO `item_db_re` VALUES ('2966','RWC_2012_Ring','RWC 2012 Ring','5','20','10','200','0','0','0','0','0','4294967295','63','2','136','0','0','150','0','0','0','','','');
@@ -5233,7 +5233,7 @@ REPLACE INTO `item_db_re` VALUES ('11514','Enriched_Slim_Pot','Enriched Slim Pot
REPLACE INTO `item_db_re` VALUES ('11515','Coconut','Coconut','0','1500','750','120','0','0','0','0','0','4294967295','63','2','0','0','0','150','0','0','0','itemheal rand(300,400),0;','','');
REPLACE INTO `item_db_re` VALUES ('11516','Asai_Fruit','Asai Fruit','0','15','7','20','0','0','0','0','0','4294967295','63','2','0','0','0','150','0','0','0','itemheal rand(16,22),0;','','');
REPLACE INTO `item_db_re` VALUES ('11517','Puri_Potion','Purification Potion','0','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0','150','0','0','0','itemheal rand(400,600),0;','','');
-REPLACE INTO `item_db_re` VALUES ('11518','N_Blue_Potion','Cure Free','0','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','1','1','0','0','0','itemheal 0,5;','','');
+REPLACE INTO `item_db_re` VALUES ('11518','N_Blue_Potion','Cure Free','0','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','1','20','0','0','0','itemheal 0,5;','','');
REPLACE INTO `item_db_re` VALUES ('11519','Beef_Toast','Bifrost','0','1200','600','40','0','0','0','0','0','4294967295','63','2','0','0','0','150','0','0','0','itemheal rand(170,250),0;','','');
REPLACE INTO `item_db_re` VALUES ('11520','Mora_Mandarin','Mora Mandarin','0','500','250','20','0','0','0','0','0','4294967295','63','2','0','0','100','150','0','0','0','itemheal 0,rand(50,80);','','');
REPLACE INTO `item_db_re` VALUES ('11521','Pingui_Berry_Juice','Pinguicula Berry Juice','0','500','250','50','0','0','0','0','0','4294967295','63','2','0','0','100','150','0','0','0','itemheal rand(400,800),rand(50,80);','','');