By DOMENICO LOMUSCIO on Thursday, 27 June 2019
Posted in General
Replies 1
Likes 0
Views 550
Votes 0
hello I have already opened a ticket on this topic only that I closed it ... I practically had a problem to know how many points were in circulation ... so they suggested me to go to the server and write a sql code. ... (select sum (points) from deq42_social_points_history) ... and I succeeded ... the problem is that it also includes the administrator points that I would like to exclude .... you can create a code on sql to be able to exclude them ?
Hi DOMENICO,

You can try to use the sql query below. Where you need to change the 'jos' to your database prefix, and the replace the ids to the administrator's id
select sum(points) from jos_social_points_history where user_id not IN ('380', '367');
·
Thursday, 27 June 2019 15:53
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post