thanks for a great module. I was looking through the Views integration and can't see how to do what I would like: create some time-based views with userpoints integrations.

so for example a View such as "last 30 days' Userpoints" which would show a rolling list of the biggest points earners in the last 30 days". Is that possible?

CommentFileSizeAuthor
#4 top1.jpg209.13 KBkmillecam

Comments

kbahey’s picture

kbahey commented

Not at the moment.

Any query on points that has a time/date dimension has to use the userpoints_txn table to do so. Depending on the size of the site, this can pose some scalability issues.

esllou’s picture

esllou commented

OK, great, no problems. It isn't really that important, just thought it would be a nice thing to add. How about a sql query to find out biggest userpoint earners for last X days? Would that be simple? I could then add that block in my online newsletter.

kbahey’s picture

kbahey commented

Yes, you can do that too.

It still has to sift through the userpoints_txn because of the time dimension of the query.

If you do that, then cache the results and refresh them once an hour or once a day so it does not add a lot of load on the database.

kmillecam’s picture

kmillecam commented
StatusFileSize
new top1.jpg209.13 KB

You may want to check out the User Points Top Contributors module. It can be configured to generate lists of points earned in a designated period.

It creates its own table (using data from userpoints_txn) that gets refreshed at cron time.

jredding’s picture

jredding commented
Status: Active » Closed (fixed)

Top contributors module seems to fix this issue so I'm closing it.