[DiscordArchive] whats the easiest way to convert AC sql query t...
[DiscordArchive] whats the easiest way to convert AC sql query t...
Original source
INSERT INTO tc.my_table SELECT entry, 1, name0 FROM ac.my_table
rektbyfaith
08-30-2025, 02:19 PM #11Archived author: stoneharry • Posted: 2025-08-30T14:19:09.612000+00:00
Original source
INSERT INTO tc.my_table SELECT entry, 1, name0 FROM ac.my_table
Original source
you can copy columns renaming them, or hardcode values, or insert queries to fetch data for rows
rektbyfaith
08-30-2025, 02:19 PM #12Archived author: stoneharry • Posted: 2025-08-30T14:19:36.042000+00:00
Original source
you can copy columns renaming them, or hardcode values, or insert queries to fetch data for rows
Original source
so you write the query once and then run it to convert data
rektbyfaith
08-30-2025, 02:19 PM #13Archived author: stoneharry • Posted: 2025-08-30T14:19:50.108000+00:00
Original source
so you write the query once and then run it to convert data
Original source
here is an example to convert SpellEditor spell DB to VMangos: https://github.com/stoneharry/WoW-Spell-...-635557187
[Embed: Create 1.12.1 cmangos/vmangos converter · Issue #91 · stoneharry/...]
The most popular patch 1.12 vanilla emulators load most spell DBC data from SQL tables rather than the spell.dbc file. The emulator tables schemas do not match the Blizzard schema. It would be usef...
https://github.com/stoneharry/WoW-Spell-.../issues/91
rektbyfaith
08-30-2025, 02:20 PM #14Archived author: stoneharry • Posted: 2025-08-30T14:20:39.997000+00:00
Original source
here is an example to convert SpellEditor spell DB to VMangos: https://github.com/stoneharry/WoW-Spell-...-635557187
[Embed: Create 1.12.1 cmangos/vmangos converter · Issue #91 · stoneharry/...]
The most popular patch 1.12 vanilla emulators load most spell DBC data from SQL tables rather than the spell.dbc file. The emulator tables schemas do not match the Blizzard schema. It would be usef...
https://github.com/stoneharry/WoW-Spell-.../issues/91
Original source
yeah but i dont want to change my database to match the azerothcore one
rektbyfaith
08-30-2025, 02:21 PM #15Archived author: Hex • Posted: 2025-08-30T14:21:52.250000+00:00
Original source
yeah but i dont want to change my database to match the azerothcore one
Original source
i want to change the query to match the TC one
rektbyfaith
08-30-2025, 02:22 PM #16Archived author: Hex • Posted: 2025-08-30T14:22:04.468000+00:00
Original source
i want to change the query to match the TC one
Original source
not sure if i understand you
rektbyfaith
08-30-2025, 02:22 PM #17Archived author: Hex • Posted: 2025-08-30T14:22:10.547000+00:00
Original source
not sure if i understand you
Original source
right
rektbyfaith
08-30-2025, 02:22 PM #18Archived author: Hex • Posted: 2025-08-30T14:22:23.243000+00:00
Original source
right
Original source
This isn't changing the DB. This is copying data between the two table formats. Converting it
rektbyfaith
08-30-2025, 02:24 PM #19Archived author: stoneharry • Posted: 2025-08-30T14:24:31.003000+00:00
Original source
This isn't changing the DB. This is copying data between the two table formats. Converting it
Original source
ok but if i dont have two tables one ac and one tc for example
rektbyfaith
08-30-2025, 02:26 PM #20Archived author: Hex • Posted: 2025-08-30T14:26:15.377000+00:00
Original source
ok but if i dont have two tables one ac and one tc for example
1 Guest(s)
1 Guest(s)