Kael wrote:problem solved
Padme wrote:Kael wrote:problem solved
i have a problem too in our server is lagging like crazy with so much trees.
i am a newb in database files.
can you help me getting there?
KevlarBR wrote:Guys, can you confirm this script is still working since last patch?
I have a server hosted @ Pingperfect. It's running OK, but there are too many trees. Log in times are huge and you can't really use your horse in the forest. Also, when the trees grow, the server lags a lot, probably applying the growing script to all trees.
I have read the whole topic, and apparently the best way of doing it is through patch.sql.
Can I use the same script no problem? If I understood corretly, I just copy and paste at the end of my patch.sql, set quality of trees I want (in my case 10), upload the new patch.sql file and restart the server?
Silvazar wrote:KevlarBR wrote:Guys, can you confirm this script is still working since last patch?
I have a server hosted @ Pingperfect. It's running OK, but there are too many trees. Log in times are huge and you can't really use your horse in the forest. Also, when the trees grow, the server lags a lot, probably applying the growing script to all trees.
I have read the whole topic, and apparently the best way of doing it is through patch.sql.
Can I use the same script no problem? If I understood corretly, I just copy and paste at the end of my patch.sql, set quality of trees I want (in my case 10), upload the new patch.sql file and restart the server?
I am in the exact same predicament. did you have any luck with it?
Silvazar wrote:I am in the exact same predicament. did you have any luck with it?
TheZar wrote:It needs to be put at the end of Dump.sql
KevlarBR wrote:Silvazar wrote:I am in the exact same predicament. did you have any luck with it?
I didn't have the balls yet to run it, but I think I will. Trees are getting on my nerves, man... But I think it is, yes.TheZar wrote:It needs to be put at the end of Dump.sql
Dump.sql or Patch.sql? I'm not sure. Anyways, what I think I'll do is shut down the server, back it up, run a query with the code to remove the trees, add the tree spawn removal code and start the server again...
Silvazar wrote:KevlarBR wrote:Silvazar wrote:I am in the exact same predicament. did you have any luck with it?
I didn't have the balls yet to run it, but I think I will. Trees are getting on my nerves, man... But I think it is, yes.TheZar wrote:It needs to be put at the end of Dump.sql
Dump.sql or Patch.sql? I'm not sure. Anyways, what I think I'll do is shut down the server, back it up, run a query with the code to remove the trees, add the tree spawn removal code and start the server again...
I hate to let you be the one to try first KevlarBR but did it work out? I am spooked that it will end up corrupting my database and all the poeple on my server will lose all their work.
Woundedcern wrote:this mod works fine but the problem i was haveing was everyone keeps saying to mod wrong file, the file that needs to be moded is the dump.sql file. mod is a one time use mod so doesnt run while game is running only on restarts.
Wir3tap wrote:This not working since last patch now? This sends my server into boot loops now if added to dump.sql.
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;
Wir3tap wrote:I read earlier it was dump.sql has this been changed back to patch now?
Estharos wrote:Is it possible to role back that coding, we are experimenting problem with it, we put the code in the dump.sql file and though it will role back if I put back the original dump file back but it didn't not.
Cheers,