News:

SMF 2.1.2 has been released! Take it for a spin! Read more.

Main Menu

Viewing Who voted in polls

Started by mattchewone, June 29, 2009, 04:13:51 PM

Previous topic - Next topic

mattchewone

Hi,

Is there a way to view who voted what in a poll?

Many Thanks

Matt

N3RVE

Run this query in phpMyAdmin (What is phpMyAdmin?)

Code (Run) Select
SELECT smf_members.realName, smf_poll_choices.label
FROM smf_log_polls
INNER JOIN smf_members ON smf_log_polls.ID_MEMBER = smf_members.ID_MEMBER
INNER JOIN smf_poll_choices ON smf_log_polls.ID_CHOICE = smf_poll_choices.ID_CHOICE
AND smf_log_polls.ID_POLL = smf_poll_choices.ID_POLL
WHERE smf_log_polls.ID_POLL = 42


Replace ID_POLL = 42 with the ID of the poll you want to check.

-[n3rve]
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Nao 尚

I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

mattchewone


Nao 尚

Hmm I'm using it on Noisen... Which runs the latest SMF2...
Of course if you don't feel like fixing the mod here and there, I can't help much.
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

STS

How do you know what poll it is, the number?

Yahmez

Quote from: STS on October 16, 2009, 05:23:53 PM
How do you know what poll it is, the number?
The topic number that the poll is in. Hover you mouse over a link to a topic to see the number in the url. (e.g. http://www.yoursite.com/community/index.php?topic=384.0)

Yahmez

Quote from: Nao/Gilles on July 01, 2009, 05:53:53 PM
Hmm I'm using it on Noisen... Which runs the latest SMF2...
Of course if you don't feel like fixing the mod here and there, I can't help much.
Any tips for making the mod work in 2.0?

STS


Nao 尚

Quote from: Yahmez on October 16, 2009, 06:55:41 PM
Any tips for making the mod work in 2.0?
Maybe if you'd asked 2 years ago, back when I converted it?
Right now, I can just tell you it's easy to do...
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

Yahmez

Quote from: Nao/Gilles on October 17, 2009, 07:20:55 AM
Quote from: Yahmez on October 16, 2009, 06:55:41 PM
Any tips for making the mod work in 2.0?
Maybe if you'd asked 2 years ago, back when I converted it?
Right now, I can just tell you it's easy to do...
Well I have only been here 9 months... Oh well, maybe when SMF 7 comes out I'll go back to 2007 and ask you then.  ;D

SgtMic

Quote from: Nao/Gilles on October 17, 2009, 07:20:55 AM
Right now, I can just tell you it's easy to do...
I saw the changes in /sources/managepermissions as easy.
The changes to /default/display.template were out of my realm.

Can you show us the correct way to make those changes?
There is nothing more deadly than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.
2/5 Fox Co.  (BlackHearts)
FAST Co. 5th Plt. (FIDO)

Nao 尚

I only see one thing to replace in the Display template...?

foreach ($context['poll']['options'] as $option)
echo '
   <dt class="middletext', $option['voted_this'] ? ' voted' : '', '">', $option['option'], '</dt>
   <dd class="middletext', $option['voted_this'] ? ' voted' : '', '">', $context['allow_poll_view'] ? '<span class="percent">' . $option['votes'] . ' (' . $option['percent'] . '%)</span>' . $option['bar_ndt'] : '', '</dd>';


Becomes:

foreach ($context['poll']['options'] as $option)
{
echo '
   <dt class="middletext', $option['voted_this'] ? ' voted' : '', '">', $option['option'], '</dt>
   <dd class="middletext', $option['voted_this'] ? ' voted' : '', '">', $context['allow_poll_view'] ? '<span class="percent">' . $option['votes'] . ' (' . $option['percent'] . '%)</span>' . $option['bar_ndt'] : '';
if ($context['allow_poll_view'] && allowedTo('poll_view_voters') && !empty($context['poll']['options'][$option['id_option']]['voters']))
foreach ($context['poll']['options'][$option['id_option']]['voters'] as $voter)
echo ' <small><a href="', $scripturl, strpos($voter['id_member'], '.') === false ? '?action=profile;u=' . $voter['id_member'] . '">' . $voter['real_name'] : '?action=trackip;searchip=' . $voter['id_member'] . '">' . $voter['id_member'], '</a></small>';
}


Well, at least that's direct from my noisen.com source code.
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

SgtMic

There is nothing more deadly than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.
2/5 Fox Co.  (BlackHearts)
FAST Co. 5th Plt. (FIDO)

SgtMic

Get this error trying to install via package manager:
Fatal error: Call to undefined function db_query() in /home/wamarin/public_html/wammc/Packages/temp/wvwDB.php on line 9

Lines 1-12
<?php

if ($context['uninstalling'])
{
  
db_query("DELETE IGNORE FROM {$db_prefix}settings WHERE variable='whovotedwhatMode' LIMIT 1"__FILE____LINE__);
}
else
{
  
db_query("INSERT IGNORE INTO {$db_prefix}settings (variable, value) VALUES ('whovotedwhatMode', 'disabled')"__FILE____LINE__);
}

?>
There is nothing more deadly than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.
2/5 Fox Co.  (BlackHearts)
FAST Co. 5th Plt. (FIDO)

Nao 尚

Well... Obviously you're supposed to use $smcFunc['db_query'] in SMF2 or just declare a fake db_query that emulates it.)
Ever made a SMF2 package before?
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

SgtMic

No, I have not made an SMF2 package before. That's why I'm here asking for help. :)
There is nothing more deadly than a US Marine and his rifle.
A close second is a US Marine and his K-BAR.
2/5 Fox Co.  (BlackHearts)
FAST Co. 5th Plt. (FIDO)

