Difference between revisions of "Dvdtranscode table"

From MythTV Official Wiki
Jump to: navigation, search
(→‎MTD: added bitrate)
m (change category)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
dvdtranscode table configures [[MTD]] when transcoding from one format to another (Ex:  mpeg2 DVD to  mpeg4 xvid)
+
{{Wrongtitle|dvdtranscode table}}
−
<pre>
+
'''dvdtranscode table''' configures the [[MTD]] when transcoding from one format to another (Ex:  [[MPEG-2]] DVD to [[MPEG-4]] [[Xvid]]).
−
<nowiki>
+
Setting these fields in the database will change how the [[MTD]] calls [http://www.transcoding.org/ transcode].
 +
 
 +
== Table Description ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  Field name  !! Type            !! Null !! Key !! Default !! Extras
 +
|-
 +
|| intid      || int(11)          ||      || PRI || NULL    || auto_increment
 +
|-
 +
|| input      || int(10) unsigned || YES  ||    || NULL    ||
 +
|-
 +
|| name        || varchar(128)    ||      ||    ||        ||
 +
|-
 +
|| sync_mode  || int(10) unsigned || YES  ||    || NULL    ||
 +
|-
 +
|| use_yv12    || tinyint(1)      || YES  ||    || NULL    ||
 +
|-
 +
|| cliptop    || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clipbottom || int(11)         || YES  ||    || NULL    ||
 +
|-
 +
|| clipleft    || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clipright  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| f_resize_h  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| f_resize_w  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| hq_resize_h || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| hq_resize_w || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| grow_h      || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| grow_w      || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clip2top    || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clip2bottom || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clip2left  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| clip2right  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| codec      || varchar(128)    ||      ||    ||        ||
 +
|-
 +
|| codec_param || varchar(128)    || YES  ||    || NULL    ||
 +
|-
 +
|| bitrate    || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| a_sample_r  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| a_bitrate  || int(11)          || YES  ||    || NULL    ||
 +
|-
 +
|| two_pass    || tinyint(1)      || YES  ||    || NULL    ||
 +
|-
 +
|| tc_param    || varchar(128)    || YES  ||    || NULL    ||
 +
|-
 +
|}
  
−
describe dvdtranscode;
+
== Fields ==
−
+-------------+------------------+------+-----+---------+----------------+
+
*'''intid''' is a unique identifier for the entries in the table.
−
| Field      | Type            | Null | Key | Default | Extra          |
+
*'''input''' relates to the ''intid'' field of the [[dvdinput table]].
−
+-------------+------------------+------+-----+---------+----------------+
+
*'''grow_h''' and '''grow_w''': If these are greater than 0, the "-X" option is used to transcode.
−
| intid       | int(11)          |      | PRI | NULL    | auto_increment |
+
*'''f_resize_h''' and '''f_resize_w''': If these are greater than 0, the "-B" option is used to transcode.
−
| input       | int(10) unsigned | YES  |    | NULL    |                |
+
*'''hq_resize_h''' and '''hq_resize_w''': If these are greater than 0, the "-Z" option is used to transcode. For example if you want to change your 720x576 DVD to 360x272, you would set hq_resize_w=360 and hq_resize_h=272.
−
| name        | varchar(128)    |      |    |        |                |
+
*'''bitrate''' is what is used with the transcode "-w" option to set the encoder bitrate.
−
| sync_mode  | int(10) unsigned | YES  |    | NULL    |                |
 
−
| use_yv12    | tinyint(1)      | YES  |    | NULL    |                |
 
−
| cliptop    | int(11)          | YES  |    | NULL    |                |
 
−
| clipbottom  | int(11)          | YES  |    | NULL    |                |
 
−
| clipleft    | int(11)          | YES  |    | NULL    |                |
 
−
| clipright  | int(11)          | YES  |    | NULL    |                |
 
−
| f_resize_h | int(11)          | YES  |    | NULL    |                |
 
−
| f_resize_w | int(11)          | YES  |    | NULL    |                |
 
−
| hq_resize_h | int(11)          | YES  |    | NULL    |                |
 
−
| hq_resize_w | int(11)          | YES |    | NULL    |                |
 
−
| grow_h      | int(11)          | YES |    | NULL    |                |
 
−
| grow_w      | int(11)          | YES  |    | NULL    |                |
 
−
| clip2top    | int(11)          | YES  |    | NULL    |                |
 
−
| clip2bottom | int(11)          | YES  |    | NULL    |                |
 
−
| clip2left  | int(11)          | YES  |    | NULL    |                |
 
−
| clip2right  | int(11)          | YES  |    | NULL    |                |
 
−
| codec      | varchar(128)    |      |    |        |                |
 
−
| codec_param | varchar(128)    | YES  |    | NULL    |                |
 
