HowTo: Replace user uploaded WMV/MOV/aso. files for FlashVideo

[Riox]

Scenario: You have a CPG and someone uploaded a video, but it is a WMV file and instead of happy comments you find ppl b*tching about the video not playing because they don't have the right plugins installed.

Preconditions: Up-to-Date CPG, FTP Access, phpMyAdmin, Video-to-FLV converter on your PC, CPG - FLV Player Integration MOD

1. Backup your Database!
2. Open your Gallery and go to the Video. Write the name of the Video down on a paper.
3. Now, go to your phpMyAdmin page and login. Select your Database

[Edit GauGau] Replaced hotlinked image with attachment 001.png [/Edit] then go to the right frame and scroll down till you find cpg14x_usr_pictures

[Edit GauGau] Replaced hotlinked image with attachment 002.png [/Edit] I named my Cuprum, don't let that bug you. Click on the first icon (as shown)

[Edit GauGau] Replaced hotlinked image with attachment 003.png [/Edit] Click on the "pid" link on top of the tabel so it lists the highest number first (New file => higher number )

[Edit GauGau] Replaced hotlinked image with attachment 004.png [/Edit]

[Riox]

Scenario: You have a CPG and someone uploaded a video, but it is a WMV file and instead of happy comments you find ppl b*tching about the video not playing because they don't have the right plugins installed.

Preconditions: Up-to-Date CPG, FTP Access, phpMyAdmin, Video-to-FLV converter on your PC, CPG - FLV Player Integration MOD

1. Backup your Database!
2. Open your Gallery and go to the Video. Write the name of the Video down on a paper.
3. Now, go to your phpMyAdmin page and login. Select your Database

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F001.png&hash=9e3f7c0d0c157c807dd5f9cafdaa9b4c32c0b6bf)
then go to the right frame and scroll down till you find cpg14x_usr_pictures

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F002.png&hash=ac61f153473fc789c916be2923657b124aae2cbe)
I named mine Cuprum, don't let that bug you. Click on the first icon (as shown)

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F003.png&hash=fe32c1c676352bb5a2fdcc72d53ec0684514f086)
Click on the "pid" link on top of the tabel so it lists the highest number first (New file => higher number )

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F004.png&hash=b7f656498e2711cc785d72eab29edf0fa28bec02)
Now, finde the name of the Video and click on the "pen" icon

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F005.png&hash=69511c48ea5b80c541debcc63109415122e6f061)
Replace the ending of the filename with .flv and start your ftp client.
Go to your CPG dir -> albums -> userpics -> ##### (# be the number shown over the filename, in my chase 11438)

(https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Ffoxbox.cc%2Friox%2Fpermalink%2Fcoppermine_howto%2F006.png&hash=e55f32e5a92cac64b705097dab88af1887933b32)
While you download the file, scroll all the way down in your phpMyAdmin window. Hit the [Go] Icon and logout from phpMyAdmin.

Convert the file you downloaded to FlashVideo and put it back on the server so you have both files there in the same directory (keep the source, someday you'll need it)


####### To the Mods #######
Sorry to put it here, I hit [Post] by accident and now I can't undo it -.-

[Joachim Müller]

Why did you post twice anyway?

[Riox]

I was writing a request when it came to me that I could do it myself. I wrote the HowTo and somewhere in the middle I hit (post) instead of (preview). Unlike you, I don’t have the (edit) button so I posted the final thing here… didn’t really know where else to put it :/