I don't believe that this is possible using just the database, the backend doesn't track when recordings are watched. You could create a script that monitors the backend or frontend log file and records the date and time for every show watched.<div>
<br></div><div>Personally, I know my kids will expose themselves to things I don't like... I know I did when I was a kid... and I choose to let them think that I'm too stupid to know it. That way I can make minor course corrections without them even realizing what I am doing rather than have them resenting me for taking total control of their lives.</div>
<div><br></div><div>But if they are young kids and you want to prevent them from accidentally watching something they shouldn't, then the parental controls are good.</div><div><br></div><div class="gmail_extra"><br><br>
<div class="gmail_quote">On Thu, Nov 29, 2012 at 8:41 AM, Brian Long <span dir="ltr"><<a href="mailto:briandlong@gmail.com" target="_blank">briandlong@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I was wondering if there is some way I can query MySQL to determine which recordings (not videos) have been recently watched and at what time they were viewed. I use a similar feature on NetFlix to ensure my kids aren't watching things they're not supposed to be watching. It would be nice to know this information from MythTV.<div>
<br></div><div>Thanks for any hints.</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>/Brian/</div><div><br></div>
</font></span><br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br></div>