xbmc/xbmc — pull request #1836 by Montellese (2012-11-23 16:59:02+00:00)
Title: smartplaylists: two fixes

The first commit fixes the "is" and "isnot" operators for numerical values (where LIKE does not work properly) and the second commit fixes the playcount rule for tvshows (I might have added that one accidentally but doesn't hurt to support it (see http://trac.xbmc.org/ticket/13596). The resulting SQL WHERE condition for the second fix is not very pretty (CASE ... WHEN and COALESCE needed) but does the job very well (for a watched/unwatched trigger).