Baumscript auf Nitradoserver einrichten

User avatar
Pepaio
Zealous Believer
 
Posts: 61
Joined: 29 Mar 2014, 16:01
Location: Godenland Server 6

Baumscript auf Nitradoserver einrichten

Post by Pepaio » 25 Oct 2016, 05:18

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.

Return to Modded Servers