[DiscordArchive] So I am planning to do something perhaps a little silly for my server, and could use an SQL script t
[DiscordArchive] So I am planning to do something perhaps a little silly for my server, and could use an SQL script t
Original source
So I am planning to do something perhaps a little silly for my server, and could use an SQL script to help automate it.
How can I get a script that will update Pool_Members with all entries of of a game object sharing a zone ID?
rektbyfaith
05-16-2025, 11:01 PM #1Archived author: Snowcraft • Posted: 2025-05-16T23:01:14.598000+00:00
Original source
So I am planning to do something perhaps a little silly for my server, and could use an SQL script to help automate it.
How can I get a script that will update Pool_Members with all entries of of a game object sharing a zone ID?
Original source
Say, All instances of object 1618 (Peacebloom) in zone 12 (Elwynn Forest)?
rektbyfaith
05-16-2025, 11:01 PM #2Archived author: Snowcraft • Posted: 2025-05-16T23:01:37.119000+00:00
Original source
Say, All instances of object 1618 (Peacebloom) in zone 12 (Elwynn Forest)?
Original source
I'm planning to set up pools for every type of gathering node in every single old world zone to ensure specific herbs don't go extinct when the zones don't get picked clean regularly.
rektbyfaith
05-16-2025, 11:02 PM #3Archived author: Snowcraft • Posted: 2025-05-16T23:02:57.145000+00:00
Original source
I'm planning to set up pools for every type of gathering node in every single old world zone to ensure specific herbs don't go extinct when the zones don't get picked clean regularly.
Original source
Alterac Mountains, for instance, has a master pool for all herbs that only has 17 active spawns at any given time, and 360+ members. Which means Winterbite is simply *never* up by sheer volume of other spawns to be picked instead.
rektbyfaith
05-16-2025, 11:03 PM #4Archived author: Snowcraft • Posted: 2025-05-16T23:03:51.560000+00:00
Original source
Alterac Mountains, for instance, has a master pool for all herbs that only has 17 active spawns at any given time, and 360+ members. Which means Winterbite is simply *never* up by sheer volume of other spawns to be picked instead.
1 Guest(s)
1 Guest(s)