-- Chapter 4: Confronting the Late Vampire
BEGIN TRANSACTION Shadow_Confronts_Jaq;
-- Shadow approaches the dimly lit bar
DECLARE @BarID INT;
SET @BarID = (SELECT TOP 1 BarID FROM Local_Bars WHERE Name = 'The Midnight Brew');
-- Verify Jaq's presence
DECLARE @JaqStatus VARCHAR(20);
SET @JaqStatus = (SELECT Status FROM Vampire_Registry WHERE Name = 'Jaq');
IF @JaqStatus = 'Hiding'
BEGIN
PRINT 'Jaq is hiding. Shadow must activate persuasion protocol.';
INSERT INTO Shadow_Thoughts (Thought)
VALUES ('Why is he hiding? What is he afraid of?');
END
ELSE
BEGIN
PRINT 'Jaq detected in bar. Prepare for interaction.';
END;
-- Interaction sequence
INSERT INTO Shadow_Actions (Action)
VALUES ('Approach Jaq at table', 'Demand explanation for delay');
-- Dialogue exchange
DECLARE @JaqResponse VARCHAR(MAX);
SET @JaqResponse = (SELECT Response FROM Vampire_Registry WHERE Name = 'Jaq');
IF @JaqResponse IS NULL
BEGIN
SET @JaqResponse = 'Apologies Shadow, unexpected complications at the coven council.';
PRINT @JaqResponse;
INSERT INTO Shadow_Thoughts (Thought)
VALUES ('Coven council? That explains his lateness. But why not tell me earlier?');
END
ELSE
BEGIN
PRINT 'Jaq explains: ' + @JaqResponse;
END;
-- Shadow decides next action based on response
INSERT INTO Shadow_Actions (Action)
VALUES ('Listen carefully', 'Consider trust level and next steps');
-- Alert: Possible plot twist
RAISERROR('Alert: Coven intrigue detected. Shadow must decide whether to intervene.', 16, 1);
COMMIT TRANSACTION Shadow_Confronts_Jaq;