summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-12-13 16:18:35 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-12-13 16:18:35 +0100
commitc1a26c8f136c6e474c0acbd7dd5d16d7651e0e3c (patch)
tree997a32d62d64343fb7fca761901469616d94776c /sql-files
parent6476db2cd11bab086c903297f4efcb5ec0a1962f (diff)
downloadhercules-c1a26c8f136c6e474c0acbd7dd5d16d7651e0e3c.tar.gz
hercules-c1a26c8f136c6e474c0acbd7dd5d16d7651e0e3c.tar.bz2
hercules-c1a26c8f136c6e474c0acbd7dd5d16d7651e0e3c.tar.xz
hercules-c1a26c8f136c6e474c0acbd7dd5d16d7651e0e3c.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db.sql4
-rw-r--r--sql-files/item_db_re.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index 6207bfc63..0ac44b742 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4738,7 +4738,7 @@ REPLACE INTO `item_db` VALUES ('12431','Minor_Brisket','Minor Stew','2','0','0',
REPLACE INTO `item_db` VALUES ('12432','Siroma_Icetea','Siroma Iced Tea','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SIROMA_ICE_TEA,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12433','Drocera_Herb_Stew','Drosera Herb Salad','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DROCERA_HERB_STEAMED,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12434','Petti_Tail_Noodle','Petite Tail Noodles','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PUTTI_TAILS_NOODLES,300000,20;','','');
-REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Mass','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_STOMACHACHE,60000,rand(5,10);','','');
+REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Mass','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','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 ('12436','Vitata500','Vitata 500','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_VITATA_500,500000,20,5; itemheal 0,200;','','');
REPLACE INTO `item_db` VALUES ('12437','Enrich_Celermine_Juice','Concentrated Ceromain Soup','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_EXTRACT_SALAMINE_JUICE,500000,10;','','');
REPLACE INTO `item_db` VALUES ('12438','F_Giant_Fly_Wing','F Giant Fly Wing','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -5201,7 +5201,7 @@ REPLACE INTO `item_db` VALUES ('13286','M_Brisket_To_Throw','Throwing Minor Stew
REPLACE INTO `item_db` VALUES ('13287','Siroma_Icetea_To_Throw','Throwing Siroma Iced Tea','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_SIROMA_ICE_TEA,300000,20;','','');
REPLACE INTO `item_db` VALUES ('13288','Drocera_Stew_To_Throw','Throwing Drosera Herb Salad','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','Throwing Petite Tail Soup','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','Throwing Black Mass','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_STOMACHACHE,60000,rand(5,10);','','');
+REPLACE INTO `item_db` VALUES ('13290','Black_Thing_To_Throw','Throwing Black Mass','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 ('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;','','');
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 1f1ed831a..30ca8cd5f 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -6011,7 +6011,7 @@ REPLACE INTO `item_db` VALUES ('12431','Minor_Brisket','Minor Brisket','2','1000
REPLACE INTO `item_db` VALUES ('12432','Siroma_Icetea','Siroma Icetea','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SIROMA_ICE_TEA,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12433','Drocera_Herb_Stew','Drosera Herb Stew','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DROCERA_HERB_STEAMED,300000,20;','','');
REPLACE INTO `item_db` VALUES ('12434','Petti_Tail_Noodle','Petite Tail Noodles','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PUTTI_TAILS_NOODLES,300000,20;','','');
-REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Thing','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_STOMACHACHE,60000,rand(5,10)','','');
+REPLACE INTO `item_db` VALUES ('12435','Black_Thing','Black Thing','2','1000','500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','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 ('12436','Vitata500','Vitata500','0','100','50','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_VITATA_500,500000,20,5; heal 0,200;','','');
REPLACE INTO `item_db` VALUES ('12437','Enrich_Celermine_Juice','Enrich Celermine Juice','2','100','50','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_EXTRACT_SALAMINE_JUICE,500000,10;','','');
REPLACE INTO `item_db` VALUES ('12438','F_Giant_Fly_Wing','Giant Fly Wing','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -6692,7 +6692,7 @@ REPLACE INTO `item_db` VALUES ('13286','M_Brisket_To_Throw','M Brisket To Throw'
REPLACE INTO `item_db` VALUES ('13287','Siroma_Icetea_To_Throw','Siroma Icetea To Throw','10','100','50','50','0','0','0','0','0','262144','63','2','32768','0','99',NULL,'0','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SIROMA_ICE_TEA,300000,20;','','');
REPLACE INTO `item_db` VALUES ('13288','Drocera_Stew_To_Throw','Drosera Stew To Throw','10','100','50','50','0','0','0','0','0','262144','63','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','63','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','63','2','32768','0','99',NULL,'0','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_STOMACHACHE,60000,rand(5,10);','','');
+REPLACE INTO `item_db` VALUES ('13290','Black_Thing_To_Throw','Black Thing To Throw','10','100','50','50','0','0','0','0','0','262144','63','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 ('13291','Starfish','Starfish','10','0','0','5','110','0','0','0','0','33554432','63','2','32768','0','50',NULL,'0','7','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral; bonus2 bAddEff,Eff_Stun,1000;','','');
REPLACE INTO `item_db` VALUES ('13292','Dried_Squid','Dried Squid','10','10','5','20','50','0','0','0','0','33554432','63','2','32768','0','0',NULL,'0','7','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral; bonus2 bAddEff,Eff_Stun,1000;','','');
REPLACE INTO `item_db` VALUES ('13293','Flying_Fish','Flying Fish','10','10','5','20','50','0','0','0','0','33554432','63','2','32768','0','0',NULL,'0','6','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Neutral; bonus3 bAutoSpell,NPC_CRITICALWOUND,1,3;','','');