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

[taxick]

I get this SQL error.

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(p.pollid) AS scount
FROM forum_poll AS p
INNER JOIN thread AS t ON (p.pollid = t.pollid)
WHERE t.forumid IN(3, 11, 14, 154, 15, 119, 4, 157, 158, 159, 16, 17, 116, 118, 153, 105, 5, 138, 19, 18, 25, 22, 21, 9, 34, 52, 91, 93, 92, 122, 132, 126, 140, 139, 141, 146, 142, 155, 147, 145, 144, 100, 102, 104, 101, 113, 136, 137, 156, 160, 134, 120, 6, 48, 50, 49, 75, 76, 65, 89, 135, 90, 121, 44, 45, 36, 95, 39, 96, 111)
AND t.visible IN (1);

MySQL Error : Table 'forum.thread' doesn't exist
Error Number : 1146
Date : Monday, January 1st 2007 @ 08:03:58 PM
Script : http://www.*************/misc.php?do=survey
Referrer :
IP Address : *****************
Username : Taxick
Classname : vB_Database

[Renee]

Originally Posted by taxick

I get this SQL error.

Oh, thank you, I forget two table_prefixes. They're now in

[taxick]

Hey

I still get the same sql error Hope you can fix it

[FleaBag]

Great hack thank you!

[taxick]

Now it works..

installed

thank you!

[ubblite]

Does this mod auto-update? For some reason I'm showing polls that have been closed saying "active".

[Renee]

Umpf sorry, I have forget that polls could close by hand

I will update it later, have to work now

[ResaleBroker]

I get this error when trying to view the list as an "Unregistered Guest" without viewing permission:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT COUNT(p.pollid) AS scount
FROM poll AS p
INNER JOIN 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

[WhyDoesItMatter]

Originally Posted by ResaleBroker

I get this error when trying to view the list as an "Unregistered Guest" without viewing permission:

Ditto, I came here to check it out. Glad I'm not the only one getting this error.

[skorzguy]

Here is what I did since I needed to make a link so anyone can see what polls are available.

Instead of adding this:

<!-- 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 -->

I made a link and pointed to this url:

http://www.allstarchat.com/forum/misc.php?do=survey

** You just need to put your website in the url instead of mine.

** You can still see the page as a guest