[Release] The Real King [QUEST]

[Tobii]

This quest is made 100% by me.

UPDATE `creature_names` SET `entry` = '11699', `name` = 'Varian Wrynn', `subname` = 'King of Stormwind', `info_str` = '', `Flags1` = '0', `type` = '7', `family` = '0', `rank` = '0', `unk4` = '0', `spelldataid` = NULL, `male_displayid` = '16502', `female_displayid` = '0', `male_displayid2` = '0', `female_displayid2` = '0', `unknown_float1` = '1', `unknown_float2` = '1', `civilian` = '0', `leader` = NULL WHERE `entry` = 11699 LIMIT 1;
UPDATE `creature_proto` SET `entry` = '11699', `minlevel` = '70', `maxlevel` = '70', `faction` = '1770', `minhealth` = '7680', `maxhealth` = '7680', `mana` = '0', `scale` = '1', `npcflags` = '2', `attacktime` = '2300', `attacktype` = '0', `mindamage` = '159', `maxdamage` = '228', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `mountdisplayid` = '0', `equipmodel1` = '23174', `equipinfo1` = '33492482', `equipslot1` = '0', `equipmodel2` = '0', `equipinfo2` = '0', `equipslot2` = '0', `equipmodel3` = '0', `equipinfo3` = '0', `equipslot3` = '0', `respawntime` = '360000', `armor` = '0', `resistance1` = '0', `resistance2` = '0', `resistance3` = '0', `resistance4` = '0', `resistance5` = '0', `resistance6` = '0', `combat_reach` = '1', `bounding_radius` = '1', `auras` = '0', `boss` = '0', `money` = '754', `invisibility_type` = '0', `death_state` = '0', `walk_speed` = '2.5', `run_speed` = '8', `fly_speed` = '14', `extra_a9_flags` = '0' WHERE `entry` = 11699 LIMIT 1;
UPDATE `creature_names` SET `entry` = '6006002', `name` = 'Anduin Wrynn', `subname` = 'King of Stormwind', `info_str` = '', `Flags1` = '0', `type` = '7', `family` = '0', `rank` = '0', `unk4` = '0', `spelldataid` = NULL, `male_displayid` = '11655', `female_displayid` = '0', `male_displayid2` = '0', `female_displayid2` = '0', `unknown_float1` = '1', `unknown_float2` = '1', `civilian` = '0', `leader` = NULL WHERE `entry` = 6006002 LIMIT 1;
UPDATE `creature_proto` SET `entry` = '6006002', `minlevel` = '5', `maxlevel` = '5', `faction` = '12', `minhealth` = '1459', `maxhealth` = '1459', `mana` = '0', `scale` = '1', `npcflags` = '2', `attacktime` = '1960', `attacktype` = '0', `mindamage` = '11', `maxdamage` = '14.19', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `mountdisplayid` = '0', `equipmodel1` = '23174', `equipinfo1` = '0', `equipslot1` = '0', `equipmodel2` = '23174', `equipinfo2` = '0', `equipslot2` = '0', `equipmodel3` = '0', `equipinfo3` = '0', `equipslot3` = '0', `respawntime` = '360000', `armor` = '0', `resistance1` = '0', `resistance2` = '0', `resistance3` = '0', `resistance4` = '0', `resistance5` = '0', `resistance6` = '0', `combat_reach` = '1', `bounding_radius` = '0', `auras` = '0', `boss` = '0', `money` = '0', `invisibility_type` = '0', `death_state` = '0', `walk_speed` = '2.5', `run_speed` = '8', `fly_speed` = '14', `extra_a9_flags` = '0' WHERE `entry` = 6006002 LIMIT 1;
UPDATE `creature_names` SET `entry` = '6006005', `name` = 'Stormwind Royal Elite Guard', `subname` = '', `info_str` = '', `Flags1` = '0', `type` = '7', `family` = '0', `rank` = '0', `unk4` = '0', `spelldataid` = NULL, `male_displayid` = '3167', `female_displayid` = '0', `male_displayid2` = '0', `female_displayid2` = '0', `unknown_float1` = '1', `unknown_float2` = '1', `civilian` = '0', `leader` = NULL WHERE `entry` = 6006005 LIMIT 1;
UPDATE `creature_proto` SET `entry` = '6006005', `minlevel` = '70', `maxlevel` = '70', `faction` = '11', `minhealth` = '50000', `maxhealth` = '100000', `mana` = '0', `scale` = '1.5', `npcflags` = '0', `attacktime` = '1410', `attacktype` = '0', `mindamage` = '1934', `maxdamage` = '2153', `rangedattacktime` = '0', `rangedmindamage` = '0', `rangedmaxdamage` = '0', `mountdisplayid` = '0', `equipmodel1` = '7483', `equipinfo1` = '0', `equipslot1` = '0', `equipmodel2` = '2080', `equipinfo2` = '0', `equipslot2` = '0', `equipmodel3` = '0', `equipinfo3` = '0', `equipslot3` = '0', `respawntime` = '360000', `armor` = '0', `resistance1` = '0', `resistance2` = '0', `resistance3` = '0', `resistance4` = '0', `resistance5` = '0', `resistance6` = '0', `combat_reach` = '1', `bounding_radius` = '0', `auras` = '0', `boss` = '0', `money` = '0', `invisibility_type` = '0', `death_state` = '0', `walk_speed` = '2.5', `run_speed` = '8', `fly_speed` = '14', `extra_a9_flags` = '0' WHERE `entry` = 6006005 LIMIT 1;
UPDATE `quests` SET `entry` = '6006004', `ZoneId` = '0', `sort` = '0', `flags` = '2', `MinLevel` = '70', `questlevel` = '70', `Type` = '1', `RequiredRaces` = '1791', `RequiredClass` = '1503', `RequiredTradeskill` = '0', `RequiredRepFaction` = '0', `RequiredRepValue` = '0', `LimitTime` = '0', `SpecialFlags` = '0', `PrevQuestId` = '0', `NextQuestId` = '0', `srcItem` = '0', `SrcItemCount` = '0', `Title` = 'The new king', `Details` = 'Hello $N. So, someone finally found me. As you can see this isn\'t a place for a king, but my guards failed to protect me, and some members of the Defias Clan took me here. I\'ve been here for a very long time. During that time, I was thinking a lot about how to gain power. I\'ve learned that the true way to get power is revenge! I want you, $C, to kill my son, to regain my place as a king, to rule Stormwind City with an iron fist. Of course, you\'ll be rewarded for your job. You can find my son in the Royal Library at Stormwind Keep. He\'s surrounded by Royal Elite Guards so watch out my friend. And How do I know all this, you ask? During the time I was here, The Defias Clan has been spying about for me. I know the child in the Keep is selected by the people of Stormwind. and will be replased the second he die. Go, go and do what has to be done!', `Objectives` = 'Find Anduin Wrynn, at the Royal Library in Stormwind Keep and kill him. He\'s surrounded by Royal Elite Guards so watch out.', `CompletionText` = 'Oh, you have returned! This is the time to strike! Be prepared Stormwind! This will be the fight of your life!!', `IncompleteText` = 'You still need to kill my son! Go, before you are the one there will be killed!', `EndText` = '', `ObjectiveText1` = '', `ObjectiveText2` = '', `ObjectiveText3` = '', `ObjectiveText4` = '', `ReqItemId1` = '0', `ReqItemId2` = '0', `ReqItemId3` = '0', `ReqItemId4` = '0', `ReqItemCount1` = '0', `ReqItemCount2` = '0', `ReqItemCount3` = '0', `ReqItemCount4` = '0', `ReqKillMobOrGOId1` = '6006002', `ReqKillMobOrGOId2` = '0', `ReqKillMobOrGOId3` = '0', `ReqKillMobOrGOId4` = '0', `ReqKillMobOrGOCount1` = '1', `ReqKillMobOrGOCount2` = '0', `ReqKillMobOrGOCount3` = '0', `ReqKillMobOrGOCount4` = '0', `ReqCastSpellId1` = '0', `ReqCastSpellId2` = '0', `ReqCastSpellId3` = '0', `ReqCastSpellId4` = '0', `RewChoiceItemId1` = '600597', `RewChoiceItemId2` = '6006002', `RewChoiceItemId3` = '6006003', `RewChoiceItemId4` = '6006004', `RewChoiceItemId5` = '6006005', `RewChoiceItemId6` = '6006006', `RewChoiceItemCount1` = '1', `RewChoiceItemCount2` = '1', `RewChoiceItemCount3` = '1', `RewChoiceItemCount4` = '1', `RewChoiceItemCount5` = '1', `RewChoiceItemCount6` = '1', `RewItemId1` = '0', `RewItemId2` = '0', `RewItemId3` = '0', `RewItemId4` = '0', `RewItemCount1` = '0', `RewItemCount2` = '0', `RewItemCount3` = '0', `RewItemCount4` = '0', `RewRepFaction1` = '0', `RewRepFaction2` = '72', `RewRepValue1` = '0', `RewRepValue2` = '-10000', `RewRepLimit` = '0', `RewMoney` = '500000000', `RewXP` = '0', `RewSpell` = '0', `CastSpell` = '0', `PointMapId` = '0', `PointX` = '0', `PointY` = '0', `PointOpt` = '0', `RequiredMoney` = '0', `ExploreTrigger1` = '0', `ExploreTrigger2` = '0', `ExploreTrigger3` = '0', `ExploreTrigger4` = '0', `RequiredQuest1` = '0', `RequiredQuest2` = '0', `RequiredQuest3` = '0', `RequiredQuest4` = '0', `ReceiveItemId1` = '0', `ReceiveItemId2` = '0', `ReceiveItemId3` = '0', `ReceiveItemId4` = '0', `ReceiveItemCount1` = '0', `ReceiveItemCount2` = '0', `ReceiveItemCount3` = '0', `ReceiveItemCount4` = '0', `IsRepeatable` = '0' WHERE `entry` = 6006004 LIMIT 1;
DELETE FROM `creature_quest_starter` WHERE `id` = 11699;
DELETE FROM `creature_quest_finisher` WHERE `id` = 11699;
INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES ('11699', '6006004');
INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES ('11699', '6006004');

