Mark Voted Polls On Forum

[ Feature Description ]
This feature marks all polls you have already voted in with a little check mark. Useful if a particular forum has a lot of polls or if you want to keep track of where you haven't voted yet. One simple file edit and it's done.

[ Tested on ]
vBulletin version 3.0.1 (should work on any vBulletin 3 series)

[ Example ]
http://www.gamingforce.com/forums/


Enjoy!

[Oblivion Knight]

Nice idea.. I'm sure I can find this useful..

[high]* Oblivion Knight clicks install and wonders off to make a new checked poll image.. [/high]

[Dean C]

Thankyou for sharing your work

[ryancooper]

Cool this will work great

[Alien]

Very nice!! Thanks for this...

[Oblivion Knight]

I'm not sure if this was changed since 3.0.1 since, if I'm honest, I never got around to installing it. Though now I'm upgrading to 3.0.3 and am FINALLY installing your hack, the image should be named poll_posticon_checked.gif instead of poll_posticon_check.gif

Thanks again for sharing your work (and I hope you do decide to release ChocoJournal.!).

[Andreas]

Nice and useful hack, but it has some problems

1. It does not support table prefixes
2. It adds a query for every thread that contains a poll

Fix for #1
In functions_fordumdisplay.php FIND

PHP Code:

function process_thread_array($thread, $lastread = -1, $allowicons = -1)
{ 

BELOW that ADD

PHP Code:

global $DB_site; 

Still in functions_forumdisplay.php FIND

PHP Code:

$pollvotecheckq = mysql_query("SELECT votedate FROM pollvote WHERE userid=$bbuserinfo[userid] AND pollid=$thread[pollid]");
$pollvotecheck = mysql_fetch_array($pollvotecheckq); 

REPLACE that with

PHP Code:

$pollvotecheck = $DB_site->query_first("SELECT votedate FROM " . TABLE_PREFIX . "pollvote WHERE userid=$bbuserinfo[userid] AND pollid=$thread[pollid]"); 

Anyone got ideas for problem #2?

This is really bad as I got a forum which is dedicated to polls, so this would add 40 queries when this forum dis being displayed

Edit:Nevermind. I got it working with just 1 additional query (which will only be executexc when there are any polls and it is not a guest). Unfortunately this does currenlty only work in forum display, but not ich searches and subscribed threads.

[Gamingforce]

This hack will be updated soon. Thanks.

[OmaniMan]

Great
* Install *

[Megareus Rex]

Ok, i had this installed for a while, but now, I find it no longer works. The poll_posticon_check.gif is still there, as is the correct code in the includes/functions_forumdisplay.php, but now polls I've voted on use the same post icon as polls I haven't voted on.

What is the problem? I really liked it, too

EDIT: Nevermind, I fixed the problem.