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.

[Paul.]

Is it possible for more than one poll to be displayed in the side block, or in other separate blocks?

4.2.2

[MaLTRaiN]

Originally Posted by Paul.

Is it possible for more than one poll to be displayed in the side block, or in other separate blocks?

4.2.2

I need the same option!!!

:up:

[Bob_R]

Can anyone help with this alignment issue? (see screenshot)

Thanks.

[Bob_R]

Originally Posted by thang28101993

I installed Mod and it is working well, but I have a small issue with template before vote, as this image:



And after Vote thread, that issue not appear:



So how I can make for the poll before vote is not wrong and clear as after vote:

Excuse me, I'm a new fan of Vbb, and I have to learn more! So, please help me to solve that problem! Thanks in advanced.

I use Vbb 4.2.0 Pl3

Originally Posted by Bob_R

Can anyone help with this alignment issue? (see screenshot)

Thanks.

Post #164 the one right above this one????

[Morrus]

Originally Posted by Impromptu

Using 4.2.

Been using it for a while and it works for a selected forumid in my case it's id4. The reason is because it's my website I initially had polls only for my threads. However, over the last 6 months, I've noticed that other members are creating posts with legitimate polls thus I've decided to show the poll results on forumid2...unfortunately it goes blank when I show forumid2 and yes there are a lot of polls in forumid2..

strangely when I have 2,4 (ie comma) it shows a blank...like edytwinky..any issue? in the worst case scenario ill just show poll results from my threads (forumid4) but would love it to show forumid2 (ie general members)

thanks

Same problem. I see you asked this back in June 2013, and it's April 2014 now, I assume that's not getting fixed.

[GPOClan]

I want the sideblock to be only visible to members, what do I have to do?
Thanks for your help.

Best regards,
Fields

[Bob_R]

Is there an answer in our future?

thang28101993, Impromptu, and Morrus needs answers as well!!!!

[M.C.]

nope... not working even if I put one forum ID works only with thread IDs

[fxdigi-cash]

ok, spent few minutes on this and just noticed that the PHP code in the mod doesn't get filled up when installed to the vb board. when you go to your sideblock in the forum blocks manager, you can edit the poll block and find no PHP code; it is empty. That's why it won't work. I grabed the code from the xml file so anyone can use it. place it in the PHP code area in the sideblock for poll and save it. it works fine.

PHP Code:

