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:  

Razer-on

Members
  • Content count

    30
  • Joined

  • Last visited

Community Reputation

0 Průměrný uživatel

About Razer-on

  • Rank
    Level 3

Contact Methods

  • Website URL
    http://razerwow.ic.cz
  1. Mangos se nechce spustit (ubuntu)

    tyhle chyby by mela opravit DB co vynde na 2.4.3 2008-08-02 14:42:17 ERROR:Item (Entry: 8498) not correct 20655 display id, must be 44666 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 10822) not correct 20655 display id, must be 51621 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 27515) not correct 38900 display id, must be 50502 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 27516) not correct 38895 display id, must be 50501 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 33808) not correct 47014 display id, must be 51920 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 33868) not correct 47131 display id, must be 51758 (using it). 2008-08-02 14:42:17 ERROR:Item (Entry: 33955) not correct 47136 display id, must be 7744 (using it). Tvuj item... 2008-08-02 14:42:17 ERROR:Item (Entry: 500100) not correct (not listed in list of existed items). A tyhle chyby opravíš -> viz níže: (vzniká spawnutím nových NPC a v DB jim automaticky nastaví spawntime na 25s.. ) 2008-08-02 14:42:19 ERROR:Table `creature` have creature (GUID: 1238849 Entry: 18772) with `MovementType`=1 (random movement) but with `spawndist`=0, replace by idle movement type (0). 2008-08-02 14:42:19 ERROR:Table `creature` have creature (GUID: 1238851 Entry: 18771) with `MovementType`=1 (random movement) but with `spawndist`=0, replace by idle movement type (0). 2008-08-02 14:42:19 ERROR:Table `creature` have creature (GUID: 1245790 Entry: 18907) with `MovementType`=1 (random movement) but with `spawndist`=0, replace by idle movement type (0). 2008-08-02 14:42:19 ERROR:Table `creature` have creature (GUID: 1245775 Entry: 18907) with `MovementType`=1 (random movement) but with `spawndist`=0, replace by idle movement type (0). 2008-08-02 14:42:19 ERROR:Table `creature` have creature (GUID: 1238270 Entry: 3473) with `MovementType`=1 (random movement) but with Fix: UPDATE `creature` SET `spawntimesecs` = 300, `spawndist` = 5 WHERE `id` IN ('18771','18772','18907','3473');
  2. Hunter

    o5 edit.... zkus jeste nahrat jinou revizi...
  3. to TommyAnders:Pěkná práce .... v learn: .learn all_game - Naučíte se všechny spelly pro GM. .. díval sem se na to jen letmo ale myslim že tohle bys měl mít .learn all_gm a ne game
  4. [SD2] EventAI

    Chtělo by aktualizovat Topick .. v SD2 je spousta nových příkazů a řazení sloupců.. chtelo by to editnout se stavajicimi novymi verzemi.. novdymu sem psal PM už cca před 2ema mesici tak nwm nwm..
  5. NPC na cestě

    no tohle asi nenamacruješ .. musíš si označait daný NPC a buď : .guid a pak .addmove a GUID .. tím uděláš trasu... ale abys to měl vymakaný tak se to dělá přes Event_AI scripty ktery sou v ScripDev2 DB .. tam je ta editace težší a doporučuju porčíst na to návod od autora ,,navdy,,: Event_Ai Script Návod by Navdy
  6. Změna modelu NPC ingame

    jde to příkazem .morph a DisplayID .. ale to jen dočasný = po restartu bude mít zase NPC původní skin.. pokud chceš trvalý tak musíš udělat přes SQL ... a uplně nejjednouší bude když to uděláš přes editor Quice dištak tady máš SQL kterým můžeš změnit.. pak jen uložíš v xxx.sql nahraješ do DB a máš to.. UPDATE `creature_template` SET `modelid_A` = 99999(Tady je DysplaiId pro Ali), `modelid_H` = 99999(Tady je DysplaiId pro Hordu), WHERE `entry` = 721(Tady ID NPC který chceš změnit); Výsledek: Všichni Rabbiti- králíčci budou vypadat jako MC Boss Ragnaros UPDATE `creature_template` SET `modelid_A` = 11121, `modelid_H` = 11121 WHERE `entry` = 721;
  7. Weapon

    j taky sem se nudil...sice už je to delší dobu , ale na oživení topicku... takhle by "měl údajně" vypadat Ledový smutek na WoltK a tady v mém podaní škoda no až na ten DiplayID skinu.. :-D Frostmourne = .additem 78945614 SQL Script: DELETE FROM `item_template` WHERE (`entry`=78945614); INSERT INTO `item_template` VALUES (78945614, 2, 8, -1, 'Frostmourne', 35575, 6, 0, 1, 95012100, 9002400, 17, -1, -1, 200, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4, 135, 7, 168, 5, 95, 32, 170, 36, 125, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 704, 921, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3600, 0, 0, 30065, 1, 0, 0, -1, 0, -1, 41630, 1, 0, 0, -1, 0, -1, 43524, 2, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, 'Whomsoever takes up this blade shall wield power eternal.Just as the blade rends flesh, so must power scar the spirit. ', 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); R@zer Lich Set = .additem 10001 až 10005 (only for Fun jeho vzhled viz obrázek víše) SQl Script: -- Razer Lich Roba 10001 DELETE FROM `item_template` WHERE (`entry`=10001); INSERT INTO `item_template` VALUES (10001, 4, 1, -1, 'Razer Lich Roba', 43075, 5, 0, 1, 2, 3, 20, -1, -1, 200, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 2000, 5, 2000, 21, 2000, 0, 2000, 1, 2000, 3, 2000, 36, 2000, 20, 2000, 25, 2000, 25, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5000, 200, 200, 200, 200, 200, 200, 0, 0, 0, 13881, 1, 0, 0, -1, 0, -1, 37619, 1, 0, 0, -1, 0, -1, 38394, 1, 0, 0, -1, 0, -1, 38397, 1, 0, 0, -1, 0, -1, 31643, 1, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 800, 0, 0, 0, 0, 2, 0, 8, 0, 4, 0, 2889, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0); -- Razer Lich Ramena 10002 DELETE FROM `item_template` WHERE (`entry`=10002); INSERT INTO `item_template` VALUES (10002, 4, 1, -1, 'Razer Lich Ramena', 42443, 5, 0, 1, 2, 3, 3, -1, -1, 200, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 2000, 5, 2000, 21, 2000, 24, 2000, 22, 2000, 28, 2000, 35, 2000, 32, 2000, 27, 2000, 33, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6000, 200, 200, 200, 200, 200, 200, 0, 0, 0, 14799, 1, 0, 0, -1, 0, -1, 36385, 1, 0, 0, -1, 0, -1, 44917, 1, 0, 0, -1, 0, -1, 42974, 1, 0, 0, -1, 0, -1, 27984, 1, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 900, 0, 0, 0, 0, 4, 0, 2, 0, 0, 0, 2859, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0); -- Razer Lich Bombardaky 10003 DELETE FROM `item_template` WHERE (`entry`=10003); INSERT INTO `item_template` VALUES (10003, 4, 1, -1, 'Razer Lich Bombardaky', 43076, 5, 0, 1, 2, 3, 7, -1, -1, 200, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 2000, 5, 2000, 21, 2000, 15, 2000, 13, 2000, 14, 2000, 12, 2000, 24, 2000, 25, 2000, 26, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7000, 200, 200, 200, 200, 200, 200, 0, 0, 0, 18050, 1, 0, 0, -1, 0, -1, 33491, 1, 0, 0, -1, 0, -1, 44917, 1, 1, 0, -1, 0, -1, 42122, 1, 0, 0, -1, 0, -1, 34760, 1, 1, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 850, 0, 0, 0, 0, 2, 0, 4, 0, 8, 0, 1532, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0); -- Razer Lich Rukavice 10004 DELETE FROM `item_template` WHERE (`entry`=10004); INSERT INTO `item_template` VALUES (10004, 4, 1, -1, 'Razer Lich Rukavice', 43073, 5, 0, 1, 84536, 16907, 10, -1, -1, 200, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 2000, 5, 2000, 21, 2000, 6, 2000, 4, 2000, 3, 2000, 28, 2000, 33, 2000, 1, 2000, 14, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8000, 200, 200, 200, 200, 200, 200, 0, 0, 0, 14799, 1, 0, 0, -1, 0, -1, 38692, 1, 0, 0, -1, 0, -1, 33933, 1, 0, 0, -1, 0, -1, 27082, 1, 0, 0, -1, 0, -1, 33405, 1, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 950, 0, 0, 0, 0, 2, 0, 4, 0, 0, 0, 2859, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0); -- Razer Lich Helma 10005 DELETE FROM `item_template` WHERE (`entry`=10005); INSERT INTO `item_template` VALUES (10005, 4, 1, -1, 'Razer Lich Helma', 47014, 5, 0, 1, 2, 3, 1, -1, -1, 200, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 2000, 5, 2000, 17, 2000, 25, 2000, 27, 2000, 20, 2000, 13, 2000, 3, 2000, 1, 2000, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9999, 200, 200, 200, 200, 200, 200, 0, 0, 0, 28869, 1, 0, 0, -1, 0, -1, 18052, 1, 0, 0, -1, 0, -1, 26982, 1, 0, 0, -1, 0, -1, 43873, 1, 0, 0, -1, 0, -1, 15531, 1, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 999, 0, 0, 0, 0, 2, 0, 1, 0, 0, 0, 2878, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0);
  8. UDB DB 2.3.3 , od jádra 5443+ , testováno 5477 vše OK Pokud vám nastane problém s tímhle: 2008-03-22 12:07:40 Item (Entry: 18833) has wrong ExtendedCost - CondExtendedCost pair (567, 161) 2008-03-22 12:07:40 Item (Entry: 18835) has wrong ExtendedCost - CondExtendedCost pair (567, 161) 2008-03-22 12:07:40 Item (Entry: 18836) has wrong ExtendedCost - CondExtendedCost pair (567, 161) 2008-03-22 12:07:40 Item (Entry: 18837) has wrong ExtendedCost - CondExtendedCost pair (567, 161) 2008-03-22 12:07:40 Item (Entry: 18855) has wrong ExtendedCost - CondExtendedCost pair (567, 161) ....dalších 80 chybyných záznamů.... Opravíte Tímhle SQL Fixem: Download http://filebeam.com/871e5d9c4cefb3bc60e0497f1da4c208
  9. [UDB 344][scriptdev297] Updatepack

    Jasny to bych nerad.. ja jen chtěl dotahnout ten porjekt Full Spawnu SSC až dokonce, když sem na něm makal ani nwm kolik hodin.. zbytek nechám na Method-manovi
  10. Citace z UDB forka Download SVN link: Download Projekt Full Spawn SSC viz: http://www.wowresource.eu/index.php?showtopic=7461&hl=full+spawn Scripty sou zahrnuty
  11. Full spawn SSC

    to charlie: no ja to spawnoval podle toho videjka a po vytach sem odpor neviděl .. takže sem to spawnoval a nastavoval movment až od výtahu dál.. jinak sry za ty druhy nagu ale z toho videjka se fakt blbě dá rozpoznat druh nagy.. ještě se to dopiluje a snad to bude ok.. přece jen 7hodin nastavovaní a spawnovaní k něčemu bude..
  12. Problem s Mailama ve hře

    to Radek402: Fakt dík za ochotu .. tohle by udělal málo kdo z těch lidí co tu je.. takže THX Sice sem to vyřešil torchu jinak ale... Jinak problém se dá vyřešit tak, že: 1) smažete v Navicatu nebo SQLyogu v DB Charcters tabulky [mail] a [mail_items] 2) kliknete pravým a vytvoříte DB test2 třeba.. do ní vyextrahujete z revize->sql->characters.sql 3) v teto test2 DB vydumpujete (zalohujete) tabulky [mail] a [mail_items] 4) pak klikněte pravým na DB characters a vyextrahujte vydumpované (zálohované) tabulky [mail] a [mail_items] = tím získáte čisté tabulky a to je celý,.. ve hře sem to odskoušel , jde vše jak má= posílaní itemů, peněz ,textů... takže snad OK .. pokud někomu nastane podobný problém a sql update nepomůže tohle by mělo zabrat
  13. Problem s Mailama ve hře

    Mam problem s Mailama ve hře.. při poslaní mailu hodi v konzoli chybu a mail druhému hráči nepříde, zkoušel sem Sql update z revize těch mail tabulek ale dělá to pořád to samí: 2008-03-15 11:28:00 SQL: SELECT id,messageType,sender,receiver,itemTextId,has_items,expire_time,cod,checked FROM mail WHERE expire_time < '1205576880' 2008-03-15 11:28:00 query ERROR: Unknown column 'has_items' in 'field list' 2008-03-15 11:28:00 SQL: DELETE FROM mail WHERE expire_time < '1205576880' AND has_items = '0' AND itemTextId = 0 2008-03-15 11:28:00 SQL ERROR: Unknown column 'has_items' in 'where clause' 2008-03-15 11:28:00 Table `event_scripts` has script (Id: 14592) not refering to any gameobject_template type 10 data2 field or type 3 data6 field or any spell effect 61 2008-03-15 11:32:33 SQL: SELECT id,messageType,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_ ime,money,cod,checked,stationery FROM mail WHERE receiver = '11' ORDER BY id DESC 2008-03-15 11:32:33 query ERROR: Unknown column 'has_items' in 'field list' 2008-03-15 11:33:07 SQL: INSERT INTO mail (id,messageType,stationery,sender,receiver,subject,itemTextId,has_items,expir _time,deliver_time,money,cod,checked) VALUES ('2', '0', '41', '11', '51', 'Refreshing Spring Water (2)', '2', '1', '1208169187','1205577187', '10000', '0', '0') 2008-03-15 11:33:07 SQL ERROR: Unknown column 'has_items' in 'field list' 2008-03-15 11:34:28 SQL: SELECT id,messageType,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_ ime,money,cod,checked,stationery FROM mail WHERE receiver = '51' ORDER BY id DESC 2008-03-15 11:34:28 query ERROR: Unknown column 'has_items' in 'field list' Prošel sem tohle forko, mangosproject a UDB forum a tipy co tam byly nepomohli takže jestli by někdo nevěděl něco navíc než na těch forkach... Mam UDB DB 2.3.3 s updatem 342 a revize: 5429
  14. =(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: 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ázka Třeba se Vám to hodí...
  15. farba vypisou mangosa

    Jestli myslíš tady tohle: Tak to se dělá přes configy= mangos.conf a realmd.conf # LogColors # Color for messages (format "normal_color details_color debug_color error_color) # Colors: 0 - BLACK, 1 - RED, 2 - GREEN, 3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 - CYAN, 7 - GREY, # 8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE # Default: "" - none colors # Example: "13 7 11 9" tam je popis barev 0 -black (černá) atd... zakladní barvy si přeložíš a a pak už jen vyplníš v nofigu jaky chceš mít.. ja je mam nastveny tak aby když se vyskytne chba zobrazilo červeně co je dobře ej zeleně atd.. takhle to pak třeba vypadá nastvený je to podle fantazije jaky chceš barvy... LogColors = "10 9 11 3" To stejný je u relmd.conf Jestli to nění to co hledáš tak sem tě špatně pochopil....
×