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
remove from 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: 3705
Registered: December 2004
Karma: 23
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
remove from 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: 3705
Registered: December 2004
Karma: 23
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: 3705
Registered: December 2004
Karma: 23
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
Message by pips is ignored  [reveal message]  [reveal all messages by pips]  [stop ignoring this user] Go to previous messageGo to next message
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: 3705
Registered: December 2004
Karma: 23
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.
Message by pips is ignored  [reveal message]  [reveal all messages by pips]  [stop ignoring this user] Go to previous messageGo to next message
Message by pips is ignored  [reveal message]  [reveal all messages by pips]  [stop ignoring this user] Go to previous messageGo to next message
Message by pips is ignored  [reveal message]  [reveal all messages by pips]  [stop ignoring this user] Go to previous message
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: Mon Nov 18 12:34:31 EST 2019

Total time taken to generate the page: 0.00859 seconds