Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+3 votes
902 views
in Plugins by

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
by
by
yes but do not work

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'
by
Ok, will check those plugins.

can you try this plugin
https://github.com/arjunsuresh/q2a-topusers-per-month
by
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'
by
again this problem not work
...