Ray Cardillo

Quote from: mattchewone on June 29, 2009, 04:13:51 PM
Is there a way to view who voted what in a poll?

I know this is an old thread, but check out this new mod that provides voter visibility with several advanced options.

http://custom.simplemachines.org/mods/index.php?mod=3373
Author of the Voter Visibility mod customization.  Adds the ability to see (and control who sees) who voted for what.  Allows you to conduct secret ballots.  Can also be used to coordinate volunteer signups, and more.

dkpeppard

Quote from: N3RVE on June 30, 2009, 12:43:53 PM
Run this query in phpMyAdmin (What is phpMyAdmin?)

Code (Run) Select
SELECT smf_members.realName, smf_poll_choices.label
FROM smf_log_polls
INNER JOIN smf_members ON smf_log_polls.ID_MEMBER = smf_members.ID_MEMBER
INNER JOIN smf_poll_choices ON smf_log_polls.ID_CHOICE = smf_poll_choices.ID_CHOICE
AND smf_log_polls.ID_POLL = smf_poll_choices.ID_POLL
WHERE smf_log_polls.ID_POLL = 42


Replace ID_POLL = 42 with the ID of the poll you want to check.

-[n3rve]

I realize this is an old post, but I think the information is still valid.

I tried running this query in my phpAdmin. I changed to the correct poll ID number but I get the following error:

#1054 - Unknown column 'smf_members.realName' in 'field list'

I am a phpAdmin novice. Can you direct me to what I may be doing wrong, please? I am currently using Simple Machines 2.0.5.

Arantor

Then apparently it isn't still valid :P

The column names were changed in 2.0.

Try this:
SELECT smf_members.real_name, smf_poll_choices.label
FROM smf_log_polls
INNER JOIN smf_members ON smf_log_polls.id_member = smf_members.id_member
INNER JOIN smf_poll_choices ON smf_log_polls.id_choice = smf_poll_choices.id_choice
AND smf_log_polls.id_poll = smf_poll_choices.id_poll
WHERE smf_log_polls.id_poll = 42
No good deed goes unpunished / All helpful urges should be circumvented

I have something to say: it's better to burn out than to fade away. There can be only one.

dkpeppard

Quote from: Arantor on September 03, 2013, 12:56:30 PM
Then apparently it isn't still valid :P

The column names were changed in 2.0.

Try this:
SELECT smf_members.real_name, smf_poll_choices.label
FROM smf_log_polls
INNER JOIN smf_members ON smf_log_polls.id_member = smf_members.id_member
INNER JOIN smf_poll_choices ON smf_log_polls.id_choice = smf_poll_choices.id_choice
AND smf_log_polls.id_poll = smf_poll_choices.id_poll
WHERE smf_log_polls.id_poll = 42


Thanks for the quick reply! :)

Your code worked without any error, but I also didn't get any username results.

When I ran the code you supplied, I was returned this:

'MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)'

At least two active users have voted in the poll, but I see no usernames returned. What should I try next, please?

Arantor

Then you could always try installing the Voter Visibility mod...
No good deed goes unpunished / All helpful urges should be circumvented

I have something to say: it's better to burn out than to fade away. There can be only one.

dkpeppard

Quote from: Arantor on September 03, 2013, 01:17:48 PM
Then you could always try installing the Voter Visibility mod...

Yeah, I was hoping to use something like this code query. It would not require me to install any modules on my forums, and I only use polls every so often.

Thank you again for your assistance.

dkpeppard

Quote from: Arantor on September 03, 2013, 01:17:48 PM
Then you could always try installing the Voter Visibility mod...

A little more background why I was hoping the MySQL script would work:

The other reason I don't just install the Voter Visibility mod is because I am one of those users who have issues with the automatic install of mods on my forums. I always have to do manual installs of forum updates, I can never use the automatic package install. The automatic process always fails.

I have my forums on a hosted site. Perhaps if I hosted my forums locally, I wouldn't have any issue, but since I have to work with my hosting provider, I have never been able to get any of the automated processes to work correctly.

I started trying to do the Voter Visibility mod install, but there is so much to edit manually, I was concerned I would either break something on my current forums, or I would break something on my forums when the next version update, such as 2.0.6, came out.

Bushstar

The information on getting the poll number does not seem correct in this thread. The poll number is not the topic number.

To get the poll number view the source of the page and look for poll=

The number after poll= is your poll number.

ajberry

If you select the data from smf_polls


SELECT *
FROM smf_polls


You will see the id's of all of your polls to then feed into the above mentioned query

Advertisement: