Life is Feudal Official Forum

[Ghost_swe79]

Hi

wanted to change back our claim timer on our server so i do what i always do after a update download and makes a backup on the patch file.

But the file does not look the same anymore and i cant even find the column for the claimtime anymore? anyone knows whats up? or are we not allowed anymore to do this kind of changes??


Best Regards^^

[DarkKnyte]

Patch.SQL applies changes to the DB that are required when features are added or removed. It creates the structure and in some cases adds default values to those new sections after they are created. It's run each time the game is started up and is really only needed after an update. It looks different because the update is different from the last one.

Rename patch.sql to patch.sql.old and make your changes to the DB. It should stick the next time you start the server, until the next time the game is updated and a new patch.sql is downloaded.

[Ghost_swe79]

Im sorry am not following u?

So u mean that just becuse I rename the new patch.sql to patch.sql.old

that would do that the claim time column should appear again? just sounds strange?

or do u mean that i should copy back the old pach.sql that was before the update or what?? and have 2 patch.sql??

[TheZar]

doing that might not do anything
I inserted this code at the bottom of patch.sql.

Code: Select all

UPDATE `objects_types` SET `OwnerTimeout`= 432000 WHERE `OwnerTimeout` = 86400;


I also edited dump.sql and put the same code after this line

Code: Select all

INSERT INTO `objects_types` (`ID`, `ParentID`, `Name`

i think you will only need to edit dump.sql
this is the line should edit it to look like this

[Ghost_swe79]

doing that might not do anything
I inserted this code at the bottom of patch.sql.

Code: Select all

UPDATE `objects_types` SET `OwnerTimeout`= 432000 WHERE `OwnerTimeout` = 86400;


I also edited dump.sql and put the same code after this line

Code: Select all

INSERT INTO `objects_types` (`ID`, `ParentID`, `Name`

i think you will only need to edit dump.sql
this is the line should edit it to look like this

Thank u so much Zar^^ that is how a explanation should look like u saved my day again a great thank u^^

[Gms0012]

that is correct..
you need to edit dump.sql!

[Ghost_swe79]

A question more p

why is it 2 different times? can someone pls explain? should it be 2 different numbers becuse i like to have it to 7 days?

do i change them both or just one? correct me know if im wrong but it was only one before right?

SET `OwnerTimeout`= 432000 WHERE `OwnerTimeout` = 86400;

[TheZar]

A question more p

why is it 2 different times? can someone pls explain? should it be 2 different numbers becuse i like to have it to 7 days?

do i change them both or just one? correct me know if im wrong but it was only one before right?

SET `OwnerTimeout`= 432000 WHERE `OwnerTimeout` = 86400;

i dont understand what you mean

[Ghost_swe79]

432000 WHERE `OwnerTimeout` = 86400;

its different numbers??

its 5 days on one and the other is 24/H or??

[TheZar]

432000 WHERE `OwnerTimeout` = 86400;

its different numbers??

its 5 days on one and the other is 24/H or??

86400 is the standard 24 hours in seconds

432000 is 4 days in seconds,

The code replaces all the "86400" with 432000

[Ghost_swe79]

AAAA oki now i get it thanx Zar^^

[Ghost_swe79]

Have they changed the dump and patch.sql again trying to do this the same way as after last update but dont get it to work

Anyone willing to send me a print on where I need to set in the claim script again thank u^^

[TheZar]

Have they changed the dump and patch.sql again trying to do this the same way as after last update but dont get it to work

Anyone willing to send me a print on where I need to set in the claim script again thank u^^

still in dump.sql, but a bit further down after all the data insertions (all of which used to be on one line, they tidied it up)

Code: Select all

(1150,624,'Horse Carcass',1,1,0,0,0,0,1000000,6,0,0,'art\\images\\universal',0,0,0,0,0,0,'','',NULL,300);
UPDATE `objects_types` SET `OwnerTimeout`= 432000 WHERE `OwnerTimeout` = 86400;

--
-- Dumping data for table `recipe`


you need it to look like that, so its after the last data entry, but before the recipe line

[Ghost_swe79]

Thank u so much Zar it worked like a sharm with ur help =) sorry for late reply ^^