[mythtv-users] Email notifier of recorded shows

Mike Luich ravenhair at gmail.com
Wed Sep 1 10:55:25 EDT 2004


Yes very nice thanks.

I've got mine piped to mail so i can send it to both me and my wife.

new_recorded.pl |mail my-email at someplace.com -s "Mythtv Recording" -c
Wife's-email at someplace.com


Hmm perhaps i should warn her............

Michael Luich
RHCE

On Wed, 01 Sep 2004 09:21:52 -0500, Josh Burks <jburks at mktinsights.com> wrote:
> 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
> 
> 
> _______________________________________________
> 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