[mythtv] [PATCH] Add transcoding support (final)
Geoffrey Hausheer
ou401cru02 at sneakemail.com
Sun Apr 20 12:12:27 EDT 2003
On Sun, 20 Apr 2003 10:30:17 -0400, "Isaac Richards ijr-at-po.cwru.edu
|mythtv/1.0-Allow|" <e6kbhbk35r0t at sneakemail.com> said:
> > 5) I noticed you didn't include the control to enable the transcoders in
> > mythfrontend (or the cvs.sql). I'm just curious why not.
>
> I need to talk with mdz 'bout stealing profile 3 like that -- I, at
> least,
> already have that number used by something else.
Here is a better cvs.sql fix. the profile # doesn't need to be '3' since
we always access it by name.
It is a bit messy, since update doesn't support multiple tables for mysql
< 4.04
------
CREATE TABLE IF NOT EXISTS transcoding (
chanid INT NOT NULL,
starttime TIMESTAMP,
isdone INT UNSIGNED NOT NULL DEFAULT 0
);
INSERT INTO recordingprofiles (name,videocodec,audiocodec) VALUES
('Transco
de','MPEG-4','MP3');
CREATE TEMPORARY TABLE tempcodec SELECT codecparams.* FROM
codecparams,recordingprofiles WHERE codecparams.profile =
recordingprofiles.id
AND recordingprofiles.name = 'Default';
CREATE TEMPORARY TABLE tempcodec1 (
profile INT UNSIGNED,
name CHAR(128),
value CHAR(128)
);
INSERT INTO tempcodec1 SELECT
recordingprofiles.id,tempcodec.name,tempcodec.value
FROM recordingprofiles,tempcodec WHERE recordingprofiles.name =
'Transcode';
INSERT INTO codecparams SELECT * FROM tempcodec1;
DROP TABLE tempcodec;
DROP TABLE tempcodec1;
More information about the mythtv-dev
mailing list