[DiscordArchive] To make all bosses in the game of any instance have a 100% drop rate for a custom item, should I wri
[DiscordArchive] To make all bosses in the game of any instance have a 100% drop rate for a custom item, should I wri
Original source
To make all bosses in the game of any instance have a 100% drop rate for a custom item, should I write boss by boss drop that item or is there a way to make it less tedious?
rektbyfaith
01-25-2025, 05:01 PM #1Archived author: Skayz • Posted: 2025-01-25T17:01:19.472000+00:00
Original source
To make all bosses in the game of any instance have a 100% drop rate for a custom item, should I write boss by boss drop that item or is there a way to make it less tedious?
Original source
Thanks again!
rektbyfaith
01-25-2025, 05:02 PM #2Archived author: Theolin • Posted: 2025-01-25T17:02:25.084000+00:00
Original source
Thanks again!
Original source
The easiest way that i know since all the instance bosses dont have the same "rank" depending on their expansion. List the IDs of bosses you want want to add an item and the specific chance.
delete from tableName where uniqueIdentifer in (id1, ... id10);
insert into lootTableName (column1, 2, ... 6) values
(11520, 1179, 0, 4, 0, 1, 0, 1, 1, 'Taragaman the Hungerer - Ice Cold Milk'),
...
...
(11519, 5574, 0, 0.1, 0, 1, 0, 1, 1, 'Bazzalan - White Leather Bag');
rektbyfaith
01-25-2025, 05:08 PM #3Archived author: Ryan Turner • Posted: 2025-01-25T17:08:30.814000+00:00
Original source
The easiest way that i know since all the instance bosses dont have the same "rank" depending on their expansion. List the IDs of bosses you want want to add an item and the specific chance.
delete from tableName where uniqueIdentifer in (id1, ... id10);
insert into lootTableName (column1, 2, ... 6) values
(11520, 1179, 0, 4, 0, 1, 0, 1, 1, 'Taragaman the Hungerer - Ice Cold Milk'),
...
...
(11519, 5574, 0, 0.1, 0, 1, 0, 1, 1, 'Bazzalan - White Leather Bag');
Original source
So I can say, for example, that all classic dungeon bosses have that extra item (apart from the normal loot) that drops, for example, 1, and then on the other hand say that all classic raids can drop that item x5 for each boss. And so with the rest of the expansions in the same way?
rektbyfaith
01-25-2025, 05:14 PM #4Archived author: Skayz • Posted: 2025-01-25T17:14:10.263000+00:00
Original source
So I can say, for example, that all classic dungeon bosses have that extra item (apart from the normal loot) that drops, for example, 1, and then on the other hand say that all classic raids can drop that item x5 for each boss. And so with the rest of the expansions in the same way?
Original source
It's the first time I've done something like this and it's hard for me to understand
rektbyfaith
01-25-2025, 05:15 PM #5Archived author: Skayz • Posted: 2025-01-25T17:15:27.087000+00:00
Original source
It's the first time I've done something like this and it's hard for me to understand
Original source
If you just run queries it's the easiest way without needing to code how to add X item to a creature
rektbyfaith
01-25-2025, 05:19 PM #6Archived author: Ryan Turner • Posted: 2025-01-25T17:19:30.864000+00:00
Original source
If you just run queries it's the easiest way without needing to code how to add X item to a creature
Original source
Its (npc, item, and the rest columns)
so..
NSERT INTO `gameobject_loot_template` values (11519, 54811, 0, 1, 0, 1, 0, 1, 1, 'Celestial Steed');
rektbyfaith
01-25-2025, 05:21 PM #7Archived author: Skayz • Posted: 2025-01-25T17:21:42.720000+00:00
Original source
Its (npc, item, and the rest columns)
so..
NSERT INTO `gameobject_loot_template` values (11519, 54811, 0, 1, 0, 1, 0, 1, 1, 'Celestial Steed');
Original source
craeture_loot_template
rektbyfaith
01-25-2025, 05:22 PM #8Archived author: Ryan Turner • Posted: 2025-01-25T17:22:13.495000+00:00
Original source
craeture_loot_template
Original source
Is the one you want to use.
rektbyfaith
01-25-2025, 05:22 PM #9Archived author: Ryan Turner • Posted: 2025-01-25T17:22:19.202000+00:00
Original source
Is the one you want to use.
1 Guest(s)
1 Guest(s)