Who voted?

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/showthrea...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:







Have fun!

[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/vbport...oted&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?