Mass Points Reset
By James on Wednesday, 05 May 2021
Posted in General Issues
Likes 0
Views 1K
Votes 0
Sorry for two posts, but it seems related and also different at the same time.

Would it be possible to have a single switch that can reset all user points to ZERO?

I have noticed in the past that when a community is very large if you try and load ALL users in EasySocial it times out. The same with executing a script in EasySocial when there are potentially thousands of users involved.

This is important because if you want everyone to have ZERO points at the exact same moment having a single button/script is ideal.

Thank you,
James
Unfortunately, we do not have this single click reset point for all the existing users.

Perhaps you can request this feature on our voice page https://stackideas.com/voices/easysocial .

If you urgently need this, I will see if possible to write a PHP script to reset all the existing user point to 0.
Arlex Wong
·
Thursday, 06 May 2021 13:09
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you Arlex.

If it's possible to write a script that would be awesome.
It's something I will need in approximately 3 months time, so not immediately but relatively soon.

I appreciate it, and I will also add a request in the Feature Request to have this added in the admin as an option.

Thank you,
James
James
·
Thursday, 06 May 2021 13:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Feature Request: https://stackideas.com/voices/easysocial/item/646-mass-points-reset-switch

Thank you,
James
James
·
Thursday, 06 May 2021 13:16
·
0 Likes
·
0 Votes
·
0 Comments
·
If it's possible to write a script that would be awesome.
It's something I will need in approximately 3 months time, so not immediately but relatively soon.

Sure, keep me update then.

Feature Request: https://stackideas.com/voices/easysocial/item/646-mass-points-reset-switch

Thanks.
Arlex Wong
·
Thursday, 06 May 2021 14:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Good morning Arlex.

Would it be safe to run the following to achieve this: TRUNCATE TABLE #__social_points_history;
Obviously we would replace the beginning with our own table prefix.

I ran a test on my localhost and it worked as far as I can tell but want to confirm with you.

If this would be an acceptable option, would it be possible to add a button in the backend of EasySocial that can execute this?

Thank you in advance,
James
James
·
Tuesday, 08 June 2021 20:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Would it be safe to run the following to achieve this: TRUNCATE TABLE #__social_points_history;
Obviously we would replace the beginning with our own table prefix.

Yes, it is the correct table to remove all the user points.

If this would be an acceptable option, would it be possible to add a button in the backend of EasySocial that can execute this?

We will see if we can include this in the next major version.
Arlex Wong
·
Wednesday, 09 June 2021 11:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex, I appreciate it!

James
James
·
Wednesday, 09 June 2021 20:06
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome.

Just for your information, I have locked and marked this thread as resolved to avoid confusion in the future. Please start a new thread if you have any other issues in the future so it will be easier for us to manage your inquiries.

Thanks for understanding.
Irwin
·
Thursday, 10 June 2021 13:15
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post