From b8324378acd6815e1cbe162ad63f12f69843187f Mon Sep 17 00:00:00 2001 From: Mumbles Date: Thu, 28 Nov 2013 11:37:07 -0800 Subject: Fixed Bug 7870 Food items sold for 0 zeny in renewal item database. http://hercules.ws/board/tracker/issue-7870-food-items-sell-for-0-zeny/ --- db/re/item_db.conf | 120 ++++++++++++++++++++++++++--------------------------- 1 file changed, 60 insertions(+), 60 deletions(-) diff --git a/db/re/item_db.conf b/db/re/item_db.conf index 727fb72a0..a67494ee0 100644 --- a/db/re/item_db.conf +++ b/db/re/item_db.conf @@ -65879,7 +65879,7 @@ item_db: ( AegisName: "Str_Dish01" Name: "Fried Grasshopper Legs" Type: 0 - Buy: 0 + Buy: 2000 Weight: 60 Upper: 63 Script: <" @@ -65892,7 +65892,7 @@ item_db: ( AegisName: "Str_Dish02" Name: "Seasoned Sticky Webfoot" Type: 0 - Buy: 0 + Buy: 4000 Weight: 500 Upper: 63 Script: <" @@ -65905,7 +65905,7 @@ item_db: ( AegisName: "Str_Dish03" Name: "Bomber Steak" Type: 0 - Buy: 0 + Buy: 6000 Weight: 500 Upper: 63 Script: <" @@ -65918,7 +65918,7 @@ item_db: ( AegisName: "Str_Dish04" Name: "Herb Marinade Beef" Type: 0 - Buy: 0 + Buy: 8000 Weight: 500 Upper: 63 Script: <" @@ -65931,7 +65931,7 @@ item_db: ( AegisName: "Str_Dish05" Name: "Lutie Lady's Pancake" Type: 0 - Buy: 0 + Buy: 10000 Weight: 500 Upper: 63 Script: <" @@ -65944,7 +65944,7 @@ item_db: ( AegisName: "Int_Dish01" Name: "Grape Juice Herbal Tea" Type: 0 - Buy: 0 + Buy: 2000 Weight: 100 Upper: 63 Script: <" @@ -65957,7 +65957,7 @@ item_db: ( AegisName: "Int_Dish02" Name: "Autumn Red Tea" Type: 0 - Buy: 0 + Buy: 4000 Weight: 500 Upper: 63 Script: <" @@ -65970,7 +65970,7 @@ item_db: ( AegisName: "Int_Dish03" Name: "Honey Herbal Tea" Type: 0 - Buy: 0 + Buy: 6000 Weight: 500 Upper: 63 Script: <" @@ -65983,7 +65983,7 @@ item_db: ( AegisName: "Int_Dish04" Name: "Morroc Fruit Wine" Type: 0 - Buy: 0 + Buy: 8000 Weight: 300 Upper: 63 Script: <" @@ -65996,7 +65996,7 @@ item_db: ( AegisName: "Int_Dish05" Name: "Mastela Fruit Wine" Type: 0 - Buy: 0 + Buy: 10000 Weight: 400 Upper: 63 Script: <" @@ -66009,7 +66009,7 @@ item_db: ( AegisName: "Vit_Dish01" Name: "Steamed Crab Nippers" Type: 0 - Buy: 0 + Buy: 2000 Weight: 100 Upper: 63 Script: <" @@ -66022,7 +66022,7 @@ item_db: ( AegisName: "Vit_Dish02" Name: "Assorted Seafood" Type: 0 - Buy: 0 + Buy: 4000 Weight: 200 Upper: 63 Script: <" @@ -66035,7 +66035,7 @@ item_db: ( AegisName: "Vit_Dish03" Name: "Clam Soup" Type: 0 - Buy: 0 + Buy: 6000 Weight: 300 Upper: 63 Script: <" @@ -66048,7 +66048,7 @@ item_db: ( AegisName: "Vit_Dish04" Name: "Seasoned Jellyfish" Type: 0 - Buy: 0 + Buy: 8000 Weight: 500 Upper: 63 Script: <" @@ -66061,7 +66061,7 @@ item_db: ( AegisName: "Vit_Dish05" Name: "Spicy Fried Bao" Type: 0 - Buy: 0 + Buy: 10000 Weight: 800 Upper: 63 Script: <" @@ -66074,7 +66074,7 @@ item_db: ( AegisName: "Agi_Dish01" Name: "Frog Egg Squid Ink Soup" Type: 0 - Buy: 0 + Buy: 2000 Weight: 100 Upper: 63 Script: <" @@ -66087,7 +66087,7 @@ item_db: ( AegisName: "Agi_Dish02" Name: "Smooth Noodle" Type: 0 - Buy: 0 + Buy: 4000 Weight: 100 Upper: 63 Script: <" @@ -66100,7 +66100,7 @@ item_db: ( AegisName: "Agi_Dish03" Name: "Tentacle Cheese Gratin" Type: 0 - Buy: 0 + Buy: 6000 Weight: 500 Upper: 63 Script: <" @@ -66113,7 +66113,7 @@ item_db: ( AegisName: "Agi_Dish04" Name: "Lutie Cold Noodle" Type: 0 - Buy: 0 + Buy: 8000 Weight: 400 Upper: 63 Script: <" @@ -66126,7 +66126,7 @@ item_db: ( AegisName: "Agi_Dish05" Name: "Steamed Bat Wing in Pumpkin" Type: 0 - Buy: 0 + Buy: 10000 Weight: 500 Upper: 63 Script: <" @@ -66139,7 +66139,7 @@ item_db: ( AegisName: "Dex_Dish01" Name: "Honey Grape Juice" Type: 0 - Buy: 0 + Buy: 2000 Weight: 100 Upper: 63 Script: <" @@ -66152,7 +66152,7 @@ item_db: ( AegisName: "Dex_Dish02" Name: "Chocolate Mousse Cake" Type: 0 - Buy: 0 + Buy: 4000 Weight: 200 Upper: 63 Script: <" @@ -66165,7 +66165,7 @@ item_db: ( AegisName: "Dex_Dish03" Name: "Fruit Mix" Type: 0 - Buy: 0 + Buy: 6000 Weight: 200 Upper: 63 Script: <" @@ -66178,7 +66178,7 @@ item_db: ( AegisName: "Dex_Dish04" Name: "Cream Sandwich" Type: 0 - Buy: 0 + Buy: 8000 Weight: 500 Upper: 63 Script: <" @@ -66191,7 +66191,7 @@ item_db: ( AegisName: "Dex_Dish05" Name: "Green Salad" Type: 0 - Buy: 0 + Buy: 10000 Weight: 200 Upper: 63 Script: <" @@ -66204,7 +66204,7 @@ item_db: ( AegisName: "Luk_Dish01" Name: "Fried Monkey Tails" Type: 0 - Buy: 0 + Buy: 2000 Weight: 60 Upper: 63 Script: <" @@ -66217,7 +66217,7 @@ item_db: ( AegisName: "Luk_Dish02" Name: "Mixed Juice" Type: 0 - Buy: 0 + Buy: 4000 Weight: 200 Upper: 63 Script: <" @@ -66230,7 +66230,7 @@ item_db: ( AegisName: "Luk_Dish03" Name: "Fried Sweet Potato" Type: 0 - Buy: 0 + Buy: 6000 Weight: 500 Upper: 63 Script: <" @@ -66243,7 +66243,7 @@ item_db: ( AegisName: "Luk_Dish04" Name: "Steamed Ancient Lips" Type: 0 - Buy: 0 + Buy: 8000 Weight: 500 Upper: 63 Script: <" @@ -66256,7 +66256,7 @@ item_db: ( AegisName: "Luk_Dish05" Name: "Fried Scorpion Tails" Type: 0 - Buy: 0 + Buy: 10000 Weight: 400 Upper: 63 Script: <" @@ -66269,7 +66269,7 @@ item_db: ( AegisName: "Str_Dish06" Name: "Shiny Marinade Beef" Type: 0 - Buy: 0 + Buy: 20000 Weight: 800 Upper: 63 Script: <" @@ -66282,7 +66282,7 @@ item_db: ( AegisName: "Str_Dish07" Name: "Whole Roast" Type: 0 - Buy: 0 + Buy: 40000 Weight: 1000 Upper: 63 Script: <" @@ -66295,7 +66295,7 @@ item_db: ( AegisName: "Str_Dish08" Name: "Bearfoot Special" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66308,7 +66308,7 @@ item_db: ( AegisName: "Str_Dish09" Name: "Tendon Satay" Type: 0 - Buy: 0 + Buy: 80000 Weight: 1000 Upper: 63 Script: <" @@ -66321,7 +66321,7 @@ item_db: ( AegisName: "Str_Dish10" Name: "Steamed Tongue" Type: 0 - Buy: 0 + Buy: 100000 Weight: 1000 Upper: 63 Script: <" @@ -66334,7 +66334,7 @@ item_db: ( AegisName: "Int_Dish06" Name: "Red Mushroom Wine" Type: 0 - Buy: 0 + Buy: 20000 Weight: 300 Upper: 63 Script: <" @@ -66347,7 +66347,7 @@ item_db: ( AegisName: "Int_Dish07" Name: "Special Royal Jelly Herbal Tea" Type: 0 - Buy: 0 + Buy: 40000 Weight: 800 Upper: 63 Script: <" @@ -66360,7 +66360,7 @@ item_db: ( AegisName: "Int_Dish08" Name: "Royal Family Tea" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66373,7 +66373,7 @@ item_db: ( AegisName: "Int_Dish09" Name: "Tristram 12" Type: 0 - Buy: 0 + Buy: 80000 Weight: 1000 Upper: 63 Script: <" @@ -66386,7 +66386,7 @@ item_db: ( AegisName: "Int_Dish10" Name: "Dragon Breath Cocktail" Type: 0 - Buy: 0 + Buy: 100000 Weight: 1000 Upper: 63 Script: <" @@ -66399,7 +66399,7 @@ item_db: ( AegisName: "Vit_Dish06" Name: "Awfully Bitter Bracer" Type: 0 - Buy: 0 + Buy: 20000 Weight: 500 Upper: 63 Script: <" @@ -66412,7 +66412,7 @@ item_db: ( AegisName: "Vit_Dish07" Name: "Sumptuous Feast" Type: 0 - Buy: 0 + Buy: 40000 Weight: 400 Upper: 63 Script: <" @@ -66425,7 +66425,7 @@ item_db: ( AegisName: "Vit_Dish08" Name: "Giant Burito" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66438,7 +66438,7 @@ item_db: ( AegisName: "Vit_Dish09" Name: "Ascending Dragon Soup" Type: 0 - Buy: 0 + Buy: 80000 Weight: 1000 Upper: 63 Script: <" @@ -66451,7 +66451,7 @@ item_db: ( AegisName: "Vit_Dish10" Name: "Immortal Stew" Type: 0 - Buy: 0 + Buy: 100000 Weight: 1000 Upper: 63 Script: <" @@ -66464,7 +66464,7 @@ item_db: ( AegisName: "Agi_Dish06" Name: "Chile Shrimp Gratin" Type: 0 - Buy: 0 + Buy: 20000 Weight: 800 Upper: 63 Script: <" @@ -66477,7 +66477,7 @@ item_db: ( AegisName: "Agi_Dish07" Name: "Steamed Alligator with Vegetable" Type: 0 - Buy: 0 + Buy: 40000 Weight: 800 Upper: 63 Script: <" @@ -66490,7 +66490,7 @@ item_db: ( AegisName: "Agi_Dish08" Name: "Incredibly Spicy Curry" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66503,7 +66503,7 @@ item_db: ( AegisName: "Agi_Dish09" Name: "Special Meat Stew" Type: 0 - Buy: 0 + Buy: 80000 Weight: 1000 Upper: 63 Script: <" @@ -66516,7 +66516,7 @@ item_db: ( AegisName: "Agi_Dish10" Name: "Steamed Desert Scorpions" Type: 0 - Buy: 0 + Buy: 100000 Weight: 1000 Upper: 63 Script: <" @@ -66529,7 +66529,7 @@ item_db: ( AegisName: "Dex_Dish06" Name: "Peach Cake" Type: 0 - Buy: 0 + Buy: 20000 Weight: 800 Upper: 63 Script: <" @@ -66542,7 +66542,7 @@ item_db: ( AegisName: "Dex_Dish07" Name: "Soul Haunted Bread" Type: 0 - Buy: 0 + Buy: 40000 Weight: 800 Upper: 63 Script: <" @@ -66555,7 +66555,7 @@ item_db: ( AegisName: "Dex_Dish08" Name: "Special Toast" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66568,7 +66568,7 @@ item_db: ( AegisName: "Dex_Dish09" Name: "Heavenly Fruit Juice" Type: 0 - Buy: 0 + Buy: 80000 Weight: 500 Upper: 63 Script: <" @@ -66581,7 +66581,7 @@ item_db: ( AegisName: "Dex_Dish10" Name: "Hwergelmir's Tonic" Type: 0 - Buy: 0 + Buy: 100000 Weight: 1000 Upper: 63 Script: <" @@ -66594,7 +66594,7 @@ item_db: ( AegisName: "Luk_Dish06" Name: "Lucky Soup" Type: 0 - Buy: 0 + Buy: 20000 Weight: 300 Upper: 63 Script: <" @@ -66607,7 +66607,7 @@ item_db: ( AegisName: "Luk_Dish07" Name: "Assorted Shish Kebob" Type: 0 - Buy: 0 + Buy: 40000 Weight: 800 Upper: 63 Script: <" @@ -66620,7 +66620,7 @@ item_db: ( AegisName: "Luk_Dish08" Name: "Strawberry Flavored Rice Ball" Type: 0 - Buy: 0 + Buy: 60000 Weight: 100 Upper: 63 Script: <" @@ -66633,7 +66633,7 @@ item_db: ( AegisName: "Luk_Dish09" Name: "Blood Flavored Soda" Type: 0 - Buy: 0 + Buy: 80000 Weight: 1000 Upper: 63 Script: <" @@ -66646,7 +66646,7 @@ item_db: ( AegisName: "Luk_Dish10" Name: "Cooked Nine Tail's Tails" Type: 0 - Buy: 0 + Buy: 100000 Weight: 500 Upper: 63 Script: <" -- cgit v1.2.3-60-g2f50 From 3fae6a6a8f25406aab8cd568e40141c57f2110ce Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Thu, 28 Nov 2013 20:37:58 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 120 +++++++++++++++++++++++------------------------ 1 file changed, 60 insertions(+), 60 deletions(-) diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 6352dc61f..d8a5497cc 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -5324,66 +5324,66 @@ REPLACE INTO `item_db_re` VALUES ('12037','Lotto_Box03','Lotto Box 03','2','0',' REPLACE INTO `item_db_re` VALUES ('12038','Lotto_Box04','Lotto Box 04','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','getrandgroupitem 12038,1;','',''); REPLACE INTO `item_db_re` VALUES ('12039','Lotto_Box05','Lotto Box 05','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','getitem rand(7542,7546),1;','',''); REPLACE INTO `item_db_re` VALUES ('12040','Stone_Of_Intelligence_','Stone of Sage','2','100000','50000','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','homevolution;','',''); -REPLACE INTO `item_db_re` VALUES ('12041','Str_Dish01','Fried Grasshopper Legs','0','0','0','60','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,1; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12042','Str_Dish02','Seasoned Sticky Webfoot','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,2; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12043','Str_Dish03','Bomber Steak','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,3; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12044','Str_Dish04','Herb Marinade Beef','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,4; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12045','Str_Dish05','Lutie Lady\'s Pancake','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,5; percentheal 10,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12046','Int_Dish01','Grape Juice Herbal Tea','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,1; percentheal 0,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12047','Int_Dish02','Autumn Red Tea','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,2; percentheal 0,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12048','Int_Dish03','Honey Herbal Tea','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,3; percentheal 0,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12049','Int_Dish04','Morroc Fruit Wine','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,4; percentheal 0,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12050','Int_Dish05','Mastela Fruit Wine','0','0','0','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,5; percentheal 0,10;','',''); -REPLACE INTO `item_db_re` VALUES ('12051','Vit_Dish01','Steamed Crab Nippers','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,1; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12052','Vit_Dish02','Assorted Seafood','0','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,2; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12053','Vit_Dish03','Clam Soup','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,3; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12054','Vit_Dish04','Seasoned Jellyfish','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,4; percentheal 5,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12055','Vit_Dish05','Spicy Fried Bao','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,5; percentheal 10,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12056','Agi_Dish01','Frog Egg Squid Ink Soup','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,1; percentheal 3,1;','',''); -REPLACE INTO `item_db_re` VALUES ('12057','Agi_Dish02','Smooth Noodle','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,2; percentheal 3,1;','',''); -REPLACE INTO `item_db_re` VALUES ('12058','Agi_Dish03','Tentacle Cheese Gratin','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,3; percentheal 3,1;','',''); -REPLACE INTO `item_db_re` VALUES ('12059','Agi_Dish04','Lutie Cold Noodle','0','0','0','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,4; percentheal 3,1;','',''); -REPLACE INTO `item_db_re` VALUES ('12060','Agi_Dish05','Steamed Bat Wing in Pumpkin','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,5; percentheal 6,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12061','Dex_Dish01','Honey Grape Juice','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,1; percentheal 2,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12062','Dex_Dish02','Chocolate Mousse Cake','0','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,2; percentheal 2,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12063','Dex_Dish03','Fruit Mix','0','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,3; percentheal 2,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12064','Dex_Dish04','Cream Sandwich','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,4; percentheal 2,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12065','Dex_Dish05','Green Salad','0','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,5; percentheal 5,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12066','Luk_Dish01','Fried Monkey Tails','0','0','0','60','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,1; percentheal 3,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12067','Luk_Dish02','Mixed Juice','0','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,2; percentheal 3,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12068','Luk_Dish03','Fried Sweet Potato','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,3; percentheal 4,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12069','Luk_Dish04','Steamed Ancient Lips','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,4; percentheal 4,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12070','Luk_Dish05','Fried Scorpion Tails','0','0','0','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,5; percentheal 5,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12071','Str_Dish06','Shiny Marinade Beef','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,6; percentheal 10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12072','Str_Dish07','Whole Roast','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,7; percentheal 10,4;','',''); -REPLACE INTO `item_db_re` VALUES ('12073','Str_Dish08','Bearfoot Special','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,8; percentheal 15,6;','',''); -REPLACE INTO `item_db_re` VALUES ('12074','Str_Dish09','Tendon Satay','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,9; percentheal 15,8;','',''); -REPLACE INTO `item_db_re` VALUES ('12075','Str_Dish10','Steamed Tongue','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,10; percentheal 20,20;','',''); -REPLACE INTO `item_db_re` VALUES ('12076','Int_Dish06','Red Mushroom Wine','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,6; percentheal 2,10;','',''); -REPLACE INTO `item_db_re` VALUES ('12077','Int_Dish07','Special Royal Jelly Herbal Tea','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,7; percentheal 4,10;','',''); -REPLACE INTO `item_db_re` VALUES ('12078','Int_Dish08','Royal Family Tea','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,8; percentheal 6,10;','',''); -REPLACE INTO `item_db_re` VALUES ('12079','Int_Dish09','Tristram 12','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,9; percentheal 8,15;','',''); -REPLACE INTO `item_db_re` VALUES ('12080','Int_Dish10','Dragon Breath Cocktail','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,10; percentheal 10,20;','',''); -REPLACE INTO `item_db_re` VALUES ('12081','Vit_Dish06','Awfully Bitter Bracer','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,6; percentheal 13,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12082','Vit_Dish07','Sumptuous Feast','0','0','0','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,7; percentheal 16,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12083','Vit_Dish08','Giant Burito','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,8; percentheal 19,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12084','Vit_Dish09','Ascending Dragon Soup','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,9; percentheal 22,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12085','Vit_Dish10','Immortal Stew','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,10; percentheal 25,0;','',''); -REPLACE INTO `item_db_re` VALUES ('12086','Agi_Dish06','Chile Shrimp Gratin','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,6; percentheal 7,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12087','Agi_Dish07','Steamed Alligator with Vegetable','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,7; percentheal 8,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12088','Agi_Dish08','Incredibly Spicy Curry','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,8; percentheal 9,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12089','Agi_Dish09','Special Meat Stew','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,9; percentheal 10,2;','',''); -REPLACE INTO `item_db_re` VALUES ('12090','Agi_Dish10','Steamed Desert Scorpions','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,10; percentheal 15,5;','',''); -REPLACE INTO `item_db_re` VALUES ('12091','Dex_Dish06','Peach Cake','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,6; percentheal 5,6;','',''); -REPLACE INTO `item_db_re` VALUES ('12092','Dex_Dish07','Soul Haunted Bread','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,7; percentheal 5,7;','',''); -REPLACE INTO `item_db_re` VALUES ('12093','Dex_Dish08','Special Toast','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,8; percentheal 5,8;','',''); -REPLACE INTO `item_db_re` VALUES ('12094','Dex_Dish09','Heavenly Fruit Juice','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,9; percentheal 5,9;','',''); -REPLACE INTO `item_db_re` VALUES ('12095','Dex_Dish10','Hwergelmir\'s Tonic','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,10; percentheal 10,10;','',''); -REPLACE INTO `item_db_re` VALUES ('12096','Luk_Dish06','Lucky Soup','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,6; percentheal 6,3;','',''); -REPLACE INTO `item_db_re` VALUES ('12097','Luk_Dish07','Assorted Shish Kebob','0','0','0','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,7; percentheal 7,3;','',''); -REPLACE INTO `item_db_re` VALUES ('12098','Luk_Dish08','Strawberry Flavored Rice Ball','0','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,8; percentheal 9,3;','',''); -REPLACE INTO `item_db_re` VALUES ('12099','Luk_Dish09','Blood Flavored Soda','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,9; percentheal 10,4;','',''); -REPLACE INTO `item_db_re` VALUES ('12100','Luk_Dish10','Cooked Nine Tail\'s Tails','0','0','0','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,10; percentheal 14,8;','',''); +REPLACE INTO `item_db_re` VALUES ('12041','Str_Dish01','Fried Grasshopper Legs','0','2000','1000','60','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,1; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12042','Str_Dish02','Seasoned Sticky Webfoot','0','4000','2000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,2; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12043','Str_Dish03','Bomber Steak','0','6000','3000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,3; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12044','Str_Dish04','Herb Marinade Beef','0','8000','4000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,4; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12045','Str_Dish05','Lutie Lady\'s Pancake','0','10000','5000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,5; percentheal 10,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12046','Int_Dish01','Grape Juice Herbal Tea','0','2000','1000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,1; percentheal 0,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12047','Int_Dish02','Autumn Red Tea','0','4000','2000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,2; percentheal 0,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12048','Int_Dish03','Honey Herbal Tea','0','6000','3000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,3; percentheal 0,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12049','Int_Dish04','Morroc Fruit Wine','0','8000','4000','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,4; percentheal 0,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12050','Int_Dish05','Mastela Fruit Wine','0','10000','5000','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,5; percentheal 0,10;','',''); +REPLACE INTO `item_db_re` VALUES ('12051','Vit_Dish01','Steamed Crab Nippers','0','2000','1000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,1; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12052','Vit_Dish02','Assorted Seafood','0','4000','2000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,2; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12053','Vit_Dish03','Clam Soup','0','6000','3000','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,3; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12054','Vit_Dish04','Seasoned Jellyfish','0','8000','4000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,4; percentheal 5,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12055','Vit_Dish05','Spicy Fried Bao','0','10000','5000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,5; percentheal 10,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12056','Agi_Dish01','Frog Egg Squid Ink Soup','0','2000','1000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,1; percentheal 3,1;','',''); +REPLACE INTO `item_db_re` VALUES ('12057','Agi_Dish02','Smooth Noodle','0','4000','2000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,2; percentheal 3,1;','',''); +REPLACE INTO `item_db_re` VALUES ('12058','Agi_Dish03','Tentacle Cheese Gratin','0','6000','3000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,3; percentheal 3,1;','',''); +REPLACE INTO `item_db_re` VALUES ('12059','Agi_Dish04','Lutie Cold Noodle','0','8000','4000','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,4; percentheal 3,1;','',''); +REPLACE INTO `item_db_re` VALUES ('12060','Agi_Dish05','Steamed Bat Wing in Pumpkin','0','10000','5000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,5; percentheal 6,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12061','Dex_Dish01','Honey Grape Juice','0','2000','1000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,1; percentheal 2,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12062','Dex_Dish02','Chocolate Mousse Cake','0','4000','2000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,2; percentheal 2,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12063','Dex_Dish03','Fruit Mix','0','6000','3000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,3; percentheal 2,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12064','Dex_Dish04','Cream Sandwich','0','8000','4000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,4; percentheal 2,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12065','Dex_Dish05','Green Salad','0','10000','5000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,5; percentheal 5,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12066','Luk_Dish01','Fried Monkey Tails','0','2000','1000','60','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,1; percentheal 3,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12067','Luk_Dish02','Mixed Juice','0','4000','2000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,2; percentheal 3,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12068','Luk_Dish03','Fried Sweet Potato','0','6000','3000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,3; percentheal 4,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12069','Luk_Dish04','Steamed Ancient Lips','0','8000','4000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,4; percentheal 4,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12070','Luk_Dish05','Fried Scorpion Tails','0','10000','5000','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,5; percentheal 5,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12071','Str_Dish06','Shiny Marinade Beef','0','20000','10000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,6; percentheal 10,2;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_STR,1200000,7; percentheal 10,4;','',''); +REPLACE INTO `item_db_re` VALUES ('12073','Str_Dish08','Bearfoot Special','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_STR,1200000,8; percentheal 15,6;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_STR,1200000,9; percentheal 15,8;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_STR,1200000,10; percentheal 20,20;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_INT,1200000,6; percentheal 2,10;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_INT,1200000,7; percentheal 4,10;','',''); +REPLACE INTO `item_db_re` VALUES ('12078','Int_Dish08','Royal Family Tea','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,8; percentheal 6,10;','',''); +REPLACE INTO `item_db_re` VALUES ('12079','Int_Dish09','Tristram 12','0','80000','40000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,9; percentheal 8,15;','',''); +REPLACE INTO `item_db_re` VALUES ('12080','Int_Dish10','Dragon Breath Cocktail','0','100000','50000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_INT,1200000,10; percentheal 10,20;','',''); +REPLACE INTO `item_db_re` VALUES ('12081','Vit_Dish06','Awfully Bitter Bracer','0','20000','10000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,6; percentheal 13,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12082','Vit_Dish07','Sumptuous Feast','0','40000','20000','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,7; percentheal 16,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12083','Vit_Dish08','Giant Burito','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,8; percentheal 19,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12084','Vit_Dish09','Ascending Dragon Soup','0','80000','40000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,9; percentheal 22,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12085','Vit_Dish10','Immortal Stew','0','100000','50000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_VIT,1200000,10; percentheal 25,0;','',''); +REPLACE INTO `item_db_re` VALUES ('12086','Agi_Dish06','Chile Shrimp Gratin','0','20000','10000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,6; percentheal 7,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12087','Agi_Dish07','Steamed Alligator with Vegetable','0','40000','20000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,7; percentheal 8,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12088','Agi_Dish08','Incredibly Spicy Curry','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,8; percentheal 9,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12089','Agi_Dish09','Special Meat Stew','0','80000','40000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,9; percentheal 10,2;','',''); +REPLACE INTO `item_db_re` VALUES ('12090','Agi_Dish10','Steamed Desert Scorpions','0','100000','50000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_AGI,1200000,10; percentheal 15,5;','',''); +REPLACE INTO `item_db_re` VALUES ('12091','Dex_Dish06','Peach Cake','0','20000','10000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,6; percentheal 5,6;','',''); +REPLACE INTO `item_db_re` VALUES ('12092','Dex_Dish07','Soul Haunted Bread','0','40000','20000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,7; percentheal 5,7;','',''); +REPLACE INTO `item_db_re` VALUES ('12093','Dex_Dish08','Special Toast','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,8; percentheal 5,8;','',''); +REPLACE INTO `item_db_re` VALUES ('12094','Dex_Dish09','Heavenly Fruit Juice','0','80000','40000','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,9; percentheal 5,9;','',''); +REPLACE INTO `item_db_re` VALUES ('12095','Dex_Dish10','Hwergelmir\'s Tonic','0','100000','50000','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_DEX,1200000,10; percentheal 10,10;','',''); +REPLACE INTO `item_db_re` VALUES ('12096','Luk_Dish06','Lucky Soup','0','20000','10000','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,6; percentheal 6,3;','',''); +REPLACE INTO `item_db_re` VALUES ('12097','Luk_Dish07','Assorted Shish Kebob','0','40000','20000','800','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,7; percentheal 7,3;','',''); +REPLACE INTO `item_db_re` VALUES ('12098','Luk_Dish08','Strawberry Flavored Rice Ball','0','60000','30000','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','sc_start SC_FOOD_LUK,1200000,8; percentheal 9,3;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_LUK,1200000,9; percentheal 10,4;','',''); +REPLACE INTO `item_db_re` 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','sc_start SC_FOOD_LUK,1200000,10; percentheal 14,8;','',''); REPLACE INTO `item_db_re` VALUES ('12101','Citron','Citron','0','20','10','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','',''); REPLACE INTO `item_db_re` 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','','',''); REPLACE INTO `item_db_re` 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','monster \"this\",-1,-1,\"--ja--\",-3,1,\"\";','',''); -- cgit v1.2.3-60-g2f50 From 0cf52e88ea2779d00c64e36b33e606d658682136 Mon Sep 17 00:00:00 2001 From: Haru Date: Fri, 29 Nov 2013 00:51:32 +0100 Subject: Corrected an uninitialized variable when adding an item - The .favorite field of newly added inventory items wasn't correctly initialized to zero, potentially causing data loss (fixes bugreport:7854, thanks to Vincent, GrumpyPanda). Signed-off-by: Haru --- src/char/char.c | 1 + src/map/mob.c | 2 +- src/map/pc.c | 4 +++- 3 files changed, 5 insertions(+), 2 deletions(-) diff --git a/src/char/char.c b/src/char/char.c index 63b47cfcf..e58fc9eef 100644 --- a/src/char/char.c +++ b/src/char/char.c @@ -1278,6 +1278,7 @@ int mmo_char_fromsql(int char_id, struct mmo_charstatus* p, bool load_everything StrBuf->Printf(&buf, ", `card%d`", j); StrBuf->Printf(&buf, " FROM `%s` WHERE `char_id`=? LIMIT %d", cart_db, MAX_CART); + memset(&tmp_item, 0, sizeof(tmp_item)); if( SQL_ERROR == SQL->StmtPrepareStr(stmt, StrBuf->Value(&buf)) || SQL_ERROR == SQL->StmtBindParam(stmt, 0, SQLDT_INT, &char_id, 0) || SQL_ERROR == SQL->StmtExecute(stmt) diff --git a/src/map/mob.c b/src/map/mob.c index 777518d87..1e197756e 100644 --- a/src/map/mob.c +++ b/src/map/mob.c @@ -2448,7 +2448,6 @@ int mob_dead(struct mob_data *md, struct block_list *src, int type) { if(mvp_sd && md->db->mexp > 0 && !md->special_state.ai) { int log_mvp[2] = {0}; unsigned int mexp; - struct item item; double exp; //mapflag: noexp check [Lorky] @@ -2471,6 +2470,7 @@ int mob_dead(struct mob_data *md, struct block_list *src, int type) { /* pose them randomly in the list -- so on 100% drop servers it wont always drop the same item */ int mdrop_id[MAX_MVP_DROP]; int mdrop_p[MAX_MVP_DROP]; + struct item item; memset(&mdrop_id,0,MAX_MVP_DROP*sizeof(int)); diff --git a/src/map/pc.c b/src/map/pc.c index b5fa9268e..6120ba033 100644 --- a/src/map/pc.c +++ b/src/map/pc.c @@ -3997,9 +3997,11 @@ int pc_additem(struct map_session_data *sd,struct item *item_data,int amount,e_l return 4; memcpy(&sd->status.inventory[i], item_data, sizeof(sd->status.inventory[0])); - // clear equips field first, just in case + // clear equip and favorite fields first, just in case if( item_data->equip ) sd->status.inventory[i].equip = 0; + if( item_data->favorite ) + sd->status.inventory[i].favorite = 0; sd->status.inventory[i].amount = amount; sd->inventory_data[i] = data; -- cgit v1.2.3-60-g2f50 From 0dfcf15836d90fa4bc72e3a0e648d2ec8b5eca78 Mon Sep 17 00:00:00 2001 From: Haru Date: Fri, 29 Nov 2013 01:49:32 +0100 Subject: Fixed a missing/incorrect check in the Moscovia Whale quest - Most of the checks for the GUSLI accessory were completely ineffective, and could be bypassed by wearing any accessory. - Replaced numeric item ID with the item DB constant. Signed-off-by: Haru --- npc/quests/quests_moscovia.txt | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/npc/quests/quests_moscovia.txt b/npc/quests/quests_moscovia.txt index fd68f6663..a181a81d9 100644 --- a/npc/quests/quests_moscovia.txt +++ b/npc/quests/quests_moscovia.txt @@ -1484,7 +1484,7 @@ mosk_fild01,86,104,3 script Aged Stranger#npc 4_M_GUSLIMAN,{ mes "This is a traditional instrument"; mes "which comes from a faraway land of"; mes "the ancestors of Moscovia."; - getitem 2707,1; + getitem GUSLI, 1; set mos_whale_edq,35; next; mes "[Aged Stranger]"; @@ -1509,7 +1509,7 @@ mosk_fild01,86,104,3 script Aged Stranger#npc 4_M_GUSLIMAN,{ mes "Are you ready to learn the Gusli?"; mes "Please equip the Gusli."; next; - if (getequipid(EQI_ACC_L) || getequipid(EQI_ACC_R) == 2707) { + if (getequipid(EQI_ACC_L) == GUSLI || getequipid(EQI_ACC_R) == GUSLI) { mes "[Aged Stranger]"; mes "Hm... Very well."; mes "At first, look at me how I play,"; @@ -1552,7 +1552,7 @@ mosk_fild01,86,104,3 script Aged Stranger#npc 4_M_GUSLIMAN,{ mes "[Aged Stranger]"; mes "Are you ready to learn the Gusli?"; next; - if (getequipid(EQI_ACC_L) || getequipid(EQI_ACC_R) == 2707) { + if (getequipid(EQI_ACC_L) == GUSLI || getequipid(EQI_ACC_R) == GUSLI) { mes "[Aged Stranger]"; mes "Um... You did well."; next; @@ -2123,7 +2123,7 @@ mosk_in,131,92,3 script Csar Alexsay III#npc 4_M_RUSKING,{ mes "A Gooselri? Which only exists"; mes "in the whale island? Let's see."; next; - if (getequipid(EQI_ACC_L) || getequipid(EQI_ACC_R) == 2707 || countitem(2707) > 0) { + if (countitem(GUSLI) > 0) { mes "[Csar Alexsay III]"; mes "Oh... Is this instrument... a Gooselri?"; next; @@ -2233,7 +2233,7 @@ mosk_in,131,92,3 script Csar Alexsay III#npc 4_M_RUSKING,{ mes "something to satisfy me"; mes "at the whale island?"; next; - if (getequipid(EQI_ACC_L) || getequipid(EQI_ACC_R) == 2707 || countitem(2707)) { + if (countitem(GUSLI) > 0) { mes "[Csar Alexsay III]"; mes "Oh... Is this instrument... a Gooselri?"; next; @@ -2478,7 +2478,7 @@ OnTouch: mes "Stop by the whale island?"; next; if(select("Go to Whale Island.:Stay put.") == 1) { - if (getequipid(EQI_ACC_L) == 2707 || getequipid(EQI_ACC_R) == 2707) { + if (getequipid(EQI_ACC_L) == GUSLI || getequipid(EQI_ACC_R) == GUSLI) { soundeffect "mos_gusli2.wav",0; mes "-Slowly, your hands are on the"; mes "Gusli, and the playing starts..."; -- cgit v1.2.3-60-g2f50 From 19758ee2206dd4d1183028e9f25c2b86f6716b73 Mon Sep 17 00:00:00 2001 From: malufett Date: Fri, 29 Nov 2013 11:11:17 +0800 Subject: Update JOB_REBELLION 'job_db1.txt' to its official values and some mini adjustment. Signed-off-by: malufett --- conf/battle/battle.conf | 1 + conf/messages.conf | 4 ++-- db/re/job_db1.txt | 5 +++-- src/char/inter.c | 5 ++++- src/map/pc.c | 5 +++-- 5 files changed, 13 insertions(+), 7 deletions(-) diff --git a/conf/battle/battle.conf b/conf/battle/battle.conf index 70062a16e..5b72f5ff9 100644 --- a/conf/battle/battle.conf +++ b/conf/battle/battle.conf @@ -54,6 +54,7 @@ player_damage_delay_rate: 100 undead_detect_type: 0 // Does HP recover if hit by an attribute that's same as your own? (Note 1) +// (Will not work in Renewal) attribute_recover: no // What is the minimum and maximum hitrate of normal attacks? diff --git a/conf/messages.conf b/conf/messages.conf index aae0596af..ba63dc73a 100644 --- a/conf/messages.conf +++ b/conf/messages.conf @@ -621,7 +621,8 @@ 652: Expanded Super Baby 653: Kagerou 654: Oboro -655: Unknown Job +655: Rebellion +656: Unknown Job // MvP Tomb // Added here so it can be easily translated @@ -667,7 +668,6 @@ 691: Sura T 692: Genetic T 693: Shadow Chaser T -694: Rebellion //------------------------------------ diff --git a/db/re/job_db1.txt b/db/re/job_db1.txt index ff175592a..abc9d2bb8 100644 --- a/db/re/job_db1.txt +++ b/db/re/job_db1.txt @@ -52,7 +52,7 @@ // Super Novice 23, 20000,0 ,500 ,100 ,440 ,590 ,610 ,2000 ,2000 ,2000 ,540 ,2000 ,540 ,540 ,690 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,690 ,540 // Gunslinger -24, 28000,88 ,0 ,450 ,540 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,490 ,590 ,440 ,940 ,1040 ,2000 ,2000 ,600 +24, 28000,88 ,0 ,450 ,540 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,490 ,590 ,540 ,940 ,1040 ,2000 ,2000 ,600 // Ninja 25, 26000,80 ,0 ,515 ,440 ,470 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,590 ,2000 ,500 // Novice High @@ -270,4 +270,5 @@ // Oboro 4212, 26000,80 , 0 ,515 ,400 ,500 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 , 750 ,2000 ,500 // Rebellion -4215, 28000,88 , 0 ,450 ,540 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,490 ,590 ,440 ,940 ,1040 ,2000 ,2000 ,600 + +4215, 28000,88 , 0 ,450 ,550 ,2000, 2000, 2000, 2000, 2000, 2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 ,2000 , 520 , 620 , 570 ,970 ,1070 ,2000 ,2000 ,600 diff --git a/src/char/inter.c b/src/char/inter.c index b213f1608..771b51602 100644 --- a/src/char/inter.c +++ b/src/char/inter.c @@ -341,8 +341,11 @@ const char* job_name(int class_) { case JOB_OBORO: return msg_txt(653 - JOB_KAGEROU+class_); - default: + case JOB_REBELLION: return msg_txt(655); + + default: + return msg_txt(656); } } diff --git a/src/map/pc.c b/src/map/pc.c index 6120ba033..57433ea0d 100644 --- a/src/map/pc.c +++ b/src/map/pc.c @@ -5759,11 +5759,12 @@ const char* job_name(int class_) case JOB_KAGEROU: case JOB_OBORO: return msg_txt(653 - JOB_KAGEROU+class_); + case JOB_REBELLION: - return msg_txt(694); + return msg_txt(655); default: - return msg_txt(655); + return msg_txt(656); } } -- cgit v1.2.3-60-g2f50 From 6f26bde38a967620b1d275136a72c5c181fbe6ae Mon Sep 17 00:00:00 2001 From: Patskie Date: Sat, 30 Nov 2013 14:00:06 +0800 Subject: - Fix Bug 7850 - Replace incorrect end commands with close - Update variable syntax Signed-off-by: Patskie Fix variables and character stuck at healing Signed-off-by: Patskie --- npc/custom/healer.txt | 17 +++++++++-------- 1 file changed, 9 insertions(+), 8 deletions(-) diff --git a/npc/custom/healer.txt b/npc/custom/healer.txt index e11e2a647..59d67b083 100644 --- a/npc/custom/healer.txt +++ b/npc/custom/healer.txt @@ -3,34 +3,35 @@ //===== By: ================================================== //= Euphy //===== Current Version: ===================================== -//= 1.1 +//= 1.2 //===== Description: ========================================= //= Basic healer script. //===== Additional Comments: ================================= //= 1.0 Initial script. //= 1.1 Aligned coordinates with @go. +//= 1.2 Fix variables and character stuck at healing //============================================================ - script Healer -1,{ - set .@price,0; // Zeny required for heal - set .@Buffs,0; // Also buff players? (1: yes / 0: no) - set .@Delay,0; // Heal delay, in seconds + .@price = 0; // Zeny required for heal + .@Buffs = 0; // Also buff players? (1: yes / 0: no) + .@Delay = 0; // Heal delay, in seconds if (@HD > gettimetick(2)) end; if (.@price) { message strcharinfo(0),"Healing costs "+.@price+" Zeny."; if (Zeny < .@price) end; - if(select("^0055FFHeal^000000:^777777Cancel^000000") == 2) end; - set Zeny, Zeny-.@price; + if(select("^0055FFHeal^000000:^777777Cancel^000000") == 2) close; + Zeny -= .@price; } specialeffect2 EF_HEAL2; percentheal 100,100; if (.@Buffs) { specialeffect2 EF_INCAGILITY; sc_start SC_INC_AGI,240000,10; specialeffect2 EF_BLESSING; sc_start SC_BLESSING,240000,10; } - if (.@Delay) set @HD, gettimetick(2)+.@Delay; - end; + if (.@Delay) @HD = gettimetick(2)+.@Delay; + close; } -- cgit v1.2.3-60-g2f50