Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Is there newest active popular Users plugin for Q2a 1.7.4?

+3 votes
80 views
asked Jan 10 in Plugins by Talip Pilat

Is there newest active popular Users plugin for Q2a 1.7.4? for example

Is there such an extension? Can be free of charge

 

1 Answer

0 votes
answered Jan 11 by ProThoughts
commented Jan 12 by Talip Pilat
Running query: CREATE EVENT if not exists qa_tupmevent ON SCHEDULE EVERY 1 MONTH starts    concat(str_to_date ( concat(concat(DATE_FORMAT(NOW(), '%Y'),month(NOW() + interval 1 month)),"1"), '%Y%m%d'), ' 00:00:00') DO BEGIN insert into qa_userscores (userid, points, date) select userid, points, CURDATE() as date from qa_userpoints order by userid asc; insert into qa_monthlytoppers (date, userid, points) select CURDATE() - interval 1 month as date, a.userid, a.points - COALESCE(b.points,0) AS mpoints from qa_userscores a, qa_userscores b where a.userid = b.userid and a.date = CURDATE() and b.date between (a.date - interval 35 day) and (a.date - interval 25 day) group by a.userid,a.points,b.points having mpoints>0; END ...

Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:

CREATE EVENT if not exists qa_tupmevent
ON SCHEDULE EVERY 1 MONTH
starts    concat(str_to_date ( concat(concat(DATE_FORMAT(NOW(), '%Y'),month(NOW() + interval 1 month)),"1"), '%Y%m%d'), ' 00:00:00')
DO
BEGIN
insert into qa_userscores (userid, points, date) select userid, points, CURDATE() as date from qa_userpoints order by userid asc;
insert into qa_monthlytoppers (date, userid, points) select CURDATE() - interval 1 month as date, a.userid, a.points - COALESCE(b.points,0) AS mpoints from qa_userscores a, qa_userscores b where a.userid = b.userid and a.date = CURDATE() and b.date between (a.date - interval 35 day) and (a.date - interval 25 day) group by a.userid,a.points,b.points having mpoints>0;

END

Error 1525: Incorrect STARTS value: 'NULL'
commented Jan 12 by Talip Pilat
again this problem not work
...