[Release] Poll Hack v0.9

Yep, here it is, the poll hack for vBulletin, tested on 1.1.2 and 1.1.3 Beta3.

The hack incorparates a poll as a thread starter, where users can vote and reply normally. You can view the test forum at http://www.naboonline.com/polltest/index.php

I hope the instructions are clear, any questions should go here.

Download the zip here! (http://www.naboonline.com/cgi-bin/load.cgi?http://www.naboonline.com/pollhack/pollv09.zip)

Enjoy!



[Edited by doron on 07-16-2000 at 11:47 AM]

Hi Doron,
I think you?ve done a great job. Really, you rock!

Here are my comments:
I downloaded your zip-file and tried to install the poll (on a totally new and clean forum, ver 1.1.3), check it out under http://www.abflussfrei.com/forum
Ok, there are a few minor bugs in your scripts:

The file options.php has an error in line 595:
your script says:
<td ALIGN="LEFT"><B>Poll Hack Options</B></td>
the correct script is:
<td ALIGN=\"LEFT\"><B>Poll Hack Options</B></td>
otherwise anything won?t work.

Then the images: you included the poll.gif. The button "Post new Poll" instead of "Post New Thread" is missing, at least I think so ;)

The correct directory name of the icons-directory is
images/icons/ not images/icon/ as you write in your poll_notes.txt.

That?s all. Your documentation worked perfectly, and with a little bit of PHP-experience it was no problem to install the poll.
The only problem is: The poll doesn?t show!!
I don?t know why.
When I post a new poll and click on the "Preview"-Button, everything seems to be fine. When I click on the "Submit"-Button, the poll has gone.

Check it out for yourself under http://www.abflussfrei.com/forum
I changed the settings for normal & unregistered users to be able to post polls.

Waiting for your answer,
bye
Michael

did you add to the step 4?

4. In the postbit template, look for

$posticon <smallfont><B>$postitle</b></smallfont>
<p><normalfont>$message</normalfont></p>

change it with:

$posticon <smallfont><B>$postitle</b></smallfont>
<p><normalfont>$message<BR><BR>$pollbit</normalfont></p>

image - there is none I am afraid, need Menno to do one...

new zip with the fix to that small bug in options.php

Hmmm, weird. I´m sure I changed the postbit-template.
I did it again and now it works. Perfect!

bye,
Michael

Dose voting on a poll send it to the top of the list? Or do you need to reply in the post to send the poll topic to the top?

Originally posted by BikeForums
Dose voting on a poll send it to the top of the list? Or do you need to reply in the post to send the poll topic to the top?

you can toggle it in the control panel, but yes, that feature is in.

Just installed this on beta3. Works like a charm so far!

Thanks for the great hack.

How about if the user does not want to submit a poll, and just wants to submit a normal message?

I tried it and it said it needed a topic and at least 2 options.

--WildWayz

cool... all i need now is to upgrade to beta 3...

Originally posted by WildWayz
How about if the user does not want to submit a poll, and just wants to submit a normal message?

I tried it and it said it needed a topic and at least 2 options.

--WildWayz

The Post New Post icon should not(!!) be replaced, but rather add after it the code with the Post New Poll image for your forum (you need to create it yourself)

I have one little snag - when I try to change my usergroups to "allow polls" and then submit, it still goes back to "no". It's like it won't let me change that field from "no" but will allow me to change any other field.

Any ideas?

wierd, it works on my 1.1.3b3 and my test 1.1.2 board. Can the usergroups post polls though?

I tried re-coding the usergroups file and I'm not sure what I did differently, but it seemed to work for the registered users, but not for the admin usergroup.

Suggestion: maybe for future versions, instead of using an entire "replace" field for the long strings, you can tell us what to "add" instead. Ed has us "replacing" for his PM hack, and then this tells us to "replace" to - but the two conflicted so I lost something.

Excellent feature though, I love it - now if I could just get the admin (me) to be able to create poll posts!

[Edited by Me2Be on 07-17-2000 at 02:16 PM]

you can edit manually the sql tables, look for your usergroup and set canpostpoll to 1.

but highly wierd

Same thing with super-mods - can't post polls.

Has anyone else got this working that is using the PM hack or is it just me?

[Edited by Me2Be on 07-17-2000 at 03:07 PM]

Hi,
look at http://www.abflussfrei.com/forum/ (it?s my playground..)
Everything?s ok there in Germany ;)
Did you run the makeprivtables.php from the pm-hack and the makepolltables.php from the poll-hack?

