[DiscordArchive] I'm trying to add it to the DK trainer Lady Alistra (ID 29195), in the DB I can see that the ID of t
[DiscordArchive] I'm trying to add it to the DK trainer Lady Alistra (ID 29195), in the DB I can see that the ID of t
Original source
I'm trying to add it to the DK trainer Lady Alistra (ID 29195), in the DB I can see that the ID of the spells she trains is just -200019 like the other two DK trainers, this might be a dumb question but am I supposed to insert new rows or is -200019 a reference to an entire table containing all DK spells somewhere and what I really need to do is insert my new spells in that table instead of straight into npc_trainer?
rektbyfaith
09-16-2022, 04:16 PM #1Archived author: brimstone • Posted: 2022-09-16T16:16:13.678000+00:00
Original source
I'm trying to add it to the DK trainer Lady Alistra (ID 29195), in the DB I can see that the ID of the spells she trains is just -200019 like the other two DK trainers, this might be a dumb question but am I supposed to insert new rows or is -200019 a reference to an entire table containing all DK spells somewhere and what I really need to do is insert my new spells in that table instead of straight into npc_trainer?
Original source
The first value is the ID value of the trainer class, its not negative its 200019
SpellID is the ID of the spell u want to add
rektbyfaith
09-16-2022, 04:18 PM #2Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:18:52.829000+00:00
Original source
The first value is the ID value of the trainer class, its not negative its 200019
SpellID is the ID of the spell u want to add
Original source
For example frost strike rank 1 is Spell ID 49 143 and ID 200019 (DK)
rektbyfaith
09-16-2022, 04:19 PM #3Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:19:16.696000+00:00
Original source
For example frost strike rank 1 is Spell ID 49 143 and ID 200019 (DK)
Original source
if u want to crreate ranks in order u have to set the last column, REQSPELL to match the ranks probably
rektbyfaith
09-16-2022, 04:19 PM #4Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:19:42.964000+00:00
Original source
if u want to crreate ranks in order u have to set the last column, REQSPELL to match the ranks probably
Original source
scratch that last part as I noticed there are no spells with any value in REQSPELL
rektbyfaith
09-16-2022, 04:23 PM #5Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:23:07.110000+00:00
Original source
scratch that last part as I noticed there are no spells with any value in REQSPELL
Original source
spell_rank table maybe takes care of it
rektbyfaith
09-16-2022, 04:23 PM #6Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:23:22.078000+00:00
Original source
spell_rank table maybe takes care of it
Original source
I skimmed through it to confirm and the only ones that seems to use reqspell is a check if you have gnomish or goblin engineering
rektbyfaith
09-16-2022, 04:24 PM #7Archived author: brimstone • Posted: 2022-09-16T16:24:08.787000+00:00
Original source
I skimmed through it to confirm and the only ones that seems to use reqspell is a check if you have gnomish or goblin engineering
Original source
yeah I dont think u need anything there
rektbyfaith
09-16-2022, 04:24 PM #8Archived author: Sulan/Dreavi/Cebu • Posted: 2022-09-16T16:24:53.556000+00:00
Original source
yeah I dont think u need anything there
Original source
Some of the IDs are positive and some are negative in my DB, the AC wiki says "SpellID: The spell ID from Spell.dbc. If the ID is negative, it's a reference pointing to the positive value of ID." which sounds pretty confusing to me
rektbyfaith
09-16-2022, 04:24 PM #9Archived author: brimstone • Posted: 2022-09-16T16:24:54.724000+00:00
Original source
Some of the IDs are positive and some are negative in my DB, the AC wiki says "SpellID: The spell ID from Spell.dbc. If the ID is negative, it's a reference pointing to the positive value of ID." which sounds pretty confusing to me
Original source
https://puu.sh/JlCfr/3db7b95d3a.pnghttps...b95d3a.png
rektbyfaith
09-16-2022, 04:25 PM #10Archived author: brimstone • Posted: 2022-09-16T16:25:08.828000+00:00
Original source
https://puu.sh/JlCfr/3db7b95d3a.pnghttps...b95d3a.png
1 Guest(s)
1 Guest(s)