reset all quests? menu

These ads disappear when you log in.

Results 1 to 9 of 9
  1. #1
    sh1tdev's Avatar Member
    Reputation
    7
    Join Date
    Sep 2019
    Posts
    7
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)

    reset all quests?

    Is there a way to reset all quests so that the player can do them again? Preferably something I could put in to a lua script? I've had a look but haven't had much luck finding anything.

    These ads disappear when you log in.

  2. #2
    UnHappy's Avatar Site Donator
    CoreCoins User
    Reputation
    17
    Join Date
    Sep 2019
    Posts
    87
    Thanks G/R
    52/13
    Trade Feedback
    0 (0%)
    Not on wow

  3. #3
    sh1tdev's Avatar Member
    Reputation
    7
    Join Date
    Sep 2019
    Posts
    7
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Oh, that's a shame. I had wanted to write some sort of New Game+ type script Maybe there is a long way round to do it.. :/

  4. #4
    stoneharry's Avatar Moderator Harry

    CoreCoins User Authenticator enabled
    Reputation
    1541
    Join Date
    Sep 2007
    Posts
    4,437
    Thanks G/R
    124/113
    Trade Feedback
    0 (0%)
    What quests a player has completed is stored in the character database. The server probably caches at least some of this data in memory. You would need to expose a function to the Lua engine for clearing quests completed for a player. This could be as simple as running a query like DELETE FROM character_quest WHERE userid = { player->GetUserId() }, but that is pseudocode and you may need to update the cached data.

  5. Thanks sh1tdev (1 members gave Thanks to stoneharry for this useful post)
  6. #5
    sh1tdev's Avatar Member
    Reputation
    7
    Join Date
    Sep 2019
    Posts
    7
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Hmm, then I guess I could use this Eluna command to run an SQL string...

    Global:CharDBQuery - Eluna

    CharDBQuery( DELETE FROM character_quest WHERE userid = { player->GetUserId() } ) <-- pseudocode

    I think there is a bit more to it, but would this be the right idea/track, stoneharry? I'd have to do this for the weekly and daily data tables too and probably the reputations... And if I were to reset the character's level I'd probably want to unequip everything first... Do you have any other feedback? Sorry, I'm a hobbyist/just starting to delve in to this so I'm looking for a bit of guidance to check I am thinking ahead appropriately.

    EDIT: I should mention I want to do this for a NewGame+ type of script.
    Last edited by sh1tdev; 09-21-2019 at 08:51 PM.

  7. #6
    Harambeqt's Avatar Elite User CoreCoins User
    Reputation
    333
    Join Date
    Mar 2010
    Posts
    1,204
    Thanks G/R
    9/29
    Trade Feedback
    0 (0%)
    Reset all, and make the quest repeatable or a daily quest?
    Should be easier.
    Support the #1 WoW Emulator:
    http://arcemu.org/
    https://github.com/arcemu/arcemu
    - - -

  8. Thanks stoneharry (1 members gave Thanks to Harambeqt for this useful post)
  9. #7
    sh1tdev's Avatar Member
    Reputation
    7
    Join Date
    Sep 2019
    Posts
    7
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    I'm not sure that would work the way I am intending? The idea is so that when the player reaches level x they can do a quest which will allow them to return to level 1, with a permanent buff for +1% stats + exp. This will allow the player to return back to the "start of the game" so to speak. The big issue with making all the quests repeatable is that it won't follow that flow of completing all the content. So what I want is to have all the quests they did on the journey from level 1 to 60 get reset from completed to incomplete and available again to do like they never did them before. The difference is this time, they have all the gold from the first playthrough, all the items, and a neat little permanent buff to show off how much of a hardcore leveling hero they are too.

    Having looked at quest_tracker on azerothcore's wiki and inside the db itself.. there is literally nothing there. the db table is empty and the wiki is blank. I literally cannot find where the completed quest db is... but there must be a record of it on the server... it's doing my head in >_<;;

  10. #8
    stoneharry's Avatar Moderator Harry

    CoreCoins User Authenticator enabled
    Reputation
    1541
    Join Date
    Sep 2007
    Posts
    4,437
    Thanks G/R
    124/113
    Trade Feedback
    0 (0%)
    Originally Posted by sh1tdev View Post
    I'm not sure that would work the way I am intending? The idea is so that when the player reaches level x they can do a quest which will allow them to return to level 1, with a permanent buff for +1% stats + exp. This will allow the player to return back to the "start of the game" so to speak. The big issue with making all the quests repeatable is that it won't follow that flow of completing all the content. So what I want is to have all the quests they did on the journey from level 1 to 60 get reset from completed to incomplete and available again to do like they never did them before. The difference is this time, they have all the gold from the first playthrough, all the items, and a neat little permanent buff to show off how much of a hardcore leveling hero they are too.

    Having looked at quest_tracker on azerothcore's wiki and inside the db itself.. there is literally nothing there. the db table is empty and the wiki is blank. I literally cannot find where the completed quest db is... but there must be a record of it on the server... it's doing my head in >_<;;
    You could delete the character and create a new one copying over only some of the data. If you want to do it without the player relogging it will be a lot more difficult.

    Yes, starting with the CharDBQuery function will get you a prototype working. If you are using TC then: TrinityCore Collaboration Platform I believe AzerothCore is a fork of Mangos/TC so the table structure is likely to be similar.

    The primary key for the table is GUID, which I think is the LowGUID actually. Object:GetGUIDLow - Eluna

    I'm not sure what you mean by a NewGame+ type script. You're on the right track, let us know if you get stuck.
    Last edited by stoneharry; 09-22-2019 at 02:54 PM.

  11. #9
    meeks61's Avatar Member
    Reputation
    1
    Join Date
    Jan 2020
    Posts
    3
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    You would need to expose a function to the Lua engine for clearing quests completed for a player

Similar Threads

  1. Reset ALL cooldowns in Arena (6x iceblock lol)
    By Ledoocat in forum World of Warcraft Exploits
    Replies: 32
    Last Post: 02-07-2011, 05:56 PM
  2. ICC 10/25 Reset All Bosses (will get hotfixed)
    By Giwin in forum World of Warcraft Exploits
    Replies: 1
    Last Post: 12-14-2009, 01:47 PM
  3. Reseting Daily Quests
    By Wesk. in forum World of Warcraft Exploits
    Replies: 13
    Last Post: 06-07-2007, 08:12 AM
  4. Replies: 5
    Last Post: 05-04-2007, 10:16 AM
All times are GMT -5. The time now is 05:04 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search