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 :: 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
Message by Ernesto is ignored  [reveal message]  [reveal all messages by Ernesto]  [stop ignoring this user] Go to previous messageGo to next message
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: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
add to 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.
Message by Ernesto is ignored  [reveal message]  [reveal all messages by Ernesto]  [stop ignoring this user] Go to previous messageGo to next message
[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: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
add to 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: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
add to 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: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
add to 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: Fri Oct 15 23:20:45 EDT 2021

Total time taken to generate the page: 0.00824 seconds