Every Month's Tops users data not stored in website

Question

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?

Answer 1

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.

Comments

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.

---

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