Life is Feudal Official Forum

[Devus]

Hello, problem looks that i edit recpie, and recpie_req.. , and all looks fine, i restart and boom normal, settings are on, and now best part.. my server is on blackboxservers, and i dont have file called... patch.sql, and dump.sql, any solve ? how change recpie for steel and mortar permamently?

[Starlyte05]

I also use Blackbox Servers, you have to Ticket them and ask for the SQL Files to be available.. once there Remove the Dump.sql and things will stay permanent! make sure you always make backups though!

enjoy

[Larainan]

I'm on ping perfect servers and I don't remove my dump sql I modify it the same as I have the patch sql file. I have my server do daily restarts at 5am and so far everything has worked fine for me and my mods have worked great. Even after the last hotfix my world has remained in tact.

[Durgrim]

hey guys. Im pretty new to modding.
So i see the patch.sql and the dump.sql and the new.sql on my server. Which ones have to be corrected in order to change
a) the flux needed for recipes
b) container capacity for trader cart, warehouse, large warehouse?


Thanks for helping me out

[Larainan]

Ok First let me start by saying open this website page it will help you immensely with item ID's for things like your bloomerym all smelting buildings and warehouses etc. http://orcz.com/Life_is_Feudal:_Objects_Database and this one for things like gold silver iron flux etc. https://lifeisfeudal.com/billing/gmcommands.php
In the new sql file i'll start with mortar. I changed my mortar recipe to give me 20 mortar per 1 flux instead of 5 mortar.

It is at line 138174 and looks like this (280, 'Mortar', '', 117, 17, 30, 528, 3, 25, 20),

So the recipe id is is 280 then name is obviously mortar, the description is blank, 117 is the kiln, 17 is the skill type associated with making mortar, in this case construction and materials prep, the number 30 refers to the necessary skill level to make the recipe, the result object type id is 528 which is the id for mortar. the number 6 refers to the crafting duration, the crafting skill depends on skill id type 25 and last but not least is quantity which is 5 originally. I changed mine to 20.

This all falls under 137963 /*!40000 ALTER TABLE `recipe` DISABLE KEYS */;

I also had to change it to 20 in the dump sql file at line 1521.

these were the only 2 changes necessary for mortar.

On to steel ingots
in the dump sql file I changed lines 2451 (401,132,476,0,10,2)
401 is steel ingot, 132 is the recipe id, 476 is flux, 0 is quality, 10 is a skill influence, and the 2 here was originally 12 meaning 12 flux, I changed it to 2.

then go down to 2463 and change the last number from 6 to 1 for the bar recipe.

and that was it I took the server offline

then I uploaded to my server after renaming the old dump sql and new sql to dump.old new.old. uploaded my edited files new and dump sql then I ran a repair on my server and restarted it

and flux was reduced for mortar and steel

[Durgrim]

awesome, thank you budd