Latest Version
Poll Extension 0.1
Requires Vanilla 0.9.3 beta snapshot from Dec 28 or later.

To use, you need to install two tables:
CREATE TABLE `LUM_Poll` (
`PollID` int(8) NOT NULL auto_increment,
`DiscussionID` int(8) NOT NULL default '0',
`Title` varchar(255) NOT NULL default '',
`Options` text,
PRIMARY KEY (`PollID`)
) ENGINE=MyISAM;

CREATE TABLE `LUM_PollVote` (
`PollID` int(8) default NULL,
`UserID` int(10) default NULL,
`Vote` int(3) NOT NULL
) ENGINE=MyISAM;


You can go to http://bytetastic.com/vanilla/forum/ to see what it's like.
You can log in with username "User1" through "User7", and password "vanilla".


Original post

I'm working on a Poll extension to Vanilla. I haven't gotten to the PHP part yet, but I'd like some feedback on the default style and javascript mechanism.

http://bytetastic.com/vanilla/poll/

I'm not sure how to place it in the discussion though. Suggestions?

I'm new to Vanilla development though, so I'd like to know.. would this be possible with an extension alone? What should I do to make it easy for the user to set up the tables required (an install script?)

I'd like to get some tips on where to start. I'm experienced with PHP, and I've already written two patches (for the Opera and Safari bug), so I could figure it out myself, but it would be nice to get some tips from those with more experience writing extensions to vanilla.

Seems awesome, we are gradually getting to the point where we have the unnecessary gadgets that some forum users demand even tho they have no actual use and they are used once or twice a year, and even then it is a novelty.

I hate it when I suggest people to migrate to Vanilla and they are like "but it doesn't have polls, or this and that unnecessary feature that you could as well put in to your site by some cleverly hacked poll script that is as good or even better than the one integrated to your forum engine"

Now if the Vanilla 1 will introduce quotation nobody should have anything to say.

I think it'd be nice built into the control panel. If it was forum wide it could stay there all the time, or if it was for a particular discussion it could just appear on that discussion (and add [poll] or whatever like [sticky] etc.) While it might be a handy feature, what we do have to remember is that technically the discussion is the most important part of the forum (surprise!) so i think it's important to avoid disrupting the flow of the text. The most that should be put into the body of the forum (imo) is perhaps a 'polled' like the 'edited' next to someones name if it isnt an anonymous vote.

The parentheses are funky on Opera. Other than that, pretty sweet.

I'm looking forward to see a poll extension for Vanilla. It's looking really promising, skyfex - keep up the good work!

Apples to Oranges has some really cool CSS styling techniques for bar graphs. This might be of interest.

fine with me :D

This is what I came up with:
http://bytetastic.com/vanilla/Picture%203.png

I still like the green better. I couldn't get orange (like the comment form) to work out.

Yeah.. There is, I think, but it doesn't seem to be completely straightforward. I could place it inside the body of the text (at the beginning would probably be best). Perhaps that would be better. What do you guys think?

http://bytetastic.com/vanilla/Picture%204.png

What is the standard method for extensions to use AJAX?
Edit: Nevermind. I found an example.

I'd recommend that if the discussion is closed, then voting should also be closed for that discussion.

Maybe it could be an option?

Sometimes you might just want people to vote on something but not wax lyrical.

I reckon an admin option to have the thread closed and stickied but still be votable in would be useful.

Of course, I like complicating things.

Creating Polls is finished. Pictures:
http://bytetastic.com/vanilla/Picture%205.png
http://bytetastic.com/vanilla/Picture%206.png

A new option field is automagically created when you start writing in the one furthest down.

I'd still like feedback on wether or not one should be able to edit them.

This was easier than I expected. <3 Vanila

mark: Will you include this extension in the default Vanilla 0.9.3 distribution if I finish it before you're done?

Making polls and then editing the options to skew results seems kind of silly; these things were never scientific research tools. I can think of several legitimate reasons, though, why someone would want to edit their options (typos, clarifications, changes, additions)

I would be happy to install your extension on my site; let's just say that if it works there, it'll work anywhere

and...?

Hmm, doesn't work here (probably my fault, since I'm running a relatively old and modified revision).

Copied the files into the extension folder, made the two tables in the database, enabled the extension, started a new discussion, made some poll options and a question (the form works great), but no poll appears in the post.

I checked the database, and the two poll tables are empty.

Tomorrow I'll do some debugging and see if the delegates you hooked into are even there in my copy.

Well I've been meaning to install the Attachment extension anyway...

Well I got that problem fixed, but the poll still wouldn't display when I looked at the thread.

In the end I discovered that "$Comment->Body = $output.$Comment->Body;" wasn't doing anything, so I replaced it with "echo($output);" and everything worked.

Now, to figure out why the attachment extension is having the same problem...

that poll extension is really good skyfex, but i do think that users shouldn't be able to change their vote each time they visit the topic.

I got it working; turns out it *was* my fault; I moved the comment options to after the body, and the delegate with it. Moving it back fixed it.

I kind of like the vote changing, it keeps the results lively.

Hi all,

After seeing your poll extension I had to try 0.9.3 to install this. Being a compleet newbie to mysql, php and css it took me a litlle time to get it up and running, but I got it right now. Only problem: I can't get the poll working.

I installed it in the extensions folder. renamed poll.php to default.php to get it recognized by vanilla. no problems until I try to open a discussion. then about 8 errors are reported starting with this one:

Notice: Undefined index: Poll in vogelblik.nl/vanilla/library/Framework/Framework.Functions.php on line 369

the rest appear to be a result of this one

Warning: Missing argument 2 for addselect() in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 85

Warning: Missing argument 4 for addwhere() in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 114

Warning: Missing argument 5 for addwhere() in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 114

Notice: Undefined index: DiscussionID in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 115

Notice: Undefined index: in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 115

Notice: Undefined index: = in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 116

Notice: Undefined index: in vogelblik.nl/vanilla/library/Framework/Framework.Class.SqlBuilder.php on line 116

A fatal, non-recoverable error has occurred
Technical information (for support personel):

Error Message
An error occured while getting the poll for this discussion.
Affected Elements
Poll.GetPollFromDiscussionID();

The error occurred on or near: 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 ''=.' limit 0, 1' at line 1

any suggestions?

mail has been send

Any news about poll.extentsion for v1?