Poll Stats

[jenigma]

I'd like to be able to see who's voting in polls, and, optionally, what they voted for.

I'd also like to be able to restrict who can vote by membergroup, so I can disallow newbies from voting... so that people cannot register new accounts just to sway the vote.

[jenigma]

Is there at least an SQL query I can use to find out who has voted in a particular poll?

[[Unknown]]

SELECT mem.realName
FROM yabbse_members AS mem, yabbse_polls AS p
WHERE FIND_IN_SET(mem.ID_MEMBER, p.votedMemberIDs)
  AND ID_POLL={thePollYouWantToLookAtsID};

-[Unknown]