Life is Feudal | LiF | Remove low quality trees

How to remove low quality trees:

Follow these steps:

1. Download HeidiSQL here 
2. Connect using the details provided in the control panel - if you do not have these to hand, they can be found via the control panel, and pressing Show SQL details.
3. Run the query below on the database, you may alter it to change the level of trees effected. The query below effect quality 80 and below.

DELETE forest, forest_patch 
FROM forest, forest_patch 
WHERE forest.GeoDataID = forest_patch.GeoDataID  AND 
      forest.Quality < 80;

SET @c442 = 1;
SET @c443 = 1;
SET @c444 = 1;
SET @c445 = 1;
SET @c446 = 1;
SET @c447 = 1;
SET @c448 = 1;
SET @c449 = 1;
SET @c450 = 1;

UPDATE forest_patch 
SET Version = @c442:[email protected]+1
WHERE TerID = 442;

UPDATE forest_patch 
SET Version = @c443:[email protected]+1
WHERE TerID = 443;

UPDATE forest_patch 
SET Version = @c444:[email protected]+1
WHERE TerID = 444;

UPDATE forest_patch 
SET Version = @c445:[email protected]+1
WHERE TerID = 445;

UPDATE forest_patch 
SET Version = @c446:[email protected]+1
WHERE TerID = 446;

UPDATE forest_patch 
SET Version = @c447:[email protected]+1
WHERE TerID = 447;

UPDATE forest_patch 
SET Version = @c448:[email protected]+1
WHERE TerID = 448;

UPDATE forest_patch 
SET Version = @c449:[email protected]+1
WHERE TerID = 449;

UPDATE forest_patch 
SET Version = @c450:[email protected]+1
WHERE TerID = 450;

SET @c442 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 442 ORDER BY TerID);
SET @c443 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 443 ORDER BY TerID);
SET @c444 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 444 ORDER BY TerID);
SET @c445 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 445 ORDER BY TerID);
SET @c446 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 446 ORDER BY TerID);
SET @c447 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 447 ORDER BY TerID);
SET @c448 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 448 ORDER BY TerID);
SET @c449 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 449 ORDER BY TerID);
SET @c450 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 450 ORDER BY TerID);

UPDATE terrain_blocks 
SET ForestVersion = @c442
WHERE ID = 442;

UPDATE terrain_blocks 
SET ForestVersion = @c443
WHERE ID = 443;

UPDATE terrain_blocks 
SET ForestVersion = @c444
WHERE ID = 444;

UPDATE terrain_blocks 
SET ForestVersion = @c445
WHERE ID = 445;

UPDATE terrain_blocks 
SET ForestVersion = @c446
WHERE ID = 446;

UPDATE terrain_blocks 
SET ForestVersion = @c447
WHERE ID = 447;

UPDATE terrain_blocks 
SET ForestVersion = @c448
WHERE ID = 448;

UPDATE terrain_blocks 
SET ForestVersion = @c449
WHERE ID = 449;

UPDATE terrain_blocks 
SET ForestVersion = @c450
WHERE ID = 450;

 

Looking for a game server host known for brilliant 24/7 customer support and quality hardware?

Try a Pingperfect Life is Feudal server today! https://pingperfect.com/gameservers/lif-life-is-feudal-game-server-hosting-rental.php

 

  • lif, trees, sql, database, growth, Life is Feudal LiF Remove low quality trees, Life is Feudal, Remove low quality trees, LIF, LiF, Life is Feudal Remove low quality trees, LiF Remove low quality trees
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Life is Feudal | LiF | Changing Actions / SkillTypes.xml editing

Navigate to your control panel. Select "Configuration Files". Edit the skilltypes.xml file...

Life is Feudal | LiF | Item Codes

You can generate any object through the GM Console in Life is Feudal. The table below contains...

Life is Feudal | LiF | Admin Commands & Help

To open console window press CTRL + @ for UK QWERTY Keyboards /gm /gm password (using the...

Life is Feudal | LiF | Direct Connection

Below is how you can connect to your server without having to wait for the server list to...

Life is Feudal | LiF | Unban a Player

You'll need to connect to your database (Step 1) then follow the YouTube video (Step 2)Step...