Video Widget

[reddyink]

Is it possible to create a widget that will find and play the most recently uploaded video or a selected uploaded video??

I would like to play, on my cms page, the latest video uploaded to my forums similar to YouTube video widget.

Can someone provide me with the php that I can use in a PHP Direct Execution widget for this?

Create the widget:
AdminCP > vBulletin CMS > Widgets > Create New Widget
Widget Type: PHP Direct Execution Widget
Title: Video-uploaded
SAVE

Now, find your widget in the list and click on Configure Next to it and enter valid PHP into the text area there.

Using a query: NEED HELP HERE
PHP Code:

$myquery = vB::$db->query_first("
SELECT
post.threadid, thread.title
FROM " . TABLE_PREFIX . "post AS post
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
WHERE post.userid = ".vB::$vbulletin->userinfo['userid']. "
ORDER BY post.dateline DESC
");
$threadurl = '<a href="' . fetch_seo_url(thread, $myquery) . '" title="'. $myquery[title] .'">'. $myquery[title] .'</a>';
$output .= "<br />" . $threadurl;

[Mooff]

tbh a database query to display the latest youtube video someone posted in a thread or a post would be horribly ugly.
You would need to go through ALL posts, take out the pagetext and search through it in order to find a youtube url.

I would advise you to search through articles instead. This query would be a lot easier since articles already have a column 'preview_object' or something, which is either empty or has a video in it.


And what you are looking for is probably not help in coding it, but someone who does code that modification, which would be a request best suited here:
https://vborg.vbsupport.ru/forumdisplay.php?f=112


That aside, i have seen modifikations around which provide 'youtube video databases' where users can link their youtube content. This would also have 'most recent videos' and 'most popular videos'.