[DiscordArchive] Anyone know a quick way to modify emblem drop quantity per boss kill in wotlk dungeons?
[DiscordArchive] Anyone know a quick way to modify emblem drop quantity per boss kill in wotlk dungeons?
Original source
Like <https://wowgaming.altervista.org/aowow/?item=47241>
rektbyfaith
07-22-2025, 08:48 PM #11Archived author: Revision • Posted: 2025-07-22T20:48:18.591000+00:00
Original source
Like <https://wowgaming.altervista.org/aowow/?item=47241>
Original source
ah okay. Guess I missed some sql files somewhere along the way lol, thanks again!
rektbyfaith
07-22-2025, 08:48 PM #12Archived author: Brodesseus • Posted: 2025-07-22T20:48:33.565000+00:00
Original source
ah okay. Guess I missed some sql files somewhere along the way lol, thanks again!
Original source
Ah filter was being a problem in my stabase manager. Found it and am able to edit. Thanks.
rektbyfaith
07-22-2025, 08:58 PM #13Archived author: JaSimm • Posted: 2025-07-22T20:58:12.995000+00:00
Original source
Ah filter was being a problem in my stabase manager. Found it and am able to edit. Thanks.
Original source
In case anyone else needs it.
rektbyfaith
07-22-2025, 09:20 PM #14Archived author: JaSimm • Posted: 2025-07-22T21:20:58.093000+00:00
Original source
In case anyone else needs it.
Original source
UPDATE reference_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE reference_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
UPDATE creature_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE creature_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
UPDATE gameobject_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE gameobject_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
rektbyfaith
07-22-2025, 09:21 PM #15Archived author: JaSimm • Posted: 2025-07-22T21:21:15.213000+00:00
Original source
UPDATE reference_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE reference_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
UPDATE creature_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE creature_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
UPDATE gameobject_loot_template SET MinCount=MinCount * 2 WHERE Item=49426;
UPDATE gameobject_loot_template SET MaxCount=MaxCount * 2 WHERE Item=49426;
Original source
If that query works you could make it all 1 line
Where item in (id1, id2, etc...)
rektbyfaith
07-22-2025, 09:32 PM #16Archived author: Ryan Turner • Posted: 2025-07-22T21:32:44.670000+00:00
Original source
If that query works you could make it all 1 line
Where item in (id1, id2, etc...)
Original source
Well no, they're different tables
rektbyfaith
07-22-2025, 09:42 PM #17Archived author: Revision • Posted: 2025-07-22T21:42:11.097000+00:00
Original source
Well no, they're different tables
Original source
The only merge possible is `MinCount = MinCount * 2, MaxCount = MaxCount * 2` for each table instead of doing them one column at a time.
rektbyfaith
07-22-2025, 09:43 PM #18Archived author: Revision • Posted: 2025-07-22T21:43:04.513000+00:00
Original source
The only merge possible is `MinCount = MinCount * 2, MaxCount = MaxCount * 2` for each table instead of doing them one column at a time.
Original source
Interestingly after server restart this is not working so I am confused now. lol
rektbyfaith
07-22-2025, 09:46 PM #19Archived author: JaSimm • Posted: 2025-07-22T21:46:46.070000+00:00
Original source
Interestingly after server restart this is not working so I am confused now. lol
1 Guest(s)
1 Guest(s)