-- Chapter 6: Consequences
BEGIN TRANSACTION Shadow_Consequence;
-- Fetch last action
DECLARE @LastAction VARCHAR(50);
SET @LastAction = (SELECT TOP 1 Action FROM Shadow_Actions ORDER BY ActionID DESC);
-- Branch consequences
IF @LastAction = 'Assist Jaq with coven council issues'
BEGIN
PRINT 'Shadow and Jaq work together to uncover hidden threats.';
INSERT INTO Story_Progress (Scene, Outcome)
VALUES ('Coven Council', 'Shadow gains trust, uncovers secret plots, alliance solidified');
PRINT 'Ending Note: Cooperation has brought strategic advantage and mutual respect.';
END
ELSE IF @LastAction = 'Bite Jaq'
BEGIN
PRINT 'Shadow’s bite escalates tensions in the coven.';
INSERT INTO Story_Progress (Scene, Outcome)
VALUES ('Coven Confrontation', 'Jaq enraged, coven challenges Shadow, fight ensues');
PRINT 'Ending Note: Shadow’s impulsive choice leads to chaos, but power surge achieved.';
END;
-- Final reflection
INSERT INTO Shadow_Thoughts (Thought)
VALUES ('Choices define paths. Tonight, the coffee shop is quiet, but tomorrow the consequences awaken.');
COMMIT TRANSACTION Shadow_Consequence;
Read More Awesome Articles