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

I have to warn you guys first, I'm a total newbie, I haven't got the faintest idea what I'm talking about . I'm planning on learning the basics soon though, but in the meantime, I'm relying on you here

When I run makepolltables.php (after having done everything in the readmethingy), I get the following error:

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.


And this is the email I recieve:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Access denied for user: 'kroet@localhost' to database 'kroet'
mysql error number: 1044
Date: Thursday 14th of December 2000 01:47:30 PM
Script: /~kroet/murmellius/makepolltables.php
Referer:

Er? Prolly some basic, newbie, mistake on my side, but I'm curious anywayz

seems you have no permissions to alter tables...also, are you running it form the main vB directory?

I'm running it from the forum main dir, and should have all the permissions I need on the server. I found out that makepolltables.php seems to be looking for *.php files instead of the *.php3 files I have on the server. It's 1.0.1.3 btw, but I thought I used the 1.0.1.3 manual readme thingy.

Originally posted by KroeT
I'm running it from the forum main dir, and should have all the permissions I need on the server. I found out that makepolltables.php seems to be looking for *.php files instead of the *.php3 files I have on the server. It's 1.0.1.3 btw, but I thought I used the 1.0.1.3 manual readme thingy.

i have not done a .php3 version, you should just do a search and replace in all the files, that should help.

btw, it's 1.1.3

Errr. I knew that. I don't remember why I typed it wrong then

I'll try the search 'n replace now

I did the search 'n replace, which didn't work. Still got the following email:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Access denied for user: 'kroet@localhost' to database 'kroet'
mysql error number: 1044
Date: Saturday 16th of December 2000 02:24:47 PM
Script: /~kroet/murmellius/makepolltables.php3
Referer:

So I think it must be the acces stuff. I don't see how it could be wrong though, since makepolltables.php3 requires global.php3 for the password etc, which requires /admin/config.php3 for the password. So, that should work. Hummzz

Originally posted by KroeT
I did the search 'n replace, which didn't work. Still got the following email:

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: Access denied for user: 'kroet@localhost' to database 'kroet'
mysql error number: 1044
Date: Saturday 16th of December 2000 02:24:47 PM
Script: /~kroet/murmellius/makepolltables.php3
Referer:

So I think it must be the acces stuff. I don't see how it could be wrong though, since makepolltables.php3 requires global.php3 for the password etc, which requires /admin/config.php3 for the password. So, that should work. Hummzz

my best guess is, you have no alter access. Is this a dedcated or a shared server? Also, have you installed any other hacks?

This is the first hack I installed. And I don't know if it's a shared one.

http://www.marmoset.net

I'll have a look

[EDIT]

Couldn't find it :|

[/EDIT]

[Edited by KroeT on 12-17-2000 at 09:45 AM]

you better contact your host and ask them for alter privilidges for mysql...

Will do