diff options
| author | Joshua Boniface <joshua@boniface.me> | 2022-07-24 12:35:47 -0400 |
|---|---|---|
| committer | Joshua Boniface <joshua@boniface.me> | 2022-07-24 12:35:47 -0400 |
| commit | bffda19bbc9d8fe95c864d7315a0c6f6a05d9d7d (patch) | |
| tree | e8949d2ba3617b48ecfe544e67fb87348e5a422c /Emby.Server.Implementations/Data/SqliteItemRepository.cs | |
| parent | 76f7a80a97f19adc6126eaef02dc64fe9a581b48 (diff) | |
Backport pull request #8166 from jellyfin/release-10.8.z
Bind @userid only when it's in the statement
Authored-by: Joseph <1315585+joseph39@users.noreply.github.com>
Merged-by: Claus Vium <cvium@users.noreply.github.com>
Original-merge: 057e8ef24061a969d4ca31b5b115e14d5ba76fe4
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteItemRepository.cs')
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index 4361440d7..1b176e60d 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -4934,6 +4934,7 @@ SELECT key FROM UserDatas WHERE isFavorite=@IsFavorite AND userId=@UserId) AND Type = @InternalPersonType)"); statement?.TryBind("@IsFavorite", query.IsFavorite.Value); statement?.TryBind("@InternalPersonType", typeof(Person).FullName); + statement?.TryBind("@UserId", query.User.InternalId); } if (!query.ItemId.Equals(default)) @@ -4988,11 +4989,6 @@ AND Type = @InternalPersonType)"); statement?.TryBind("@NameContains", "%" + query.NameContains + "%"); } - if (query.User != null) - { - statement?.TryBind("@UserId", query.User.InternalId); - } - return whereClauses; } |