diff options
Diffstat (limited to 'sql-files/item_db.sql')
| -rw-r--r-- | sql-files/item_db.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 082bc4502..99b6d7316 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -852,6 +852,7 @@ REPLACE INTO `item_db` VALUES ('1545','N_Mace','Novice Mace','4','0','0','0','57 REPLACE INTO `item_db` VALUES ('1546','Krieger_Onehand_Mace1','Glorious Morning Star','4','20','10','0','130','0','0','1','0','312755','63','2','2','4','80',NULL,'1','8','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiPlayer,75; bonus2 bIgnoreDefRate,RC_DemiPlayer,20; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiPlayer,(getrefine()-4)*(getrefine()-4); bonus2 bIgnoreDefRate,RC_DemiPlayer,5; bonus bAspdRate,5; } if(getrefine()>8) { bonus2 bAddEff,Eff_Stun,2000; bonus bAspdRate,5; }','',''); REPLACE INTO `item_db` VALUES ('1547','Mace_Of_Madness','Mace Of Madness','4','20','10','0','150','0','0','1','0','312754','63','2','2','3','0',NULL,'0','8','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,MC_CARTREVOLUTION,25; bonus bStr,2;','',''); REPLACE INTO `item_db` VALUES ('1548','Veteran_Hammer','Veteran Hammer','4','10000','5000','1800','160','0','0','1','2','33040','63','2','2','3','80',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,getskilllv(AL_DP); bonus bCritical,getskilllv(PR_MACEMASTERY)*2; bonus bInt,1; bonus bLuk,1;','',''); +REPLACE INTO `item_db` VALUES ('1549','Pilebuncker','Pile Bunker','4','10000','5000','3500','450','0','0','1','0','1024','8','2','2','3','99',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1550','Book','Book','4','30000','15000','600','85','0','0','1','3','4260096','63','2','2','2','14',NULL,'1','15','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1551','Bible','Bible','4','60000','30000','1000','115','0','0','1','2','4260096','63','2','2','3','27',NULL,'1','15','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2;','',''); REPLACE INTO `item_db` VALUES ('1552','Tablet','Tablet','4','51000','25500','800','125','0','0','1','1','4260096','63','2','2','3','27',NULL,'1','15','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -1138,6 +1139,7 @@ REPLACE INTO `item_db` VALUES ('2135','Shadow_Guard','Shadow Guard','5','20','10 REPLACE INTO `item_db` VALUES ('2136','Cracked_Buckler','Cracked Buckler','5','0','0','0','0','0','5','0','0','18446744073709551615','63','2','32','0','0',NULL,'0','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,2; bonus2 bAddEle,Ele_Neutral,-10; bonus3 bAutoSpellWhenHit,PR_KYRIE,1,50; bonus bMdef,1;','',''); REPLACE INTO `item_db` VALUES ('2137','Valkyrja\'s_Shield_C','Neo Valkyrja\'s Shield','5','0','0','0','0','0','5','0','0','18446744073709551614','2','2','32','0','95',NULL,'0','4','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5;','',''); REPLACE INTO `item_db` VALUES ('2138','Bradium_Shield','Bradium Shield','5','20','10','1800','0','0','5','0','1','13623168','2','2','32','0','65',NULL,'1','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,CR_SHIELDBOOMERANG,60; bonus bAgi,-1; bonus bMaxHP,500;','',''); +REPLACE INTO `item_db` VALUES ('2139','Flame_Thrower','Flame Thrower','5','20000','10000','2000','0','0','60','0','0','1024','8','2','32','0','99',NULL,'0','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('2199','Ahura_Mazda','Ahura Mazdah','5','1','0','10','0','0','100','0','0','18446744073709551615','63','2','32','0','1',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,50; bonus bMdef,99; bonus bShortWeaponDamageReturn,100; bonus2 bSubRace,RC_DemiPlayer,95; skill CR_FULLPROTECTION,5; skill WZ_ESTIMATION,1; skill ST_FULLSTRIP,5; skill HW_MAGICPOWER,10; bonus bMaxHPrate,200; bonus bNoGemStone,0; bonus bSpeedRate,25;','sc_start4 SC_ENDURE,60000,10,0,0,1;','sc_end SC_ENDURE;'); REPLACE INTO `item_db` VALUES ('2201','Sunglasses','Sunglasses','5','5000','2500','100','0','0','0','0','0','18446744073709551615','63','2','512','0','0',NULL,'0','12','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Blind,500;','',''); REPLACE INTO `item_db` VALUES ('2202','Sunglasses_','Sunglasses','5','5000','2500','100','0','0','0','0','1','18446744073709551615','63','2','512','0','0',NULL,'0','12','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bResEff,Eff_Blind,500;','',''); @@ -1627,6 +1629,15 @@ REPLACE INTO `item_db` VALUES ('2796','Magical_Stone','Rocks','5','0','0','200', REPLACE INTO `item_db` VALUES ('2797','Magical_Stone_','Rocks','5','0','0','200','0','0','0','0','0','8454660','63','2','136','0','99',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddDamageClass,2049,10; bonus2 bAddDefClass,2050,-10; bonus3 bAddClassDropItem,6151,2049,70;','',''); REPLACE INTO `item_db` VALUES ('2798','Will_Of_Exhausted_Angel','Will Of Exhausted Angel','5','0','0','200','0','0','0','0','0','33024','63','2','136','0','99',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_arch02\") { bonus2 bAddDefClass,1761,50; bonus2 bAddDefClass,1762,50; }','',''); REPLACE INTO `item_db` VALUES ('2799','Kuirpenring','Kuirpenring','5','0','0','100','0','0','0','0','1','18446744073709551615','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,1;','',''); +REPLACE INTO `item_db` VALUES ('2800','Accelerator','Accelerator','5','100000','50000','100','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,2;','',''); +REPLACE INTO `item_db` VALUES ('2801','Hovering_Booster','Hovering Booster','5','100000','50000','2000','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1;','',''); +REPLACE INTO `item_db` VALUES ('2802','Suicidal_Device','Suicidal Device','5','500000','250000','1000','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('2803','Shape_Shifter','Shape Shifter','5','100000','50000','500','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3;','',''); +REPLACE INTO `item_db` VALUES ('2804','Cooling_Device','Cooling Device','5','100000','50000','2500','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','',''); +REPLACE INTO `item_db` VALUES ('2805','Mag_Field_Generator','Magnetic Field Generator','5','100000','50000','6000','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','',''); +REPLACE INTO `item_db` VALUES ('2806','Barrier_Builder','Barrier Builder','5','150000','75000','8000','0','0','3','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','',''); +REPLACE INTO `item_db` VALUES ('2807','Repair_Kit','Repair Kit','5','200000','100000','400','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('2808','Camouflage_Generator','Camouflage Generator','5','250000','125000','1000','0','0','0','0','1','1024','8','2','136','0','99',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,3;','',''); REPLACE INTO `item_db` VALUES ('2819','Swordman_Manual','Swordsman Manual','5','0','0','100','0','0','0','0','0','1','63','2','136','0','1',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,100; skill SM_BASH,1; skill SM_PROVOKE,1; skill SM_MAGNUM,1;','',''); REPLACE INTO `item_db` VALUES ('2820','Thief_Manual','Thief Manual','5','0','0','100','0','0','0','0','0','1','63','2','136','0','1',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'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` VALUES ('2821','Acolyte_Manual','Acolyte Manual','5','0','0','100','0','0','0','0','0','1','63','2','136','0','1',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,100; skill AL_HEAL,1; skill AL_INCAGI,1; skill AL_BLESSING,1;','',''); @@ -3208,6 +3219,7 @@ REPLACE INTO `item_db` VALUES ('6393','Round_Feather','Round Feather','3','700', REPLACE INTO `item_db` VALUES ('6394','Golden_Feather','Golden Feather','3','650','325','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6395','Angel_Magic_Power','Angel Magic Power','3','820','410','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6396','Auger_Of_Spirit','Auger Of Spirit','3','0','0','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('6493','Makibishi','Makibishi','3','30','15','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6512','Charm_Fire','Charm Fire','3','100','50','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6513','Charm_Ice','Charm Ice','3','100','50','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6514','Charm_Wind','Charm Wind','3','100','50','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -5223,6 +5235,7 @@ REPLACE INTO `item_db` VALUES ('13287','Siroma_Icetea_To_Throw','Siroma Icetea T REPLACE INTO `item_db` VALUES ('13288','Drocera_Stew_To_Throw','Drosera Stew To Throw','10','100','50','50','0','0','0','0','0','262144','8','2','32768','0','99',NULL,'0','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DROCERA_HERB_STEAMED, 300000, 20;','',''); REPLACE INTO `item_db` VALUES ('13289','Petti_Noodle_To_Throw','Petite Noodle To Throw','10','100','50','50','0','0','0','0','0','262144','8','2','32768','0','99',NULL,'0','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PUTTI_TAILS_NOODLES, 300000, 20;','',''); REPLACE INTO `item_db` VALUES ('13290','Black_Thing_To_Throw','Black Thing To Throw','10','100','50','50','0','0','0','0','0','262144','8','2','32768','0','99',NULL,'0','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_STOMACHACHE, 60000, rand(5,10), 75;','',''); +REPLACE INTO `item_db` VALUES ('13294','Explosive_Kunai','Explosive Kunai','10','100','50','30','50','0','0','0','0','33554432','63','2','32768','0','100',NULL,'0','7','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral;','',''); REPLACE INTO `item_db` VALUES ('13300','Huuma_Bird_Wing','Huuma Wing Shuriken','4','90000','45000','3000','150','0','0','1','0','33554432','63','2','34','4','65',NULL,'1','22','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtkEle,Ele_Wind; bonus bDex,-2; bonus bAgi,-1;','',''); REPLACE INTO `item_db` VALUES ('13301','Huuma_Giant_Wheel','Huuma Giant Wheel Shuriken','4','40000','20000','2500','50','0','0','1','3','33554432','63','2','34','4','42',NULL,'1','22','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Bleeding,100;','',''); REPLACE INTO `item_db` VALUES ('13302','Huuma_Giant_Wheel_','Huuma Giant Wheel Shuriken','4','40000','20000','2500','50','0','0','1','4','33554432','63','2','34','4','42',NULL,'1','22','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddEff,Eff_Bleeding,100;','',''); |