Hide Poll Results

Firefly has a hardcoded version of this for hacker of the month, it allows the original poll poster, admins and mods of that form to view the results of the poll and none of the regular users. They can only view the poll if the poll is closed either by a admin/mod or the poll ends.

Relatively simple install, just two templates and two php files, though editing poll.php will be one of the more lengthy tasks.

This was tested on vB 2.2.6 and won't work without some editing on versions before as the multiple choice poll was introduced in the 2.2.x series and there is some reference to this in the queries, if you remove the references to these it should work.

[BillaBongUSA]

Hey, thanks alot . But there's that problem that if you click on "View Results" before you vote, you can see the results.

[BillaBongUSA]

Oh, nevermind, I just read your post on the first page about changing $thread to $threadinfo. Thanks again!

[WizyWyg]

Is there a way to HIDE the results even from the ADMINS of the board as well as those who created the poll. I want to have it so the results remain anonymous to everyone (including admins and tbose who created the poll) until it ends or the admin closes the poll.

[Link14716]

If an admin wanted to see it, all they'd have to do is hit "Edit Poll" which defeats that purpose

[Phillip Chapman]

I'm working on installing this hack and it appears my poll.php file doesn't contain the following which needs to be changed...

if ($option[votes] == 0) {
$option[percent]=0;
} else{
$option[percent] = number_format($option[votes]/$pollinfo[numbervotes]*100,2);
}

Am I missing something? Or because I'm running vBulletin 2.2.9 is this change no longer necessary?

This is the first hack I've installed, so please be as detailed as posssible.

[Phillip Chapman]

Ok... I was able to install the hack. However, now whenever I post a poll I'm getting the following error...

Database error in vBulletin 2.2.9:

Invalid SQL: INSERT INTO poll (pollid,question,dateline,options,votes,active,num beroptions,timeout,multiple,hidepoll) VALUES (NULL,'What is your favorite non-Muppet series of characters?','1039707446','Looney Tunes|||Peanuts|||Disney|||Hanna-Barbara|||Nick Toons','0|||0|||0|||0|||0',1,5,'7','0','0')
mysql error: Unknown column 'hidepoll' in 'field list'

mysql error number: 1054

Date: Thursday 12th of December 2002 08:37:26 AM
Script: http://forum.muppetcentral.com/poll.php
Referer: http://forum.muppetcentral.com/poll.php

Can anyone please help with this?

[Phillip Chapman]

Think I finally got everything working now. :classic:

[Phillip Chapman]

I'm needing to uninstall this hack. It works fine, we just want to have a totallly clean board and database. Obviously, I just overwrite the original php files.

My question is, how do I remove an SQL Query from the database under PHP admin? The code I added was...

PHP Code:

ALTER TABLE `poll` ADD `hidepoll` SMALLINT(5) UNSIGNED NOT NULL AFTER `voters` 


Exactly, what do I need to do to remove this from the database? (I understand it may not be totally necessary to remove this but I want to be sure it is gone and there are no future issues with this code).

Thanks in advance for your help!

[Boofo]

Scott, in the following code from your file, is this supposed to be $thread['postuserid'] or $threadinfo['postuserid']?

PHP Code:

----------------------
showthread.php
----------------------
look for the following on line 294
$pollbits="";

below it add
  $noshow = 0;
  if($pollinfo['hidepoll'] && $bbuserinfo['usergroupid'] != 6 && $thread['postuserid'] != $bbuserinfo['userid'] && !ismoderator($thread[forumid],"caneditposts")) {
    $noshow = 1;
  } 


[Threshold]

1) The thread notes that you made some changes to the original. Are those changes in the .txt file that is part of the first post?

2) At the beginning of the instructions, there are some steps for people who are using verions 2.0.x. Where do those instructions end and where do the instructions begin for people using later versions? (I am running 2.3.0).

Is this step for people on version 2.0.x ? ==>

Run the sql query to add the column to the poll table so users can select to hide the poll or not
ALTER TABLE `poll` ADD `hidepoll` SMALLINT(5) UNSIGNED NOT NULL AFTER `voters`