Hi,

Is it possible to count how many points have been assigned all together to all users from the very beginning?

If i understand correctly the above, you want to calculate the total points earned by all users? If yes, you can try the below sql:

select sum(points) from `jos_social_points_history` where state = 1;

Replace the jos to your Joomla database table prefix.

Hope this help and have a nice day

mmmmmm.... it won't show

select sum(points) from `zhmkp_social_points_history` where state = 1;

Hi,

Try to execute the query from the tab 'SQL'. Please see https://take.ms/pmyk8

Hope this help and have a nice day

Thanks. It worked.

Hi there,

You are most welcome.

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

Thanks for understanding.