bye,
Michael

Hi Michael,

Sure did. The PMs are working fine, and with regard to the polls, only registered users are able to post polls even though now I have told admins, super mods and registered users should have priviledges to post polls.

(Where in Germany?)

did you set the "number of posts for polls" to 0? maybe that fixes it

I'm going to try a fresh install without the PM hack (gotta love having a test board) to see what happens. Be right back!

@Me2Be:
Bavaria, in a city near to munich..
cu,
mm

I did a brand new install without any hacks added, and it works perfectly now. I'm going to try and re-install the PM hack and see if I encounter any problems on there. Thanks Doron, I love this hack!

Michael, how far is that from Kaiserslautern? (My husband went to high school there)

wierd, i got it running with the pm hack.

@Me2Be:
well, it´s 373 km from where I live. I´ve never been there.

bye,
Michael

And what's even more strange is that I reinstalled the PM hack after I installed the polls and everything is working perfect now.

Maybe it was in a tempermental mood or something ;)

I have found that when someone who is not logged in comes along and votes in a poll it says Invalid Username - I think it should take them to the login screen thing. I'm having to delay the rollout of the polls on my forums because of this.

No matter I've added a login box to forumdisplay

hmm, it should ask them to log in, must be a error. thanks for catching it.

Can my anybody help?
I have Install the hack. In the "normal" forum, working the hack Perfect! But I have 3 foren with a own Template. In the, are no Poll. I have making the Step 4 but here is only a "Post New Thread". No poll.
Have I forgot a step or?????
Thank you!
Bye
Tho

you need to add $pollbit to where in the other templates oyu want the polls to show.

hi doron... the poll hack is looking great :D ... i want to install it now and was wondering if the zip file you have above is the latest ? what do i need to install it ?

the zip is the latest, there is a notes.txt which tells you what to do.

It's been isntalled on 1.1.2 and 1.1.3b3

YOU DA MAN!

I'm not sure whether this is related to this hack or not. Im running 1.1.3 beta 3 with the latest version of the PM hack installed. I have just added this poll hack and had followed the step by step instructions precisely to the stage where i had successfully posted a test poll, which worked perfectly. I could view the test poll and vote on it without a problem

at this point i decided to switch my VB back on. However, after submitting the options I ended up getting a parse error:

Parse error: parse error, expecting `STRING' or `'{'' or `'$'' in global.php on line 57

which corresponds to
// ###################### Start dovars #######################

If I try to visit the forum I receive a slightly different parse error:
Parse error: parse error, expecting `STRING' or `'{'' or `'$'' in global.php on line 52
corresponding to:
eval($optionstemp[template]);

I've got no idea why this has suddenly happened, especially as global.php isnt altered by the poll?

Does anyone know what I could do to fix this problem?

TIA

[Edited by Morgo on 07-20-2000 at 10:39 AM]

Hi Doron,

I added your poll and now everything is running smoothly. However, I do have a couple of remarks:

1) I do not use icons; therefore, I kept getting a mysql error. I solved this eventually by changing "iconid=$iconid"; in poll.php to "iconid=0;".

2) I would like to have a regular prefix to poll threads in their title, something like "[Poll]:" - any idea how I can do that?

3) I think that somewhere on the forumdisplay, next to the poll-thread title or even under "replies" it should have the total number of voters so far. Any idea how I can add that?

Thanks for a great hack!

Toda :)

Bira

1) I do not use icons; therefore, I kept getting a mysql error. I solved this eventually by changing "iconid=$iconid"; in poll.php to "iconid=0;".

yeah, that's the best way


2) I would like to have a regular prefix to poll threads in their title, something like "[Poll]:" - any idea how I can do that?

showthread.php, line 69
look for
$threadtitle=htmlspecialchars($threadinfo[title]);
change it to:
$threadtitle='Poll: ' . htmlspecialchars($threadinfo[title]);

That will add a Poll: infront of each poll.


3) I think that somewhere on the forumdisplay, next to the poll-thread title or even under "replies" it should have the total number of voters so far. Any idea how I can add that?


that's planned for the next version ;)

Doron,

Changing that line 69 in showthread.php will put a "Poll:" prefix ahead of ALL threads, not just the poll ones, no???

Doron,

You have a small bug - in the template pollresults, the link back to the forum is forumshow.php?forumid=$forumid whereas it should be forumdisplay.php etc. :)

One more impeding wish, Doron:

Can you please add to the user permissions (as opposed to usergroup permissions) a "can post new polls - yes/no" option? This way, if someone abuses this option, I can simply bar him personally from posting polls.

