[DiscordArchive] Can you share the sql?
[DiscordArchive] Can you share the sql?
Original source
Can you share the sql?
rektbyfaith
09-30-2025, 06:24 PM #1Archived author: Ryan Turner • Posted: 2025-09-30T18:24:45.670000+00:00
Original source
Can you share the sql?
Original source
At least the column names
rektbyfaith
09-30-2025, 06:24 PM #2Archived author: Ryan Turner • Posted: 2025-09-30T18:24:53.189000+00:00
Original source
At least the column names
Original source
Also you shouldn't be imporatn dbc data into the dbc table of the database, make a custom table and do the changes there and export it back to DBC or change the DBC file itself
rektbyfaith
09-30-2025, 06:25 PM #3Archived author: Ryan Turner • Posted: 2025-09-30T18:25:35.697000+00:00
Original source
Also you shouldn't be imporatn dbc data into the dbc table of the database, make a custom table and do the changes there and export it back to DBC or change the DBC file itself
Original source
The tables are there for overrides, that's their entire purpose.
rektbyfaith
09-30-2025, 06:27 PM #4Archived author: Revision • Posted: 2025-09-30T18:27:14.753000+00:00
Original source
The tables are there for overrides, that's their entire purpose.
Original source
I'm not modifying either of those files directly. Just opening them to see the base data.
rektbyfaith
09-30-2025, 06:27 PM #5Archived author: Bauf • Posted: 2025-09-30T18:27:21.810000+00:00
Original source
I'm not modifying either of those files directly. Just opening them to see the base data.
Original source
I used an INSERT IGNORE INTO the skilllineability_dbc table in a custom\db_world sql file, using the data from SkillLineAbility.dbc, and the world server gave me an error about column amount mismatch.
rektbyfaith
09-30-2025, 06:30 PM #6Archived author: Bauf • Posted: 2025-09-30T18:30:55.148000+00:00
Original source
I used an INSERT IGNORE INTO the skilllineability_dbc table in a custom\db_world sql file, using the data from SkillLineAbility.dbc, and the world server gave me an error about column amount mismatch.
Original source
Then I noticed the difference in skilllineability_dbc.sql
rektbyfaith
09-30-2025, 06:31 PM #7Archived author: Bauf • Posted: 2025-09-30T18:31:36.022000+00:00
Original source
Then I noticed the difference in skilllineability_dbc.sql
Original source
I see the differences
rektbyfaith
09-30-2025, 06:33 PM #8Archived author: Ryan Turner • Posted: 2025-09-30T18:33:20.044000+00:00
Original source
I see the differences
Original source
Good it's not just on my end then. I got an override working using the formatting from skilllineability_dbc.sql. I was just curious about it because I have not seen a difference like that in any of the other dbc's I've modified.
rektbyfaith
09-30-2025, 06:40 PM #9Archived author: Bauf • Posted: 2025-09-30T18:40:09.285000+00:00
Original source
Good it's not just on my end then. I got an override working using the formatting from skilllineability_dbc.sql. I was just curious about it because I have not seen a difference like that in any of the other dbc's I've modified.
1 Guest(s)
1 Guest(s)