summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
diff options
context:
space:
mode:
authorHercules.ws <dev@herc.ws>2016-07-11 23:54:52 +0200
committerHerculesWSAPI <dev@herc.ws>2016-07-11 23:54:52 +0200
commit302aefbd150bd5c26bfd4a0c51f74bbec9c843a3 (patch)
tree53cb3eeccf8e05bc5310edc5c493577693e7e2a5 /sql-files/item_db.sql
parent9d6ed011444bdd11a8502a81541c7daf819132e7 (diff)
downloadhercules-302aefbd150bd5c26bfd4a0c51f74bbec9c843a3.tar.gz
hercules-302aefbd150bd5c26bfd4a0c51f74bbec9c843a3.tar.bz2
hercules-302aefbd150bd5c26bfd4a0c51f74bbec9c843a3.tar.xz
hercules-302aefbd150bd5c26bfd4a0c51f74bbec9c843a3.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <dev@herc.ws>
Diffstat (limited to 'sql-files/item_db.sql')
-rw-r--r--sql-files/item_db.sql13
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;','','');