Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.
A select from fudprefix_poll_opt_track with some inner joins to the polls and users is sufficient for me. Thanks!
SELECT p.name AS "Poll", u.login AS "User", po.name as "Option"
FROM fud_poll_opt_track pt
INNER JOIN fud_users u ON pt.user_id = u.id
INNER JOIN fud_poll p ON pt.poll_id = p.id
INNER JOIN fud_poll_opt po ON pt.poll_id = po.poll_id AND pt.poll_opt = po.id
WHERE p.name = 'Does FUDforum support polls?';
Powered by: FUDforum 3.1.3.Copyright ©2001-2023 FUDforum Bulletin Board Software