search

stoneharry / WoW-Spell-Editor

A Spell Editor for WoW versions WOTLK 3.3.5, TBC 2.4.3, or Vanilla 1.12.1.
252 stars 115 forks source link

SQL Exports do not match database #227

Open StraysFromPath opened 5 months ago

StraysFromPath commented 5 months ago

Spell editor version 2.2.0

Describe the bug SQL exports for spell.dbc include fields such as "ID_DDD" and "DISPEL" where the database is expecting "ID" and "Dispel_Type". This is the same for roughly 60 fields.

This might be a issue with wow type? I am on Azerothcore - maybe this bug is because TrinityCore or Mangos or whatever WSE is designed for uses a different database?

To Reproduce Steps to reproduce the behavior: Export as SQL Try to import the SQL to spell.dbc

Expected behavior Export fields and database fields should match.

Screenshots If applicable, add screenshots to help explain your problem.

image

Additional context Add any other context about the problem here.

stoneharry commented 5 months ago

Edit these files: WoW Spell Editor\SqlMap\AzerothCore

They define the mappings for how the SQL gets created.