2012-01-15, 03:05
I really enjoy the benefits of using MySQL. Since switching over however, there is one little hitch that I am curious if there is a way around. In my video library, I have the following:
\HD General\
\SD General\
\SD General (Duplicates)\
\HD Kids\
\SD Kids\
\SD Kids (Duplicates)\
(The 'duplicate' folders contain the same content as the 'HD' folders do, only in SD)
Before switching to SQL, I simply pointed different devices to only certain directories like this:
MBR AppleTV = SD General, SD General (Duplicates)
Kids AppleTV = SD Kids, SD Kids (Duplicates)
HTPC = HD General, SD General, HD Kids, SD Kids
This prevented HD content from being available on the ATVs that can't play it, duplicate listings on the HTPC and filtered age appropriate content accordingly.
I can pull the kids off the SQL if necessary. It would be ideal to have an option to 'Hide SD Duplicates" or 'Hide HD Duplicates' in the menus (like satellite) but since that doesn't seem to be an option, is there a way to select which sources are available where, like I did above, without borking my SQL database on updates? Particularly when cleaning the DB?
Note: Update and clean commands are only issued from the HTPC...
Thanks in advance!
\HD General\
\SD General\
\SD General (Duplicates)\
\HD Kids\
\SD Kids\
\SD Kids (Duplicates)\
(The 'duplicate' folders contain the same content as the 'HD' folders do, only in SD)
Before switching to SQL, I simply pointed different devices to only certain directories like this:
MBR AppleTV = SD General, SD General (Duplicates)
Kids AppleTV = SD Kids, SD Kids (Duplicates)
HTPC = HD General, SD General, HD Kids, SD Kids
This prevented HD content from being available on the ATVs that can't play it, duplicate listings on the HTPC and filtered age appropriate content accordingly.
I can pull the kids off the SQL if necessary. It would be ideal to have an option to 'Hide SD Duplicates" or 'Hide HD Duplicates' in the menus (like satellite) but since that doesn't seem to be an option, is there a way to select which sources are available where, like I did above, without borking my SQL database on updates? Particularly when cleaning the DB?
Note: Update and clean commands are only issued from the HTPC...
Thanks in advance!