Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
Followers 0
Razer-on

Karazhan PreQuest Kompletně v CZ pro 2.3.3

By Razer-on, in MaNGOS

Recommended Posts

Razer-on    0

Razer-on
Posted

=(2.3.3 UDB 0.9.1 (341)rev. 5400+)= testováno

Druhá verze překladu optimalizovaná pro 2.3.3 patch , s vlastníma úpravama Q

Přeložená Serie Q do CZ:

Kzserie.JPG

 

SQL scripty:

REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `ExtendedCost`, `RequiredArenaRank`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES (24474, 0, 0, -1, 'Violet Scrying Crystal', 37219, 1, 64, 1, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32042, 0, 0, 0, 5000, 0, 5000, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 4, '', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, '', 0, 0, 0, 0);

DELETE FROM `creature` WHERE `id`=22890;
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`spawn_position_x`,`spawn_position_y`,`spawn_position_z`,`spawn_orientation`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
(92405, 22890, 555, 0, 0, -107.136, -507.261, 21.4762, 3.01357, 25, 0, 0, -107.136, -507.261, 21.4762, 0, 5000, 0, 0, 0);

DELETE FROM `creature_loot_template` WHERE (`entry`=22890);
INSERT INTO `creature_loot_template` VALUES 
(22890, 24514, 0, 100, 1, 1, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9824;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9824;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9824;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9824);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9824;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9824;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17613, 9824);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17613;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9824, 2562, 68, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 132, 0, 0, 9826, -9824, 9826, 24474, 1, 0, 'Arcane Disturbances', 'Hledam jeden Krystal. Je velice vzacny a jeho zvlastnosti je ze mi doda zapomenutou Karazhan energii, diky niz pak muzu ozivit jednoho ze svych mrtvych pratel. $B$BKrystal mas urcite v baglu tak ho najdi a ja te odmenim.$B$B', 'Odevzdej Krystal pravoplatnemu majteli.', 'Ok vidim ze jsi na spravne ceste jit za svym cilem, $N.$B', 'Tak co nasel si ho, $N. nebo ne?', '', '', '', '', '', 0, 0, 24474, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44000, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9825;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9825;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9825;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9825);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9825;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9825;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17613, 9825);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17613;
DELETE FROM `quest_template` WHERE `entry` = 9825;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9825, 2562, 68, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 9826, -9824, 0, 0, 0, 0, 'Restless Activity', 'Jak jsi mozna zpozoroval, okoli Karazhanu je plne bloudicich dusi. Nikdo nevi jak se tu vubec odcitli!$B$BPrines mi jejich duchovni esenci abych mohl studovat jejich mysleni.   Karazhan ma mnoho tajemstvi, $N.   Ja jsem odhodlany odkryt vsechny z nich.', 'Prines 10x Ghostly Essences k Archmage Alturus-ovi, ktery stoji pred Karazhanem.', 'Ja studuji tyto esence, $N. Dekuji ti za tvou pomoc.', 'Mate uz duchovni essence, ktere potrebuju ke studovani, $N?', '', '', '', '', '', 24480, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 250, 0, 0, 0, 0, 44000, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9826;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9826;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9826;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9826);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9826;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9826;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18165, 9826);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18165;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9826, 279, 68, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 132, 0, 0, 0, 0, 9829, 24482, 1, 0, 'Contact from Dalaran', 'Cawf, $N.$BJeden agent v utajeni pobyvajici v Kirin Toru, Magus Senate of Dalaran.  Byli jsme prirazeni k tomu, abychom drzeli ok Karazhanu a Medivh ho mel v propade, ze veci vymkly se z rukou.$B$BStalo se mnoho zahadnych veci po tom co Medvih zmizel.$BTato zprava obsahuje detaily mych nalezu. Vem to Archmage Cedric, i s Violet Eye, najdes ho nekde v okrajovych mistech Dalaranu.', 'Alturusova zprava pro Archmage Cedricv v okrajovych mistech Dalaranu.', 'Vy vite o Violet Eye?', 'Nasel si Archmage Cedricv, $N. ?', '', '', '', '', '', 24482, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 37500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9829;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9829;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9829;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (18165, 9829);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 18165;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9829;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9829;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18166, 9829);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18166;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9829, 3703, 68, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9826, 0, 0, 9831, 0, 0, 0, 'Khadgar', 'Nepochybne z Karazhanu uprchlo hodne demonske energie a my to ted musime proverit.$B$BJedini lide, kteri mohou znovu otevrit Karazhan byl domele mrtvi: Khadgar a Medivh.$B$BAz do nedavna... dovedeli jsme se od ucen Khadgara, ze je nazivu a a je v miste nazvanem Shattrath City. Najdi ho a dejte mu Alturus- ovu zpravu.', 'Doruc Alturusovu zpravu Khadgar-ovi v Shattrath City v Terokkar Forest.', 'Ukaz mi co jsi dorucil...?$B', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 37500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9831;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9831;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9831;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (18166, 9831);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 18166;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9831;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9831;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18166, 9831);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18166;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9831, 3789, 68, 70, 81, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9829, 0, 0, 9832, 0, 0, 0, 'Entry Into Karazhan', 'Tahle zprava neni moc povzbudiva, $N.  Ziskat vstup do Karazhaun bude obtizny, at tak nebo onak.$B$BMusel sem klic rozdelit na tri kusy fragmenu ktere potrebuje ziskat aby jste se mohli dostat dale.$B$BPrvni ulomek je v  Auchindounu ktera je prevzata z Shadow rady.$B$BVrat mi muj ulomek.....', 'Khadgar chce abyste vstoupili do Shadow Labyrinth v Auchindoun a znovu ziska First Key Fragment z Arcane Container ktery je tam ukryt.', 'Velmi dobre, $N.', 'Mas prome ulomek, $c?', '', '', '', '', '', 24514, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9832;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9832;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9832;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (18166, 9832);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 18166;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9832;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9832;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18166, 9832);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18166;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9832, 3703, 68, 70, 81, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9831, 0, 0, 25000, 0, 0, 0, 'The Second and Third Fragments', 'Ja jsem ukryl druhy zlomek na spodu Serpent Lake, davno pred tim nez se toto misto tak nazyvalo. Obrovsky odtok ktery tam je prevzal nejpis pod dohled vladce hlubin Coilfang Reservoir i s nadobou ve ktere je druhy ulomek.$B$BTreti ulomek opravdu otestuje tvoji odvahu, je totiz ukryt v Tempest keepu kteremu nyni vladne  Kael\'thas.$B$BPrines mi tyto zbyvajici casti fragmentu, $N. Zavisi to vse na vasem uspechu.', 'Ziskejte druhy Key Fragment z Arcane Container uvnitr Coilfang Reservoir a treti Key Fragment z Arcane Container uvnitr Tempest Keep.   Vrat to Khadgar v Shattrath Citya potom dokoncete tento tento ukol.', 'Jste opravdu spravnymi drziteli klice, $N.Jste hodni pro vstup do Karazhanu.$BAle jeste je jeden mensi problmek....', 'Jak jde vase hledani ulomku z fragmentu, $N?', '', '', '', '', '', 24487, 24488, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 350, 0, 0, 0, 0, 0, 94800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `quest_template` WHERE (`entry`=10737);
DELETE FROM `creature_questrelation` WHERE (`quest`=10737);
DELETE FROM `gameobject_questrelation` WHERE (`quest`=10737);
DELETE FROM `creature_involvedrelation` WHERE (`quest`=10737);
DELETE FROM `gameobject_involvedrelation` WHERE (`quest`=10737);
DELETE FROM `areatrigger_involvedrelation` WHERE (`quest`=10737);

