[Archive] How Do I: Reset Achievements?
[Archive] How Do I: Reset Achievements?
Original source
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!
rektbyfaith
11-04-2025, 05:16 PM #1Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
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!
Original source
Hi there,
character_achievement is the one that should handle it.
In character_achievement_progress you can see the achievements that are in progress.
rektbyfaith
11-04-2025, 05:16 PM #2Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Hi there,
character_achievement is the one that should handle it.
In character_achievement_progress you can see the achievements that are in progress.
Original source
Notice : While having .gm on you actually don't trigger the achievements
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Something to bare in mind next time
rektbyfaith
11-04-2025, 05:16 PM #3Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Notice : While having .gm on you actually don't trigger the achievements
Something to bare in mind next time
Original source
Got it! Thanks!
rektbyfaith
11-04-2025, 05:16 PM #4Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Got it! Thanks!
Original source
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
rektbyfaith
11-04-2025, 05:16 PM #5Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
Original source
Quote:DGLim said:xD.. Oh well!
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
Click to expand...
![[Image: 1f600.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png)
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.
rektbyfaith
11-04-2025, 05:16 PM #6Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Quote:DGLim said:xD.. Oh well!
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
Click to expand...
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.
Original source
Quote:DGLim said:Shit happens. That's what i usually say!
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
Click to expand...
Luckily it's easily fixed!
rektbyfaith
11-04-2025, 05:16 PM #7Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Quote:DGLim said:Shit happens. That's what i usually say!
Ha ha ha... I know right. Note to self: never let wife have admin rights... she's the one who triggered it lol
Click to expand...
Luckily it's easily fixed!
Original source
Here your script:
Code:
[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.
rektbyfaith
11-04-2025, 05:16 PM #8Archived author: WorldofNoLifer • Posted: 2025-11-04T18:16:29.143358
Original source
Here your script:
Code:
[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.
1 Guest(s)
1 Guest(s)