[DiscordArchive] Holy cow that was quick and effective. Do I need to take any steps after updating the values? Anythi
[DiscordArchive] Holy cow that was quick and effective. Do I need to take any steps after updating the values? Anythi
Original source
Holy cow that was quick and effective. Do I need to take any steps after updating the values? Anything with the server or clients?
rektbyfaith
06-06-2022, 12:20 AM #1Archived author: Deleted User • Posted: 2022-06-06T00:20:37.432000+00:00
Original source
Holy cow that was quick and effective. Do I need to take any steps after updating the values? Anything with the server or clients?
Original source
You did update them, not just run the query I gave you? You should be able to use the command `reload npc_trainer` to reload the values and it should update instantly.
rektbyfaith
06-06-2022, 12:21 AM #2Archived author: Revision • Posted: 2022-06-06T00:21:18.629000+00:00
Original source
You did update them, not just run the query I gave you? You should be able to use the command `reload npc_trainer` to reload the values and it should update instantly.
Original source
Yes, I updated the rows, ran the query again to verify the change persisted. So, I run the reload command in the client?
rektbyfaith
06-06-2022, 12:22 AM #3Archived author: Deleted User • Posted: 2022-06-06T00:22:51.844000+00:00
Original source
Yes, I updated the rows, ran the query again to verify the change persisted. So, I run the reload command in the client?
Original source
Yes, the command can be run from the client or the server console.
rektbyfaith
06-06-2022, 12:23 AM #4Archived author: Revision • Posted: 2022-06-06T00:23:12.548000+00:00
Original source
Yes, the command can be run from the client or the server console.
Original source
The effect was immediate. Thank you. So I am a little less lost, and don't have to ask help as often, what was the process you used to get the SpellID numbers?
rektbyfaith
06-06-2022, 12:24 AM #5Archived author: Deleted User • Posted: 2022-06-06T00:24:32.759000+00:00
Original source
The effect was immediate. Thank you. So I am a little less lost, and don't have to ask help as often, what was the process you used to get the SpellID numbers?
Original source
I just used my AoWoW installation to find them, but to use PhpMyAdmin or HeidiSQL etc you could use the ID of Hira Snowdawn which is the mount trainer in Dalaran, `SELECT * FROM npc_trainer WHERE ID=31238` to find the reference IDs and grab those to find the spells associated to those references.
rektbyfaith
06-06-2022, 12:25 AM #6Archived author: Revision • Posted: 2022-06-06T00:25:50.886000+00:00
Original source
I just used my AoWoW installation to find them, but to use PhpMyAdmin or HeidiSQL etc you could use the ID of Hira Snowdawn which is the mount trainer in Dalaran, `SELECT * FROM npc_trainer WHERE ID=31238` to find the reference IDs and grab those to find the spells associated to those references.
Original source
Thank you so much.
rektbyfaith
06-06-2022, 12:27 AM #7Archived author: Deleted User • Posted: 2022-06-06T00:27:29.298000+00:00
Original source
Thank you so much.
Original source
Ofc, you can also run a nested query to get the spells directly from the creature entry: `SELECT * FROM npc_trainer WHERE ID IN (SELECT ABS(SpellID) FROM npc_trainer WHERE ID=31238);`
rektbyfaith
06-06-2022, 12:29 AM #8Archived author: Revision • Posted: 2022-06-06T00:29:35.865000+00:00
Original source
Ofc, you can also run a nested query to get the spells directly from the creature entry: `SELECT * FROM npc_trainer WHERE ID IN (SELECT ABS(SpellID) FROM npc_trainer WHERE ID=31238);`
Original source
Whew. I have some real work to do brushing up on SQL. It works though. From what I follow, this queries the npc_trainer table for all SpellID's associated with trainer ID=31238, and returns a list of the absolute values of those SpellID's which are used to query npc_trainer again, selecting those ID's.
rektbyfaith
06-06-2022, 12:33 AM #9Archived author: Deleted User • Posted: 2022-06-06T00:33:46.282000+00:00
Original source
Whew. I have some real work to do brushing up on SQL. It works though. From what I follow, this queries the npc_trainer table for all SpellID's associated with trainer ID=31238, and returns a list of the absolute values of those SpellID's which are used to query npc_trainer again, selecting those ID's.
Original source
Negative values inside npc_trainer are references, remove the - sign and that value is the ID of the entry in npc_trainer. That's why it's `ABS(SpellID)` as it pretty much removes the - sign. So yes, you're right. I think I'm a little confused by what you wrote but I believe you're saying the same thing.
rektbyfaith
06-06-2022, 12:35 AM #10Archived author: Revision • Posted: 2022-06-06T00:35:28.147000+00:00
Original source
Negative values inside npc_trainer are references, remove the - sign and that value is the ID of the entry in npc_trainer. That's why it's `ABS(SpellID)` as it pretty much removes the - sign. So yes, you're right. I think I'm a little confused by what you wrote but I believe you're saying the same thing.
1 Guest(s)
1 Guest(s)