DELETE FROM `quest_template` WHERE (`entry`=9836);
DELETE FROM `creature_questrelation` WHERE (`quest`=9836);
DELETE FROM `gameobject_questrelation` WHERE (`quest`=9836);
DELETE FROM `creature_involvedrelation` WHERE (`quest`=9836);
DELETE FROM `gameobject_involvedrelation` WHERE (`quest`=9836);
DELETE FROM `areatrigger_involvedrelation` WHERE (`quest`=9836);

DELETE FROM `creature_questrelation` WHERE `quest` = 25000;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 25000;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 25000;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (18166, 25000);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 18166;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 25000;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 25000;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (15608, 25000);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=15608;
DELETE FROM `quest_template` WHERE `entry` = 25000;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (25000, 1941, 69, 70, 81, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 9832, 0, 0, 9837, 0, 0, 0, 'The Master\'s Touch', 'Takze jste sestavili cely klic,ktery jsem pouzil jako ucen.$B$BBez Medivh- ovo souhlasu, je ale klic bezcenny.   Ano, samozrejme, ja vim, ze Medivh je mrtvy. Toto jenom dela veci obtiznejsi ale ne nemozne.$B$BV Azerothu je misto nazyvane Caverns of Time, hlidane bronzovymi dragonflighty.Najdete cestu, a cestujte zpet v case a najdete Medviha, ktery vam klic aktivuje.', 'Jdete do Caverns of Time a presvecte Medivha aby vam klic aktivoval.', 'Ten klic, znam ho. To je Kadghar-uv klic...', 'Kdo jste a co chcete?', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 350, 0, 0, 0, 0, 0, 94800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9837;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9837;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9837;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (15608, 9837);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 15608;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9837;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9837;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18166, 9837);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18166;
REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9837, 3703, 69, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 25000, 0, 0, 9838, 0, 0, 0, 'Return to Khadgar', 'Zda se, ze mam vzpominky z budoucnosti o tomto klici.$B$B<Medivh se diva na tebe a vidi te jako ducha.>$B$BMate ovsem zkusenosti z casu predvami, $N.   Nechejte nas doufat ve vasi silu a uspech.$B$BKhadgaruv klic byl v nejlepsich rukou a nemohl doufat v lepsiho ucne.$B$BPredpokladejme, ze potrebujete vlastni klice.$B$B<Medivh sahne do roucha a vyda vam vas vlastni klic.>$B$BHodne zdaru a hodne stesti ....budeteho ve velke mire potrebovat, $c.', 'Vratit se ke Khadgaru v Shattrath City.', 'Jeho vlastni klic? To je neuveritelne!$B$BOvsem ted uz neni navrat zpet, $N. Klic je vas a jen vas.', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24490, 0, 0, 0, 1, 0, 0, 0, 967, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 114000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9838;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9838;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9838;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (18166, 9838);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 18166;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9838;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9838;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17613, 9838);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17613;
DELETE FROM `quest_template` WHERE `entry` = 9838;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9838, 2562, 69, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9837, 0, 0, 9840, 0, 0, 0, 'The Violet Eye', 'Velka zodpovednost byla na vas nyni uvrzena, $N.$BJestli naznaky, toho co Violet Eye videla, pak by se hodila pomoc.$B$BI pres hadky s Cedricem, se zda byt ze se do Karazahanu opet vrati temne casy .Proto se vrate k Alturusovi  a pomocte mu jakymkoliv zpusobem.', 'Promluv s Archmage Alturusem pred Karazhanem.', 'Ja poslu doporucenou zpravu a vy se vratite s klicem opet na toto misto? $N.', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 75, 0, 0, 0, 0, 0, 37500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9840;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9840;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9840;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9840);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9840;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9840;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (16388, 9840);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=16388;
DELETE FROM `quest_template` WHERE `entry` = 9840;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9840, 2562, 69, 70, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9838, 0, 0, 9843, 0, 0, 0, 'Assessing the Situation', 'Ted, kdyz jsme nasli cestu zpet do Medivh- ovy veze - nebo spise vy- Takbychom potrebovali nastinint situaci toho co se deje uvnitr.$B$BJeden z nasich agentu, kteremu se podarilo infiltrovat do Karazhanu pozoroval deni v kmenu Keanan, ale byl zabit.nyni novy agent Koren - Karazhansky kovar- je pod nasim utajenim, pokuste se ho vyhledat uvnitr Karazhanu.', 'Najdi Korena uvnitr Karazhanu.', '<Koren se na tebe diva s nejistym pohledem.>$B$BJa nevim nic o Violet Eye. jsem nic vic nez kovar.', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9843;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9843;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9843;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (16388, 9843);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 16388;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9843;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9843;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17613, 9843);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17613;
DELETE FROM `quest_template` WHERE `entry` = 9843;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9843, 2562, 70, 70, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 9840, 0, 0, 9844, 0, 0, 0, 'Keanna\'s Log', 'Keanna?$Bja se nikdy nesetkal s timto jmenem. Ale rika se ze nekdo s timto jmenem pobyva v komnatach pro hosty.$BA o Violet Eye jsem bohuzel nikdy neslysel.$B$BA ja bych se ted zas vratil ke sve praci, dovolite - li.', 'Hledejte v komnatach pro hosty uvnitr Karazhanu kde by mely byt informace ke Keanna  kmenu a pote je prineste k Archmage Alturusovi pred Karazhanem.', 'Nasli jste kmen. doufam ze informace ktere mate jsou duveryhodne, $N.', 'Nasel si Keanna\'s log... ?', '', '', '', '', '', 24492, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 967, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9844;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9844;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9844;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9844);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9844;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9844;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17613, 9844);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17613;
DELETE FROM `quest_template` WHERE `entry` = 9844;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9844, 2562, 70, 70, 62, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 9843, 0, 0, 9860, 0, 0, 0, 'A Demonic Presence', 'Keanna-ovi zaznamy potvrzuji nase podezreni z demonicke pritomnosti uvnitr Karazhanu.$B$BPlamene Legie agent popisuje prichodem z vrcholu veze.$B$BKarazhan je velmi ulezite misto, $c. Je to portal do onen svetu. Mozne nasledky v cizich rukou jsou nemyslitelne. Tyto demonicke vyboje museji byt zastaveny.   A vy, $N, jste jediny kdo ma klic.', 'Archmage Alturus chce abyste znicili zdroj demonicke moci na vrcholu Karazhanu...', 'Vy jste to dokazali! Ano!$B$BTyto zpravy musite dat Cedricovi. Jsem zaujat vasim uspechem.', '', '', 'Zabij Prince Malchezaara', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15690, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 44000, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

