From d764a30d9bdad187e2397b117b0c8f5a93341a78 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Mon, 18 Nov 2013 23:13:28 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'sql-files') 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);','',''); -- cgit v1.2.3-70-g09d2