diff options
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs index 346dcf359..9d6343568 100644 --- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs +++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs @@ -1966,13 +1966,13 @@ namespace MediaBrowser.Server.Implementations.Persistence whereClauses.Add(string.Format("(InheritedParentalRatingValue > 0 or UnratedType not in ({0}))", inClause)); } - //var excludeTagIndex = 0; - //foreach (var excludeTag in query.ExcludeTags) - //{ - // whereClauses.Add("Tags not like @excludeTag" + excludeTagIndex); - // cmd.Parameters.Add(cmd, "@excludeTag" + excludeTagIndex, DbType.String).Value = "%" + excludeTag + "%"; - // excludeTagIndex++; - //} + var excludeTagIndex = 0; + foreach (var excludeTag in query.ExcludeTags) + { + whereClauses.Add("Tags not like @excludeTag" + excludeTagIndex); + cmd.Parameters.Add(cmd, "@excludeTag" + excludeTagIndex, DbType.String).Value = "%" + excludeTag + "%"; + excludeTagIndex++; + } if (addPaging) { @@ -2070,8 +2070,6 @@ namespace MediaBrowser.Server.Implementations.Persistence _updateInheritedRatingCommand.Transaction = transaction; _updateInheritedRatingCommand.ExecuteNonQuery(); - - _updateInheritedRatingCommand.ExecuteNonQuery(); } transaction.Commit(); |
