• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

Replace Help

I'm trying to build a query for mysql that I can execute from phpmyadmin that will replace the following:

Video Description

to

[media]http:domain.com/video/video.flv[/media]

the length of the domain could change and the file format could change also, so I'm not sure how to do this.  Any suggestions?

The reason I'm doing this is I just recently moved to IPB and my old embed codes will not work on it.  I was using Avea Media on SMF forums to embed my links, but no mod for this on IPB just BBCodes.
0
Nathan Riley
Asked:
Nathan Riley
1 Solution
 
Jagadishwor DulalBraces MediaCommented:
You can add the domain name in a variable like
$domname="http://www.domain.com/";
and when you fetch your record of meida file concatenate your domain and video location like:
$video=$row['medialocation'];
echo $domname.$video;//for video file full path
0
 
Nathan RileyFounder/CTOAuthor Commented:
I need to update the records within the post table within mysql.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now