Jump to content

Reset all RealmFirst! achievement

Recommended Posts

Hi all, how can i reset all RealmFirst achievements on the server so they are again obtainable?

Some realmfirst (lich king, malygos, algalon) do not give the realmfirst and i think due to imported characters with already that achievement.

Sorry for my eventual bad english.

Thanks a lot

Link to post
Share on other sites
  • 10 months later...

There are several options:

There is a check for the realm first achievement across the characters once the event happens.

QueryResult result = CharacterDatabase.Query("SELECT achievement FROM character_achievement GROUP BY achievement");

The safest method is to delete that character. You may have to restart the server before a new player reaches level 80, first class, first kill, etc... after the rewards were stripped from the player. If it was a GM that received the achievement, then just delete it. If it's a player, you will have to strip it from character_achievement, including character_achievement_progress.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By rksemk
      Hello, compile the trinity but I get the following error

      I have no idea what causes this error
      Here I give you the logs
      please help!
  • Create New...