i have a big problem, after almost a year i decided to play again lif, but the problem is that the changes i made in the DB wont work.
1. Clients have edited .xml files
2. in the "patch.sql" are the "update"-commands that change storage amount in the warehouses and some other things.
but when server starts, the values in the db are resetted.
can someone tell me, how i can change the calues in the DB without that this values being resetted after every server start?
thanks for help and sry for bad english
in logfile:
- Code: Select all
^CREATE TABLE IF NOT EXI
ECHO 2016-02-05 10:58:58.756 {02} <initServer> ### Patching database [2/2]...
WARN 2016-02-05 10:58:58.756 {02} <initServer> ### DB::noRS(0 ms) USE `lif_1`;
WARN 2016-02-05 10:58:59.115 {02} <initServer> ### DB::mNoRS(353 ms) /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
DELETE FROM `animal_breeds`;
DELETE FROM `objects_types`;
DELETE FROM `recipe`;
DELETE FROM `recipe_requirement`;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
i tried to lock the tables in mysql but then the server hangs up when trying to patch the db.
