BB Code for Video

[Hummie]

I put this at vulletin dot com, but thought I'd try here too.
***
Before vbulletin added the standard bb code for "video," I had utilized the code "video" in a custom code to play windows media player videos in my forum. I teach with them and I have hundreds of threads with this code.

Now there is a conflict in my forum. I tried to edit my existing custom video bb code and it would not let me because there is this new video bb code.

I want to change the new bb code (that appears in the icon on the compose box) to a different named code (ie "vidoes") so they are different.

I don't want to change the custom bb code name because then I'd have to go through my forum and find hundreds and hundreds of threads and edit each post to get the video to work.

I cannot find where to change the built in codes in vbulletin.

***
I see there is a template for bbcode_video
....can I somehow add my code for my videos that are on my own hosting to that template?


My bb code is currently:
<embed src="http://www.mysite.com/folder/{param}" HEIGHT="480" WIDTH="720" ALIGN="center"AUTOSTART="false"/>


***
Found this thread. Is this what I need to do?

[ErnestA]

There are some dangers associated with this and since I've never been in this situation before, I can't say for sure what effect it would have.

But, if I was in this situation, I would consider doing a search and replace directly in the database table holding the threads. Obviously do an entire backup of your system before trying this.

If you're running MySQL here's how to do it:

http://www.mediacollege.com/computer...d-replace.html

I think the correct table in the vB database is 'post', and the field you're interested in is 'pagetext'. I'd run two queries:

update post set pagetext = replace(pagetext,'[VIDEO]','[CUSTOMVIDEO]');
update post set pagetext = replace(pagetext,'[/VIDEO]','[/CUSTOMVIDEO]');

replace CUSTOMVIDEO with whatever you want your new tag to be.

Like I said, backup, backup, backup (especially the database). I have no idea what effect this will have.

By default, MySQL should be case insensitive, but make sure just because you want one query to match [video] and [VIDEO] without having to worry about case sensitivity. You can find out more about that here:

http://dev.mysql.com/doc/refman/5.0/...nsitivity.html

Anyways, the information is provided AS-IS with no warranty or liability. Good luck.

[Hummie]

Thanks for your reply. Yes, a backup would be important before doing this suggestion.

It might be better to create a new database and then make the changes on it, then change the strings in the config files to the new one. That way if it doesn't work, I can always quickly reupload the original config pointing to the original database.

How do I do a search of mysql? In my hosting?

Thanks for your reply. I was beginning to think no one would answer.