Miscellaneous Hacks - Poll Survey

Info

Display all polls in a list from your forum.
http://yourforum.ltd/misc.php?do=survey

Polls are displayed by forumpermission. If a user hasn't the permission to see a forum where a poll is in, the poll will not display.


Installation (info.txt)

(The pagenav is limited to 25 polls on a site.
If you want change the limit, open the xml file and search for:

sanitize_pageresults($scount['scount'], $pagenumber, $perpage, 100, 25);

Change the '25' to your whished limit.)

1. Login to your admin control panel
2. Go to "Plugins & Products" -> "Manage products"
3. Click on "Add/Import product"
4. Browse for "Poll_Survey.xml" (included in the zip file), and click "Import"
5. Optional: Make a link to the poll survey where always you want.

I used the navbar dropdown menu "useful links".
If you want too, then did this:

Search in template "navbar" for:

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>

Add below:

<!-- Poll Survey begin -->
        <tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=survey">$vbphrase[survey_all_polls]</a></td></tr>
<!-- Poll Survey end -->

That was all

*Added forget table_prefix
*Added variable for hand closed polls

[YLP1]

Does this mod find all polls within the entire forum or just designated forum ids? I ask because I have a forum specifically for polls but sometimes people post a poll in other forum categories.

I installed the mod -- awesome! It pulls polls from all forums! Thank you.

[CHIPIT195]

I'm getting the following error:
-------------------------------------
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT COUNT(p.pollid) AS scount
FROM vb_poll AS p
INNER JOIN vb_thread AS t ON (p.pollid = t.pollid)
WHERE t.forumid IN()
AND t.visible IN (1);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND t.visible IN (1)' at line 4
Error Number : 1064
Date : Sunday, April 22nd 2007 @ 01:29:26 PM
Script : http://"mysite.com"/misc.php?do=survey&order=desc&sort=dateline
Referrer :
IP Address : "12.345.67.890"
Username : Unregistered
Classname : vB_Database_MySQLi

---------------------------------------------



???

[Zaguzin]

I have a problem



As you see, I have two polls with the same ID!
But the main problem is that - one of this polls doen't exist!
What's the matter?

[Free-D]

I have the same problem as Zaguzin
Every 3d, 13th, 23d, etc. polls are duplicated on surveys page

[mkdevo]

this looks great. would you be able to add a feature to show the (current) poll results on the main poll page?