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

Home » FUDforum » How To » Show participants of a poll
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Show participants of a poll [message #164469] Tue, 08 February 2011 16:36 Go to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
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] Wed, 09 February 2011 03:21 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
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] Wed, 09 February 2011 04:28 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
Thank you!
Re: Show participants of a poll [message #164500 is a reply to message #164482] Sat, 12 February 2011 04:01 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 05:09 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
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 09:59 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
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 10:57 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 11:13 Go to previous messageGo to next message
Rodge is currently offline  Rodge   Switzerland
Messages: 18
Registered: July 2006
Karma: 0
Junior Member
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 15:54 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 10:00 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
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 10:20 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 10:24 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
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 11:56 Go to previous messageGo to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
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 07:28 Go to previous message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
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
  Switch to threaded view of this topic Create a new topic Submit Reply
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: Thu Mar 28 23:57:10 GMT 2024

Total time taken to generate the page: 0.02400 seconds