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  
Razer-on

Karazhan PreQuest v češtině

Recommended Posts

(2.3.2 UDB 0.9.1 (337)rev. 5074)

Kdo má zájem o tento upraveny PreQuest v mem podaní překladu zde scripty:

1.Quest začíná u toho NPC: http://www.wowhead.com/?npc=17613

2.Mus9te splnit tento Q http://www.wowhead.com/?quest=9825 aby jste mohli ziskat nasledující Q

3.Přeloženo od http://www.wowhead.com/?quest=9824 až po..... -> http://www.wowhead.com/?quest=9837

4. Po ziskani The Master's Key můžete jit do Karazhanu

 

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_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` = 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);

update quest_template set QuestFlags=128, SpecialFlags=0 where entry=25000;

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;
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 (25000, 1941, 69, 70, 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);

 

:rolleyes: (my work R@zer for Aeternitas Project) (zde je popis co kde a jak plnit na tento prequest Karazhan CZ

edit: přidána ukázkaukazkaQKZ.JPG

Edited by Razer-on

Share this post


Link to post
Share on other sites

GJ, ale chtelo by to udelat malou korekturu ;)

navic, nevim, jestli je dobry oslovovat v Qstu mnoznym cislem

Share this post


Link to post
Share on other sites
GJ, ale chtelo by to udelat malou korekturu ;)

navic, nevim, jestli je dobry oslovovat v Qstu mnoznym cislem

Jasny mouchy sou.. ale nektery z tech Questu sou Group(skupinovy) tak je to v mnoznym je fakt ze nekde sem se uklep ale jak říkám mouchy ...

Share this post


Link to post
Share on other sites
Výborná práce :P

 

Něco pro Ascent by jsi neměl? :D

THX za pochvalu.. no na Ascent emulatoru nezarabam.. ale myslim že jsou nějaký převadče mezi databazema ... ja myslim že se tady najde nejakyej typek co to převede na pdoporu Acentu :innocent:

Share this post


Link to post
Share on other sites

Když překládáš questy, měl by ses zapojit do veřejného projektu. Když bude každý překládat na svém písečku nikdy se wow nepřeloží. Takže jestli chceš pomoct vyššímu záměru zkus se podívat sem:

baner_468_60.jpg

Share this post


Link to post
Share on other sites

No to jsem si myslel. Tak v tom případě bych ho zase odkázal na UDB projekt. Tak aby to bylo v originální databázi UDB. Podle mě je to takto jenom práce navíc po každé aktualizaci zjišťovat jestli to už na UDB opravili nebo ne a když ne tak to tam nahrávat, kontrolovat jestli je struktura databáze stejná atd. prostě dvojí práce, když to jde udělat v rámci projektu.

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  

×