summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-11-22 13:16:03 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-11-22 13:16:03 +0100
commit62bca692a28632ba25243c2c9cac09db3249b81f (patch)
tree895dbd120f455f83d05083282ceb07f311fa2d57 /sql-files/item_db.sql
parentc9bdd5a97ed8c8bd25982a136150c99e2526583c (diff)
downloadhercules-62bca692a28632ba25243c2c9cac09db3249b81f.tar.gz
hercules-62bca692a28632ba25243c2c9cac09db3249b81f.tar.bz2
hercules-62bca692a28632ba25243c2c9cac09db3249b81f.tar.xz
hercules-62bca692a28632ba25243c2c9cac09db3249b81f.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files/item_db.sql')
-rw-r--r--sql-files/item_db.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index c02e1bc25..b32d43fd9 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4381,7 +4381,7 @@ REPLACE INTO `item_db` VALUES ('12071','Str_Dish06','Shiny Marinade Beef','0','2
REPLACE INTO `item_db` VALUES ('12072','Str_Dish07','Whole Roast','0','40000','20000','1000','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_FOOD_STR,1200000,7; percentheal 10,4;','','');
REPLACE INTO `item_db` VALUES ('12073','Str_Dish08','Bearfoot Special','0','60000','30000','500','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_FOOD_STR,1200000,8; percentheal 15,6;','','');
REPLACE INTO `item_db` VALUES ('12074','Str_Dish09','Tendon Satay','0','80000','40000','1000','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_FOOD_STR,1200000,9; percentheal 15,8;','','');
-REPLACE INTO `item_db` VALUES ('12075','Str_Dish10','Steamed Tongue','0','100000','50000','1000','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_FOOD_STR,1200000,10; percentheal 20,20;','','');
+REPLACE INTO `item_db` VALUES ('12075','Str_Dish10','Steamed Tongue','0','100000','50000','1000','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_FOOD_STR,1200000,10; percentheal 20,10;','','');
REPLACE INTO `item_db` VALUES ('12076','Int_Dish06','Red Mushroom Wine','0','20000','10000','300','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_FOOD_INT,1200000,6; percentheal 2,10;','','');
REPLACE INTO `item_db` VALUES ('12077','Int_Dish07','Special Royal Jelly Herbal Tea','0','40000','20000','800','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_FOOD_INT,1200000,7; percentheal 4,10;','','');
REPLACE INTO `item_db` VALUES ('12078','Int_Dish08','Royal Family Tea','0','60000','30000','1000','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_FOOD_INT,1200000,8; percentheal 6,10;','','');
@@ -4407,8 +4407,8 @@ REPLACE INTO `item_db` VALUES ('12097','Luk_Dish07','Assorted Shish Kebob','0','
REPLACE INTO `item_db` VALUES ('12098','Luk_Dish08','Strawberry Flavored Rice Ball','0','60000','30000','400','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_FOOD_LUK,1200000,8; percentheal 9,3;','','');
REPLACE INTO `item_db` VALUES ('12099','Luk_Dish09','Blood Flavored Soda','0','80000','40000','1000','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_FOOD_LUK,1200000,9; percentheal 10,4;','','');
REPLACE INTO `item_db` VALUES ('12100','Luk_Dish10','Cooked Nine Tail\'s Tails','0','100000','50000','500','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_FOOD_LUK,1200000,10; percentheal 14,8;','','');
-REPLACE INTO `item_db` VALUES ('12101','Citron','Citron','0','20','10','300','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','','','');
-REPLACE INTO `item_db` VALUES ('12102','Meat_Skewer','Grilled Skewer','0','20','10','300','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','','','');
+REPLACE INTO `item_db` VALUES ('12101','Citron','Citron','0','20','10','300','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_FOOD_BASICAVOIDANCE,180000,30;','','');
+REPLACE INTO `item_db` VALUES ('12102','Meat_Skewer','Grilled Skewer','0','20','10','300','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_FOOD_BASICHIT,180000,30;','','');
REPLACE INTO `item_db` VALUES ('12103','Bloody_Dead_Branch','Bloody Branch','2','10000','5000','200','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','monster \"this\",-1,-1,\"--ja--\",-3,1,\"\";','','');
REPLACE INTO `item_db` VALUES ('12104','Random_Quiver','Random Quiver','2','10000','5000','200','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','getrandgroupitem 12104,1;','','');
REPLACE INTO `item_db` VALUES ('12105','Set_Of_Taiming_Item','Taming Gift Set','2','10000','5000','200','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','getrandgroupitem 12105,1; getrandgroupitem 12105,1; getrandgroupitem 12105,1;','','');
@@ -4575,8 +4575,8 @@ REPLACE INTO `item_db` VALUES ('12268','Rainbow_Cake_','Rainbow Cake','2','2','1
REPLACE INTO `item_db` VALUES ('12269','Tasty_Colonel','Tasty Pink Ration','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PLUSATTACKPOWER,600000,15;','','');
REPLACE INTO `item_db` VALUES ('12270','Tasty_Major','Tasty White Ration','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PLUSMAGICPOWER,600000,15;','','');
REPLACE INTO `item_db` VALUES ('12271','Mre_A','Military Ration A','0','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','percentheal 5,0;','','');
-REPLACE INTO `item_db` VALUES ('12272','Mre_B','Military Ration B','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCHIT,600000,33;','','');
-REPLACE INTO `item_db` VALUES ('12273','Mre_C','Military Ration C','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCFLEE,600000,33;','','');
+REPLACE INTO `item_db` VALUES ('12272','Mre_B','Military Ration B','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_BASICHIT,600000,33;','','');
+REPLACE INTO `item_db` VALUES ('12273','Mre_C','Military Ration C','2','2','1','70','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_BASICAVOIDANCE,600000,33;','','');
REPLACE INTO `item_db` VALUES ('12274','Gold_Pill_1','Daehwandan','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_ATKER_ASPD,3600000,5,10;','','');
REPLACE INTO `item_db` VALUES ('12275','Gold_Pill_2','Taecheongdan','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','sc_start2 SC_ATKER_MOVESPEED,3600000,5,10;','','');
REPLACE INTO `item_db` VALUES ('12276','Mimic_Scroll','Mimic Scroll','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','mercenary_create 2058,1800000;','','');
@@ -4613,7 +4613,7 @@ REPLACE INTO `item_db` VALUES ('12306','Newcomer','Freshman Magic Powder','11','
REPLACE INTO `item_db` VALUES ('12307','Kid','Kid Magic Powder','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','setfont 7;','','');
REPLACE INTO `item_db` VALUES ('12308','Magic_Castle','Magic Magic Powder','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','setfont 8;','','');
REPLACE INTO `item_db` VALUES ('12309','Bulging_Head','JJangu Magic Powder','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','setfont 9;','','');
-REPLACE INTO `item_db` VALUES ('12310','Spray_Of_Flowers','Spray Of Flowers','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'1',NULL,'0',NULL,'0','sc_start SC_INCFLEE,600000,10;','','');
+REPLACE INTO `item_db` VALUES ('12310','Spray_Of_Flowers','Spray Of Flowers','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'1',NULL,'0',NULL,'0','sc_start SC_FOOD_BASICAVOIDANCE,600000,10;','','');
REPLACE INTO `item_db` VALUES ('12311','Large_Spray_Of_Flowers','Huge Spray Of Flowers','11','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'1',NULL,'0',NULL,'0','itemskill ALL_PARTYFLEE,1;','','');
REPLACE INTO `item_db` VALUES ('12312','Thick_Manual50','Thick Battle Manual','2','0','0','0','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_CASH_PLUSEXP,3600000,50;','','');
REPLACE INTO `item_db` VALUES ('12313','Protection_Of_Angel','Guardian Angel','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'1',NULL,'0',NULL,'0','itemskill ALL_ANGEL_PROTECT,1;','','');
@@ -4622,9 +4622,9 @@ REPLACE INTO `item_db` VALUES ('12315','Goddess_Bless','Goddess Of Blessing','2'
REPLACE INTO `item_db` VALUES ('12316','Angel_Bless','Angel Of Blessing','2','0','0','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','','','');
REPLACE INTO `item_db` VALUES ('12317','Powder_Snow','Snow Powder','2','0','0','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','end;','','');
REPLACE INTO `item_db` VALUES ('12318','Little_Heart','Small Hearts','2','0','0','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','','','');
-REPLACE INTO `item_db` VALUES ('12319','Strawberry_Cake','Rune Strawberry Cake','2','0','0','300','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_INCATKRATE,600000,5; sc_start SC_INCMATKRATE,600000,5;','','');
-REPLACE INTO `item_db` VALUES ('12320','Pineapple_Juice','Schwartzwald Pine Jubilee','2','0','0','300','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_INCHIT,600000,10; sc_start SC_PLUSAVOIDVALUE,600000,20;','','');
-REPLACE INTO `item_db` VALUES ('12321','Spicy_Sandwich','Arunafeltz Desert Sandwich','2','0','0','300','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_CRITICALPERCENT,600000,7;','','');
+REPLACE INTO `item_db` VALUES ('12319','Strawberry_Cake','Rune Strawberry Cake','2','0','0','300','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_PLUSATTACKPOWER,600000,5; sc_start SC_PLUSMAGICPOWER,600000,5;','','');
+REPLACE INTO `item_db` VALUES ('12320','Pineapple_Juice','Schwartzwald Pine Jubilee','2','0','0','300','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_FOOD_BASICHIT,600000,10; sc_start SC_FOOD_BASICAVOIDANCE,600000,20;','','');
+REPLACE INTO `item_db` VALUES ('12321','Spicy_Sandwich','Arunafeltz Desert Sandwich','2','0','0','300','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_FOOD_CRITICALSUCCESSVALUE,600000,7;','','');
REPLACE INTO `item_db` VALUES ('12322','Chocolate_Pie','Chocolate Pie','0','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','percentheal 5,5;','','');
REPLACE INTO `item_db` VALUES ('12323','N_Fly_Wing','Novice Fly Wing','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','itemskill AL_TELEPORT,1;','','');
REPLACE INTO `item_db` VALUES ('12324','N_Butterfly_Wing','Novice Butterfly Wing','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','itemskill AL_TELEPORT,3;','','');
@@ -4641,7 +4641,7 @@ REPLACE INTO `item_db` VALUES ('12334','Cherish_Box','Treasure Edition Helm Box'
REPLACE INTO `item_db` VALUES ('12335','Yummy_Skewered_Dish','Grilled Delicious Skewer','0','1000','500','350','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','percentheal 60,60;','','');
REPLACE INTO `item_db` VALUES ('12336','Baked_Mushroom','Grilled Mushroom','0','500','250','300','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','percentheal 30,30;','','');
REPLACE INTO `item_db` VALUES ('12337','Grilled_Sausage','Grilled Sausages','0','300','150','200','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','percentheal 20,20;','','');
-REPLACE INTO `item_db` VALUES ('12338','Grilled_Corn','Grilled Corn','2','100','50','100','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_CHASEWALK2,180000,2; sc_start SC_INCINT,180000,2; sc_start SC_INCAGI,180000,2;','','');
+REPLACE INTO `item_db` VALUES ('12338','Grilled_Corn','Grilled Corn','2','100','50','100','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_FOOD_STR,180000,2; sc_start SC_FOOD_INT,180000,2; sc_start SC_FOOD_AGI,180000,2;','','');
REPLACE INTO `item_db` VALUES ('12339','Cherish_Box_Ori','Treasure Edition Box','2','0','0','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','getrandgroupitem 12339,1;','','');
REPLACE INTO `item_db` VALUES ('12340','Mysterious_Rice_Powder','Chewy Rice Powder','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'1',NULL,'0',NULL,'0','pet 1815;','','');
REPLACE INTO `item_db` VALUES ('12341','Special_Alloy_Trap_Box','Special Alloy Trap Box','2','30000','15000','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','getitem 7940,100;','','');