CREATE TRIGGER T_InsertItem ON [dbo].[UserGameItems] AFTER INSERT
AS
    IF EXISTS ( SELECT * FROM [dbo].[UserGameItems] AS ugi
                INNER JOIN [dbo].[UsersGames] AS ug ON ugi.UserGameId = ug.GameId
                INNER JOIN [dbo].[Items] AS i ON i.ItemTypeId = ugi.ItemId
                WHERE ug.Level < i.MinLevel)
BEGIN
RAISERROR ('Item level is bigger than hero level!', 16, 1);
ROLLBACK TRANSACTION;
RETURN
END;
GO

-- добавям пари на определените юзъри
UPDATE UsersGames
SET Cash += 50000
WHERE GameId IN (SELECT Id FROM Games
                    WHERE Name = 'Bali')
            AND
            UserId IN (SELECT Id FROM Users
WHERE Username IN ('baleremuda', 'loosenoise', 'inguinalself', 'buildingdeltoid', 'monoxidecos'))

--вадя общата стойност на определените итеми от определените юзъри
UPDATE UsersGames
SET Cash -= (SELECT SUM(AllSums.Price) FROM
(SELECT Price FROM Items
WHERE (Id BETWEEN 251 AND 299) OR (Id BETWEEN 501 AND 539)) AS AllSums)
WHERE GameId IN (SELECT Id FROM Games
                    WHERE Name = 'Bali')
            AND
            UserId IN (SELECT Id FROM Users
WHERE Username IN ('baleremuda', 'loosenoise', 'inguinalself', 'buildingdeltoid', 'monoxidecos'))

-- тука се пробвам да навържа таблиците за да изкарам данните, които се искат
SELECT u.Username, g.Name, us.Cash, i.Name FROM Users AS u
INNER JOIN UsersGames AS us ON u.Id = us.UserId
INNER JOIN UserGameItems AS ugi ON ugi.UserGameId = us.GameId
INNER JOIN Games AS g ON g.Id = us.GameId
INNER JOIN Items AS i ON i.Id = ugi.ItemId
WHERE g.Name = 'Bali'