FUDforum

Post Form

Logged in user:

CommonCrawl [Bot] [logout]

Forum:

How To

Title:

Poll:

[CREATE POLL]

Message Icon:

No Icon

Smiley Shortcuts:
[ list all smilies ]

Formatting Tools:

Body:

Forum Options:
HTML code is off
BBcode is on
Images are on
Smilies are on
Editing Time Limit: Unlimited

[quote title=pips wrote on Tue, 11 September 2012 06:00][quote title=naudefj wrote on Thu, 17 February 2011 10:57][quote title=Ernesto wrote:]Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.[/quote]

Yes, but not for "Anonymous" [img=images/smiley_icons/icon_razz.gif]Razz[/img]

[quote title=Rodge wrote:]A select from fudprefix_poll_opt_track with some inner joins to the polls and users is sufficient for me. Thanks![/quote]

Here's a query for you to try:[code]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?';[/code][/quote]

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. [img=images/smiley_icons/icon_confused.gif]Confused[/img]

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... [/quote]

File Attachments:

Allowed File Extensions: jpg jpeg png gif txt doc gz bz2 inc php zip diff
Maximum File Size: 1024KB
Maximum Files Per Message: 3

Options:

	Post Notification
	Notify me when someone replies to this message.
	Include Signature
	Include your profile signature.
	Disable smilies in this message

Topic View

Post by pips is ignored

Re: Show participants of a poll

Tue, 11 September 2012 06:20

naudefj

Karma:

You need to change the SQL to match your installation.
Typically you need to change the 'fud_' prefix to your DB prefix.

Post by pips is ignored

Re: Show participants of a poll

Thu, 17 February 2011 10:54

naudefj

Karma:

Patch to allow anon voting:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5115&view=rev

Post by Rodge is ignored

Re: Show participants of a poll

Thu, 17 February 2011 05:57

naudefj

Karma:

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?';

Post by Rodge is ignored

Re: Show participants of a poll

Tue, 15 February 2011 00:09

Ernesto

Karma:

Can Vote is already in the group manager, what he wanted was to be able to see who had voted for what.

Re: Show participants of a poll

Fri, 11 February 2011 23:01

naudefj

Karma:

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