Vande wrote:Wondering if this still works too.
Yes. I run it. As been mentioned multiple times, make sure you have a solid backup.
I actually changed mine to remove quality under 35 trees, and that made a huge difference.
Vande wrote:Wondering if this still works too.
KhaimovMR wrote:Thanks to the author of the script.
I'm going to use it's idea in next version of LiFDS-CP (LiF dedicated server control panel) to clean out all the low quality trees on a single button click.Spoiler
PS: If someone has an ideas to implement into lifds-cp you're welcome, guys: LiFDS-CP
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.