Left or Right Polls Block

[Alfr3d]

Hi @ all.
I'm using: You are currently running vBadvanced CMPS v4.0.0.
How Do I a polls block?

[Alfr3d]

Anyone??

[Alfr3d]

I'm solving in a part.
I create a PHP File Module, then in file to include choose : currentpoll.php.
After create, I found a mysql problem in index:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT poll.*, thread.pollid, thread.title AS threadtitle, open, threadid, replycount, forumid , voteoption
FROM poll AS poll
INNER JOIN thread AS thread USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 100452)
WHERE open <> 10 AND visible = 1
AND active = 1
ORDER BY;

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 '' at line 7
Error Number : 1064
Request Date : Thursday, August 2nd 2012 @ 03:45:56 PM
Error Date : Thursday, August 2nd 2012 @ 03:45:56 PM

[Brian]

There's no need to create a new module. Just go to Admin CP => vBa CMPS => Edit Modules => Current Poll and update the settings at the bottom of that page to select a forum to pull your polls from and such.