[mythtv] [mythtv-commits] Ticket #4026: Default playback group for XvMC does not invclude 1080I/P

[Steve Daniels]

On 06/02/2008, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 02/06/2008 05:53 AM, Steve Daniels wrote:
> > Just a thought, maybe if it was possible to export the profiles, then
> > an effort to collate (on the wiki?) and list the most popular and
> > prevalent could be made, and include these within svn?
> >
> > Steve 'no patch attached' Daniels
>
<snip/>
>
> So, by including a page on the wiki with the above query and a table
> that includes the above and perhaps a "username" column (or have a
> "username" header that spans all columns between users), you could do
> exactly as you suggested.  Since users will probably have to manually
> transcribe the data to the wiki format (guessing as I don't speak wiki),
> it may make more sense to use the '\G' approach in the query shown on
> the wiki page.
>
> I attached mine.  The one whose Hostname is listed as frontend is the
> cut-down playback profile I'm actually using.  The ones whose Hostname
> is listed as masterbackend are the built-in example profiles (started up
> the frontend on the master backend just to get the "originals" for this
> output).
>
> Anyone know their SQL well enough to know how to get the output to only
> include values (i.e. for Hostname, Playback Profile Name, and Priority)
> when they change from the row above?  I've seen it before on Oracle
> queries, but I have no clue how it's done.
>
> Mike "make it so" Dean  ;)
>
> (And, thanks, BTW.  Good suggestion, and I'm hoping you'll take the time
> to set up the page and get it started and possibly post it to the -users
> list to get more examples from trunk users.)
>

Hi Mike,

Thank you for the encouragement, and for providing that snippet of
SQL. I'll try and get my head round it all 100% then look to attacking
the wiki and move this discussion over to -users.

Steve Daniels