Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
376 views
in Plugins by
I am using echteinfachtv's Best Users of the month plugin and everything works fine, except it doesn't stores the previous month's users details in the bestusers page. The database is already created, I do the manual cronjob on first of every month. But why this problem coming?
Q2A version: 1.5.4

1 Answer

0 votes
by

Do you have the default prefix for q2a tables?

qa_userscores

This is set in the cronjob file that you manually call.

--

you could also run a mysql query directly on first of the month:

INSERT INTO `qa_userscores` (userid, points, date) SELECT userid, points, DATE(NOW()) AS date from `qa_userpoints` ORDER BY userid ASC;

--

As many people are not familiar with mysql and php I will think about changing the plugin so that it automatically updates the database table as soon as the admin visits the admin/plugins page. This should be easier for all users.

by
I just run the cronjob on every month's first day. The scores gets resetted for new month but the last month's scores won't get stored.
by
If you have problems with the cronjob you can get the PRO version now which requires no cronjob. See release info here http://www.question2answer.org/qa/33953/new-premium-plugin-best-users-pro-by-q2apro-com
...