Set all user achievements to zero
By Abi on Wednesday, 01 February 2017
Posted in General
Replies 3
Likes 0
Views 123
Votes 0
Hello guys,

I want to reset all user achievement to zero so that no user has a badge and no user has a point. How can I do this. I've searched the Forum but nothing to help me.

Thanks...
Hello Abi,

We do not have the options to reset user's points and achievements currently.
Mark
·
Wednesday, 01 February 2017 14:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Mark,

How can I do so via sql /phpmyadmin?

Also, I'm testing badges an points and noticed that I'm getting double notification (see the image) because I'm changing the threshold/frequency values to achieve the points and badges.
Abi
·
Wednesday, 01 February 2017 15:22
·
0 Likes
·
0 Votes
·
0 Comments
·
You would need to truncate 3 tables:

#__social_points_history
#__social_badges_history
#__social_badges_maps
Mark
·
Wednesday, 01 February 2017 15:47
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post