FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Show participants of a poll
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Show participants of a poll [message #164469] Tue, 08 February 2011 11:36 Go to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
How to show the participants and their votes of a poll within FUDforum?

Thanks
Re: Show participants of a poll [message #164481 is a reply to message #164469] Tue, 08 February 2011 22:21 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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.


Re: Show participants of a poll [message #164482 is a reply to message #164481] Tue, 08 February 2011 23:28 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thank you!
Re: Show participants of a poll [message #164500 is a reply to message #164482] Fri, 11 February 2011 23:01 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
It should be relatively easy to add a "Can Vote" permissions to the Group Manager.
However, as Ernesto said, it's not yet implemented.
Re: Show participants of a poll [message #164531 is a reply to message #164500] Tue, 15 February 2011 00:09 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.

[SOLVED] Re: Show participants of a poll [message #164532 is a reply to message #164531] Tue, 15 February 2011 04:59 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
A select from fudprefix_poll_opt_track with some inner joins to the polls and users is sufficient for me. Thanks!
Re: Show participants of a poll [message #164568 is a reply to message #164531] Thu, 17 February 2011 05:57 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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" Razz

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?';
Re: Show participants of a poll [message #164569 is a reply to message #164568] Thu, 17 February 2011 06:13 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thats basically what I did. Thats easy
Re: Show participants of a poll [message #164574 is a reply to message #164569] Thu, 17 February 2011 10:54 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
Patch to allow anon voting:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5115&view=rev
Re: Show participants of a poll [message #167740 is a reply to message #164568] Tue, 11 September 2012 06:00 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
naudefj wrote on Thu, 17 February 2011 10: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" Razz

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. Confused

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...
Re: Show participants of a poll [message #167741 is a reply to message #167740] Tue, 11 September 2012 06:20 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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 [message #167742 is a reply to message #167741] Tue, 11 September 2012 06:24 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Yea, i figured that out Laughing

re-ran it and no errors.


What exactly does it do? Laughing
Re: Show participants of a poll [message #167743 is a reply to message #167742] Tue, 11 September 2012 07:56 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 [message #167749 is a reply to message #164469] Wed, 12 September 2012 03:28 Go to previous message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Ok,

figured out how to do this Surprised

Replace the Fud_ with the specific database prefix
Replace "does fud forum supp...." with the specific poll title.


Great stuff! Thanks
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: How to stop giving hackers half of what they want
Next Topic: Change display order of posts
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Oct 24 02:03:44 EDT 2017

Total time taken to generate the page: 0.00802 seconds