vBulletin Forum Sideblocks - Show Poll In Forum Sideblock

.::Show Poll In Forum Sideblock::.

-> Special Thanks To Paul M For allowing me to use one of the code from his one of the mod.

What is it?
=====================================

This mod will show the Poll in Forum Sideblock.

Features
=====================================

1. Enable/Disable the mod from admincp.
2. Get Latest Poll From Multiple Forum. New!
3. Get Poll From Particular Thread.
4. Fully Integrated with Vbulletin Forum Sideblock Manager

-> You can change display order
-> Cache Time

5. No Template Edits.

Upgrade Instructions
=====================================

1. Upload The New xml from Product manager in Admincp. (Don't Forget to click on overwrite)
2. Enable the mod and enter threadid or forumid's for fetching the poll.
3. Run clear system cache under Maintenance



New Installation Instructions
=====================================
1. In the Product Manager in AdminCP, import the product XML file.
2. Open Settings -> Show Poll In Forum Sideblock
Enable the mod and enter threadid or forumid for fetching the poll.
3. Run clear system cache under Maintenance



Uninstalling:
=====================================
1. You can disable the mod from admincp OR Uninstall the product from the Product Manager in the AdminCP.



Mod History:

v1.0 : 08 Jul 2011 : First Release.
v2.0 : 10 Jul 2011 : With More Features And Integrated with Vbulletin Forum Sideblock Manager.
v2.1 : 28 Jul 2011 : Fix Table Prefix Issue and added multiple forums feature.


-> Click On Mark As Installed If You Have Installed This Mod.
-> You Can Nominate it also for Mod Of The Month.

[wildheart]

No, we are working to get it right, I really appreciate your help especially because I am still so much in the dark. Do you suggest I undo everything and try again?

[cherylferraro]

Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum 
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error   : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM
Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/
IP Address    : *
Username      : me
Classname     : vB_Database
MySQL Version : 5.1.56

[Badshah93]

Originally Posted by cherylferraro

Great mod thank you for sharing it. It works well with the thread id however when I try to use a forum id instead of the thread id loading the forum page generates the following error:

Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT forum.forumid as forumidd, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM vb_forum 
LEFT join vb_thread ON thread.forumid = forum.forumid where forum.forumid = 64 ORDER BY thread.pollid DESC LIMIT 1;

MySQL Error   : Unknown column 'forum.forumid' in 'field list'
Error Number  : 1054
Request Date  : Saturday, July 16th 2011 @ 11:23:12 AM
Error Date    : Saturday, July 16th 2011 @ 11:23:13 AM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/
IP Address    : 98.164.244.76
Username      : me
Classname     : vB_Database
MySQL Version : 5.1.56

try this xml

[AttalaEA]

Thank you so much

[AttalaEA]

How can I change poll title to anything else in the sideblock same vbulletin.

[Badshah93]

Originally Posted by AttalaEA

How can I change poll title to anything else in the sideblock same vbulletin.

Edit this phrase

sideblock_poll_title

[AttalaEA]

Originally Posted by Sherif

Edit this phrase

sideblock_poll_title

Thank You Sherif. This works great.

[Trek]

I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

[Badshah93]

Originally Posted by Trek

I'm having the same problem as the other person mentioned with the SQL error and using a ForumID. I tried your new XML, but the problem continues.

uninstall the product and delete all poll sideblock forum block manager. then install this new xml.

i tested this mod on a forum with table prefix, its working fine there hopefully it will be for u also.

[mjp1111]

Can I show a poll from multiple or all forums if I separate with a comma or do something else?