Life is Feudal Official Forum

[Alakar]

It does not return any results or show you any results, it runs until it reorganizes all the changes. Which can be several hours per tile depending on how many changes have occurred.

-Alakar

[Alakar]

Figured out a new version that takes only seconds to do per world terrain tile. =) Much better than the hours the previous one took. Testing some more first.

-Alakar
http://arkhaya.com/

[NavyS34l]

Figured out a new version that takes only seconds to do per world terrain tile. =) Much better than the hours the previous one took. Testing some more first.

-Alakar
http://arkhaya.com/

that's awesome news, I did see you last post, just haven't had a chance to sit down and work on it some more. I'm curious to hear your approach on it. Hope to have some time tonight.

[DiWorm]

any news about tunnel remover?

[Revv]

I would be very interested in this also!
Any more news on it?

[Alakar]

Code: Select all

CREATE PROCEDURE `test_tun_removal`(IN `GeoTerID` INT)
   LANGUAGE SQL
   NOT DETERMINISTIC
   CONTAINS SQL
   SQL SECURITY DEFINER
   COMMENT ''

BEGIN

CREATE Temporary TABLE `ark_tuntemp` (
   `ID` INT NULL,
   INDEX `ID` (`ID`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

CREATE TEMPORARY TABLE `ark_geo_versions` (
   `Version` INT(11) NULL DEFAULT NULL,
   `NewVersion` INT(11) NULL DEFAULT NULL,
   INDEX `Version` (`Version`),
   UNIQUE INDEX `NewVersion` (`NewVersion`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;


insert into ark_tuntemp ( ID ) (
   SELECT ID from geo_patch
   WHERE Version in ( select Version from geo_patch where ( Substance = 0 or LevelFlags = 128 )and TerID = GeoTerID ) and TerID = GeoTerID
);

-- DELETE TUNNELS

DELETE FROM geo_patch where ID in ( Select ID from ark_tuntemp );

-- RE-INDEX
INSERT INTO ark_geo_versions ( Version ) ( SELECT Version from geo_patch where TerID = GeoTerID group by Version);

SET @n = 1;
UPDATE ark_geo_versions SET NewVersion = @n:=@n+1;

UPDATE geo_patch g
JOIN ark_geo_versions v on v.Version = g.Version
SET g.Version = v.NewVersion WHERE g.TerID = GeoTerID;

UPDATE terrain_blocks SET GeoVersion = ( select Version from geo_patch where TerID = GeoTerID order by Version desc limit 1 ) WHERE ID = GeoTerID;

drop temporary table if exists ark_tuntemp;
DROP TEMPORARY TABLE IF EXISTS ark_geo_versions;

END

This is what I have so far that works really well. It will remove all tunnels but there are some side effects in areas where people have tried to tunnel but not finished building one where some rock and other things might be pushed up a bit at the entrance. I am sure it just means that there are more things to find, but searching for Substance 0 which is Air or LevelFlags set to 128 (Tunnel Walls) seems to get most when you include everything else in that terrain ID with the same version.

To use serverwide just

Code: Select all

call test_tun_removal(442);
call test_tun_removal(443);
call test_tun_removal(444);
call test_tun_removal(445);
call test_tun_removal(446);
call test_tun_removal(447);
call test_tun_removal(448);
call test_tun_removal(449);
call test_tun_removal(450);


Afterwards remove all references to cached patches from the terrain_blocks table (will write basic function for this later) and start server. First few loads will take clients a little longer to load into as they are not able to use the cached terrain until server has underwent "midhight maintenance."

-Alakar
http://arkhaya.com/

[DiWorm]

Code: Select all

CREATE PROCEDURE `test_tun_removal`(IN `GeoTerID` INT)
   LANGUAGE SQL
   NOT DETERMINISTIC
   CONTAINS SQL
   SQL SECURITY DEFINER
   COMMENT ''

BEGIN

CREATE Temporary TABLE `ark_tuntemp` (
   `ID` INT NULL,
   INDEX `ID` (`ID`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

CREATE TEMPORARY TABLE `ark_geo_versions` (
   `Version` INT(11) NULL DEFAULT NULL,
   `NewVersion` INT(11) NULL DEFAULT NULL,
   INDEX `Version` (`Version`),
   UNIQUE INDEX `NewVersion` (`NewVersion`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;


insert into ark_tuntemp ( ID ) (
   SELECT ID from geo_patch
   WHERE Version in ( select Version from geo_patch where ( Substance = 0 or LevelFlags = 128 )and TerID = GeoTerID ) and TerID = GeoTerID
);

-- DELETE TUNNELS

DELETE FROM geo_patch where ID in ( Select ID from ark_tuntemp );

-- RE-INDEX
INSERT INTO ark_geo_versions ( Version ) ( SELECT Version from geo_patch where TerID = GeoTerID group by Version);

SET @n = 1;
UPDATE ark_geo_versions SET NewVersion = @n:=@n+1;

UPDATE geo_patch g
JOIN ark_geo_versions v on v.Version = g.Version
SET g.Version = v.NewVersion WHERE g.TerID = GeoTerID;

UPDATE terrain_blocks SET GeoVersion = ( select Version from geo_patch where TerID = GeoTerID order by Version desc limit 1 ) WHERE ID = GeoTerID;

drop temporary table if exists ark_tuntemp;
DROP TEMPORARY TABLE IF EXISTS ark_geo_versions;

END

This is what I have so far that works really well. It will remove all tunnels but there are some side effects in areas where people have tried to tunnel but not finished building one where some rock and other things might be pushed up a bit at the entrance. I am sure it just means that there are more things to find, but searching for Substance 0 which is Air or LevelFlags set to 128 (Tunnel Walls) seems to get most when you include everything else in that terrain ID with the same version.

To use serverwide just

Code: Select all

call test_tun_removal(442);
call test_tun_removal(443);
call test_tun_removal(444);
call test_tun_removal(445);
call test_tun_removal(446);
call test_tun_removal(447);
call test_tun_removal(448);
call test_tun_removal(449);
call test_tun_removal(450);


Afterwards remove all references to cached patches from the terrain_blocks table (will write basic function for this later) and start server. First few loads will take clients a little longer to load into as they are not able to use the cached terrain until server has underwent "midhight maintenance."

-Alakar
http://arkhaya.com/

Thanks a lot!

But can you give some example for remove all references to cached patches from the terrain_blocks table
dont understand whats need to do here

Set to NULL for TerCachedCRC?

[Alakar]

Code: Select all

UPDATE `terrain_blocks` SET `CachedGeoVersion`=NULL, `CachedTerCRC`=NULL, `CachedServerGeoIdxCRC`=NULL, `CachedServerGeoDatCRC`=NULL, `CachedClientGeoIdxCRC`=NULL, `CachedClientGeoDatCRC`=NULL, `PackedTerCRC`=NULL, `PackedClientGeoIdxCRC`=NULL, `PackedClientGeoDatCRC`=NULL, `CachedClientGeoIdxSize`=NULL, `CachedClientGeoDatSize`=NULL WHERE  `ID`>0;

That will reset them all.

-Alakar

[DiWorm]

Code: Select all

UPDATE `terrain_blocks` SET `CachedGeoVersion`=NULL, `CachedTerCRC`=NULL, `CachedServerGeoIdxCRC`=NULL, `CachedServerGeoDatCRC`=NULL, `CachedClientGeoIdxCRC`=NULL, `CachedClientGeoDatCRC`=NULL, `PackedTerCRC`=NULL, `PackedClientGeoIdxCRC`=NULL, `PackedClientGeoDatCRC`=NULL, `CachedClientGeoIdxSize`=NULL, `CachedClientGeoDatSize`=NULL WHERE  `ID`>0;

That will reset them all.

-Alakar

Ok, I test it, it works normaly Thank you for this script ^_^

[Alakar]

Ok, I test it, it works normaly Thank you for this script ^_^

Thank you, I am still working on some more things on it to find other mining actions so we don't get the rock issue I described earlier.

-Alakar

[Ghost_swe79]

Have I understod this right to delete the tunnels, just go with one at the time as an quary all 3 of them and then restart the server?

Best regards

[Muffinman88]

hi guys ive been reading this post and dreaming of this for are lif server only prob is ive never done anything like this before and was wonderin if anyone could shed some light onto how i learn to run scripts

[BladeRavinger]

Stupid question..... well not really a smart observation

wouldnt we just clear the patch.sql of updates then add a script that finds and removes all tunnels, then every server restart the tunnels will be deleted, you can move the patch.sql so that un foreseen crashes dont ruin the tunnels

[Alakar]

Stupid question..... well not really a smart observation

wouldnt we just clear the patch.sql of updates then add a script that finds and removes all tunnels, then every server restart the tunnels will be deleted, you can move the patch.sql so that un foreseen crashes dont ruin the tunnels

I would advise against it because maintenance scripts that take a longer amount of time sometimes prevent the server from booting.

-Alakar

[Dyfan]

Hey! Thanks for redirecting me to this post! I am novice in scripting but is this script still working? Heard from someone who is more into scripting that the tunnel script was out-dated from the last patch and would not work? I really need to add this to my server, http://life-is-feudal.org/server/5228/ , because it's getting out of hand with loading times and lag.

[Azeron]

When running the SQL against MariaDB version5.5.39:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 15

What is the version that your running your scripts on ?

[Flocky]

I would like to bring this discussion up again. Has anyone found a way to delete reinforced tunnels?

[Cogollops]

Then the full code to use it is?

[SomeoneD]

Has anyone found a way to delete reinforced tunnels? *HELP*

[Eso]

With this tool https://www.absoftware.it/LIFManager.
You can select an area on the map and delete things at your choiche:
Tunnels,
Geo Patches,
Trees,
Movable Objects,
Unmovable Objects.
After that you restart the server and the job its done .

Its have also others utility you can read in the software website.
Some of those is:
-Change the substance,altitude and quality of the surface material.
-Manage players inventory and more.