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.

[Badshah93]

Originally Posted by mjp1111

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

no.. i have not integrated that feature yet but will be doing later tonight. (as i got many request for it)

[wildheart]

All my edit problems has been sorted and I reinstalled this mod! Works perfectly and I love the look of it.:up:

Thanks for your help.

Here is an example of what it looks like: http://reptile-parrots.com/forums/

[Dennis Kaczor]

Been looking for something like this and installed OK.

My only problem is I have a dark skin and the tittle text is very dark looking, where can I edit that to make it lighter to read... Anyone point me in the right direction on this, and thanks in advance.

Dennis

[cherylferraro]

Originally Posted by Sherif

try this xml

Thank you for the suggestion. I installed the xml file you provided but unfortunately when I switch the selection from thread id to forum id it generates this 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  : Tuesday, July 19th 2011 @ 01:02:13 PM
Error Date    : Tuesday, July 19th 2011 @ 01:02:14 PM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/index.php
IP Address    : *
Username      : me
Classname     : vB_Database
MySQL Version : 5.1.56

[Badshah93]

Originally Posted by cherylferraro

Thank you for the suggestion. I installed the xml file you provided but unfortunately when I switch the selection from thread id to forum id it generates this 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  : Tuesday, July 19th 2011 @ 01:02:13 PM
Error Date    : Tuesday, July 19th 2011 @ 01:02:14 PM
Script        : http://www.mysite.com/forum/
Referrer      : http://www.mysite.com/forum/index.php
IP Address    : *
Username      : me
Classname     : vB_Database
MySQL Version : 5.1.56

please see this post

https://vborg.vbsupport.ru/showpost.php?p=2222317&postcount=49

Originally Posted by Dennis Kaczor

Been looking for something like this and installed OK.

My only problem is I have a dark skin and the tittle text is very dark looking, where can I edit that to make it lighter to read... Anyone point me in the right direction on this, and thanks in advance.

Dennis

GO to edit templates -> Block Templates -> block_sideblock template

in that you can change the color by editing css.

[Dennis Kaczor]

GO to edit templates -> Block Templates -> block_sideblock template

in that you can change the color by editing css.[/QUOTE]

I seen this in your code, but did not know where to find it, and thanks worked like a charm

[VBUsers]

nothing is showing up for me

[Badshah93]

Originally Posted by VBUsers

nothing is showing up for me

Please read all the pages of this thread, i am sure you will find your answer.

[netzwart]

This sounds like a cool MOD. I have two questions:

1. Is it possible to let the MOD choose the polls randomly ? In other words, the polls shown in the sidebar should change regularly without the need to define which poll should be shown in the admincp.

2. Is this MOD working with vB 4.0.8 ?

Thank you

Netzwart

[Badshah93]

Version 2.1 Added.

New Feature -> user can enter multiple forumid's to fetch latest poll.