Re: Show participants of a poll |
Wed, 12 September 2012 03:28 |
|
Ok,
figured out how to do this 
Replace the Fud_ with the specific database prefix
Replace "does fud forum supp...." with the specific poll title.
Great stuff! Thanks
|
|
Re: Show participants of a poll |
Tue, 11 September 2012 07:56 |
|
Ok, after some consideration.
If i replace
"poll" with the poll name
"user" with the user name who created it
and run, is this supposed to return a list of who voted on what?
(Sorry for the dumb questions)
|
|
|
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.
|
|
Re: Show participants of a poll |
Tue, 11 September 2012 06:00 |
|
naudefj wrote on Thu, 17 February 2011 10:57Ernesto 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?';
Hello chaps.
So, i'm trying to to do what the OP wanted to do and show who is voting in a poll.
I put the above SQL query into the SQl thing and got a heap of red text. 
Does this still work for 3.04?
I just cut and pasted it and then hit "Run query" Did i do it wrong?
any help appreciated...
|
|
|
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 |
Post by Ernesto is ignored |
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 |
Post by Ernesto is ignored |
Post by Rodge is ignored |