[DiscordArchive] I was editing DB with Keira and it bugged (and the creature loot values got erased), where could I f
[DiscordArchive] I was editing DB with Keira and it bugged (and the creature loot values got erased), where could I f
Original source
I was editing DB with Keira and it bugged (and the creature loot values got erased), where could I find the default DB values?
rektbyfaith
06-20-2025, 02:38 PM #1Archived author: Adrien • Posted: 2025-06-20T14:38:03.773000+00:00
Original source
I was editing DB with Keira and it bugged (and the creature loot values got erased), where could I find the default DB values?
Original source
(without having to rebuild/reinstall)
rektbyfaith
06-20-2025, 02:38 PM #2Archived author: Adrien • Posted: 2025-06-20T14:38:37.131000+00:00
Original source
(without having to rebuild/reinstall)
Original source
What's the creature id
rektbyfaith
06-20-2025, 02:39 PM #3Archived author: Ryan Turner • Posted: 2025-06-20T14:39:39.791000+00:00
Original source
What's the creature id
Original source
257
rektbyfaith
06-20-2025, 02:44 PM #4Archived author: Adrien • Posted: 2025-06-20T14:44:44.464000+00:00
Original source
257
Original source
I restored the candle drop but I lack the reference ones
rektbyfaith
06-20-2025, 02:44 PM #5Archived author: Adrien • Posted: 2025-06-20T14:44:58.396000+00:00
Original source
I restored the candle drop but I lack the reference ones
Original source
(kobold worker)
rektbyfaith
06-20-2025, 02:45 PM #6Archived author: Adrien • Posted: 2025-06-20T14:45:11.473000+00:00
Original source
(kobold worker)
Original source
```sql
DELETE FROM `creature_loot_template` WHERE (`Entry` = 257);
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(257, 0, 11111, 0.2, 0, 1, 0, 1, 1, 'Kobold Worker - (Small Pouch ReferenceTable)'),
(257, 0, 20000, 30, 0, 1, 1, 1, 1, 'Kobold Worker - (Grey 1-5 EXP 0 ReferenceTable)'),
(257, 0, 20014, 30, 0, 1, 0, 1, 1, 'Kobold Worker - (Food 1-5 EXP 0 ReferenceTable)'),
(257, 755, 0, 20, 0, 1, 0, 1, 1, 'Kobold Worker - Melted Candle');
```
<@228003132569812993>
rektbyfaith
06-20-2025, 03:00 PM #7Archived author: Ryan Turner • Posted: 2025-06-20T15:00:46.561000+00:00
Original source
```sql
DELETE FROM `creature_loot_template` WHERE (`Entry` = 257);
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(257, 0, 11111, 0.2, 0, 1, 0, 1, 1, 'Kobold Worker - (Small Pouch ReferenceTable)'),
(257, 0, 20000, 30, 0, 1, 1, 1, 1, 'Kobold Worker - (Grey 1-5 EXP 0 ReferenceTable)'),
(257, 0, 20014, 30, 0, 1, 0, 1, 1, 'Kobold Worker - (Food 1-5 EXP 0 ReferenceTable)'),
(257, 755, 0, 20, 0, 1, 0, 1, 1, 'Kobold Worker - Melted Candle');
```
<@228003132569812993>
Original source
thank you!
rektbyfaith
06-20-2025, 03:02 PM #8Archived author: Adrien • Posted: 2025-06-20T15:02:58.911000+00:00
Original source
thank you!
1 Guest(s)
1 Guest(s)