[mythtv-users] Email notifier of recorded shows

Josh Burks jburks at mktinsights.com
Wed Sep 1 10:21:52 EDT 2004


The script works great. Nice formatted output, too.

<enlightment>
So the scheduled recordings aren't stored in the DB, that's why I can't 
find them there.
</enlightment>

Josh Burks


Adam Lewandowski wrote:
> Here's a perl script (requires DBD::mysql, available through CPAN) that 
> makes it look a little better. Run it through cron and cron will send 
> you the output as an email on it's own.
> I looked in to pulling the scheduled recordings also but that 
> information is not stored in the database, you need to communicate with 
> the backend server over a socket to get it. Maybe some other day.
> 
> Josh Burks wrote:
> 
>> > mysql -u mythtv -pyourpw -e "select title, subtitle, description,
>> > starttime, CONCAT(hour(endtime-starttime), ':',
>> > minute(endtime-starttime)) length, channum, callsign from recorded r,
>> > channel c where r.chanid = c.chanid AND DATE_SUB(CURDATE(),INTERVAL 24
>> > HOUR) <= starttime;" mythconverg
>>
>> add this to the end of that command:
>>
>> | mail -s "Recorded by MythTV" your_email at your_domain.com
>>
>> It's raw data straight out of the db, oh and sendmail has to be running.
>>
>> Almost all you need in a one-liner.
>>
>> Josh Burks
>>
>>
>>
>> Adam Lewandowski wrote:
>>
>>> This isn't exactly what you're looking for, but here's a quick mysql 
>>> query command that will return all of the shows recorded in the last 
>>> 24 hours. It could be run as a cron job for a pretty crude report.
>>> Obviously, use your own mythtv database user id and password.
>>>
>>> mysql -u mythtv -pyourpw -e "select title, subtitle, description, 
>>> starttime, CONCAT(hour(endtime-starttime), ':', 
>>> minute(endtime-starttime)) length, channum, callsign from recorded r,
>>> channel c where r.chanid = c.chanid AND DATE_SUB(CURDATE(),INTERVAL 
>>> 24 HOUR) <= starttime;" mythconverg
>>>
>>>
>>>
>>> Tim Ahpee wrote:
>>>
>>>> Hi All,
>>>>
>>>> I've had a look through the mailing list archives and also thrown a few
>>>> queries at Google but haven't yeilded anything.
>>>>
>>>> What I'm after is a script that will send me a mail once a day with 
>>>> what shows
>>>> have been recorded, what are to be recoreded etc. Does one exist? If 
>>>> not I
>>>> might be off to write one.
>>>>
>>>> Thanks in advance,
>>>>
>>>> Tim
>>>>  
>>>>
>>>> ------------------------------------------------------------------------ 
>>>>
>>>>
>>>> _______________________________________________
>>>> mythtv-users mailing list
>>>> mythtv-users at mythtv.org
>>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>>  
>>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>  
>>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


More information about the mythtv-users mailing list