[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]

Hii

doron ..Where is the zip file of this hack ??

I may be going nuts but here is the whole story in a nutshell.

I had vB 113 and the older poll hack from october. Cant remember the version number. I upgraded to vB ver.114. During this time I also moved servers. Worst came to worst... I created a back up of the vB data base. On the new server I installed 114 instead of doing a 113 to 114 upgrade. I imported the tables and all.

Now yesterday I download the latest release of Poll Hack. I read the intructions not thinking about theolder verison I had installed befor ethe server move and before the 114 upgrade. I follow the instruction for the 114 install cause I did not see in the MySQL tables any of the tables that were there from when I did the install of Poll hack on 113.

I get the following error running makepolltables.php

Editing post table ...
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


I get the following in an email:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Duplicate column name 'pollid'
mysql error number: 1060
Date: Monday 18th of December 2000 11:14:58 AM
Script: /makepolltables.php
Referer:

Ok now the fun part. After reviewing the tables and not finding any reference to Poll hack install. I decided to try the upgrade from older version as in the instructions. Still I get the error as above.

I am lost. I need some where to be pointed.

Anyone?

first - the hack is at vbulletin.org

Originally posted by GMTalk
I may be going nuts but here is the whole story in a nutshell.

I had vB 113 and the older poll hack from october. Cant remember the version number. I upgraded to vB ver.114. During this time I also moved servers. Worst came to worst... I created a back up of the vB data base. On the new server I installed 114 instead of doing a 113 to 114 upgrade. I imported the tables and all.

Now yesterday I download the latest release of Poll Hack. I read the intructions not thinking about theolder verison I had installed befor ethe server move and before the 114 upgrade. I follow the instruction for the 114 install cause I did not see in the MySQL tables any of the tables that were there from when I did the install of Poll hack on 113.

I get the following error running makepolltables.php

Editing post table ...
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


I get the following in an email:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Duplicate column name 'pollid'
mysql error number: 1060
Date: Monday 18th of December 2000 11:14:58 AM
Script: /makepolltables.php
Referer:


Ok now the fun part. After reviewing the tables and not finding any reference to Poll hack install. I decided to try the upgrade from older version as in the instructions. Still I get the error as above.

I am lost. I need some where to be pointed.

Anyone?

this means you already have the poll hack installed (at least in the db). Do you have a poll table and does it contain anything? Try running the upgrade script in stead...

No there is not a poll table in there


I went through and looked and there is no table with Poll in it.

I have also tried the upgrade and it did not work either.

I decided to try the upgrade from older version as in the instructions. Still I get the error as above.

What can I do at this point. I would really like to have poll hack on the board.

so, you don't have any old polls? If not, simply remove the pollid column from the post table

Doron,

I have removed the poll id from the post table and tried once again.

THis is the error that I have gotten now when trying to run makepoll....

Editing post table ... Editing thread table ... Done!
Editing usergroup table ...

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Did a refreash and I got the same error.

This is what I got in the Email:

Database error in vBulletin: Invalid SQL: ALTER TABLE usergroup ADD canpostpoll SMALLINT (6) DEFAULT '0' not null
mysql error: Duplicate column name 'canpostpoll'
mysql error number: 1060
Date: Tuesday 19th of December 2000 04:54:30 PM
Script: /makepolltables.php
Referer:

I also tried it once again and did the items you stated and then did the following: removed poll from thread table as well as canpostpoll from usergroup table.

Upon doing this and retrying I get the following:

Editing post table ...
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

The email is as follows.
Database error in vBulletin: Invalid SQL: INSERT INTO template (templateid,title,template) VALUES (NULL,'editpoll','<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> $cssinclude

Then I got this email:
Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Duplicate column name 'pollid'
mysql error number: 1060
Date: Tuesday 19th of December 2000 05:05:50 PM
Script: /makepolltables.php
Referer:

I just want to say I appreciate the help Doron.

[Edited by GMTalk on 12-19-2000 at 06:06 PM]

seems you have some fields from the poll hack and some not...

delete the poll table
drop the pollid in post
drop the canpostpoll in table usergroup
drop the poll column in the thread table
drop the table pollvote

you might also want to delete the templates as well, they are listing in the file. If you still are having problems, mail me and I will send you a script that will automatically do it.

hi,

The only problem i have is when i created a poll, and then try to vote, i get this:

No forum specified. If you followed a valid link, please notify the webmaster.

Anybody has the same problem as me? or know how i can fix this, thnx

i'm using vB1.1.3

Originally posted by DEMOLiTiON
hi,

The only problem i have is when i created a poll, and then try to vote, i get this:

No forum specified. If you followed a valid link, please notify the webmaster.

Anybody has the same problem as me? or know how i can fix this, thnx

i'm using vB1.1.3

when did you download the poll? this was the bug about a variable not being escaped in the install script.

In the pollvote template, look for <INPUT TYPE=hidden name=threadid VALUE=
there should be a $threadid in the VALUE=""

ok Doron,

here is what I run into now. I followed all your instructions removed all traces of Poll hack and all templates associated with it. Run makepolltables.php get the following:

Editing post table ... Editing thread table ... Done!
Editing usergroup table ... Done!
Creating table poll..
Creating table pollvote..
FINISHED!
Creating templates...

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.


I deleted the make polltables.php and then gave myself the rights to create polls as instructed.

I pull up the forum to test and enter the
poll.php?action=newpoll&forumid=x with the x being the forum ID and all O got was a blank screen. ALl other areas and tests were fine for the posting of messages and all. Just when I try the polls I get a blank screen

Any suggestions.