[HTL] & [TXT] Edit Poll Options

[Andreas]

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:

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

Are we supposed to put this code above all 3?

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.php?do=polledit&pollid=3
Username: wAmbAm
IP Address: 82.37.28.131

[assassingod]

You've installed it incorrectly (You've copied text from the install file into the query accindently)

[msimplay]

You've installed it incorrectly (You've copied text from the install file into the query accindently)
thank you fixed now :D very useful hack lol why on earth is this even a hack should be standard :mad:

[msimplay]

ok what about vb3 gold now :o

[Leah]

I tried to install it in vB3 Gold, but there's something with the code in poll.php that needs to be changed.

[msimplay]

I tried to install it in vB3 Gold, but there's something with the code in poll.php that needs to be changed.
i had a problem with installing this too

[PET]

is this working in GOLD ?

[msimplay]

is this working in GOLD ?
i tested it and its not working for me i don't know about anyone else

[Leah]

Not working in GOLD for me either.

[JaNa]

Very useful...

/me clicks install

[PET]

bleah. How a bad way of writing the TXT file. How can i know that the TXT file is not finished ? You shoud'v write an ending message. Like :

#########################3
That's id, i hope you enjoy my hack

[Andreas]

Hmm, I haven't upgraded to Gold yet :(

But normally it should work.
I'll test that when I got time to do so.

[theArchitect]

*theArchitect Clicks intalll*.

Very nice. Though I had to make a couple of changes to get it working with 3.0.3.

[Andreas]

Hmm ... gonna check & update the instructions soon :)

[theArchitect]

Hmm ... gonna check & update the instructions soon :) Sorry, I should have been more specific.

In your instructions your original code requested a find and replace for:
globalize($_POST, array('pollid' => INT, 'closepoll', 'pollquestion' => STR, 'options', 'pollvotes', 'timeout'));

while the original PHP was:
globalize($_POST, array('pollid' => INT, 'closepoll', 'pollquestion' => STR, 'options', 'pollvotes', 'timeout' => INT));

Another find and replace requested I search for:
timeout = '" . addslashes($timeout) . "'

while the original PHP was:
timeout = $timeout

Nit picking I know, but perhaps confusing for a newbie who is expecting a carbon copy with the find and replace.

And nice to see that you have updated the instructions too. :cool:

Love your work.

[Andreas]

Yep. As this was originally written for RC2 the code to search for was a bit different.
In the meanwhile I already updated the instructions :)