1
Serverside Modding / Re: [SQL] [WoD] [TrinityCore 6.x] Modifying item_sparse_loca
« on: February 28, 2016, 10:29:43 am »
Hey again!
That's really helpful, thank you! I more or less got that from reading the documentation, although when I tried it, I couldn't "override" a particular item (I cloned one of the entries that did work on item_sparse and changed its id to the same of that item). I'll try again, this time being more careful (perhaps I missed something!).
Something that caused me great confusion is that some of the entries in item_sparse that -are- being read by the client reflected in the hotfixes_data table, or at least my search queries didn't find them. That threw me off quite a bit!
Having a huge freeze might be a problem, true... If the typical user has to wait more than 10~15 seconds to load the new names once in-game, it's not going to work out.
Are there any alternatives to this? I thought that modifying the core so it handles the "give me the item template" OPCODE modifies the name/description of the item to one that I could set to an alternate table but I couldn't find which handler did that.
Maybe the only way to get these modifications to work is to integrate some sort of in-game patching or create a launcher to take care of that? It's not a very elegant answer since modifications would need to be way too frequent, but... It could work.
There's probably a way to set up SQL to open, modify and save the DB2 files too.
That's really helpful, thank you! I more or less got that from reading the documentation, although when I tried it, I couldn't "override" a particular item (I cloned one of the entries that did work on item_sparse and changed its id to the same of that item). I'll try again, this time being more careful (perhaps I missed something!).
Something that caused me great confusion is that some of the entries in item_sparse that -are- being read by the client reflected in the hotfixes_data table, or at least my search queries didn't find them. That threw me off quite a bit!
Having a huge freeze might be a problem, true... If the typical user has to wait more than 10~15 seconds to load the new names once in-game, it's not going to work out.
Are there any alternatives to this? I thought that modifying the core so it handles the "give me the item template" OPCODE modifies the name/description of the item to one that I could set to an alternate table but I couldn't find which handler did that.
Maybe the only way to get these modifications to work is to integrate some sort of in-game patching or create a launcher to take care of that? It's not a very elegant answer since modifications would need to be way too frequent, but... It could work.
There's probably a way to set up SQL to open, modify and save the DB2 files too.