global $vbulletin, $vbphrase, $db;
if ($vbulletin->options['poll_on_sideblock_vb4']) {

if (!empty($vbulletin->options['poll_on_sideblock_vb4_thread'])) {
$getthread = $db->query_first("SELECT threadid, pollid, forumid, open, lastpost FROM ".TABLE_PREFIX."thread where threadid = ".$vbulletin->options['poll_on_sideblock_vb4_thread']."");

}

elseif (!empty($vbulletin->options['poll_on_sideblock_vb4_forum']))  {

$getthread = $db->query_first("SELECT forum.forumid, thread.threadid, thread.pollid, thread.forumid, thread.open, thread.lastpost FROM ".TABLE_PREFIX."forum as forum
LEFT join ".TABLE_PREFIX."thread as thread ON thread.forumid = forum.forumid where forum.forumid IN (".$vbulletin->options['poll_on_sideblock_vb4_forum'].") ORDER BY thread.pollid DESC LIMIT 1");

}


$poll = '';
if ($getthread['pollid'])
{
    $pollbits = '';
    $counter = 1;
    $pollid = $getthread['pollid'];

    $show['editpoll'] = iif(can_moderate($getthread['forumid'], 'caneditpoll'), true, false);

    // get poll info
    $pollinfo = $db->query_first_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "poll
        WHERE pollid = $pollid
    ");

    require_once(DIR . '/includes/class_bbcode.php');
    $bbcode_parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());

    $pollinfo['question'] = $bbcode_parser->parse(unhtmlspecialchars($pollinfo['question']), $getthread['forumid'], true);

    $splitoptions = explode('|||', $pollinfo['options']);
    $splitoptions = array_map('rtrim', $splitoptions);

    $splitvotes = explode('|||', $pollinfo['votes']);

    $showresults = 0;
    $uservoted = 0;
    $forumperms = fetch_permissions($getthread['forumid']);
    if (!($forumperms & $vbulletin->bf_ugp_forumpermissions['canvote']))
    {
        $nopermission = 1;
    }

    if (!$pollinfo['active'] OR !$getthread['open'] OR ($pollinfo['dateline'] + ($pollinfo['timeout'] * 86400) < TIMENOW AND $pollinfo['timeout'] != 0) OR $nopermission)
    {
        //thread/poll is closed, ie show results no matter what
        $showresults = 1;
    }
    else
    {
        //get userid, check if user already voted
        $voted = intval(fetch_bbarray_cookie('poll_voted', $pollid));
        if ($voted)
        {
            $uservoted = 1;
        }
    }


    if ($pollinfo['timeout'] AND !$showresults)
    {
        $pollendtime = vbdate($vbulletin->options['timeformat'], $pollinfo['dateline'] + ($pollinfo['timeout'] * 86400));
        $pollenddate = vbdate($vbulletin->options['dateformat'], $pollinfo['dateline'] + ($pollinfo['timeout'] * 86400));
        $show['pollenddate'] = true;
    }
    else
    {
        $show['pollenddate'] = false;
    }

    foreach ($splitvotes AS $index => $value)
    {
        $pollinfo['numbervotes'] += $value;
    }

    if ($vbulletin->userinfo['userid'] > 0)
    {
        $pollvotes = $db->query_read_slave("
            SELECT voteoption
            FROM " . TABLE_PREFIX . "pollvote
            WHERE userid = " . $vbulletin->userinfo['userid'] . " AND pollid = $pollid
        ");
        if ($db->num_rows($pollvotes) > 0)
        {
            $uservoted = 1;
        }
    }

    if ($showresults OR $uservoted)
    {
        if ($uservoted)
        {
            $uservote = array();
            while ($pollvote = $db->fetch_array($pollvotes))
            {
                $uservote["$pollvote[voteoption]"] = 1;
            }
        }
    }

    $left = vB_Template_Runtime::fetchStyleVar('left');
    $right = vB_Template_Runtime::fetchStyleVar('right');
    $option['open'] = $left[0];
    $option['close'] = $right[0];

    foreach ($splitvotes AS $index => $value)
    {
        $arrayindex = $index + 1;
        $option['uservote'] = iif($uservote["$arrayindex"], true, false);
        $option['question'] = $bbcode_parser->parse($splitoptions["$index"], $getthread['forumid'], true);

        // public link
        if ($pollinfo['public'] AND $value)
        {
            $option['votes'] = '<a href="' . fetch_seo_url('poll', $pollinfo, array('do' => 'showresults')) . 
                '">' . vb_number_format($value) . '</a>';
        }
        else
        {
            $option['votes'] = vb_number_format($value);   //get the vote count for the option
        }

        $option['number'] = $counter;  //number of the option

        //Now we check if the user has voted or not
        if ($showresults OR $uservoted)
        { // user did vote or poll is closed

            if ($value <= 0)
            {
                $option['percentraw'] = 0;
            }
            else if ($pollinfo['multiple'])
            {
                $option['percentraw'] = ($value < $pollinfo['voters']) ? $value / $pollinfo['voters'] * 100 : 100;
            }
            else
            {
                $option['percentraw'] = ($value < $pollinfo['numbervotes']) ? $value / $pollinfo['numbervotes'] * 100 : 100;
            }
            $option['percent'] = vb_number_format($option['percentraw'], 2);

            $option['graphicnumber'] = $option['number'] % 6 + 1;
            $option['barnumber'] = round($option['percent']) * 2;
            $option['remainder'] = 201 - $option['barnumber'];

            // Phrase parts below
            if ($nopermission)
            {
                $pollstatus = $vbphrase['you_may_not_vote_on_this_poll'];
            }
            else if ($showresults)
            {
                $pollstatus = $vbphrase['this_poll_is_closed'];
            }
            else if ($uservoted)
            {
                $pollstatus = $vbphrase['you_have_already_voted_on_this_poll'];
            }


            $templater = vB_Template::create('sideblock_pollresult');
                $templater->register('names', $names);
                $templater->register('option', $option);
            $pollbits .= $templater->render();
        }
        else
        {

            if ($pollinfo['multiple'])
            {
                $templater = vB_Template::create('sideblock_polloption_multiple');
                    $templater->register('option', $option);
                $pollbits .= $templater->render();
            }
            else
            {
                $templater = vB_Template::create('sideblock_polloption');
                    $templater->register('option', $option);
                $pollbits .= $templater->render();
            }
        }
        $counter++;
    }

    if ($pollinfo['multiple'])
    {
        $pollinfo['numbervotes'] = $pollinfo['voters'];
        $show['multiple'] = true;
    }

    if ($pollinfo['public'])
    {
        $show['publicwarning'] = true;
    }
    else
    {
        $show['publicwarning'] = false;
    }

    $displayed_dateline = $getthread['lastpost'];
    $pollinfo['threadid'] = $getthread['threadid'];

    if ($showresults OR $uservoted)
    {
        $templater = vB_Template::create('sideblock_pollresults_table');
            $templater->register('pollbits', $pollbits);
            $templater->register('pollenddate', $pollenddate);
            $templater->register('pollendtime', $pollendtime);
                        $templater->register('pollinfo', $pollinfo);
                        $templater->register('show', $show);
            $templater->register('pollstatus', $pollstatus);
        $poll = $templater->render();
    }
    else
    {
        $templater = vB_Template::create('sideblock_polloptions_table');
            $templater->register('pollbits', $pollbits);
            $templater->register('pollenddate', $pollenddate);
            $templater->register('pollendtime', $pollendtime);
                        $templater->register('show', $show);
            $templater->register('pollinfo', $pollinfo);
        $poll = $templater->render();
    }
    
return $poll;

}
}
else {
} 


[Mohammad Kamal]

How can I show more than one poll?