How Do I: Reset Achievements?

[WorldofNoLifer]

Hi! I accidentally leveled a character to level 85 and triggered the "1st In Server To Level 80" achievement... Is there a way to reset this for the realm? Thanks!

 

[ExO]

Hi there,
character_achievement is the one that should handle it.
In character_achievement_progress you can see the achievements that are in progress.

 

[OMGhixD]

Notice : While having .gm on you actually don't trigger the achievements

Something to bare in mind next time

 

[WorldofNoLifer]

Got it! Thanks!

 

[WorldofNoLifer]

Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol

 

[ExO]

Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol

xD.. Oh well!
Honestly I've triggered it a few times myself from testing, always removed it in character_achievement, so no hard feelings at your wife haha.

 

[OMGhixD]

Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol

Shit happens. That's what i usually say!

Luckily it's easily fixed!

 

[Rhisk]

Here your script:

[COLOR="#006400"]-- Deleting Realm First! Level 80[/COLOR]
[COLOR="#0000FF"]SET[/COLOR] @achievement := 457;
[COLOR="#0000FF"]SET[/COLOR] @criteria := 5212;
[COLOR="#0000FF"]SET[/COLOR] @GUID :=([COLOR="#0000FF"]SELECT[/COLOR] `guid` [COLOR="#0000FF"]FROM[/COLOR] `character_achievement` [COLOR="#0000FF"]WHERE[/COLOR] `achievement` = @achievement);

[COLOR="#0000FF"]DELETE FROM[/COLOR] `character_achievement` [COLOR="#0000FF"]WHERE[/COLOR] `achievement` = @achievement;
[COLOR="#0000FF"]DELETE FROM[/COLOR] `character_achievement_progress` [COLOR="#0000FF"]WHERE[/COLOR] `guid`= @GUID [COLOR="#0000FF"]AND[/COLOR] `criteria` = @criteria;

This is for characters db.