[DiscordArchive] are there any scripts/collection for sql that would let u extract stuff instead of trying to find co
[DiscordArchive] are there any scripts/collection for sql that would let u extract stuff instead of trying to find co
Original source
are there any scripts/collection for sql that would let u extract stuff instead of trying to find correct tables and their relations from scratch?
rektbyfaith
02-22-2022, 01:14 PM #1Archived author: Grandold • Posted: 2022-02-22T13:14:24.631000+00:00
Original source
are there any scripts/collection for sql that would let u extract stuff instead of trying to find correct tables and their relations from scratch?
Original source
like full queries that would do certain things, for example extract all items with all possible related values/stats/effects etc
rektbyfaith
02-22-2022, 01:15 PM #2Archived author: Grandold • Posted: 2022-02-22T13:15:26.342000+00:00
Original source
like full queries that would do certain things, for example extract all items with all possible related values/stats/effects etc
Original source
or maybe there is some wowhead wotlk copy somewhere that would have those, just havent found one
rektbyfaith
02-22-2022, 01:16 PM #3Archived author: Grandold • Posted: 2022-02-22T13:16:30.040000+00:00
Original source
or maybe there is some wowhead wotlk copy somewhere that would have those, just havent found one
Original source
I'm not absolutely certain what you're asking for. You could use one of many of the available databases (like wowhead but for wotlk) that could give you all information easily readable
rektbyfaith
02-22-2022, 01:16 PM #4Archived author: Revision • Posted: 2022-02-22T13:16:42.641000+00:00
Original source
I'm not absolutely certain what you're asking for. You could use one of many of the available databases (like wowhead but for wotlk) that could give you all information easily readable
Original source
mm but none of those (afaik) got any way to export data
rektbyfaith
02-22-2022, 01:17 PM #5Archived author: Grandold • Posted: 2022-02-22T13:17:17.124000+00:00
Original source
mm but none of those (afaik) got any way to export data
Original source
but ye thats kinda what im after atm, like just one of those wowhead-like systems but with a way to export all to json/xml/whatever
rektbyfaith
02-22-2022, 01:18 PM #6Archived author: Grandold • Posted: 2022-02-22T13:18:05.263000+00:00
Original source
but ye thats kinda what im after atm, like just one of those wowhead-like systems but with a way to export all to json/xml/whatever
Original source
Weeell. I don't know of any way to export the data because I have never needed it since it's easy enough to write a query to get it when you know how to write one. I haven't even checked if my databases (that runs off of aowow) can do any kind of exporting
rektbyfaith
02-22-2022, 01:19 PM #7Archived author: Revision • Posted: 2022-02-22T13:19:17.618000+00:00
Original source
Weeell. I don't know of any way to export the data because I have never needed it since it's easy enough to write a query to get it when you know how to write one. I haven't even checked if my databases (that runs off of aowow) can do any kind of exporting
Original source
the thing is, i've exported the item db (was it item_template i think) and all related stuff i was able to find, but always there seems to be something missing... like last export was missing all quest reward items. then again if i use lets say wowhead (or any similar site) api to check single items stats, there is once again more stuff than in my sql queries
rektbyfaith
02-22-2022, 01:21 PM #8Archived author: Grandold • Posted: 2022-02-22T13:21:40.286000+00:00
Original source
the thing is, i've exported the item db (was it item_template i think) and all related stuff i was able to find, but always there seems to be something missing... like last export was missing all quest reward items. then again if i use lets say wowhead (or any similar site) api to check single items stats, there is once again more stuff than in my sql queries
Original source
If you want something easy to use, you could use Keira (https://github.com/azerothcore/Keira3/releases) - which I totally forgot about - it's pretty user friendly.
rektbyfaith
02-22-2022, 01:22 PM #9Archived author: Revision • Posted: 2022-02-22T13:22:20.123000+00:00
Original source
If you want something easy to use, you could use Keira (https://github.com/azerothcore/Keira3/releases) - which I totally forgot about - it's pretty user friendly.
Original source
but ye, the original question was kinda aiming if there is any app/site where u could export stuff and be 100% sure everything is there
rektbyfaith
02-22-2022, 01:22 PM #10Archived author: Grandold • Posted: 2022-02-22T13:22:21.237000+00:00
Original source
but ye, the original question was kinda aiming if there is any app/site where u could export stuff and be 100% sure everything is there
1 Guest(s)
1 Guest(s)