-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Erstellungszeit: 24. Mai 2013 um 00:10
-- Server Version: 5.1.66-0+squeeze1
-- PHP-Version: 5.3.10

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `wcf2`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wcf1_bbcode_media_provider`
--

CREATE TABLE IF NOT EXISTS `wcf1_bbcode_media_provider` (
  `providerID` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `regex` text COLLATE utf8_unicode_ci NOT NULL,
  `html` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`providerID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=19 ;

--
-- Daten für Tabelle `wcf1_bbcode_media_provider`
--

INSERT INTO `wcf1_bbcode_media_provider` (`providerID`, `title`, `regex`, `html`) VALUES
(1, 'YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/watch\\?(?:.*?&)?v=)(?<ID>[a-zA-Z0-9_-]+)(?<start>#t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?', '<iframe width="560" height="315" src="https://www.youtube-nocookie.com/embed/{$ID}?wmode=transparent{$start}" frameborder="0" allowfullscreen></iframe>'),
(2, 'Vimeo', 'http://vimeo\\.com/(?<ID>\\d+)', '<iframe src="http://player.vimeo.com/video/{$ID}" width="400" height="225" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>'),
(3, 'MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?<ID>\\d+)', '<object style="width:611px;height:383px;" width="611" height="383"><embed src="http://www.myvideo.de/movie/{$ID}" width="611" height="383" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true"></embed><param name="movie" value="http://www.myvideo.de/movie/{$ID}"></param><param name="AllowFullscreen" value="true"></param><param name="AllowScriptAccess" value="always"></param></object>'),
(4, 'Clipfish', 'http://(?:www\\.)?clipfish\\.de/video/(?<ID>\\d+)/\r\nhttp://(?:www\\.)?clipfish.de/embed_video/?vid=(?<ID>\\d+)', '<div style="width:464px; height:404px;"><div style="width:464px; height:384px;"><iframe src="http://www.clipfish.de/embed_video/?vid={$ID}&amp;as=0&amp;col=990000" name="Clipfish Embedded Video" width="464" height="384" align="left" marginheight="0" marginwidth="0" frameborder="0" scrolling="no"></iframe></div></div>'),
(5, 'Veoh', 'http://(?:www\\.)?veoh\\.com/watch/v(?<ID>\\d+[a-zA-Z0-9]+)', '<object width="410" height="341" id="veohFlashPlayer" name="veohFlashPlayer"><param name="movie" value="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&amp;permalinkId=v{$ID}&amp;player=videodetailsembedded&amp;videoAutoPlay=0&amp;id=anonymous"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&amp;permalinkId=v{$ID}&amp;player=videodetailsembedded&amp;videoAutoPlay=0&amp;id=anonymous" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="410" height="341" id="veohFlashPlayerEmbed" name="veohFlashPlayerEmbed"></embed></object>'),
(6, 'DailyMotion', 'https?://(?:www\\.)?dailymotion\\.com/video/(?<ID>[a-zA-Z0-9]+)', '<iframe frameborder="0" width="480" height="208" src="https://www.dailymotion.com/embed/video/{$ID}"></iframe>'),
(7, 'YouKu', 'https?://(?:.+?\\.)?youku\\.com/v_show/id_(?<ID>[a-zA-Z0-9_-]+)(?:\\.html)?', '<iframe height=498 width=510 src="http://player.youku.com/embed/{$ID}" frameborder="0" allowfullscreen></iframe>'),
(8, 'github gist', 'https://gist.github.com/(?<ID>[^/]+/[0-9a-zA-Z]+)', '<script src="https://gist.github.com/{$ID}.js"> </script>'),
(9, 'Soundcloud', 'https?://soundcloud.com/(?<artist>[a-zA-Z0-9_-]+)/(?<song>[a-zA-Z0-9_-]+)', '<iframe width="100%" height="166" scrolling="no" frameborder="no" src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fsoundcloud.com%2F{$artist}%2F{$song}"></iframe>'),
(10, 'Facebook', 'https?://www.facebook.com/photo.php\\?v=(?<ID>\\d+)\r\nhttps?://www.facebook.com/video/video.php?v=(?<ID>\\d+)\r\nhttps?://www.facebook.com/video/embed?video_id=(?<ID>\\d+)', '<iframe src="https://www.facebook.com/video/embed?video_id={$ID}" width="560" height="315" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>'),
(11, 'TwitchTV', 'http://www.twitch.tv/(?<CHANNEL>[a-zA-Z0-9]+)/c/(?<ID>\\d+)', '<object bgcolor=''#000000'' data=''http://www.twitch.tv/widgets/archive_embed_player.swf'' height=''378'' type=''application/x-shockwave-flash'' width=''620''>\r\n<param name=''movie'' value=''http://www.twitch.tv/widgets/archive_embed_player.swf'' />\r\n<param name=''allowScriptAccess'' value=''always'' />\r\n<param name=''allowNetworking'' value=''all'' />\r\n<param name=''allowFullScreen'' value=''true'' />\r\n<param name=''flashvars'' value=''chapter_id={$ID}&title=&auto_play=false&channel={$CHANNEL}&start_volume=25'' />\r\n</object>'),
(12, 'Justin.tv', 'http://www.justin.tv/(?<CHANNEL>[a-zA-Z0-9]+)/b/(?<ID>\\d+)', '<object type="application/x-shockwave-flash" height="300" width="400" data="http://www-cdn.justin.tv/widgets/archive_embed_player.swf" bgcolor="#000000">\r\n<param name="movie" value="http://www-cdn.justin.tv/widgets/archive_embed_player.swf" />\r\n<param name="allowScriptAccess" value="always" />\r\n<param name="allowNetworking" value="all" />\r\n<param name="allowFullScreen" value="true" />\r\n<param name="flashvars" value="auto_play=false&start_volume=25&title=&channel={$CHANNEL}&archive_id={$ID}" />\r\n</object>'),
(13, 'Ustream', 'http://www.ustream.tv/(?:embed/)?recorded/(?<ID>\\d+)', '<iframe width="480" height="392" src="http://www.ustream.tv/embed/recorded/{$ID}?v=3&amp;wmode=direct" scrolling="no" frameborder="0" style="border: 0px none transparent;"></iframe>'),
(14, 'Collegehumor', 'http://www.collegehumor.com/(video|e)/(?<ID>\\d+)', '<iframe src="http://www.collegehumor.com/e/{$ID}" width="600" height="369" frameborder="0" webkitAllowFullScreen allowFullScreen></iframe>'),
(15, 'Myspace', 'https?://www.myspace.com/video/[a-zA-Z0-9-]+/[a-zA-Z0-9-]+/(?<ID>\\d+)\r\nhttps?://www.myspace.com/video/vid/(?<ID>\\d+)\r\nhttps?://www.myspace.com/[a-zA-Z0-9-]+/videos/video/(?<ID>\\d+)', '<object width="425px" height="360px" >\r\n<param name="allowScriptAccess" value="always"/>\r\n<param name="allowFullScreen" value="true"/>\r\n<param name="wmode" value="transparent"/>\r\n<param name="movie" value="http://mediaservices.myspace.com/services/media/embed.aspx/m={$ID},t=1,mt=video"/>\r\n<embed src="http://mediaservices.myspace.com/services/media/embed.aspx/m={$ID},t=1,mt=video" width="425" height="360" allowFullScreen="true" type="application/x-shockwave-flash" wmode="transparent" allowScriptAccess="always"></embed>\r\n</object>'),
(16, 'Metacafe', 'http://www.metacafe.com/(embed|w(atch)?)/(?<ID>\\d+)', '<iframe src="http://www.metacafe.com/embed/{$ID}/" width="440" height="248" allowFullScreen frameborder=0></iframe>'),
(17, 'JibJab', 'http://www.jibjab.com/view/(?<ID>[0-9a-zA-Z]+)', '<object quality=''high'' data=''http://aka.zero.jibjab.com/client/zero/ClientZero_EmbedViewer.swf?external_make_id={$ID}'' pluginspage=''http://www.macromedia.com/go/getflashplayer'' type=''application/x-shockwave-flash'' wmode=''transparent'' height=''319'' width=''425''>\r\n<param name=''wmode'' value=''transparent''></param>\r\n<param name=''movie'' value=''http://aka.zero.jibjab.com/client/zero/ClientZero_EmbedViewer.swf?external_make_id={$ID}''></param>\r\n<param name=''scaleMode'' value=''showAll''></param>\r\n<param name=''quality'' value=''high''></param>\r\n<param name=''allowNetworking'' value=''all''></param>\r\n<param name=''allowFullScreen'' value=''true'' />\r\n<param name=''FlashVars'' value=''cornerRadius=10&external_make_id={$ID}''></param>\r\n<param name=''allowScriptAccess'' value=''always''></param>\r\n</object>'),
(18, 'Ted', 'http://www.ted.com/talks/(?:lang/[a-zA-Z]+/)?(?<ID>[0-9a-zA-Z-_]+).html', '<iframe src="http://embed.ted.com/talks/{$ID}.html" width="560" height="315" frameborder="0" scrolling="no" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;