XF 1.2 how to restore original video bbcodes

[electrogypsy]

so i noticed that my video links were no longer embedding, just showing a blank spot where the video should be. i was using this plugin before upgrading to 1.2:

http://xenforo.com/community/resources/xxms-bbcode-mediasites-package.27/

and i think it was screwing up my videos somehow, so i deleted the plugin and all the video bbcodes it entered, including the ones for youtube, etc.

my question is, how do i restore the original video embed bbcodes that came with xenforo? thanks!

 

[Jeremy]

You will most likely have to copy and paste them from a new installation or run the following query:

    INSERT INTO xf_bb_code_media_site
        (media_site_id, site_title, site_url, match_urls, embed_html, match_is_regex)
    VALUES
        ('facebook', 'Facebook', 'http://www.facebook.com', 'facebook.com/*video.php?v={$id:digits}\nfacebook.com/*photo.php?v={\$id:digits}', '<iframe src="https://www.facebook.com/video/embed?video_id={$id}" width="500" height="300" frameborder="0"></iframe>', 0),
        ('vimeo', 'Vimeo', 'http://www.vimeo.com', 'vimeo.com/{$id:digits}\nvimeo.com/groups/*/videos/{$id:digits}', '<iframe src="http://player.vimeo.com/video/{$id}" width="500" height="300" frameborder="0"></iframe>', 0),
        ('youtube', 'YouTube', 'http://www.youtube.com', 'youtube.com/watch?v={$id}\nyoutube.com/v/{$id}\nyoutu.be/{$id}\nyoutube.com/*/u/*/{$id}\nyoutube.com/watch?feature=player_embedded&v={$id}', '<iframe width="500" height="300" src="http://www.youtube.com/embed/{$id}?wmode=opaque" frameborder="0" allowfullscreen></iframe>', 0),
        ('metacafe', 'Metacafe', 'http://www.metacafe.com', '#metacafe\\\\.com/watch/(?P<id>\\\\d+)/#siU', '<iframe src="http://www.metacafe.com/embed/{$id:digits}/" width="500" height="300" allowFullScreen frameborder=0></iframe>', 1),
        ('dailymotion', 'Dailymotion', 'http://www.dailymotion.com', 'dailymotion.com/video/{$id:alphanum}', '<iframe frameborder="0" width="500" height="300" src="http://www.dailymotion.com/embed/video/{$id}?width=500&hideInfos=1"></iframe>', 0),
        ('liveleak', 'Liveleak', 'http://www.liveleak.com', 'liveleak.com/view?i={$id}', '<iframe width="500" height="300" src="http://www.liveleak.com/ll_embed?i={$id}" frameborder="0" allowfullscreen></iframe>', 0)

 

[electrogypsy]

thanks for the sql, that worked perfectly. unfortunately none of my youtube videos are showing up still. looks like i'll have to create a seperate thread for that.