missing ingredient/pizza recipes

Post Reply
anemathis
Posts: 3
Joined: Sun Apr 24, 2016 11:32 pm

missing ingredient/pizza recipes

Post by anemathis » Sun Apr 24, 2016 11:49 pm

Hey dudes. Love the work everyone on here is doing! Love love love it!

In attempting some cooking earlier today It came to my attention that the following recipes are not on the database. I'm not familiar enough yet with the DB here to commit these changes myself so I am posting them here for someone more experienced to hopefully take this on.

Marinara Sauce (61)

Yield: Marinara Sauce x 4 - 5747
Water Crystal
1 x Kazham Peppers
1 x Black Pepper - 626
1 x Olive Oil - 633
1 x Rock Salt - 936
1 x Mithran Tomato - 4390
1 x Anchovy - 5652

Pomodoro Sauce (28)
Yield: Pomodoro Sauce x 4 - 5194
Water Crystal
1 x Bay Leaves - 623
1 x Black Pepper - 626
1 x Olive Oil - 633
1 x Rock Salt - 936
1 x Holy Basil - 1590
1 x Wild Onion - 4387
1 x Mithran Tomato - 4390
1 x Misareaux Parsley - 5195

Marinara Pizza (40)
Yield: Marinara Pizza x 1 - 5743
HQ 1: Marinara Pizza +1 x 1 -5744
Fire Crystal
1 x Mhaura Garlic - 614
1 x Dried Marjoram - 622
1 x Holy Basil - 1590
1 x Pizza Dough - 2561
1 x Chalaimbille - 5684
1 x Marinara Sauce - 5747
Last edited by anemathis on Mon Apr 25, 2016 4:08 pm, edited 2 times in total.

Avatarati
Posts: 53
Joined: Mon Jun 30, 2014 2:51 pm

Re: missing ingredient/pizza recipes

Post by Avatarati » Mon Apr 25, 2016 12:07 am

Lookup all the item ID's for each ingredient and I'll build the queries for you ;)

anemathis
Posts: 3
Joined: Sun Apr 24, 2016 11:32 pm

Re: missing ingredient/pizza recipes

Post by anemathis » Mon Apr 25, 2016 4:07 pm

Avatarati wrote:Lookup all the item ID's for each ingredient and I'll build the queries for you ;)
That would be fantastic! I went ahead and updated my OP with item IDs gathered from here: https://wiki.dspt.info/index.php/Basic_Item_IDs

Many thanks!

Avatarati
Posts: 53
Joined: Mon Jun 30, 2014 2:51 pm

Re: missing ingredient/pizza recipes

Post by Avatarati » Tue Apr 26, 2016 12:52 am

Here you go. The ID's start at 4000, which should be way past the last ID in your database. May want to doublecheck though. Can change that as necessary.

Code: Select all

-- Marinara Sauce
INSERT INTO synth_recipes (ID,Type,KeyItem,Alchemy,Bone,Cloth,Cook,Gold,Leather,Smith,Wood,Crystal,HQCrystal,Ingredient1,Ingredient2,Ingredient3,Ingredient4,
Ingredient5,Ingredient6,Ingredient7,Ingredient8,Result,ResultHQ1,ResultHQ2,ResultHQ3,ResultQty,ResultHQ1Qty,ResultHQ2Qty,ResultHQ3Qty)
VALUES (4000,1,0,0,0,0,61,0,0,0,0,4101,4243,612,626,633,936,4390,5652,0,0,5747,5747,5747,5747,4,4,4,4);

-- Pomodoro Sauce
INSERT INTO synth_recipes (ID,Type,KeyItem,Alchemy,Bone,Cloth,Cook,Gold,Leather,Smith,Wood,Crystal,HQCrystal,Ingredient1,Ingredient2,Ingredient3,Ingredient4,
Ingredient5,Ingredient6,Ingredient7,Ingredient8,Result,ResultHQ1,ResultHQ2,ResultHQ3,ResultQty,ResultHQ1Qty,ResultHQ2Qty,ResultHQ3Qty)
VALUES (4001,1,0,0,0,0,28,0,0,0,0,4101,4243,623,626,633,936,1590,4387,4390,5195,5194,5194,5194,5194,4,4,4,4);

-- Marinara Pizza
INSERT INTO synth_recipes (ID,Type,KeyItem,Alchemy,Bone,Cloth,Cook,Gold,Leather,Smith,Wood,Crystal,HQCrystal,Ingredient1,Ingredient2,Ingredient3,Ingredient4,
Ingredient5,Ingredient6,Ingredient7,Ingredient8,Result,ResultHQ1,ResultHQ2,ResultHQ3,ResultQty,ResultHQ1Qty,ResultHQ2Qty,ResultHQ3Qty)
VALUES (4002,1,0,0,0,0,40,0,0,0,0,4096,4238,614,622,1590,2561,5684,5747,0,0,5743,5744,5744,5744,1,1,1,1);
Just put this into whatever database application you're using, paste into a query builder, and execute!

Avatarati
Posts: 53
Joined: Mon Jun 30, 2014 2:51 pm

Re: missing ingredient/pizza recipes

Post by Avatarati » Tue Apr 26, 2016 12:57 am

Oh, also as a note, Pomodoro Sauce should already be in the database. So make sure to not insert that one. The Marinara Sauce and Marinara Pizza are not though.

anemathis
Posts: 3
Joined: Sun Apr 24, 2016 11:32 pm

Re: missing ingredient/pizza recipes

Post by anemathis » Sat Apr 30, 2016 6:51 pm

Awesome! Thanks so much! and you were right about the pomodoro, i didnt think to look under "bowl of pomodoro sauce"

Post Reply