[DiscordArchive] Is there a SQL Query to delete all Quest from one Zone?
[DiscordArchive] Is there a SQL Query to delete all Quest from one Zone?
Original source
Is there a SQL Query to delete all Quest from one Zone?
rektbyfaith
08-27-2021, 07:23 PM #1Archived author: Lushen • Posted: 2021-08-27T19:23:08.907000+00:00
Original source
Is there a SQL Query to delete all Quest from one Zone?
Original source
`DELETE FROM quest_template WHERE questsortid='x';`
Replace x with the zone id taken from AreaTable.dbc, any quest using that sorting id will then be deleted
TC btw
rektbyfaith
08-27-2021, 07:40 PM #2Archived author: Yakumo • Posted: 2021-08-27T19:40:26.630000+00:00
Original source
`DELETE FROM quest_template WHERE questsortid='x';`
Replace x with the zone id taken from AreaTable.dbc, any quest using that sorting id will then be deleted
TC btw
Original source
Thanks a lot <3
rektbyfaith
08-27-2021, 07:40 PM #3Archived author: Lushen • Posted: 2021-08-27T19:40:43.099000+00:00
Original source
Thanks a lot <3
Original source
This only deletes the template quest btw, you would still have to clean up start/end references etc
rektbyfaith
08-27-2021, 07:41 PM #4Archived author: Yakumo • Posted: 2021-08-27T19:41:17.447000+00:00
Original source
This only deletes the template quest btw, you would still have to clean up start/end references etc
Original source
You might want to bulk select all quests first, to get all references
rektbyfaith
08-27-2021, 07:41 PM #5Archived author: Yakumo • Posted: 2021-08-27T19:41:55.832000+00:00
Original source
You might want to bulk select all quests first, to get all references