[DiscordArchive] did you ever fix this?
[DiscordArchive] did you ever fix this?
Original source
my shortlist of things i wish i could backport to wotlk, mythic+, raids, and monk
rektbyfaith
09-26-2023, 09:34 PM #21Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-09-26T21:34:57.550000+00:00
Original source
my shortlist of things i wish i could backport to wotlk, mythic+, raids, and monk
Original source
one day
rektbyfaith
09-26-2023, 09:36 PM #22Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-09-26T21:36:00.181000+00:00
Original source
one day
Original source
Would someone be able to explain the targeting of changes in an sql that you can apply, for example there is one from the Individual-progression module that changes all stacksize of ammo from 1000 back to 200 with [UPDATE `item_template` SET `stackable` = 200 WHERE `stackable` = 1000 AND `InventoryType` = 24;]
If one was to want to change the stacksize of ore, or herbs or even all crafting mats for example, is there a breakdown somewhere that I missed that would lay out if they are in a particular way to select all, like this command, or if its a manual process and then save the edit from there?
I am looking to learn how to do it, as much as an example of where it has been done so I can learn from context if thats a thing
rektbyfaith
09-26-2023, 09:43 PM #23Archived author: Addrianna • Posted: 2023-09-26T21:43:27.122000+00:00
Original source
Would someone be able to explain the targeting of changes in an sql that you can apply, for example there is one from the Individual-progression module that changes all stacksize of ammo from 1000 back to 200 with [UPDATE `item_template` SET `stackable` = 200 WHERE `stackable` = 1000 AND `InventoryType` = 24;]
If one was to want to change the stacksize of ore, or herbs or even all crafting mats for example, is there a breakdown somewhere that I missed that would lay out if they are in a particular way to select all, like this command, or if its a manual process and then save the edit from there?
I am looking to learn how to do it, as much as an example of where it has been done so I can learn from context if thats a thing
Original source
As I can find copper ore, and see the stackable limit currently at 20, just wanted to see if there was a way to select them more than just finding them all manually and adjusting them
rektbyfaith
09-26-2023, 09:44 PM #24Archived author: Addrianna • Posted: 2023-09-26T21:44:32.617000+00:00
Original source
As I can find copper ore, and see the stackable limit currently at 20, just wanted to see if there was a way to select them more than just finding them all manually and adjusting them
Original source
My first instinct would be to do something like
UPDATE item_template SET stackable = 200 WHERE BagFamily = 1,024
as that uses the same command as the one I know works, and targets just things that go in a mining bag, if I am understanding how it would work
rektbyfaith
09-26-2023, 09:48 PM #25Archived author: Addrianna • Posted: 2023-09-26T21:48:23.778000+00:00
Original source
My first instinct would be to do something like
UPDATE item_template SET stackable = 200 WHERE BagFamily = 1,024
as that uses the same command as the one I know works, and targets just things that go in a mining bag, if I am understanding how it would work
Original source
ya youd jsut have to find a field that they all share
rektbyfaith
09-26-2023, 09:50 PM #26Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-09-26T21:50:20.552000+00:00
Original source
ya youd jsut have to find a field that they all share
Original source
https://www.azerothcore.org/wiki/item_template might help you find what your looking for
[Embed: item_template]
Wiki and Documentation of the AzerothCore project
https://www.azerothcore.org/wiki/item_template
rektbyfaith
09-26-2023, 09:51 PM #27Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2023-09-26T21:51:15.488000+00:00
Original source
https://www.azerothcore.org/wiki/item_template might help you find what your looking for
[Embed: item_template]
Wiki and Documentation of the AzerothCore project
https://www.azerothcore.org/wiki/item_template
Original source
Awesome, I missed that page on the wiki, I was reading off the trinitycore wiki as that came up
rektbyfaith
09-26-2023, 09:52 PM #28Archived author: Addrianna • Posted: 2023-09-26T21:52:12.061000+00:00
Original source
Awesome, I missed that page on the wiki, I was reading off the trinitycore wiki as that came up
Original source
That means I am on the right thinking track atleast
rektbyfaith
09-26-2023, 09:52 PM #29Archived author: Addrianna • Posted: 2023-09-26T21:52:30.381000+00:00
Original source
That means I am on the right thinking track atleast
Original source
I used to play Ashran on my hunter and turn on Aspect of the Pack in the middle of the group. Does that make me a terrible human being
rektbyfaith
09-26-2023, 09:53 PM #30Archived author: Anchy • Posted: 2023-09-26T21:53:04.154000+00:00
Original source
I used to play Ashran on my hunter and turn on Aspect of the Pack in the middle of the group. Does that make me a terrible human being
1 Guest(s)
1 Guest(s)