-- Chapter 5: Shadow's Decision
BEGIN TRANSACTION Shadow_Decides;
-- Check trust level with Jaq
DECLARE @TrustLevel INT;
SET @TrustLevel = (SELECT TrustScore FROM Shadow_Registry WHERE Target = 'Jaq');
-- Decision point: Help or Bite
IF @TrustLevel >= 5
BEGIN
PRINT 'Shadow decides to help Jaq.';
-- Helping sequence
INSERT INTO Shadow_Actions (Action, Outcome)
VALUES ('Assist Jaq with coven council issues', 'Strengthens alliance and gains insider info');
-- Update plot flags
UPDATE Plot_Flags
SET Status = 'AllianceFormed'
WHERE Character = 'Shadow';
PRINT 'Plot Update: Alliance with Jaq secured. New opportunities unlocked.';
END
ELSE
BEGIN
PRINT 'Shadow decides to bite Jaq. Initiate vampire protocol.';
-- Biting sequence
INSERT INTO Shadow_Actions (Action, Outcome)
VALUES ('Bite Jaq', 'Gain temporary power boost, risk coven retaliation');
-- Update plot flags
UPDATE Plot_Flags
SET Status = 'ConflictTriggered'
WHERE Character = 'Shadow';
PRINT 'Plot Update: Shadow has bitten Jaq. Tensions with coven escalate.';
END;
-- Shadow thoughts
INSERT INTO Shadow_Thoughts (Thought)
VALUES ('Every choice has consequences. Will power or alliance prevail?');
COMMIT TRANSACTION Shadow_Decides;