−
| bitrate     | int(11)          | YES  |    | NULL    |                |
 
−
| a_sample_r  | int(11)          | YES  |    | NULL    |                |
 
−
| a_bitrate  | int(11)          | YES  |    | NULL    |                |
 
−
| two_pass    | tinyint(1)      | YES  |    | NULL    |                |
 
−
+-------------+------------------+------+-----+---------+----------------+
 
  
−
</nowiki>
+
== Example Entries ==
 +
<pre>
 +
intid: 9
 +
input: 6
 +
name: Good
 +
sync_mode: 1
 +
use_yv12: 1
 +
cliptop: 0
 +
clipbottom: 0
 +
clipleft: 16
 +
clipright: 16
 +
f_resize_h: 5
 +
f_resize_w: 0
 +
hq_resize_h: 0
 +
hq_resize_w: 0
 +
grow_h: 0
 +
grow_w:
 +
clip2top: 0
 +
clip2bottom: 0
 +
clip2left: 0
 +
clip2right: 0
 +
codec: divx5
 +
codec_param: NULL
 +
bitrate: 1618
 +
a_sample_r: NULL
 +
a_bitrate: NULL
 +
two_pass: 0
 +
tc_param: NULL
 
</pre>
 
</pre>
−
 
+
[[Category:Unused DB Table]]
−
== [[MTD]] ==
 
−
This table tells [[MTD]] what paramaters for a given type to pass to the [http://www.transcoding.org/ transcode program]
 
−
 
 
−
Setting these fields in the database change how mtd calls [http://www.transcoding.org/ transcode]
 
−
 
 
−
* grow_h and grow_w:  Changing these to values other greater than 0 pass the "-X" option to transcode.
 
−
 
 
−
* f_resize_h and f_resize_w: Changing these to values other greater than 0 pass the "-B" option to transcode.
 
−
 
 
−
* hq_resize_h and hq_resize_w:  Changing these to values other greater than 0 pass the "-Z" option to transcode.  This is best used for example if you want to change your 720x576 DVD to  360x272 you would set hq_resize_w=360 and hq_resize_h=272
 
−
 
 
−
* bitrate is what is used with the transcode "-w" option to set the encoder bitrate
 

Latest revision as of 04:40, 15 October 2010

Important.png Note: The correct title of this article is dvdtranscode table. It appears incorrectly here due to technical restrictions.

dvdtranscode table configures the MTD when transcoding from one format to another (Ex: MPEG-2 DVD to MPEG-4 Xvid). Setting these fields in the database will change how the MTD calls transcode.

Table Description

Field name Type Null Key Default Extras
intid int(11) PRI NULL auto_increment
input int(10) unsigned YES NULL
name varchar(128)
sync_mode int(10) unsigned YES NULL
use_yv12 tinyint(1) YES NULL
cliptop int(11) YES NULL
clipbottom int(11) YES NULL
clipleft int(11) YES NULL
clipright int(11) YES NULL
f_resize_h int(11) YES NULL
f_resize_w int(11) YES NULL
hq_resize_h int(11) YES NULL
hq_resize_w int(11) YES NULL
grow_h int(11) YES NULL
grow_w int(11) YES NULL
clip2top int(11) YES NULL
clip2bottom int(11) YES NULL
clip2left int(11) YES NULL
clip2right int(11) YES NULL
codec varchar(128)
codec_param varchar(128) YES NULL
bitrate int(11) YES NULL
a_sample_r int(11) YES NULL
a_bitrate int(11) YES NULL
two_pass tinyint(1) YES NULL
tc_param varchar(128) YES NULL

Fields

  • intid is a unique identifier for the entries in the table.
  • input relates to the intid field of the dvdinput table.
  • grow_h and grow_w: If these are greater than 0, the "-X" option is used to transcode.
  • f_resize_h and f_resize_w: If these are greater than 0, the "-B" option is used to transcode.
  • hq_resize_h and hq_resize_w: If these are greater than 0, the "-Z" option is used to transcode. For example if you want to change your 720x576 DVD to 360x272, you would set hq_resize_w=360 and hq_resize_h=272.
  • bitrate is what is used with the transcode "-w" option to set the encoder bitrate.

Example Entries

intid: 9
input: 6 
name: Good
sync_mode: 1
use_yv12: 1
cliptop: 0
clipbottom: 0 
clipleft: 16
clipright: 16
f_resize_h: 5 
f_resize_w: 0 
hq_resize_h: 0
hq_resize_w: 0 
grow_h: 0
grow_w:
clip2top: 0
clip2bottom: 0 
clip2left: 0
clip2right: 0
codec: divx5
codec_param: NULL
bitrate: 1618
a_sample_r: NULL
a_bitrate: NULL
two_pass: 0
tc_param: NULL
Retrieved from "http://www.mythtv.org/wiki?title=Dvdtranscode_table&oldid=49384"