Who voted?

[Konqueror]

Who voted? v1.1b

1.1b:
-----
Important bugfix thanks to kypdurron:
Votes did show up even when the voter chose not to make it public.
Added seperate instructions if you want all votes to be public.

1.1:
----
The hack now also works with multiple choice polls.
Displays a message when no public votes are found.

1.0a:
-----
Important bugfix. Somehow I forgot to include the database changes in the instructions.
If you've already installed version 1.0 please just run this MySQL query:
ALTER TABLE pollvote ADD showvote TINYINT(1) DEFAULT "0" NOT NULL;

1.0:
----
Initial release

This hack was requested at https://vborg.vbsupport.ru/showthread.php?s=&threadid=33239
Basically what this hack does is that it gives voters the option to select if their vote is to be made public. If they select yes, everyone can see what they voted for.
I'm not good at writing descriptions, so just go and have a look here:

http://www.stefanh3.f2s.com/hacks/whovoted/step1.jpg

http://www.stefanh3.f2s.com/hacks/whovoted/step2.jpg

http://www.stefanh3.f2s.com/hacks/whovoted/step3.jpg

Have fun! :)

[LanciaStratos]

Both me and my members thank you very much! Great hack! :D

[Lesane]

Thanks for the great hack Konqueror.

[Tommy Boy]

Excellent! :p

[squawell]

it's great!!

thankz~:D

[Konqueror]

Updated! Please everyone download the new instructions...

[phase1]

When I install this script and try to use it I get this error:
Fatal error: Call to undefined function: updateuserforum() in /hsphere/local/home/phase1/networking.phase1design.com/forums/poll.php on line 43

Anyone have a suggestion on how to fix, or does this script not work with old polls????

[Konqueror]

Updated version posted. This should also work for you now, phase1. :)

[kypdurron]

Great hack! one problem, however is that it doesn't work correctly.
It is displaying all votes, regardless of whether they are public or not.
I made the following additions to poll.php

if ($votes = $DB_site->query_first("SELECT pollid FROM pollvote
WHERE pollid='$pollid' AND voteoption='$tmp'AND SHOWVOTE=1")) {
$votes = $DB_site->query("SELECT * FROM pollvote WHERE poll
id='$pollid' AND voteoption='$tmp' AND SHOWVOTE=1 ORDER BY userid ASC");

[atrl]

I cant get the My SQL DB change right can anyone help by showing me a pic of what it should look like, im not sure of all the values? Please Help?

[kypdurron]

you mean the changes to Mysql DB?
I guess..do the following(prompt in limegreen,type commands in skyblue):

WARNING! TRY AT YOUR OWN RISK!

$mysql (you may have to do mysql -u <userid> -p, then type the admin password)
mysql>connect vbulletin; (or whatever the database is called)
mysql>TABLE pollvote ADD showvote TINYINT(1) DEFAULT "0" NOT NULL;

To verify it worked, do
mysql>select * from pollvote;
you should see something like:
+------------+--------+--------+---------------+--------------+-------------+
| pollvoteid | pollid | userid | votedate | voteoption | showvote |
+------------+--------+--------+----------------+----------+----------+
| 1 | 1 | 1 | 1009029051 | 3 | 0 |
+------------+--------+--------+------------+------------+----------+
mysql>exit;

[Tommy Boy]

Good hack, Konqueror. And nice catch, kypdurron!

BTW: I think you forgot to modify the "pollresults" template as well... ;)

[SirSteve]

Not sure why but if you choose not to make your vote public, it still shows up as if you choose yes...

[kypdurron]

SirSteve: make the modifications I suggested to fix this.

Basically, I added "AND SHOWVOTE=1" to the two lines shown above.

[SirSteve]

Thanks. That worked. However, look here:

http://www.sirstevesguide.com/vbportal/forums/poll.php?action=whovoted&pollid=23

You don't have to be registered to vote so I think it's not showing the text because of that. Can you display the # of guests that votes? Like:

It was OK, but distribution continued to be a problem for me.:
JediTricks master jedi The Eradicator Guests (25 votes)

or something like that.

[Lucky]

Great Tool!

Thanks :)

[trainer]

great hack! this would be perfect for my site if it could be setup so only admins/supermods can see the results of who voted.

any ideas if that could be easily done?

thanks a pile

[glenvw]

This looks great.

Two questions:

Can it be set up so that the voter has no choice. That is I want all votes to be made public.

Also, I see talk about the fact that anyone can vote. Can it be set up so that only registered members can vote?

Thank you!

Glen

[trainer]

[QUOTE]Originally posted by glenvw
This looks great.

Two questions:

Can it be set up so that the voter has no choice. That is I want all votes to be made public.

Also, I see talk about the fact that anyone can vote. Can it be set up so that only registered members can vote?

Thank you!

Glen

[Sufian]

Great hack, it does what I need, however, I just want who voted and not the option they voted for..how can I modify this hack for that?

[subu1]

i install this, but i thing i am stupid because where can i see who votet

[Yahooman]

Yeah, that's exactly what I was looking for! I wanna see if the users who read the poll voted too! - Just for control ;)

Yahooman


[QUOTE=Sufian;351644]Great hack, it does what I need, however, I just want who voted and not the option they voted for..how can I modify this hack for that?