[HTL] & [TXT] Edit Poll Options

Edit Poll Options
Version: 1.0
vB-version: 3.0.0 Release Candidate 2
Developer: Kirby
Install difficulty: Easy
File edits: 4
Template edits: 1

Description of the Hack:
By default it is not possible to change poll options (multiple votes, public) when you edit a poll.
This hack allows to change these options.
Please note that it is only possible to make a public poll non-public, you cannot make a non-public poll public with this hack.

History

• 1.00 Initial release
• 1.01 Updated instructions for vB 3.0.3
  Dropped HTL

HACK INSTALLATION DETAILS:
Files modified for this Hack:
poll.php

Templates modified for this Hack:
editpoll.php

[Merjawy]

hmmm I don't see the hack.. wheres the zip file?

[gmarik]

It's lost, don't you see it?

[Boofo]

I found 3 instances of this code in the poll.php:

PHP Code:

 $threadinfo = $DB_site->query_first("
  SELECT *, NOT ISNULL(deletionlog.primaryid) AS isdeleted 

Are we supposed to put this code above all 3?

PHP Code:

 if (!$pollinfo['public'] AND $public)
  $public = 0; 

[Andreas]

No. Only around line 459 (for RC2).

[Boofo]

Maybe you should update the instructions?

[Boofo]

The one under this?


start adding the edit to the db

[Andreas]

Yep.

Instructions updated (line number added)

[Boofo]

You might want to alos mention it is under that. RC3 has that on a different line.

[msimplay]

What did i do wrong i get that error
i use rc4 vb3

Database error in vBulletin 3.0.0 Release Candidate 4:
  
  Invalid SQL: 
  		UPDATE poll
  		SET numberoptions = '6',
  		question = 'Is this site any good ?',
  		votes = '0|||0|||0|||0|||0|||0',
 		options = 'Excellent|||Good|||Average|||Poor|||Never been here before|||I thought this used to be amc\'s homepage :S',
  		active = '1',
  		REPLACE that with
  		timeout = '0',
  		multiple = 0,
  		public = 1
  		WHERE pollid = 3
     
 mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPLACE that with
  		timeout = '0',
  		multiple = 0,
  
  
  mysql error number: 1064
  
  Date: Sunday 14th of March 2004 12:20:45 PM
  Script: http://www.wambam.net/vbulletin/poll.php
  Referer: http://www.wambam.net/vbulletin/poll...ledit&pollid=3
  Username: wAmbAm
  IP Address: 82.37.28.131