Life is Feudal Official Forum

[Starlyte05]

Hello

Steel is ID 401
Flux is ID 476
Iron is ID 402


When I look up any of these recipes under the Recipe or Recipe _ Requirements I cannot find any way to alter the flux required am I doing something wrong?

[Cattoaster]

Hej,

you have more than one recipes for steel (steel bars, steel ingots, steel lumps and lumps/bars/ingots from bars/ingots/lumps etc.)

Recipe with ID 132 is used for steel ingots (object id 401) with the following ingredients: flux and iron. You can find this info from the table 'recipe'.
Next step is to look up in the table 'recipe_requirements' where column 'RecipeID' matches your desired recipe with id 132:

Code: Select all

SQL output:
ID | RecipeID | MaterialObjectTypeID | Quality | Influence | Quantity
'400', '132', '402', '0', '70', '2'
'401', '132', '476', '0', '10', '12'
'402', '132', '138', '0', '5', '23'
'736', '132', '464', '0', '5', '30'


Flux is enlisted in the second row. With this info you can now edit the recipe_requirements as you wish, but keep in mind that you should edit the file dump.sql. Otherwise each server restart will reset your edits.
Search in dump.sql for "'401', '132', '476', '0', '10', '12'" (should be around line #2072).

[Starlyte05]

Excellent!!!! Thank you so much !

once I read your post it all kind of just clicked and everything is going great Cheers!

[Kael]

where i can find the dumb.sql?

i cant find it in the web ftp for my server and even in heidi-SQL i cant find any file which is named like this.

i changed the recipe for the Zweihänder, than i relogged from my server - because i cant restart it, because the file dumb.sql isnt found in my heidisql /


So i got:
recipe requierements.
there i got the recipre ID 314 for Zweihänder.
So i changed MaterialObjecttype from 364 to 401 - so that they should use the steel ingot and not longer the normal ingots.

when i press enter, nothing happens and even when i relogg the server dont want steel ingots and accept normal ingots as well.

[Kael]

nobody knows where i can find the dumb.sql?

i cant find it in HeidiSQL

[Cattoaster]

Dump.sql is a file you can find in <LiF dedicated server directory>\sql\dump.sql

You need SFTP or Remote Access to edit this file. Or ask your host support.

[Kael]

Thanks very much. i ask my host support, because i dont got the right to see this file.
got it now!

Now i just have to understand how i must change this file. i will try it