List all question votes and answer votes of a user

Question

I am again having the issue that I need to list all votes of a user within a chosen month.

I once proposed to add a timestamp to qa_uservotes that is unfortunately still not implemented.

So how would you go and:

1. List all question votes of a specific user within this month (or another month)?

2. List all answer votes of a specific user within this month (or another month)?

in v1.7.1

Answer 1

Sorry I didn't reply to the previous post. This is actually on my list to implement for 1.8, when I get to it.

As for your question, right now one way to estimate the vote dates would be to use the dates of the actual posts voted on, since people vote mostly on newer posts. (In fact that may be what I do when adding this to Q2A.)

Edit: forgot to add, you can also make an event plugin that stores the date of the vote in a separate table. A little bit overkill since you would basically end up duplicating the qa_votes table, but that's the only way to do it accurately for now.