I did some changes to Trintiycore's Access_requirement to create some Instance attunements.
This is the code: https://gist.github.com/Demonid/f8b910c8854146848f74
So now all players on a Raid need XXX Achievement to enter YYY Instance.
So now the issue, i was trying to reset some achievements like: http://wowhead.com/achievement=3916
I did 2 query's to delete those achievements from all characters on my DB:
Query: DELETE FROM `character_achievement` WHERE achievement IN (3917,3916,3918,3812,4078,4156,4079,4532,4608,4636 ,4637,4576,4817,4815,4818,4816);
Query2: DELETE FROM `character_achievement_progress` WHERE criteria IN (3917,3916,3918,3812,4078,4156,4079,4532,4608,4636 ,4637,4576,4817,4815,4818,4816);
So i restart the server and this is what i got: http://puu.sh/8U6NK
Seems like each achievements has multiple criteria ID's... and i have to delete them too... the question here is, is there a way to reset those achievement without finding each criteria ID, is there an easy way to find them, etc.
This is what i was doing until now: New Char DB > create new character > .achievement add "Achievement to reset" > Look at `character_achievement_progress` to check what criterias are now done from the Achievement i want to reset then delete them, it seems to work but it's to much work, so that why I'm asking if there is an easier way.
Thanks for reading ^^ and hope somebody can help ^^.