<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<br>
<small><font face="Arial"><big><br>
James,</big></font></small><br>
<font face="Arial"><br>
</font><font face="Arial">AFAIK, update channel set contrast=49143;<br>
..will set contrast of -all- channels in the table channel to that
value. If you want to just set one you append a where ie<br>
</font>
<pre wrap=""><font face="Arial">
<big>update channel set contrast=49143 where chanid=4;
contrast, brightness, color and hue are all integers, no quotes needed.
You can be even snazzier by using
update channel set contrast=49143, brightness 45850, color 45868, hue 31458 where chanid=4;
Hope this helps
Alan</big></font><font face="Arial">
</font></pre>
<br>
<br>
Jay R. Ashworth wrote:<br>
<blockquote type="cite" cite="mid20040818154106.P32490@cgi.jachomes.com">
<pre wrap="">On Wed, Aug 18, 2004 at 03:19:39PM -0400, James Pifer wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I'm trying to make color/brightness adjustments of a recording while
watching it. I hit F as it says in keys.txt, but nothing happens.
Hitting G while watching LiveTV let's me adjust recording settings. Has
something changed with how to adjust while watching a recording?
</pre>
</blockquote>
<pre wrap=""><!---->
We had that problem as well; like some other key-press-response
problems we have, it seems intermittent.
</pre>
<blockquote type="cite">
<pre wrap="">Also, I've painstakingly adjusted one of the channels and I 'think' it
looks good now. I want to change all the rest of my channels to match. I
can select contrast, brightness, colour, hue from channel. How do I
update these in a sql statement to match the one channel I have? The
settings are:
contrast 49143
brightness 45850
color 45868
hue 31458
I'm not a sql guy, so any help would probably save me a lot of time.
</pre>
</blockquote>
<pre wrap=""><!---->
$ mysql -u root -p mythconverg
Password:
<mumble>
</pre>
<blockquote type="cite">
<pre wrap="">update channel set contrast=49143;
</pre>
</blockquote>
<pre wrap=""><!---->
... etc. I think you can set all of them in one pass, but I don't
remember what the syntax is for that. Do a describe channel before you
do that and check the column type; I assume it's numeric, but not
having my box handy, I can't tell; in the unlikely event it's a string,
you'd have to single quote the 49143.
</pre>
<blockquote type="cite">
<pre wrap="">Last one, I haven't searched for this answer yet, but what is the Fine
Tuning adjustment for that's found in the channel editor?
</pre>
</blockquote>
<pre wrap=""><!---->
Same thing, 'cept it twiddles the tuner frequency.
Cheers,
-- jra
</pre>
<pre wrap="">
<hr width="90%" size="4">
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote>
</body>
</html>