Forums WoW Modding Support Archives TrinityCore Discord Archives [DiscordArchive] Hi friends... how can i update my core with SQL update ??

[DiscordArchive] Hi friends... how can i update my core with SQL update ??

[DiscordArchive] Hi friends... how can i update my core with SQL update ??

rektbyfaith
Administrator
0
10-04-2021, 10:12 PM
#1
Archived author: WolfZ • Posted: 2021-10-04T22:12:53.270000+00:00
Original source

Hi friends... how can i update my core with SQL update ??
rektbyfaith
10-04-2021, 10:12 PM #1

Archived author: WolfZ • Posted: 2021-10-04T22:12:53.270000+00:00
Original source

Hi friends... how can i update my core with SQL update ??

rektbyfaith
Administrator
0
10-05-2021, 09:45 AM
#2
Archived author: <o> • Posted: 2021-10-05T09:45:38.356000+00:00
Original source

gems are a bit complicated, but not the worst.

`item_templates` has a field `gem_properties` that links to an ID in `GemProperties.dbc`.

The entry in `GemProperties.dbc` has a field `Enchant_Id` that links to an ID in `SpellItemEnchantment.dbc`

The entry in `SpellItemEnchantment` is documented here (or in the trinitycore source code): <https://wowdev.wiki/DB/SpellItemEnchantment>

There is an additional field in `SpellItemEnchantment` called `Condition_Id`, which holds a reference to a row in `SpellItemEnchantmentCondition.dbc` for stuff like gem requirements (meta gems etc.)

The condition table is documented here (or tc source): <https://wowdev.wiki/DB/SpellItemEnchantmentCondition>
rektbyfaith
10-05-2021, 09:45 AM #2

Archived author: <o> • Posted: 2021-10-05T09:45:38.356000+00:00
Original source

gems are a bit complicated, but not the worst.

`item_templates` has a field `gem_properties` that links to an ID in `GemProperties.dbc`.

The entry in `GemProperties.dbc` has a field `Enchant_Id` that links to an ID in `SpellItemEnchantment.dbc`

The entry in `SpellItemEnchantment` is documented here (or in the trinitycore source code): <https://wowdev.wiki/DB/SpellItemEnchantment>

There is an additional field in `SpellItemEnchantment` called `Condition_Id`, which holds a reference to a row in `SpellItemEnchantmentCondition.dbc` for stuff like gem requirements (meta gems etc.)

The condition table is documented here (or tc source): <https://wowdev.wiki/DB/SpellItemEnchantmentCondition>

rektbyfaith
Administrator
0
10-05-2021, 09:46 AM
#3
Archived author: <o> • Posted: 2021-10-05T09:46:22.441000+00:00
Original source

Gems effects are technically a type of enchantment, which is why they use `SpellItemEnchantment.dbc` that's also used for normal enchantments
rektbyfaith
10-05-2021, 09:46 AM #3

Archived author: <o> • Posted: 2021-10-05T09:46:22.441000+00:00
Original source

Gems effects are technically a type of enchantment, which is why they use `SpellItemEnchantment.dbc` that's also used for normal enchantments

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)