DELETE FROM `creature_questrelation` WHERE `quest` = 9860;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9860;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9860;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17613, 9860);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17613;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9860;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9860;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (18165, 9860);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=18165;
DELETE FROM `quest_template` WHERE `entry` = 9860;
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqSourceRef1`, `ReqSourceRef2`, `ReqSourceRef3`, `ReqSourceRef4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (9860, 279, 70, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 9844, 0, 0, 0, 0, 0, 0, 'The New Directive', 'Pomoc, kterou jste poskytli Violet Eye nebude bezodmeny.$B$BVymyslete co by ste chteli dostat od nasi organizace, $c, ale odmenu ziskate az  od Archmage Cedric v Dalaranu.', 'Promluv s Archmage Cedrickem v Dalaranu.', 'Alturus mi rekl,vse co se stalo, $N. Ale to neni konec.... Je jen otazka casu kdy Plamene legie opet obnovi demonickou moc.$B$B<Cedric vam dava odmenu se znakem Violet Eye.>$B$BCo rikas, $N?', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31113, 0, 0, 0, 1, 0, 0, 0, 967, 0, 0, 0, 0, 3000, 0, 0, 0, 0, 132000, 114000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0);

 

 

(cely je to moje práce : R@zer for Aeternitas Project) (zde je popis co kde a jak plnit na tento prequest Karazhan CZ

ukázkaukazkaQKZ.JPG

 

Třeba se Vám to hodí...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing MaNGOS
×