Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: HowTo: Replace user uploaded WMV/MOV/aso. files for FlashVideo  (Read 3007 times)

0 Members and 1 Guest are viewing this topic.

Riox

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 55

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]
« Last Edit: May 15, 2008, 06:54:16 pm by Joachim Müller »
Logged

Riox

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 55
Re: HowTo: Replace user uploaded WMV/MOV/aso. files with FlashVideo
« Reply #1 on: May 15, 2008, 05:11:28 pm »

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

(http://foxbox.cc/riox/permalink/coppermine_howto/001.png)
then go to the right frame and scroll down till you find cpg14x_usr_pictures

(http://foxbox.cc/riox/permalink/coppermine_howto/002.png)
I named mine Cuprum, don't let that bug you. Click on the first icon (as shown)

(http://foxbox.cc/riox/permalink/coppermine_howto/003.png)
Click on the "pid" link on top of the tabel so it lists the highest number first (New file => higher number )

(http://foxbox.cc/riox/permalink/coppermine_howto/004.png)
Now, finde the name of the Video and click on the "pen" icon

(http://foxbox.cc/riox/permalink/coppermine_howto/005.png)
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)

(http://foxbox.cc/riox/permalink/coppermine_howto/006.png)
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 -.-
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: HowTo: Replace user uploaded WMV/MOV/aso. files for FlashVideo
« Reply #2 on: May 15, 2008, 06:54:59 pm »

Why did you post twice anyway?
Logged

Riox

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 55
Re: HowTo: Replace user uploaded WMV/MOV/aso. files for FlashVideo
« Reply #3 on: May 15, 2008, 07:29:42 pm »

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 :/
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 21 queries.