Hide Poll Results

[high]Installation Instructions[/high]

Step 1: Upload the .xml file to the Product Manager
Step 2: Click [high]INSTALL[/high]

Requested by: https://vborg.vbsupport.ru/showthread.php?t=95019 (mrsbuzzy, 68 Z-28 & 1996 328ti)

[high]What does this Plugin do?[/high]

Basically, this will disable poll results from showing from everyone :devious:

[high]Are there any screenshots?[/high]

See my next post

[high]Version History:[/high]

1.0.0: First release
1.0.1: Added more functionality (Results shown when poll is closed, hidden while open); Corrected 3 bugs (2 phrases in the added template, pollresult_voted now cached in cache_templates) ; 1 template edit / overwrite required (pollresult_voted) to add new phrases;
1.0.2: Fixed another bug - Should allow you to vote on unvoted polls now
1.0.3: Fixed bug that unregistered users can see poll results

Chris

[djnth]

I installed this and I have one MAJOR problem. I'm using vBAdvanced CMPS and the poll on the front page is pulling polls that are supposed to be hidden and displaying the results. Even when I'm not logged in as an ADMIN, just as a guest. Now I have people that are able to see the results of a secret vote. You can view it at www.azdancemusic.com

[msgotit]

Originally Posted by djnth

I installed this and I have one MAJOR problem. I'm using vBAdvanced CMPS and the poll on the front page is pulling polls that are supposed to be hidden and displaying the results. Even when I'm not logged in as an ADMIN, just as a guest. Now I have people that are able to see the results of a secret vote. You can view it at www.azdancemusic.com

Sorry about that, didn't think about it. You will have to go into the currentpoll.php mod and edit it. At line 65 (in mine) so it should be around there, add hidepoll to the list of fields to get:

Find this:

PHP Code:

SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public $query[pollfields] 


Change it to:

PHP Code:

SELECT thread.pollid, hidepoll, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public $query[pollfields] 


Then find this:

PHP Code:

if ($pollinfo['showresults']) 


And change it to this:

PHP Code:

if ($pollinfo['showresults'] && !$pollinfo['hidepoll']) 


I think that will do it, let me know if it doesn't. I don't think there is a way to do it in the product so this is it, let me know if you need anything else.

Mark

EDIT: PS. I haven't actually tried this so I don't know for sure, but it should work.

[skogen]

Need urgent help!

When I and other users try to make a new poll I got errors

PHP Code:

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO poll
        (question, dateline, active, timeout, multiple, public, maxoptions, hidepoll, numberoptions,
options, votes)
VALUES
        (Do you want to compte?', 1140716784, 1, 50, 0, 1, 0, 0, 2, 'Yes |||No!', '0|||0');

MySQL Error  : Unknown column 'hidepoll' in 'field list'
Error Number : 1054
Date         : Thursday, February 23rd 2006 @ 06:46:24 PM
Script       : http://www.mysite.com/forum/poll.php
Referrer     : http://www.mysite.com/forum/poll.php?do=newpoll&t=11273
IP Address   : 192.168.0.1
Username     : any
Classname    : vb_database 


[msgotit]

Skogen,

Can you look at your database tables? If so, did the hidepoll field get put in to the poll table?

Because it is trying to insert hidepoll in there I would assume that you have used the one I posted, and I would suggest trying to re-import it. If I had to guess, it didn't add the field, and I am not sure why. Let me know if that works!

[BrandiDup]

exactly what I needed! thank you very much

[bobc973]

Originally Posted by msgotit

Skogen,

Can you look at your database tables? If so, did the hidepoll field get put in to the poll table?

Because it is trying to insert hidepoll in there I would assume that you have used the one I posted, and I would suggest trying to re-import it. If I had to guess, it didn't add the field, and I am not sure why. Let me know if that works!

What are the type, attributes, null and default values if we want to add it manually to the table?

Thanks!

[msgotit]

Originally Posted by bobc973

What are the type, attributes, null and default values if we want to add it manually to the table?

Thanks!

First you have to be using the xml product I posted in the middle of the the last page. If you open that up you will see it but I believe it is tinyint with default 0. Hope this helps!

Mark

[bobc973]

Yes that was it tinyint, length 1, default 0. THANK YOU!

[Hurricane]

I know this is not the proper way of doing this, but here is a modification of the modified version of the regular hack.

This one is for admins. Only the admins can hide results to polls and admins can always see the results.

THIS IS NOT AN UPGRADE! Do not install with the other one! This is named differently so you can not overwrite the other one. You will have to uninstall the other one first and install this one.

[gonkowonko]

Originally Posted by Hurricane

I know this is not the proper way of doing this, but here is a modification of the modified version of the regular hack.

This one is for admins. Only the admins can hide results to polls and admins can always see the results.

THIS IS NOT AN UPGRADE! Do not install with the other one! This is named differently so you can not overwrite the other one. You will have to uninstall the other one first and install this one.

Love it works lovely