Or download SQL file here DOWNLOAD QUEST HERE

Quest Info:

Hello $N. So, someone finally found me. As you can see this isn't a place for a king, but my guards failed to protect me, and some members of the Defias Clan took me here. I've been here for a very long time. During that time, I was thinking a lot about how to gain power. I've learned that the true way to get power is revenge! I want you, $C, to kill my son, to regain my place as a king, to rule Stormwind City with an iron fist. Of course, you'll be rewarded for your job. You can find my son in the Royal Library at Stormwind Keep. How do I know, you ask? During the time I was here, The Defias Clan has been spying about for me. I know the child in the Keep is selected by the people of Stormwind. Go. Go and do what has to be done!

Spawn ID's:
11699 : Varian Wrynn (Place him if you can't fine the one in the cave)
6006002 : Anduin Wrynn (Place him in the royal library, the original can't be killed)
6006005 : Stormwind Royal Elite Guard (Place some to protect Anduin Wrynn)

How to add the quest to Varian Wrynn: (only if it isn't done auto)
.quest addboth 6006004 (Need's to be selected) (This will add the start and finish to Varian Wrynn)

UPDATE `quests` SET `entry` = '6006004', `ZoneId` = '0', `sort` = '0', `flags` = '2', `MinLevel` = '70', `questlevel` = '70', `Type` = '1', `RequiredRaces` = '1791', `RequiredClass` = '1503', `RequiredTradeskill` = '0', `RequiredRepFaction` = '0', `RequiredRepValue` = '0', `LimitTime` = '0', `SpecialFlags` = '0', `PrevQuestId` = '0', `NextQuestId` = '0', `srcItem` = '0', `SrcItemCount` = '0', `Title` = 'The new king', `Details` = 'Hello $N. So, someone finally found me. As you can see this isn\'t a place for a king, but my guards failed to protect me, and some members of the Defias Clan took me here. I\'ve been here for a very long time. During that time, I was thinking a lot about how to gain power. I\'ve learned that the true way to get power is revenge! I want you, $C, to kill my son, to regain my place as a king, to rule Stormwind City with an iron fist. Of course, you\'ll be rewarded for your job. You can find my son in the Royal Library at Stormwind Keep. He\'s surrounded by Royal Elite Guards so watch out my friend. And How do I know all this, you ask? During the time I was here, The Defias Clan has been spying about for me. I know the child in the Keep is selected by the people of Stormwind. and will be replased the second he die. Go, go and do what has to be done!', `Objectives` = 'Find Anduin Wrynn, at the Royal Library in Stormwind Keep and kill him. He\'s surrounded by Royal Elite Guards so watch out.', `CompletionText` = 'Oh, you have returned! This is the time to strike! Be prepared Stormwind! This will be the fight of your life!!', `IncompleteText` = 'You still need to kill my son! Go, before you are the one there will be killed!', `EndText` = '', `ObjectiveText1` = '', `ObjectiveText2` = '', `ObjectiveText3` = '', `ObjectiveText4` = '', `ReqItemId1` = '0', `ReqItemId2` = '0', `ReqItemId3` = '0', `ReqItemId4` = '0', `ReqItemCount1` = '0', `ReqItemCount2` = '0', `ReqItemCount3` = '0', `ReqItemCount4` = '0', `ReqKillMobOrGOId1` = '6006002', `ReqKillMobOrGOId2` = '0', `ReqKillMobOrGOId3` = '0', `ReqKillMobOrGOId4` = '0', `ReqKillMobOrGOCount1` = '1', `ReqKillMobOrGOCount2` = '0', `ReqKillMobOrGOCount3` = '0', `ReqKillMobOrGOCount4` = '0', `ReqCastSpellId1` = '0', `ReqCastSpellId2` = '0', `ReqCastSpellId3` = '0', `ReqCastSpellId4` = '0', `RewChoiceItemId1` = '600597', `RewChoiceItemId2` = '6006002', `RewChoiceItemId3` = '6006003', `RewChoiceItemId4` = '6006004', `RewChoiceItemId5` = '6006005', `RewChoiceItemId6` = '6006006', `RewChoiceItemCount1` = '1', `RewChoiceItemCount2` = '1', `RewChoiceItemCount3` = '1', `RewChoiceItemCount4` = '1', `RewChoiceItemCount5` = '1', `RewChoiceItemCount6` = '1', `RewItemId1` = '0', `RewItemId2` = '0', `RewItemId3` = '0', `RewItemId4` = '0', `RewItemCount1` = '0', `RewItemCount2` = '0', `RewItemCount3` = '0', `RewItemCount4` = '0', `RewRepFaction1` = '0', `RewRepFaction2` = '72', `RewRepValue1` = '0', `RewRepValue2` = '-10000', `RewRepLimit` = '0', `RewMoney` = '500000000', `RewXP` = '0', `RewSpell` = '0', `CastSpell` = '0', `PointMapId` = '0', `PointX` = '0', `PointY` = '0', `PointOpt` = '0', `RequiredMoney` = '0', `ExploreTrigger1` = '0', `ExploreTrigger2` = '0', `ExploreTrigger3` = '0', `ExploreTrigger4` = '0', `RequiredQuest1` = '0', `RequiredQuest2` = '0', `RequiredQuest3` = '0', `RequiredQuest4` = '0', `ReceiveItemId1` = '0', `ReceiveItemId2` = '0', `ReceiveItemId3` = '0', `ReceiveItemId4` = '0', `ReceiveItemCount1` = '0', `ReceiveItemCount2` = '0', `ReceiveItemCount3` = '0', `ReceiveItemCount4` = '0', `IsRepeatable` = '0' WHERE `entry` = 6006004 LIMIT 1;

## = Make them to 0 before you put in to DB or change to custom weapon ID.

Warning: This quest can be done by alliance if they turn on "At war" with stormwind! But when the quest is finished they will get -100000 REP with stowmwind

If you need help leav a comment and i will see what i can do!

[2dgreengiant]

awesome , i liked your friend also

[Tobii]

hehe, damn they are anoying! i can't take screeny.. xD

[Gastricpenguin]

Tobii, you just gave me one hell of an idea. Once its ready- you'll get soooo much credit Heres some rep for the idea xD

[2dgreengiant]

i want in on this idea as i said this was good first

[Lich King]

nice, good job +Rep

[Hellgawd]

I also want in on your idea, Gastric! ^^
As well, +4Rep, this is an awesome quest!

[MysterioussouL]

good job +Rep x3

[King Shaun]

Nice quest, just one thing...

I am the only real KING!

Otherwise, nice work!

Rep cookehs for you! (X7)

Edit: Pfft, cannot give to you, must spread.

[kate1]

awsome m8, and +rep cake with candles for you.

[Tom_2001]

This is great

[Tobii]

Nice quest, just one thing...

I am the only real KING!

Otherwise, nice work!

Rep cookehs for you! (X7)

Edit: Pfft, cannot give to you, must spread.

I think i survive..