Exercice11

DELETE FROM `gameobject_template` WHERE entry = 250000;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES
(250000, 9, 558, 'Journal intime de Kreator', '', '', '', 1, 4000, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0);

DELETE FROM `gameobject_template_addon` WHERE entry = 250000;
INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `mingold`, `maxgold`) VALUES
(250000, 35, 0, 0, 0);

DELETE FROM `page_text` WHERE ID IN (4000, 4001, 4002);
INSERT INTO `page_text` (`ID`, `Text`, `NextPageID`, `VerifiedBuild`)VALUES
(4000, 'J\'aime séquestrer les recrues dans ma cave', 4001, 0),
(4001, 'J\'adore les rousses, c\'est donc pour cela que ma compagne ne l\'est pas. Logique !', 4002, 0),
(4002, 'J\'espère que mes recrues seront vraiment efficace pour une fois...', 0, 0);