[mythtv-users] Web based 'cutpoint' editing
Anthony Giggins
seven at seven.dorksville.net
Wed Feb 8 00:48:31 UTC 2012
On 8 February 2012 05:45, Anthony Giggins <seven at seven.dorksville.net>wrote:
>
>
> On 7 February 2012 23:12, Mario Weilguni <roadrunner6 at gmx.at> wrote:
>
>> Am 06.02.2012 23:19, schrieb Anthony Giggins:
>>
>>
>>
>> On 7 February 2012 07:59, Mario Weilguni <roadrunner6 at gmx.at> wrote:
>>
>>> Am 06.02.2012 22:50, schrieb Anthony Giggins:
>>>
>>>
>>>
>>> On 7 February 2012 05:59, Mario Weilguni <roadrunner6 at gmx.at> wrote:
>>>
>>>> Am 06.02.2012 01:46, schrieb Anthony Giggins:
>>>> > What is the SQL query that fetches the Series dropdown list, this
>>>> > doesn't quiet look complete?
>>>> >
>>>>
>>>> It's within selectMovie.php
>>>>
>>>>
>>>> select title, count(1) as cnt, sum(filesize) as size
>>>> from recorded r
>>>> where transcoded = 0
>>>> and deletepending = 0
>>>> and not exists (select 1 from recordedmarkup m where
>>>> m.chanid=r.chanid and m.starttime=r.starttime and m.type in (0,1))";
>>>> group by title having count(1) > 1
>>>> order by size desc
>>>>
>>>> Regards
>>>> Mario
>>>>
>>>>
>>>>
>>> I'd like to see this set to
>>> group by title having count(1) > 0
>>>
>>> As if you have transcoded an entire series and then another episode
>>> appears you dont see this in the list until the next episode airs.
>>>
>>> Cheers,
>>>
>>>
>>> Well, having count(1) > 0 is a little pointless, same as where true.
>>> How do you distinguish between series and real "films"?
>>>
>>> Regards
>>> Mario
>>>
>>
>> Agree'd, I dont see there to be a need to distinguish although films wont
>> have a subtitle but once you transcode them they wouldn't show in the list
>> either.
>>
>> group by title
>>
>> is all that is needed
>>
>>
>> Hmmm... maybe you're right. What query do you propose?
>>
>> Regards,
>> Mario
>>
>>
>> This seems to work
>
>
>> select title, count(1) as cnt, sum(filesize) as size
>> from recorded r
>> where transcoded = 0
>> and deletepending = 0
>> and not exists (select 1 from recordedmarkup m where
>> m.chanid=r.chanid and m.starttime=r.starttime and m.type in (0,1))";
>> group by title
>> order by size desc
>>
>
> Cheers,
>
> Anthony
>
I guessing the Delete cut point hasn't yet been added in 0.3?
also visually the link looks wrong
Cutpoint l�schen or from the code Cutpoint löschen
Cheers,
Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20120208/572fd841/attachment.html
More information about the mythtv-users
mailing list