[RELEASE] Poll Hack v1.0.1

[EDIT] Some users found a badley-coded part of the hack, I am rewriting that part and therefore have deleted the url from this post[/EDIT]

The Poll Hack for the vB, now updated for speed and fuctionality. Demo at http://www.naboonline.com/polltest/

new features from 0.9.2 (previous version)

- if a user votes without logging in, is asked to login and the pollvote still counts
(2 new templates,error_pollvotenologin, error_pollvoteinvaliduser)
- Graphical view of poll results available. Template pollyesvote has a new variable $pollbargraph. If you
do not want to have the graphical view, simply remove the variable.
- poll icon ist now not needed to be inserted into the vBulletin icon db.
- new file pollmodule.php - hacks in files only reference to it, much less code to enter into the new files!
- speed enhancements and less mysql calls.

Overall features

- Let registered users post a new thread that has a poll integrated in it
- Let registered users vote on the poll
- Multiple votes impossible as userid is stored on vote
- Define # of poll options in CP
- Limit who can post a poll by usergroups (from the control panel)
- Designed to be easily translated. Only some text is hard coded (see localisation section below)
- Fully templateable - you can customise the look of the poll
- Users who can not post can not vote as well
- Make sure person did not vote, press back, and vote again
- Admin/Moderator edit of Polls at all times
- Edit Poll while no votes (for user who started the poll thread)
- vB code parse for options
- closing a thread == close a poll
- Admin delete
- View results without voting
- Close a poll (admin/mod/author)
- Graphical view of votes (bar graph and/or pie graph) **NEW**

Note to upgraders: Due to a change in the how data is stored, the new poll is not backwards compatible. Therefore, you will need to run updatepoll.php

The poll hack will be intergrated into vBulletin 2.0, so if you are in no hurry, you should better wait


[Edited by doron on 11-04-2000 at 06:00 AM]

Doron, can you help me? I got this error when I ran the updatepoll.php - the weird thing is that my directory is not /usr/local/apache/sites...

But my board is still functional so I don't know what this is about!

<!-- Database error in vBulletin: Invalid SQL: ALTER TABLE thread ADD poll SMALLINT (1) DEFAULT '0' not null
mysql error: Duplicate column name 'poll'
mysql error number: 1060
Date: Saturday 02nd of December 2000 08:33:54 PM
Script: /updatepoll.php
Referer:
-->

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/sites/***.com/htdocs/updatepoll.php:7) in /usr/local/apache/sites/***.com/htdocs/global.php on line 754

Warning: Cannot add header information - headers already sent by (output started at /usr/local/apache/sites/***.com/htdocs/updatepoll.php:7) in /usr/local/apache/sites/***.com/htdocs/global.php on line 757
Editing thread table ...

[Edited by Me2Be on 12-02-2000 at 07:44 PM]

Me2b, I had a kind of similar problem than the one you mention in you last 2 quotes.

Check my recent thread:
http://www.vbulletin.com/forum/showt...?threadid=5041

I'm sure you have the same blank lines problem.

Benj

[Edited by Benj on 12-02-2000 at 08:37 PM]

Benj, I just tried checking for blank spaces and couldn't find anything. The weird thing is that the board is working fine - It just gives me the error when I run the updatepoll.php file

ALTER TABLE thread ADD poll SMALLINT (1) DEFAULT '0' not null

look for that and comment it ouy with a //, you seem to already have the poll column in thread. As for the other error, that other thread seems to cover it.

you probably got the 2nd error once, retried the updatescript, but it succedded the first time to create that column. What sort of system are you on?

Originally posted by ukliam
I have added this hack for 1.1.4 on my test board... but it did not add any of the templates when I ran the makepolltables.php file.

Any ideas?

Right... could I have a copy of the templates or an edited makepolltables.php file that just does the templates and does not add any tables...

thanks

Originally posted by ukliam

Right... could I have a copy of the templates or an edited makepolltables.php file that just does the templates and does not add any tables...

thanks

just comment out (by putting a // infront of the line) the lines where the tables are created ie ALTER etc. The onlyones you need are the INSERT lines.

Cheers... it was a problem with my header as well.
But it all works fine now.

doron, commenting out that line worked perfectly! I still got that header error even after making sure there was no white space, but nevertheless, it still worked!

Thanks doron!

hmm, the header issue is wierd, I'll try to reproduce. Are you all running php4?

php4 for me! But like I said, it did work though!