older vshare site upgraded to last version, how convert all videos to .mp4?

[cmedia]

Hi!

lately i upgraded a 2.6 installation to a 3.2, all seems fine, BUT the videos not play on mobile phone because they are all .FLV!!!

convert all video to mp4 is easy, there are a lot of free converter, i can do local on my computer.

but what about the vshare database?

how i can "rename" all videos in database from "videofilename.flv" to "videofilename.mp4"?

[cmedia]

UPDATE videos
SET video_flv_name=REPLACE(video_flv_name, '.flv', '.mp4')

seems using this query all .flv are renamed to .mp4

i tested on a local server, i will do on my vshare site as soon i convert the flv to mp4 on my computer with a freee convetrer and upload it :D

[cmedia]

Worded fine!!!!