vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Youtube BBcode no longer works, mass change? (https://vborg.vbsupport.ru/showthread.php?t=316488)

pjkcards 01-07-2015 05:09 PM

Youtube BBcode no longer works, mass change?
 
For many years our forum used the custom Youtube bbcode [youtube] to embed videos. With vB 4.2 now, the [video] tag is used, so now all old posts which used the [youtube] tag doesn't work. What is the best way to change this in bulk?

Thanks.

ozzy47 01-07-2015 09:48 PM

1) Close your site via the ACP.
2) Do a full site backup.
3) Run this query, change 'old name' and 'new name' as needed.

Code:

UPDATE post SET pagetext = REPLACE(pagetext, 'old name', 'new name')
So for example:

Opening tag:
Code:

UPDATE post SET pagetext = REPLACE(pagetext, '[TAG1]', '[TAG3]')
Closing tag.
Code:

UPDATE post SET pagetext = REPLACE(pagetext, '[/TAG1]', '[/TAG3]')
Remember this is case sensitive, so make sure you do it right.

Check out the site to make sure it is done right.

4) Reopen site via ACP if things are right, if not, restore your backup.

OUTL4W 01-07-2015 10:01 PM

Yes...Ozzy is correct as usual....but I believe if you also re-create the YouTube bb code....the old posts that have the [youtube] tags , the videos will show up again.

If in need of a new YouTube bb code:
https://vborg.vbsupport.ru/showthread.php?t=304938
:D
Plays yt HD version by default....[video] tags don't.

ozzy47 01-07-2015 10:03 PM

Yeah I am not sure about recreating the bbcode, as I am only going from memory here. I don't have any youtube videos embedded on my site, so I would have no way of replicating what the OP is experiencing.

MarkFL 01-08-2015 01:42 AM

I have put together a custom BBCode on my site for embedding youtube videos. What's different about this one is that if the user resizes their browser window, the video dynamically resizes, always maintaining a 10% border to the left and right and always maintaining an aspect ratio of 16:9. I have also wrapped the video player in a container.

Title: YouTube

BB Code Tag Name: youtube

Replacement:

HTML Code:

<br>
<div class="video_wrapper MHB_wrappers">
        <div class="MHB_wrapper_header mhb_gradient"></div>
        <div style="background-color:transparent">
                <div class="video-container">
                        <iframe src="http://www.youtube.com/embed/{param}?hd=1&vq=hd1080">
                        </iframe>
                </div>
        </div>
        <div class="MHB_wrapper_footer mhb_gradient"></div>
</div>
<br>

In your additional.css template, include the following:

Code:

.video-container
{
        position: relative;
        padding-bottom: 56.25%;
        padding-top: 30px; height: 0; overflow: hidden;
}
 
.video-container iframe,
.video-container object,
.video-container embed
{
        position: absolute;
        top: 0;
        left: 0;
        width: 100%;
        height: 100%;
}

.video_wrapper
{
        border: 1px solid #BBBBBB;
        -moz-border-radius: 10px;
        -webkit-border-radius: 10px;
        border-radius: 10px;
        margin-left: 10%;
        margin-right: 10%;
}

.MHB_wrappers
{
        box-shadow: 2px 2px 3px rgba(20,74,98,0.5);
}

.MHB_wrapper_header
{
        -moz-border-radius: 10px 10px 0px 0px;
        -webkit-border-radius: 10px 10px 0px 0px;
        border-radius: 10px 10px 0px 0px;
        padding-top: 15px;
}

.MHB_wrapper_footer
{
        -moz-border-radius: 0px 0px 10px 10px;
        -webkit-border-radius: 0px 0px 10px 10px;
        border-radius: 0px 0px 10px 10px;
        padding-bottom: 15px;
}

.mhb_gradient
{
        background: #207498; /* Old browsers */
        background: -moz-linear-gradient(top, #2891be 0%, #103a4c 100%); /* FF3.6+ */
        background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#2891be), color-stop(100%,#103a4c)); /* Chrome,Safari4+ */
        background: -webkit-linear-gradient(top, #2891be 0%,#103a4c 100%); /* Chrome10+,Safari5.1+ */
        background: -o-linear-gradient(top, #2891be 0%,#103a4c 100%); /* Opera 11.10+ */
        background: -ms-linear-gradient(top, #2891be 0%,#103a4c 100%); /* IE10+ */
        background: linear-gradient(to bottom, #2891be 0%,#103a4c 100%); /* W3C */
        filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#2891be', endColorstr='#103a4c',GradientType=0 ); /* IE6-9 */
}


pjkcards 01-08-2015 05:37 PM

Thanks guys. Before I try ozzy's idea, I tried re-creating the BBcode. However, it just shows up as a big blank space, and the video doesn't load (just as before). I deleted the BBcode and created a new one with the same result. Any idea why this is?

MarkFL: looks nice, but I get the same result - a big blank space in the post, with no video loading. Are you using this in vB 4.2?

Any further ideas would be greatly appreciated. Ideally I want to make use of the youtube tag as opposed to doing a mass db replacement. Thanks.

kh99 01-08-2015 05:42 PM

Did you try writing a new post as the test? It could be that caching is stopping you from seeing the changes.

kh99 01-08-2015 05:50 PM

Also, I believe the youtube tag took just the code as the parameter. Does the video tag work the same way (maybe it does, I'm not familiar with it)? If not then you probably don't want to do a replace.

pjkcards 01-09-2015 02:08 AM

Quote:

Originally Posted by kh99 (Post 2531301)
Did you try writing a new post as the test? It could be that caching is stopping you from seeing the changes.

Yes, I did, with no luck. No idea why it isn't working, or why the old youtube tag stopped working.

Quote:

Originally Posted by kh99 (Post 2531303)
Also, I believe the youtube tag took just the code as the parameter. Does the video tag work the same way (maybe it does, I'm not familiar with it)? If not then you probably don't want to do a replace.

The video tag is slightly different, and uses options. But there must be a way to do the replace which fixes that. Ideally though, I'd like to just fix the youtube tags.

Any other ideas? Thanks in advance!

MarkFL 01-09-2015 03:38 AM

Quote:

Originally Posted by pjkcards (Post 2531298)
...MarkFL: looks nice, but I get the same result - a big blank space in the post, with no video loading. Are you using this in vB 4.2?

Yes, it works for me in 3 different varieties of vB 4.2.x. Try posting a new video and let me know if you still get a blank space. :D


All times are GMT. The time now is 03:11 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01010 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (1)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete