[mythtv-users] Browsing Recordings by Rule (rather than title)

Kevin Hulse jedi at mishnet.org
Fri Sep 29 18:46:13 UTC 2006


On Fri, Sep 29, 2006 at 12:53:50PM -0500, Kevin Hulse wrote:
> 	Is there any way to setup the recordings 
> browser in 0.20 to organize recordings by "wishlist"
> and "season pass" rather than by title. I would like
> to see all of the search-by-particular-actor titles
> together as a group rather than need to hunt them
> down.
> 
> 	If this isn't already an available option,
> could I get pointers on how to go about changing
> the behaivor of the recordings browser in my own
> copy of the source?

	I already figured out the basic data aspects of it.
This is more or less it and is sufficient for mapping the
raw MPG files to wishlists or series titles.

select replace(a.title,'(Keyword Search)','') as wishlist,
	b.chanid,b.starttime,
	concat(b.title,' -- ',b.subtitle)
	from record a,recorded b
		where  a.recordid=b.recordid
		and a.title like '%(Keyword Search)%'
UNION ALL
select replace(a.title,'(Keyword Search)','') as wishlist,	
	b.chanid,b.starttime,
	b.subtitle
	from record a,recorded b
		where  a.recordid=b.recordid
	and a.title not like '%(Keyword Search)%';

	I have a script that presents the Recordings data
inside of my Video directory so that I can browse all video
data from the same place. It generates something like...

./Franklin/Franklin_000_Finders_Keepers_for_Franklin_--_Franklins_Blanket.mpg
./Franklin/Franklin_305_Franklin_and_the_Fortune_Teller_--_Franklins_Cellar.mpg
./Franklin/Franklin_206_Franklins_Family_Treasure_--_Franklins_Music_Lessons.mpg
./Franklin/Franklin_204_Franklins_Kite_--_Franklin_and_the_Baby_Sitter.mpg
./Franklin/Franklin_109_Franklins_School_Play_--_Franklin_and_the_Secret_Club.mpg
./Franklin/Franklin_000_Franklin_the_Spy_--_Franklin_and_the_Library_Book.mpg
./Franklin/Franklin_301_Franklin_and_His_Night_Friend_--_Franklin_and_the_Two_Henrys.mpg
./schwarzenegger_
./schwarzenegger_/schwarzenegger__000_Commando_--_.mpg
./schwarzenegger_/schwarzenegger__000_End_of_Days_--_.mpg
./schwarzenegger_/schwarzenegger__000_Red_Heat_--_.mpg
./schwarzenegger_/schwarzenegger__000_The_6th_Day_--_.mpg
./Star_Trek
./Star_Trek/Star_Trek_000_Balance_of_Terror.mpg
./Star_Trek/Star_Trek_000_Devil_in_the_Dark.mpg

          ...and that's basically the structure I am interested in seeing
in the Recordings browser.

	Oh, and are episode numbers stored anywhere in the myth schema?
It would be nice to have those just for reference and also for recording
rules. 



More information about the mythtv-users mailing list