[DiscordArchive] Right. Node pools or something? How do I modify the pool? Is that a `gameobject`?
[DiscordArchive] Right. Node pools or something? How do I modify the pool? Is that a `gameobject`?
Original source
Right. Node pools or something? How do I modify the pool? Is that a `gameobject`?
rektbyfaith
09-24-2023, 12:11 AM #1Archived author: Michael Crilly • Posted: 2023-09-24T00:11:46.657000+00:00
Original source
Right. Node pools or something? How do I modify the pool? Is that a `gameobject`?
Original source
Handled through the various `pool_*` tables, in this case both `pool_gameobject` and `pool_pool` (pool of pools)
rektbyfaith
09-24-2023, 12:12 AM #2Archived author: Bench • Posted: 2023-09-24T00:12:52.215000+00:00
Original source
Handled through the various `pool_*` tables, in this case both `pool_gameobject` and `pool_pool` (pool of pools)
Original source
This is coming back to me now. Thanks.
rektbyfaith
09-24-2023, 12:14 AM #3Archived author: Michael Crilly • Posted: 2023-09-24T00:14:42.115000+00:00
Original source
This is coming back to me now. Thanks.
Original source
So I'm editing, for example, things like this: ```MariaDB [acore_world]> select * from pool_template where description like '%Silverleaf%' and entry = 494;
+-------+-----------+-----------------------------+
| entry | max_limit | description |
+-------+-----------+-----------------------------+
| 494 | 25 | Silverleaf in Elwynn Forest |
+-------+-----------+-----------------------------+
1 row in set (0.000 sec)```
rektbyfaith
09-24-2023, 12:16 AM #4Archived author: Michael Crilly • Posted: 2023-09-24T00:16:49.619000+00:00
Original source
So I'm editing, for example, things like this: ```MariaDB [acore_world]> select * from pool_template where description like '%Silverleaf%' and entry = 494;
+-------+-----------+-----------------------------+
| entry | max_limit | description |
+-------+-----------+-----------------------------+
| 494 | 25 | Silverleaf in Elwynn Forest |
+-------+-----------+-----------------------------+
1 row in set (0.000 sec)```
Original source
So there's nothing in `pool_pool` for `Silverleaf` or `Elwynn Forest`, so I assume they're not pools of pools, then.
rektbyfaith
09-24-2023, 12:19 AM #5Archived author: Michael Crilly • Posted: 2023-09-24T00:19:11.700000+00:00
Original source
So there's nothing in `pool_pool` for `Silverleaf` or `Elwynn Forest`, so I assume they're not pools of pools, then.
Original source
OK, so I need to edit the `pool_templates` and increase the `max_limit` field, maybe double it, and I can omit `pool_gameobject` changes as it's fine because `chance` is `0`, which is ignored anyway as `pool_template.max_limit > 1`?
rektbyfaith
09-24-2023, 12:23 AM #6Archived author: Michael Crilly • Posted: 2023-09-24T00:23:56.627000+00:00
Original source
OK, so I need to edit the `pool_templates` and increase the `max_limit` field, maybe double it, and I can omit `pool_gameobject` changes as it's fine because `chance` is `0`, which is ignored anyway as `pool_template.max_limit > 1`?
Original source
And the tree looks like this: `gameobject_template.entry -> gameobject.id -> gameobject.guid -> pool_gameobject.guid;`. OK cool
rektbyfaith
09-24-2023, 12:38 AM #7Archived author: Michael Crilly • Posted: 2023-09-24T00:38:35.467000+00:00
Original source
And the tree looks like this: `gameobject_template.entry -> gameobject.id -> gameobject.guid -> pool_gameobject.guid;`. OK cool
Original source
Hmm, what is "MASTER Herbs Silverpine Forest zone 130"?
rektbyfaith
09-24-2023, 01:03 AM #8Archived author: Michael Crilly • Posted: 2023-09-24T01:03:04.947000+00:00
Original source
Hmm, what is "MASTER Herbs Silverpine Forest zone 130"?
Original source
Should I ignore those, if I'm upping `max_limit`s?
rektbyfaith
09-24-2023, 01:04 AM #9Archived author: Michael Crilly • Posted: 2023-09-24T01:04:09.415000+00:00
Original source
Should I ignore those, if I'm upping `max_limit`s?
Original source
Well, this updated about 20 rows for me: ```SET @HerbMultiplier = 3;
SET @Silerleaf = 1617;
UPDATE pool_template
INNER JOIN (SELECT pt.* FROM pool_template pt
INNER JOIN gameobject g ON g.id=@Silerleaf
INNER JOIN pool_gameobject pgo ON pgo.guid=g.guid
WHERE pt.entry=pgo.pool_entry) as objects
ON pool_template.entry = objects.entry
SET pool_template.max_limit=(pool_template.max_limit * @HerbMultiplier);``` and it tripled the spawn rates.
rektbyfaith
09-24-2023, 01:22 AM #10Archived author: Michael Crilly • Posted: 2023-09-24T01:22:26.744000+00:00
Original source
Well, this updated about 20 rows for me: ```SET @HerbMultiplier = 3;
SET @Silerleaf = 1617;
UPDATE pool_template
INNER JOIN (SELECT pt.* FROM pool_template pt
INNER JOIN gameobject g ON g.id=@Silerleaf
INNER JOIN pool_gameobject pgo ON pgo.guid=g.guid
WHERE pt.entry=pgo.pool_entry) as objects
ON pool_template.entry = objects.entry
SET pool_template.max_limit=(pool_template.max_limit * @HerbMultiplier);``` and it tripled the spawn rates.
1 Guest(s)
1 Guest(s)