安其拉废墟最终BOSS-无疤者奥斯里安击杀后，应掉落一件紫色装备、一件徽记以及两件其拉兑换装备物品，现击杀后没有掉落紫色装备。
涟漪成员
楼主 · 2023-08-21 01:28
【已关闭】
安其拉废墟尾王掉落问题
涟漪 · 2023-08-21 01:28 · 2 回复 · 2 查看 · 问题反馈 · 已关闭
洛加斯特管理员
2 楼 · 2023-08-21 01:33
紫色装备一般掉落哪些，可以的话把数据库链接附带下
洛加斯特管理员
3 楼 · 2023-08-21 04:00
该问题已经修改，开源社区中的数据库配置有误，原配置是紫装1.5%的掉落概率，所以导致紫装不存在。
修复后的SQL语句为：
DELETE FROM
INSERT INTO
(15339, 20884, 0, 0, 0, 1, 1, 1, 1, 'Ossirian the Unscarred - Qiraji Magisterial Ring'),
(15339, 20886, 0, 0, 0, 1, 2, 1, 1, 'Ossirian the Unscarred - Qiraji Spiked Hilt'),
(15339, 20888, 0, 0, 0, 1, 1, 1, 1, 'Ossirian the Unscarred - Qiraji Ceremonial Ring'),
(15339, 20890, 0, 0, 0, 1, 2, 1, 1, 'Ossirian the Unscarred - Qiraji Ornate Hilt'),
(15339, 21220, 0, 100, 0, 1, 0, 1, 1, 'Ossirian the Unscarred - Head of Ossirian the Unscarred'),
(15339, 34024, 34024, 100, 0, 1, 3, 1, 2, 'Ossirian the Unscarred - (ReferenceTable)'),
(15339, 34025, 34025, 100, 0, 1, 4, 1, 2, 'Ossirian the Unscarred - (ReferenceTable)'),
(15339, 190024, 34024, 1, 0, 1, 1, 1, 1, '');
修复后的SQL语句为：
DELETE FROM
creature_loot_template WHERE (Entry = 15339);INSERT INTO
creature_loot_template (Entry, Item, Reference, Chance, QuestRequired, LootMode, GroupId, MinCount, MaxCount, Comment) VALUES(15339, 20884, 0, 0, 0, 1, 1, 1, 1, 'Ossirian the Unscarred - Qiraji Magisterial Ring'),
(15339, 20886, 0, 0, 0, 1, 2, 1, 1, 'Ossirian the Unscarred - Qiraji Spiked Hilt'),
(15339, 20888, 0, 0, 0, 1, 1, 1, 1, 'Ossirian the Unscarred - Qiraji Ceremonial Ring'),
(15339, 20890, 0, 0, 0, 1, 2, 1, 1, 'Ossirian the Unscarred - Qiraji Ornate Hilt'),
(15339, 21220, 0, 100, 0, 1, 0, 1, 1, 'Ossirian the Unscarred - Head of Ossirian the Unscarred'),
(15339, 34024, 34024, 100, 0, 1, 3, 1, 2, 'Ossirian the Unscarred - (ReferenceTable)'),
(15339, 34025, 34025, 100, 0, 1, 4, 1, 2, 'Ossirian the Unscarred - (ReferenceTable)'),
(15339, 190024, 34024, 1, 0, 1, 1, 1, 1, '');
主题已关闭,不再接受回帖;如需反馈请发新主题或前往客服群。