Hallo zusammen.
Ich habe bei Nitrado einen Lif yo Server gemietet für 10 Spieler. Nun habe ich den ersten Teil des Baumscriptcodes in die Datei patch.sql kopiert wie angegeben.
Der code:
DELETE forest, forest_patch
FROM forest, forest_patch
WHERE forest.GeoDataID = forest_patch.GeoDataID AND
forest.Quality < 40;
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;
_________________________________________
Dann erfahre ich das das noch nicht alles war was man machen muss und stehe nun im Regen :-) in der Datenbank muss noch ein Eintrag gemacht werden auf dem Nitradoserver. Wer kann mir das machen ?
Liebe Grüße.