I’m looking to find a quick solution to the following problem.
I used to manually place embed code for my videos in my database, but now I place the video url and sponsor url separately to provide more flexibility. I have thousands of entries so I don’t have time to go through manually. I have always placed the full path of the .flv file. So I need a script to do the following:
Locate any link ending with flv such as http://sampledomain.com/flv/video1.flv, and place that value in the video_url column. If it cannot find an flv it will place a default value.
I also need it to locate any link that is not a picture (jpg, png etc) or flv and place that value in the sponsor_url column. If it cannot find any link it will place a default value.
I hope this makes sense. Please feel free to ask any and all questions before bidding.
