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

this happens during voting...I'll look at this, seems that people are able to vote though on your forums

Yeah it is really weird....I just got like 15 more emails like that this morning.

I went through and tested all of the poll functions as an administrator and as a regular users...I'm not sure were the error is coming into play.

Maybe it is from:
- A moderator trying to edit the poll
- A guest trying a poll function

I'll try and do some more testing.

Originally posted by VirtueTech
Yeah it is really weird....I just got like 15 more emails like that this morning.

I went through and tested all of the poll functions as an administrator and as a regular users...I'm not sure were the error is coming into play.

Maybe it is from:
- A moderator trying to edit the poll
- A guest trying a poll function

I'll try and do some more testing.

Perhaps you can ask your users if they saw it and what triggered it. My only guess is, as your forum is pretty big, that people are playing with the poll by trying to vote directly. If this continues, I can patch up poll.php to throw an html error and thus avoid the db errors.

James-
Did you edit the two new templates that were created to have $pollid and $optionChoice in BOTH of them? (I think those are the variable names)

Doron-
In the updatepoll file you forgot to escape the $'s.

so, is it working yet?

all bugs should be ironed out now, waiting on VirtueTech to see about that error he keeps getting, even though it could be a template issue...

I see you installed it on your forums, are you getting any sort of db errors?

hello !

I got the same DB-Error as VirtuTech.

My users do not see the poll-hack, cause the button is not implemented - but even then i got some error messages from time to time.

So i do not think it is a problem when users play with the poll itself.

bye tom

Originally posted by doron
all bugs should be ironed out now, waiting on VirtueTech to see about that error he keeps getting, even though it could be a template issue...

I see you installed it on your forums, are you getting any sort of db errors?

Database error in vBulletin: Invalid SQL: SELECT threadid FROM post WHERE
pollid=
mysql error: You have an error in your SQL syntax near '' at line 1
mysql error number: 1064
Date: Monday 06th of November 2000 09:38:52 AM
Script:
Referer: http://atforumz.com/poll.php


That's the one I get, but the polls seem to work anyway. I didn't bother to check last night (I have a special addy for DB errors), but it's the only one I get.

are you missing a $pollid at the end of that statement? I'm at work and don'e have ready access to the code...

Look at the 2 new templates that were created - they're probably missing the variables $pollid and $optionChoice (the variables have the same names as the <input type="hidden"..> they're in)

error_pollvotenologin

You must be logged in to vote on a poll

<p>To log in, fill in the form below:

<p>
<form action="poll.php" method=post>
Username: <INPUT TYPE="TEXT" NAME="username" SIZE=7 MAXLENGTH=25>
Password: <INPUT TYPE="PASSWORD" NAME="password" SIZE=7 MAXLENGTH=13>
<input type="hidden" name="action" value="pollvote">
<input type="hidden" name="optionNumber" value="$optionNumber">
<input type="hidden" name="pollid" value="$pollid">
<input type="submit" value="Login!"></form>

<p><smallfont>The administrator has required you to <a href="member.php?action=signup">register</a> before you can vote on polls. <a href="member.php?action=lostpw">Forgotten your password?</a></smallfont>

error_pollvoteinvaliduser:

Your username and password do not correspond.

<p>To vote in, fill out the correct informaion below:

<p>
<form action="poll.php" method=post>
Username: <INPUT TYPE="TEXT" NAME="username" SIZE=7 MAXLENGTH=25>
Password: <INPUT TYPE="PASSWORD" NAME="password" SIZE=7 MAXLENGTH=13>
<input type="hidden" name="action" value="pollvote">
<input type="hidden" name="optionNumber" value="$optionNumber">
<input type="hidden" name="pollid" value="$pollid">
<input type="submit" value="Login!"></form>

<p><smallfont>The administrator has required you to <a href="member.php?action=signup">register</a> before you can vote on polls. <a href="member.php?action=lostpw">Forgotten your password?</a></smallfont>

I really have no idea how the $pollid and $optionNumber are not there - could you all check if it exists in your templates?

thanks!