TrinityCore/TrinityCore — Issue #4816: [DB/FIX][GOBJECT] The Worst Mage In Dalaran - A Children's Book
Author: Valcorb
Created: 2012-01-14 14:19:54+00:00
State: open

```sql

-- [BOOK] The Worst Mage In Dalaran - A Children's Book

-- Adding text
-- Text is coming from Wowhead comments
DELETE FROM `page_text` WHERE `entry` BETWEEN 5000 AND 5008;
INSERT INTO `page_text` (`entry`, `text`, `next_page`, `WDBVerified`)
VALUES
(5000, "The Worst Mage in Dalaran: A Children's Book", 5001, 12340),
(5001, "Once upon a time there lived a mage who could not cast fireball, polymorph or frostbolt. When he conjured water, it came out as mud. Hist attempts at arcane intellect made the subjects stuipder. Without any doubt, his tutors agreed that their pupil, Bungledorf, was the worst mage in Dalaran.", 5002, 12340),
(5002, "Bungledorf had come to learn with great hopes. He guzzled mana potions before class, mistakenly believing they would increase his skill. But all they ever increased was the number of times he accidentally burped during the important invocations, often setting classmates robes ablaze or turning his teacher's beard into sheep's wool in the process.", 5003, 12340),
(5003, "At his first exam, Bungledorf was asked to cast frost armor correctly. The other students shifted in their seats fearfully as he began the incantation. A blue fog encompassed the young lad and for a moment it looked as though he had succeeded. But then he began to shiver and sneeze violently, and everyone finally realized: He had given himself frostbite.", 5004, 12340),
(5004, "One day Bungledorf was in the park, wondering whether he was cut out to be a mage. He saw some children playing nearby and remembered his dream of being a powerful spellcaster. 'Yes,' he thought. 'I can do it: I just need to try harder!' He looked for something to practice on and noticed an unusual tree before him. Summoning his courage, Bungledorf began casting a spell on it. He shut his eyes, afraid to see the result...", 5005, 12340),
(5005, "When he finally looked, the tree was replace with a beautiful night elf. 'It worked!' He cried, 'It's transformed! I am a mage after all!'", 5006, 12340),
(5006, "The Night Elf was confused for a moment and then smiled at him gently, 'I am a druid, young one. We take other forms by our own will.'", 5007, 12340),
(5007, "Bungledorf blushed and stepped away, only to trip over his robes and fall headfirst into the lawn. A chorus of giggles greeted him as he adjusted his long pointed cap and shuffled off toward the dormitory, his head hanging low.", 5008, 12340),
(5008, "The Night Elf Lingered, pondering the boy. When she turned to leave, she caught her foot in something, and nearly lost her balance. Surprised at the unfamiliar obstacle, she looked down to see a glistening crop of mageroyal. It's petals slowly unfurling into full bloom, where moments ago there had been nothing. She wondered at this, and then realizing, turned back in the direction of Bungledorf had been walking, but the young mage was already gone.", 0, 12340);

-- Update data in gameobject_template
UPDATE `gameobject_template` SET `type`=9, `data0`=5000, `data1`=0, `data2`=1 WHERE `entry`=192706;