[mythtv-users] Email notifier of recorded shows
Josh Burks
jburks at mktinsights.com
Tue Aug 31 17:11:49 EDT 2004
> 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
More information about the mythtv-users
mailing list