Life is Feudal Official Forum

[Hieve]

Hello there,

I've been looking through the database to get some information about how many tree's are stumps atm and how the quality is of the most of them.

Well... forest_patch table says that there are 70.000 Trees with TreeHealth = 0 (=ill) from 100.000 rows - I'm not sure if this value can be correct as this would mean 3/4 of all trees on the map are ill.
next thing is the uproot > there are just 4! rows that have the TreeHealth = 3 (=Stump) , this can't be true as their are ALOT of tree's that need to be uprooted on the map (>100 minimum)

I'm not quite sure if I'm just looking at the false entries or if theres really something wrong...

besides that there are lots of tree's which are stumps on the map and the interaction with them is not possible (so no manual uprooting or taking a look at it)

[Catall]

Your selection depends on how you sort data and if you let mariaDB show you all lines. Our Forest_patch has somewhat aroun 1.3 Million lines ... 70.000 could be possible in that relation.

I can't tell you for sure, because we are using a forrest_script every (daily) restart that removes every tree/stump under Q20.

[Hieve]

Your selection depends on how you sort data and if you let mariaDB show you all lines. Our Forest_patch has somewhat aroun 1.3 Million lines ... 70.000 could be possible in that relation.

I can't tell you for sure, because we are using a forrest_script every (daily) restart that removes every tree/stump under Q20.

yeah this sounds good so far besides it won't work here:

if i look through my database the table forest has ~87k lines and under quality 20 are 70k - this would be alot of the forest out there ..
forest_patch STILL says that there are still just 4 Trees with TreeHealth = 3 (stump)

What exactly do I need to look to find the stumps in the database - cause there are still some stumps ingame which can't be used in any way.

[Catall]

I did mix up forest_patch and geo_patch ... forrest patch isn't that big on our Server either .

If you want to identify Stumps in database you'd take a look to table forrest, not table forrest_patch. As far as i know, Quality Zero should mean tree-stump.

i just did a restart, no trees below Q21 are existent in forrest. BUT Trees with 0 health exist in forrest_patch.

Anyway, you know you must not delete anything from your DB without backup and when Server is running

[Catall]

I'd assume "health" is somewhat not used by lif:YO, confimration for my guess is needed.

In Addition we use that script sole Content of patch.sql (set Quality to < 1 you should be fine):

Code: Select all

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

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:=@c442+1
WHERE TerID = 442;

UPDATE forest_patch
SET Version = @c443:=@c443+1
WHERE TerID = 443;

UPDATE forest_patch
SET Version = @c444:=@c444+1
WHERE TerID = 444;

UPDATE forest_patch
SET Version = @c445:=@c445+1
WHERE TerID = 445;

UPDATE forest_patch
SET Version = @c446:=@c446+1
WHERE TerID = 446;

UPDATE forest_patch
SET Version = @c447:=@c447+1
WHERE TerID = 447;

UPDATE forest_patch
SET Version = @c448:=@c448+1
WHERE TerID = 448;

UPDATE forest_patch
SET Version = @c449:=@c449+1
WHERE TerID = 449;

UPDATE forest_patch
SET Version = @c450:=@c450+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;

[Hieve]

I'd assume "health" is somewhat not used by lif:YO, confimration for my guess is needed.

yes a bit confusing here - forest_patch has health in its description with the status stump, while forest has quality that also has some status?

in forest there would be ~1k trees with quality 0 , but I already seen Trees with Quality 0 out there that were not stumps...