Thanks,

Bira

Doron, in the vote options (the options you vote for) it adds a slash ahead of an apostrophe, like "It\'s" :(

hm... if you use addslashes() in the right way, there shouldn't be a problem.

Unless magic_quotes is activated in your php.ini file.

Originally posted by Menno
hm... if you use addslashes() in the right way, there shouldn't be a problem.

Unless magic_quotes is activated in your php.ini file.

Magic_quotes is on (1?), but that doesn't cause any slashes to appear in the posts. I've only got this problem in the poll options.

Originally posted by bira
Doron, in the vote options (the options you vote for) it adds a slash ahead of an apostrophe, like "It\'s" :(

Wierd I don't get that on the test board. Could you show me the poll that is doing that? http://www.naboonline.com/polltest/showthread.php?threadid=34

I tested it, seems to work. It adds the slashes to them, but should not show em when viewing.

As for the Poll: code, add after the line (in showthread.php)
if ($pollquery[pollid] <> 0) { //post has a poll

add this:

$threadtitle='Poll: ' . $threadtitle;

that will add a Poll: only if it is a poll

Ok, i uploaded the new zip with the fix for the forumshow (what a stupid mistake). The reason is that I had poll.php and pollshow.php at one time.

As for the user "pollvote", I think what I will do is a "pollban" field where you enter there userid's. that's for 1.0, in say about a month's time?

[Edited by doron on 07-21-2000 at 01:12 PM]

Doron, here - I made a sample for you: http://www.atlasf1.com/bb/showthread.php?threadid=7213

Please note that this is the only place where we have this slashes problem :(

Thanks for the "Poll" prefix - however it's not much help if it only shows on the actual thread itself. If you're there, you can see that it's a poll, heh. I wanted a prefix to the title on the forumdisplay page.

And also thanks for adding the userban :)

shabat shalom :)



[Edited by bira on 07-21-2000 at 09:18 PM]

very wierd, I can't dupe it. Are you using php 4 perhaps?

could you check if the slashes are existent in the db? They should not be. That is the only way to explain this.

doron, I'm using php3 and the slashes exist in the database.

$DB_site->query("INSERT INTO poll (pollid,options,question) VALUES (NULL,'".addslashes($polloptionsstring)."','".addslashes($question)."')");

It addes the slashes to $polloptinsstring, but when it gets added into the db, they should be stripped by the db itself. Sounds like a php error not removing the /'s.

ok, new zip is on the server with a postpoll graphic from menno.

doron, so what are you saying? That's it's not fixable? :(

what I am saying is that I really have no idea how that can be. I'm looking into this, but my guess is that

a) This is some wierd php bug with your system
b) you copied the hack somehow wrongly (even though i do not see how).

Do you get this when a poll is not closed as well? What about if you edit that poll - do you get the '/' also in those textfields?

Doron, I get those slashes in every situation, including on edit - even if I remove them and click submit.

The only way I can get rid of them is if I remove them via phpmyadmin - i.e. directy at the mysql table.

I checked that I copied the code correctly - no problem there.

What boggles me is the fact that I don't get slashes anywhere else than in the poll options.

doron - you probably missed a stripslashes() somewhere. I haven't looked at the code yet, so I don't know where :)

duh, i missed them somehow. Funnily, even without em, it works on my testboard.

Bira, look in poll.php for:

$optionQuestion = bbcodeparse($splitoptions[$run],$forumid,$foruminfo[allowsmilie]);

replace with:

$optionQuestion = bbcodeparse(stripslashes($splitoptions[$run]),$forumid,$foruminfo[allowsmilie]);

that should fix it except for the editing.

ummm, no, slashes still appear there and on new polls added after the change. You sure there shouldn't be a stripslashes() also somewhere else in the code?

ah, found it.

Doron, the same change should be made in showthread.php :)

Thanks to you and to Ed :)

duh, showthread, showthread. Sorry, I wrote that in a hurry, forgot that.

Doron, I just installed this and I want to say thanx:)

The only thing I would change (not including your future additions) is the setting default to "can't". OMG what a pain when you have a lot of usergroups and mods!

Great hack, though!

Can someone please add bar graphs to it?

so anything new happening with the poll hack ? i am finally ready to try it :rolleyes: be afraid to do so before :(

just being picky :) i thought'd i add if not already states that in newpoll template you need to edit the smilies and vbcode links to point your own forums :)

Originally posted by bira
ah, found it.

