Well, since there is now myTV Collection (which I love though it is kiling all my ratios). I was wondering if something could be done not so similar to that where we utilize the watched episodes table.
What I was thinking was maybe a way to have a forum badge (image) that says what you've most recently watched, or what you watch the most, or something like that. Maybe if possible a way for myTV to upload what you are currently watching so that a badge could say what you are watching at this very moment. ITs just an idea. I could write it myself in Coldfusion but that would be useless for most people saying they don't have coldfusion running somewhere in thier network.
Of course these images wouldn't be limited to forums. Maybe a way to change your mySpace, Facebook, etc. status.
Just an idea I wanted to throw out there and see what people thought.
There was actually a facebook plugin that would update your status with what you were watcing.... of course, if you were watching pr0n through your VMC then it could get embarassing
Something like that has been discussed @ TheTVDB, so it's definitely on the radar.
I'm on writing the code to do the semi-auto uploads of MyCollection.xml now, so that's a step in the right direction - I'm still looking at other ways of handling this though. One idea is to queue up events that happens and send them thru at pre-defined times, there's a bunch of stuff that could be done, including a offsite backup of your collection (obviously, not the media itself - but your DB) which would allow for really easy re-installs if/when you nuke your HTPC.
But hey, add this post to bugnet and it wont be forgot about at least :)
Oh, also - the status tag in your sidebar badge will at some point show how much time you've spent infront of myTV :)
If you're in a team, you'll be able to blame it on your team members, and that's one of the reasons for working in a team, but if you're working by yourself and your program has errors, all you can do is blame it on Microsoft.
actually, most of this I was trying to see if it could be a community addon (like myTV Collection, which I know you've also helped with) ;) That is if it was ok with you. I'm gonna probably play with it some using CF since i have access to it and know how to program in it. I'm about to start learning C# .net (as you know), so I may play with that as well.
watched status of episodes is included in mycollection.xml, so you could get most watched etc, there are lots of statistics i have to add to the site, something like currently playing would have to be pushed out by the mytv app wouldnt it?
Kode, you're just grabbing watched status though, right? That's not the same as the the data in the tvViewedhistory table (or maybe you're gettting that as well?).
From what I understand I can set a show, season, or episode to watched and it merely marks the respective episodes as watched in the tvEpisodes table. With the tvViewedHistory, you'd have access to what I watched yesterday and at what times. I was just trying to leverage that data since currently its not being used (though I'm sure Arne has some good ideas for it, otherwise it wouldn't be there ;))
ahh gotcha, yeah im just getting watched status i believe, although the xml output could probably be modified to include some of that data
No, you're getting the full tvviewedhistory output - well, sorta. You're getting the total number of times an episode has been watched (this does not include just setting the episode as watched by pressing the "flag watched' button). So you could very quickly do a report on which episode has been watched the most etc.
You're not, however, getting the dates when something was watched - it would be too much data to stick in the single XML file I think.
As for "watching now" - that's something myTV would have to push, but I could allow a plugin to attach to my PlayMedia event which would allow for this.
Oh. my main idea wasn't to show my lifetime watching habbits, but to show maybe what I watched this week so far.
per episode it would be too much but couldnt you have something like
<shows> <watched> <Episode EpisodeID="2" date"098980" /> <Episode EpisodeID="3" date="786787" /> <Episode EpisodeID="4" date="9879898" /> <Episode EpisodeID="5" date="9809909" /> </watched> <Show SeriesID="70327" Name="something" BannerUrl="something" FSLocation="something" Size="53853820928"> <Episode EpisodeID="6732" Title="Which Was Nice" Seen="0" /> etc </Show></shows>
and just display like the last 10 or something, not really suggesting its done, doesnt really bother me either way :)
admin:No, you're getting the full tvviewedhistory output - well, sorta. You're getting the total number of times an episode has been watched (this does not include just setting the episode as watched by pressing the "flag watched' button). So you could very quickly do a report on which episode has been watched the most etc.
Hmm I think it should include the ones flagged as watched. Just becuase I didn't watch it in myTV doesn't mean I haven't watched the EP :)
myTV Moderatorthetvdb.com Administrator
True, however the tvWatchedHistory table is myTV specific and is [will be] used for various reports, including those simply flagged as watched will break that.
So I would need to write a script to update the watched history with a date/time value if the watch flag was true?
If you really want to you could just edit the SPs that flag watched/unwatched and from there on out (until you install a new release) it'll put a record in the table.
admin: If you really want to you could just edit the SPs that flag watched/unwatched and from there on out (until you install a new release) it'll put a record in the table.
So I just need to have it set a valid date correct? So I could put 1/1/1970 for the date if I just mark it watched? I will look at this when I get the next build.