[DiscordArchive] and i just check that 1 npc didn't have loot id, is there any list or some database that i need to l
[DiscordArchive] and i just check that 1 npc didn't have loot id, is there any list or some database that i need to l
Original source
and i just check that 1 npc didn't have loot id, is there any list or some database that i need to look ?
rektbyfaith
08-27-2021, 11:12 AM #1Archived author: zxcnxc • Posted: 2021-08-27T11:12:44.493000+00:00
Original source
and i just check that 1 npc didn't have loot id, is there any list or some database that i need to look ?
Original source
![[Image: unknown.png?ex=690bd9ed&is=690a886d&hm=3...f521f0d76&]](https://cdn.discordapp.com/attachments/689803159086170250/880771819349606450/unknown.png?ex=690bd9ed&is=690a886d&hm=37e50b628b4c0680f6c2469a2bf196ea64fcdee4f2f8518bd398b9bf521f0d76&)
rektbyfaith
08-27-2021, 11:12 AM #2Archived author: zxcnxc • Posted: 2021-08-27T11:12:46.209000+00:00
Original source
Original source
Hi Awanama,
Thanks for helping!
<https://github.com/azerothcore/wiki/blob/bb3c368c8d327176e946de46d5c1f19907e6c75a/docs/sql-standards.md>
Is a good read to start with our SQL standards
rektbyfaith
08-27-2021, 11:34 AM #3Archived author: Honey • Posted: 2021-08-27T11:34:44.528000+00:00
Original source
Hi Awanama,
Thanks for helping!
<https://github.com/azerothcore/wiki/blob/bb3c368c8d327176e946de46d5c1f19907e6c75a/docs/sql-standards.md>
Is a good read to start with our SQL standards
Original source
thanks for guide me,
since i took example from this
https://github.com/azerothcore/azerothco...1aa946cca7
is this good enough ?
[Embed: fix(DB/Loot): 'Deadwood Headdress Feather' Drop rates Inaccurate by...]
Changes Proposed:
Changed the drop rates for 'Deadwood Headdress Feather'
Issues Addressed:
Closes #6937
Closes chromiecraft/chromiecraft#1179
SOURCE:
https://tbc.wowhead.com/...
https://github.com/azerothcore/azerothco...1aa946cca7
rektbyfaith
08-27-2021, 11:38 AM #4Archived author: zxcnxc • Posted: 2021-08-27T11:38:12.818000+00:00
Original source
thanks for guide me,
since i took example from this
https://github.com/azerothcore/azerothco...1aa946cca7
is this good enough ?
[Embed: fix(DB/Loot): 'Deadwood Headdress Feather' Drop rates Inaccurate by...]
Changes Proposed:
Changed the drop rates for 'Deadwood Headdress Feather'
Issues Addressed:
Closes #6937
Closes chromiecraft/chromiecraft#1179
SOURCE:
https://tbc.wowhead.com/...
https://github.com/azerothcore/azerothco...1aa946cca7
Original source
here sql that i copy from keira3 for this issues
https://github.com/azerothcore/azerothco...ssues/7498
![[Image: unknown.png?ex=690be004&is=690a8e84&hm=d...4b21b294b&]](https://cdn.discordapp.com/attachments/689803159086170250/880778358500261888/unknown.png?ex=690be004&is=690a8e84&hm=d921a40f6304c89577ff70ea69a7d5d3684c89ee2110ce0777d70924b21b294b&)
[Embed: Incorrect "Blood Red Key" Droprates · Issue #7498 · azerothcore/aze...]
What client do you play on? enUS Faction Alliance Horde Content Phase: Generic 1-19 20-29 30-39 40-49 50-59 Current Behaviour Original report: Chromie issue#1498 The item "Blood Red Key&am...
https://github.com/azerothcore/azerothco...ssues/7498
rektbyfaith
08-27-2021, 11:38 AM #5Archived author: zxcnxc • Posted: 2021-08-27T11:38:45.363000+00:00
Original source
here sql that i copy from keira3 for this issues
https://github.com/azerothcore/azerothco...ssues/7498
[Embed: Incorrect "Blood Red Key" Droprates · Issue #7498 · azerothcore/aze...]
What client do you play on? enUS Faction Alliance Horde Content Phase: Generic 1-19 20-29 30-39 40-49 50-59 Current Behaviour Original report: Chromie issue#1498 The item "Blood Red Key&am...
https://github.com/azerothcore/azerothco...ssues/7498
Original source
just missing lootid for ur'dan. i have no idea what i need to looking for
rektbyfaith
08-27-2021, 11:40 AM #6Archived author: zxcnxc • Posted: 2021-08-27T11:40:38.045000+00:00
Original source
just missing lootid for ur'dan. i have no idea what i need to looking for
Original source
The
```sql
AND (`item` IN (1234))
```
Part could make the query to be Not repeatable. Hence If you havea creature template without a matching Item, it gets NOT deleted but there is still a `INSERT` after, which could result in an error.
rektbyfaith
08-27-2021, 11:43 AM #7Archived author: Honey • Posted: 2021-08-27T11:43:51.316000+00:00
Original source
The
```sql
AND (`item` IN (1234))
```
Part could make the query to be Not repeatable. Hence If you havea creature template without a matching Item, it gets NOT deleted but there is still a `INSERT` after, which could result in an error.
Original source
Maybe <@224931509046345729> can have a look
rektbyfaith
08-27-2021, 11:44 AM #8Archived author: Honey • Posted: 2021-08-27T11:44:28.261000+00:00
Original source
Maybe <@224931509046345729> can have a look
Original source
https://github.com/zxcnxc/azerothcore-wo...b17ae48ea0
here my commit if my screenshoot too small, thanks for helping me
[Embed: fix(DB/Loot): 'Blood Red Key' Drop rates Inaccurate · zxcnxc/azero...]
Missing loot id for Ur'dan, and i don't know how to fix that
Drop rate of the Blood Red Key different from the drop rate on TBC wowhead.
https://github.com/zxcnxc/azerothcore-wo...b17ae48ea0
rektbyfaith
08-27-2021, 11:45 AM #9Archived author: zxcnxc • Posted: 2021-08-27T11:45:59.944000+00:00
Original source
https://github.com/zxcnxc/azerothcore-wo...b17ae48ea0
here my commit if my screenshoot too small, thanks for helping me
[Embed: fix(DB/Loot): 'Blood Red Key' Drop rates Inaccurate · zxcnxc/azero...]
Missing loot id for Ur'dan, and i don't know how to fix that
Drop rate of the Blood Red Key different from the drop rate on TBC wowhead.
https://github.com/zxcnxc/azerothcore-wo...b17ae48ea0
Original source
Keira makes all queries repeatable
rektbyfaith
08-27-2021, 11:46 AM #10Archived author: Kitzunu • Posted: 2021-08-27T11:46:01.826000+00:00
Original source
Keira makes all queries repeatable
1 Guest(s)
1 Guest(s)