Doron, the same change should be made in showthread.php :)

Thanks to you and to Ed :) i installed the polls on my test forum and added the 2 lines Ed said in the poll.php and showthread.php

now when i post a poll with a ' in it

i.e. don't it comes up => don't which is fine

but hit the edit link, and do nothing but submit again...

the don't now comes up as don\'t

and if i do another edit and submit it ends up show as

don\\\'t

I finally installed the Poll hack and everything went perfect. I just modified it so that a user can't enter a message along with the poll, put in their signature, or put in a topic subject. I feel all of that is not needed in the poll post. Thank Doron.

[QUOTE]Originally posted by bira
[B]Doron, here - I made a sample for you: http://www.atlasf1.com/bb/showthread.php?threadid=7213

Please note that this is the only place where we have this slashes problem :(

Thanks for the "Poll" prefix - however it's not much help if it only shows on the actual thread itself. If you're there, you can see that it's a poll, heh. I wanted a prefix to the title on the forumdisplay page.

And also thanks for adding the userban :)

[Edited by rangersfan on 08-10-2000 at 07:01 PM]

Originally posted by eva2000
Originally posted by bira
ah, found it.

Doron, the same change should be made in showthread.php :)

Thanks to you and to Ed :) i installed the polls on my test forum and added the 2 lines Ed said in the poll.php and showthread.php

now when i post a poll with a ' in it

i.e. don't it comes up => don't which is fine

but hit the edit link, and do nothing but submit again...

the don't now comes up as don\'t

and if i do another edit and submit it ends up show as

don\\\'t

look for the same lines in editpost.php. I'll get the exact code latter and post the changes.

the next version will have graphical stuff in it. Hopefully it will be done next month

thanks doron... your poll will be a great addition to my anime forum :D ...after that it will be to get a more on my prequels forum :D

Doron : Problem..

User who have "Store username and password" set to "NO" can't vote because they aren't asked for their username/password so they always get "Invalid username/password" message".

Gonna make a fix? I guess you need to throw in a form in the middle that asks for their username/password before sending it on to the verifiyusername function.

[Edited by rangersfan on 08-07-2000 at 05:06 PM]

ah yes i forgot not everyone sets save username and passwords...

i have a fix for that, gotta test it better. The basic idea is to have a login form in the poll template if the user is not logged in.

Yes that would be a good way to do as all the variables would then be passed on.

Originally posted by rangersfan
Bira what I did to prefix "POLL" was edit poll.php and on about line 146 find "$subject=censortext($subject);"

After that line add :

$subject = "POLL: " . $subject

Insert whatever identifier you want. This will make all NEW polls have that in front of them in their title. Your old polls will still show the same title as before. This is the much easier way of doing it. You have to edit several files, (forumdisplay, showthread, search.php) just to name some if you want to check every post for a poll and then add "POLL" if it is one. Saving it as part of the title is the way to do it. You can even insert html into there to make it stand out more. [/B]

Hi Rangersfan,

Thanks for the help and advice. I have two questions though:

1) Right now, in poll.php lines 146-7 I have:

$subject=censortext($subject);
$message=censortext($message);


Your instructions are a bit confusing. Do you intend me to add a line, inbetween the above two lines, without a semicolon at the end??

2) What do you mean I can use HTML? How?

Thanks for your help mate - I appreciate it.

Cheers,

Bira

Well yes you need to put the semi-colon :) and the line can go in the middle or after both lines, it doesn't matter. As for the HTML, scratch that idea as the code will make that line into a Link later on and it wouldn't work.

thanks Rangersfan :)

Doron - request

Can you make it so that if I edit a poll (as Admin) I can have some blank fields to add options to?

I've got the hack installed, but it keeps telling me that it is having a problem accessing the database...the rest of the forum works fine though - any idea whats wrong?

TWTCommish - could you post the url or the exact error?

[Edited by doron on 08-30-2000 at 12:42 PM]

My apologies for being so vague...I figured it all out, however. KILLER hack!!! The instructions were a bit tricky to follow, but the hack itself is awesome.

Hello,

On my forums at http://forums.paintballcity.com the poll.php script runs sooooo slow and eats up MySQL.

Any way to fix this?

Originally posted by VirtueTech
Hello,

On my forums at http://forums.paintballcity.com the poll.php script runs sooooo slow and eats up MySQL.

Any way to fix this?

Could you show an example poll for this? Is it during poll creation or during the view of a poll or on an edit?

Edit seems to be the longest.

Welll I actually took the poll links off my site so that people did not try and post polls.

