SQL to award 'Newbie' badge to Users existing prior to EasySocial
By Andy on Monday, 01 August 2016
Posted in Technical Issues
Likes 0
Views 420
Votes 0
Hello. I think I'm right in saying that users in existence before installing EasySocial would not get the 'Newbie' badge.

My users are now getting excited about how many badges they have (great success of badges for the community - thanks!)

Issue is some as complaining they don't have their Newbie badge. Is there a SQL command I can do on the DB tables to give any users without a Newbie badge that badge? I don't want them to get a 'Newbie' email though as many users I've had for years and years....

Thanks!
hey Andy,

I am sorry for the delay of this reply,

I believe to achieve this, you have to run 2 sql in your database, can you backup all of your database data and provide us with your phpmyadmin access so I can help you update on this.
Arlex Wong
·
Monday, 01 August 2016 13:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex... Thanks for offering to help me here... I've backed up the database and provided my PHP MYADMIN access details in the original post details here.... Hope it is a smooth operation!
Andy
·
Tuesday, 02 August 2016 20:04
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome.

I already help you updated, please take a look
Arlex Wong
·
Wednesday, 03 August 2016 00:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex - Looks PERFECT. Thanks so much!
Andy
·
Wednesday, 03 August 2016 00:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Wednesday, 03 August 2016 00:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post