Remove low quality trees

How to remove low quality trees.

To remove low quality trees simply follow these steps.

1. Download HediSQL here 
2. Connect using the details provided in the contol panel - if you do not have theese to hand, they can be found via the control panel, and pressing Show SQL details.
3. Run the query bellow 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;
  • lif, trees, sql, database, growth
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Admin Commands & Help

~ in-game for console/gm /gm password (using the password set in world_X.xml [GM friends can...

Direct Connection

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

Unban a player

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

Connect to your database

1. Download Heidi Sql from here http://www.heidisql.com/download.php (Click the big Installer...

How To: Add a Custom Map

Please note it will take a few hours of downtime so make sure you have the time before you...