Without wading through all 6 pages of this post, where can I find the most recent, complete version with all the bugfixes worked into it? Or is there not one?

I hope vBhackers.org will be different than UBBhackers in that it has each totally working hack setup proprietarily, instead of linking to the thread.

-jim

Hi there!

I installe you poll hack but is doesn?t work:

everytimes i want to post a poll it seams at the and like a normal post!!!

first so:

Post New Poll
Your UserName: Want to register?
Your Password: Forgotten your password?
Subject:
Message:
See Forum Rules (above) for
more information about what
codes you are allowed to use
in your posts.

vB Code help is here.
Smilies help is here.


Question:

Remember to keep the poll options short and to the point
Option 1:
Option 2:
Option 3:

after post so:

Author Thread

bIGaXE
Administrator

Registered: Jan 1970
Posts: 683

asdfasdf
__________________
Linux Rulez!!!



i can?t se a poll :(

Please help me!!!

Sorry!! my english is not very good ;)

Nobody knows a answer?

could you show the url please?

As for the poll hack with all working bug fixies, it will come out very soon. Those comments about poll.php being slow scare me and I'm going through the code again to see if I can optimise it.

A full release (0.9.2) will comeout hopefully next week.

Originally posted by doron
A full release (0.9.2) will comeout hopefully next week.

I will wait for the full release :)

and I?ll try it again ;-)

thx to you

I think great work :)

Hi..

Whin i run makepolltables.php3 This message came !

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 it send me an email >>

Database error in vBulletin: Invalid SQL: ALTER TABLE post ADD pollid MEDIUMINT (8) UNSIGNED DEFAULT '0' not null
mysql error: alter command denied to user: 'mydomain@localhost' for table 'post'
mysql error number: 1142
Date: Saturday 28th of October 2000 01:48:55 AM
Script: /forums/makepolltables.php3
Referer:
ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ ÜÜÜÜÜ ÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜÜ

Note I HAVE PHP3

PLEAS HELP,

And thank you

You have to talk to your host about giving you "alter" permissions. Nothing we can do about that.

Ed Sullivan..

Is this answer for me ?

yep, the error means, you may not use the alter command...which is bad, very for upgrading. You better contact your host and request alter privlidges.

Ok ... :(

Ed Sullivan ,doron

Is "alter command" needed for PM also ?

If so . i don't know what is it . what i have to tell my host ?

Thanks

alter is needed for any upgrade or hack.

What host are you using? Tell them that you need ALTER privlidges for your mysql databases.

Thank you ..

I ask thim about that but i think thay don't know .

Any how i am planing to change them but i don't know is it easy to move my forums ?

what i need to that and can i do it my self ?

do you have some sort of mysql web interface? Did you set up a mysql user yourself?

No doren...

The site support mysql and php3 and ssi ...

And i ask them to install vB for me first time and they do and charge me . But to day whin i ask thim about "alter " thay told me that we cant do it cos it is not fault and every thing work well , i am sure thay said like this cos thay dont know how to do it . And i told them you can charge me any thing you want but thay said NO.

So do you know any company or person can move my vB to new server if i get one ? and wich the BEST host in your opanion ?

About your setting up mysql befor no i dont and also the sort of mysql web interface i don't have.

So pleas help me .

Thank you very much..

Del
web@cashcool.com



[Edited by dellow on 10-29-2000 at 02:26 PM]

Um, best ask in the hosting forum for that ;)

Hi Doron,

Thanks for a nice and stable hack, the instructions worked fine for me.

Just one important thing, though... Users who have not stored their Username/Password in the browser can't vote, they will forever get the "Invalid Username" error.

This needs an instant fix as many users don't select that option at all, particularly those accessing forums from Inernet cafes and other public places.

Originally posted by islandman
Hi Doron,

Thanks for a nice and stable hack, the instructions worked fine for me.

Just one important thing, though... Users who have not stored their Username/Password in the browser can't vote, they will forever get the "Invalid Username" error.

This needs an instant fix as many users don't select that option at all, particularly those accessing forums from Inernet cafes and other public places.



This is fixed in the 1.0.1 version, which will _hopefully_ be released this week. I have to test the upgrade script before I release the code. You might want to wait for it.

Hi Doron,

Thanks for the reply. I will wait for the next release and do take extra time for the testing.

Btw, may I suggest the following in the documentation?
1. Warning to users who have installed other hacks, so as not to overwrite other parameters especially in the options.php, user.php usergroup.php stuff

That's all.

Gerry