Post by pips is ignored |
Post by pips is ignored |
Post by pips is ignored |
Re: Show participants of a poll |
Tue, 11 September 2012 06:20 |
|
You need to change the SQL to match your installation.
Typically you need to change the 'fud_' prefix to your DB prefix.
|
|
Post by pips is ignored |
|
Post by Rodge is ignored |
Re: Show participants of a poll |
Thu, 17 February 2011 05:57 |
|
Ernesto wrote:Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.
Yes, but not for "Anonymous"
Rodge wrote:A select from fudprefix_poll_opt_track with some inner joins to the polls and users is sufficient for me. Thanks!
Here's a query for you to try: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?';
|
|
Post by Rodge is ignored |
Re: Show participants of a poll |
Tue, 15 February 2011 00:09 |
|
Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.
|
|
Re: Show participants of a poll |
Fri, 11 February 2011 23:01 |
|
It should be relatively easy to add a "Can Vote" permissions to the Group Manager.
However, as Ernesto said, it's not yet implemented.
|
|
Post by Rodge is ignored |
Re: Show participants of a poll |
Tue, 08 February 2011 22:21 |
|
Don't think there is a functionality to toggle between anonymous polling.
If you want the results, they are in the fudprefix_poll_opt_track table.
|
|
Post by Rodge is ignored |