[zosky]

hi yall.

i have a ton of "hollywood" TV, documentories, anime & home movies in my library... my TV list ends up being MASSIVE, & useless. i found a way around this using a combination of smartPlaylists & categories... this bash script exports a list of all shows that have "anime" in the path & all shows in the anime category ... the difference (anime without the anime category) is updated

are there other (better) solutions to do this ?
xwmm is amazing for editing single items
(it does not do anything in bulk)

maybe this will tickle some1 (smarter then i)
and we can see this in an add-on ?

cheers
~ z

Code:

#/bin/bash
# xbmc anime catogrizer

mysqlCMD="-uxbmc -pxbmc xbmcvid60"

## list all anime in anime DIR by showID
ALL=$(mysql -e "SELECT tvshowlinkpath.idShow
      FROM path, tvshowlinkpath, tvshow
      WHERE path.strPath LIKE \"%anime%\"
      AND tvshowlinkpath.idPath = path.idPath
      AND tvshow.idShow = tvshowlinkpath.idShow" $mysqlCMD|sort )

## list all anime in anime CAT by showID
ANI=$(mysql -e "SELECT idShow
        FROM genrelinktvshow WHERE idGenre = 57" $mysqlCMD|sort )

## COMMpare both lists & output NEW
# (unique to file1 / ALL w/o CAT=Anime)
NEW=$(comm -23 <(echo "$ALL") <(echo "$ANI"))

## IF SOMETHING IS NEW ... UPDATE THE DB
[[ "$NEW" ]] && {
      for newID in $NEW; do
      mysql -e "INSERT INTO genrelinktvshow (idGenre, idShow)
            VALUES (\"57\", \"$newID\")" $mysqlCMD
      done
      echo "set CAT anime for $(echo "$NEW"|wc -l) new shows"
    }

[DaMizZa]

There is... I just set it up the other day and so far it's working beautifully. Check out this thread for a well-written up tutorial on the topic:

http://forum.xbmc.org/showthread.php?tid=89678