[DiscordArchive] Did acore recently change their database but not the documentation?
[DiscordArchive] Did acore recently change their database but not the documentation?
Original source
No, column still exists in `creature_loot_template`
rektbyfaith
04-17-2024, 01:15 PM #11Archived author: Bench • Posted: 2024-04-17T13:15:16.773000+00:00
Original source
No, column still exists in `creature_loot_template`
Original source
I get this for a value of 0.
rektbyfaith
04-17-2024, 01:15 PM #12Archived author: Cyanide • Posted: 2024-04-17T13:15:24.263000+00:00
Original source
I get this for a value of 0.
Original source
```DELETE FROM `creature_loot_template` WHERE (`Entry` = 334) AND (`Item` IN (8226));
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(334, 8226, 0, 100, 0, 1, 0, 1, 1, '');```
rektbyfaith
04-17-2024, 01:15 PM #13Archived author: Cyanide • Posted: 2024-04-17T13:15:37.327000+00:00
Original source
```DELETE FROM `creature_loot_template` WHERE (`Entry` = 334) AND (`Item` IN (8226));
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(334, 8226, 0, 100, 0, 1, 0, 1, 1, '');```
Original source
Intended to add a blue item to a rare mob in redridge (no quest required)
rektbyfaith
04-17-2024, 01:17 PM #14Archived author: Cyanide • Posted: 2024-04-17T13:17:10.433000+00:00
Original source
Intended to add a blue item to a rare mob in redridge (no quest required)
Original source
No error on my DB
rektbyfaith
04-17-2024, 01:18 PM #15Archived author: Bench • Posted: 2024-04-17T13:18:02.697000+00:00
Original source
No error on my DB
Original source
what in the f
rektbyfaith
04-17-2024, 01:18 PM #16Archived author: Cyanide • Posted: 2024-04-17T13:18:28.818000+00:00
Original source
what in the f
Original source
holy shit i'm gonna have to manually repair 400 custom quests with this bonus money update. i'd strongly suggest in future if you're making a column obsolete just leave it there but empty so you don't brick SQL insert/replaces
rektbyfaith
04-17-2024, 01:22 PM #17Archived author: Cyanide • Posted: 2024-04-17T13:22:11.998000+00:00
Original source
holy shit i'm gonna have to manually repair 400 custom quests with this bonus money update. i'd strongly suggest in future if you're making a column obsolete just leave it there but empty so you don't brick SQL insert/replaces
Original source
I would recommend instead just putting the column back and then dropping it after running your custom query
rektbyfaith
04-17-2024, 01:22 PM #18Archived author: Bench • Posted: 2024-04-17T13:22:38.766000+00:00
Original source
I would recommend instead just putting the column back and then dropping it after running your custom query
Original source
(And export the newly made rows as a backup of the changes)
rektbyfaith
04-17-2024, 01:22 PM #19Archived author: Bench • Posted: 2024-04-17T13:22:53.515000+00:00
Original source
(And export the newly made rows as a backup of the changes)
Original source
That's much smarter. How would I add it back as a column?
rektbyfaith
04-17-2024, 01:23 PM #20Archived author: Cyanide • Posted: 2024-04-17T13:23:45.388000+00:00
Original source
That's much smarter. How would I add it back as a column?