Export individual spells as SQL

[StraysFromPath]

Is your feature request related to a problem? Please describe. I don't always want to export an entire database or make MPQ patches.

Sometimes, especially for Azerothcore, a simple SQL export I can put into the spell_dbc table (contains mostly overrides of the spells located in the Client DBC files) would do the job.

Describe the solution you'd like Like Keira3, an option to export just 1 thing as 1 SQL query.

Any other comments/information

[stoneharry]

You can just tick spell.dbc on the export UI, and select SQL as the export type. Am I missing something?

Or you mean you want to export a single spell? It would be easier to just copy over the data from the spell editor DB to the AC world DB with a query. Something like this: https://github.com/stoneharry/WoW-Spell-Editor/issues/91#issuecomment-635557187

[StraysFromPath]

You can just tick spell.dbc on the export UI, and select SQL as the export type. Am I missing something?

Or you mean you want to export a single spell? It would be easier to just copy over the data from the spell editor DB to the AC world DB with a query. Something like this: #91 (comment)

Thank you for the reply!

Yes I'd like to just export a single spell at a time as SQL to go into azerothcore#s "spelldbc override" table.

if I'm only making tiny edits day to day like increasing a mob's spell damage from 25 to 28, I don't really need to export a 250mb SQL file of all spells and then awkwardly try to filter the one line from that doc I want.

It's also best practice for me to keep backups of my changes in the form of a list of my changes spells - rather than bulk joblots of 250mb files which have 1 change in them.

I don't think the copy query would work in the following scenarios:

a) if the server/spell editor are on different machines e.g a friend makes a spell and sends to me b) if I am making spells offline using the local db on holiday and want to email them to myself for when I get back

For context this is Keira3's export interface.

You can either get the diff -

or the full

in one click which is insanely convenient/useful

your editor is better in many ways, but their export is better

[stoneharry]

I can see how this would be useful, but I think this can be worked around by selecting individual rows in any SQL IDE and exporting them individually.

I have tried to keep the spell editor emulator agnostic, i.e: there is no compatibility with emulators. It only supports the Blizzard client structures.

There is quite a lot of server side functionality that it would be nice to integrate with spell editor, but the big challenge is keeping that in sync as the emulators make changes. I have never wanted to invest into the maintenance. And users will complain when it breaks.