vBulletin CMS Widgets - Media Library CMS Sidebar

Media Library CMS Sidebar

Released 06-06-2010
By Vikas - http://www.ngcoders.com
For Plugin - https://vborg.vbsupport.ru/showthread.php?t=240677 (8WayRun.Com - Media Library)
For Demo - http://www.roboticsindia.com/ ( Left Sidebar )

Installation

• Goto Admincp->vBullietin CMS->Widgets->Create New Widget
• Choose PHP Direct Execution as Widget's Type
• Place a Title. eg Latest Videos. Keep it short as this is what will appear as title on your pages.
• Click Save
• Click Configure on the right of the new created widget.
• Remove the default code that appears. Be sure to not leave behind even a single letter.
• Copy and Paste the code that you can find below.
• Leave the template name as is (vbcms_widget_execphp_page)
• Click Save
• Goto Admincp->vBullietin CMS->Layout Manager
• Click Go on the Default Layout
• Add the Widget to your Layout
• Click Save
• That's all !!

PHP Code

PHP Code:

 
global $vbulletin;
require_once(DIR.'/media/media_functions_hrefs.php');

//  %d
$show_count = 5; 

$medias = $vbulletin->db->query_read("
    SELECT media.*, media_service.*
    FROM " . TABLE_PREFIX . "media AS media
    LEFT JOIN " . TABLE_PREFIX . "media_service AS media_service ON(media_service.serviceID = media.serviceID)
    ORDER BY media.dateline DESC
    LIMIT ".$show_count);


$output = '
  <style type="text/css">
    .thumbnail img{
      width: 90px;
      height: 70px;
      border: 1px solid #ccc;
      padding: 5px;
      margin: 5px;
      float: left;
    }
    
    .video_bit {
      min-height: 90px;
    }
  
  </style>
                                                           
';

while ($media = $vbulletin->db->fetch_array($medias))
{

    $media['thumbnail'] = $vbulletin->options['media_thumb_dir']."/thumbs/". $media['mediaID'] .".jpg";
    $media['href'] = construct_href_details($media);

    extract($media);
    
    $title = substr($title,0,60);
    
    $mediabits .= sprintf('<div class="cms_widget_post_bit video_bit"><div class="thumbnail"><a href="%s"><img src="%s"></a></div><div class="cms_widget_post_header"><a href="%s">%s</a></div><div class="cms_widget_post_userinfo"><a href="member.php/u=%d">%s</a> On %s</div></div>',$href,$thumbnail,$href,$title,$userid,$username,date('F j, Y, g:i a',$dateline));
}



$output .= $mediabits; 


[Xencored]

Hey mate i think its best if you change the title to CMS sidebar
Jaxel added a forums sidebar one in his mods page (just not a CMS one) i think it will be easyer for people to find
Good Work too :up::up:

[rotor]

Been waiting for this..... thx much appreciated :up:

[ngcoders]

Changed to CMS side bar.

[schlottkej]

Where is the Forums Sidebar version in his thread?

[schlottkej]

Wow.. I found it... Ill repost

# NEW FEATURE: Widget support for both the ForumHome Sidebar and the vbCMS.

This has been updated since the previous versions, so please update your codes.

Sidebar Block:
Code:

PHP Code:

global $vbulletin;
    require_once(DIR.'/media/media_functions_hrefs.php');

    $medias = $vbulletin->db->query_read("
        SELECT media.*, media_service.*
        FROM " . TABLE_PREFIX . "media AS media
        LEFT JOIN " . TABLE_PREFIX . "media_service AS media_service ON(media_service.serviceID = media.serviceID)
        ORDER BY media.dateline DESC
        LIMIT 3
    ");

    while ($media = $vbulletin->db->fetch_array($medias))
    {
        if ($media['length'] == 0)
        {
            $media['length'] = "???";
        }
        else
        {
            $duration = $media['length'];
            $minutes = floor($duration / 60);
            $seconds = $duration % 60;
            $seconds = str_pad($seconds, 2, "0", STR_PAD_LEFT); 
            $media['length'] = "$minutes:$seconds";
        }

        $media['intrate'] = intval($media['rating']);
        $media['thumbnail'] = $vbulletin->options['media_thumb_dir']."/thumbs/". $media['mediaID'] .".jpg";
        $media['href'] = construct_href_details($media);

        $templater = vB_Template::create('8WR_media_WIDGET');
            $templater->register('media', $media);
        $mediabits .= $templater->render();
    }

    return $mediabits; 


CMS Widget:
Code:

PHP Code:

 require_once(DIR.'/media/media_functions_hrefs.php');

    $medias = vB::$vbulletin->db->query_read("
        SELECT media.*, media_service.*
        FROM " . TABLE_PREFIX . "media AS media
        LEFT JOIN " . TABLE_PREFIX . "media_service AS media_service ON(media_service.serviceID = media.serviceID)
        ORDER BY media.dateline DESC
        LIMIT 3
    ");

    while ($media = vB::$vbulletin->db->fetch_array($medias))
    {
        if ($media['length'] == 0)
        {
            $media['length'] = "???";
        }
        else
        {
            $duration = $media['length'];
            $minutes = floor($duration / 60);
            $seconds = $duration % 60;
            $seconds = str_pad($seconds, 2, "0", STR_PAD_LEFT); 
            $media['length'] = "$minutes:$seconds";
        }

        $media['intrate'] = intval($media['rating']);
        $media['thumbnail'] = vB::$vbulletin->options['media_thumb_dir']."/thumbs/". $media['mediaID'] .".jpg";
        $media['href'] = construct_href_details($media);

        $templater = vB_Template::create('8WR_media_WIDGET');
            $templater->register('media', $media);
        $mediabits .= $templater->render();
    }

    $output = $mediabits;

# BUG FIX: Fixed formatting buttons on quick reply for comments.
# BUG FIX: Fixed MySQLi errors for those who happen to be using it.
# BUG FIX: Fixed service constructs for non-SEO slugged links.
# BUG FIX: Fixed RSS feeds for tags in table prefix settings. 


[nomoreturn]

Installed but didnt got the thumbnil of videos

[akxt660]

Have a way to add the userinfo bellow off any midia?

[Reef Man]

do you know how I can configure this on a vbadvanced block?

[LouisB]

Sidebar block works great. Thanks.