API tools faq
paste
Guest User

Untitled

a guest
Apr 20th, 2018
65
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.73 KB | None | 0 0
raw download clone embed print report
  1. /*Mikulášksý Event - Insomnia*/
  2. -- Anděl template
  3. DELETE FROM `creature_template` WHERE `entry` BETWEEN 730011 AND 730016;
  4. INSERT INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  5. -- Horde
  6. (730011, 0, 5233, 0, 5233, 0, 'Andel', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 85, 35, 2, 1, 0.5, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
  7. -- Ali
  8. (730012, 0, 5233, 0, 5233, 0, 'Andel', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 11, 11, 2, 1, 0.5, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
  9. -- čert template
  10. -- Horde
  11. (730013, 0, 2007, 0, 2007, 0, 'Cert', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 85, 35, 2, 1, 1, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
  12. -- Ali
  13. (730014, 0, 2007, 0, 2007, 0, 'Cert', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 11, 11, 2, 1, 1, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
  14. -- Mikuláš template
  15. -- Horde
  16. (730015, 0, 13369, 0, 13369, 0, 'Mikulas', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 85, 35, 2, 1, 1, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, ''),
  17. -- Ali
  18. (730016, 0, 13369, 0, 13369, 0, 'Mikulas', 'Mystiq Event Team', NULL, 70, 70, 10586, 10586, 0, 5347, 37000, 11, 11, 2, 1, 1, 0, 999999, 1e+07, 0, 99999999, 9999999, 9999999, 0, 0, 0, 0, 0, 0, 0, 1e+09, 1e+12, 65535, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 0, '');
  19. -- umisteni creature
  20. DELETE FROM `creature` WHERE `guid` BETWEEN 731000 AND 731005;
  21. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  22. (731000, 730011, 1, 1, 0, 0, 1617.68, -4418.69, 14.3092, 2.15666, 25, 0, 0, 10586, 0, 0, 0),
  23. (731001, 730012, 0, 1, 0, 0, -8818.79, 631.365, 94.8834, 5.36305, 25, 0, 0, 10586, 0, 0, 0),
  24. (731002, 730013, 1, 1, 0, 0, 1838.97, -4305.92, -12.6376, 3.78166, 25, 0, 0, 10586, 0, 0, 0),
  25. (731003, 730014, 0, 1, 0, 0, -8608.99, 385.945, 102.925, 5.48892, 25, 0, 0, 10586, 0, 0, 0),
  26. (731004, 730015, 1, 1, 0, 0, 2203.11, -4780.05, 73.9329, 5.43413, 25, 0, 0, 10586, 0, 0, 0),
  27. (731005, 730016, 0, 1, 0, 0, -8537.85, 749.139, 97.2855, 2.59137, 25, 0, 0, 10586, 0, 0, 0);
  28. -- quest_template
  29. -- Ali
  30. DELETE FROM `creature_questrelation` WHERE `id` IN (730012, 730014);
  31. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  32. (730012, 730021),
  33. (730014, 730022);
  34. DELETE FROM `creature_involvedrelation` WHERE `id` IN (730014, 730016);
  35. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  36. (730014, 730021),
  37. (730016, 730022);
  38. DELETE FROM `quest_template` WHERE `entry` IN (730021, 730022);
  39. INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `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`, `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`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES
  40. (730021, 2, 0, 10, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 730022, 0, 730022, 0, 0, 0, 'Ztraceny spolecnik', 'Zdravim Te, priteli.$BPredvanocni obdobi je tady a to znamena spoustu spechu a stresu. Ja a mi dva spolecnici procházíme mesta po celem Azerothu a prinasime detem alespo? trochu klidu v podobe sladkosti a cukratek. I zde ve Stormwindu jsme se rozhodli deti obdarovat. Bohuzel jsem nekde ztratil Mikulase a Certa a ted nevim co si pocit. Pomohl by jsi mi je najit ? Naposledy jsem je videl nekde ve ctvrti Old Town, zkus se tam po nem porozhlednout. Nechces preci nechat zdejsi deti smutne, ze ne ?$B', 'Najdi Certa a Mikulase.', '', 'Zdravim Te, priteli.$BPredvanocni obdobi je tady a to znamena spoustu spechu a stresu. Ja a mi dva spolecnici procházíme mesta po celem Azerothu a prinasime detem alespon trochu klidu v podobe sladkosti a cukratek. I zde ve Stormwindu jsme se rozhodli deti obdarovat. Bohuzel jsem nekde ztratil Mikulase a Certa a ted nevim co si pocit. Pomohl by jsi mi je najit ? Naposledy jsem je videl nekde ve ctvrti Old Town, zkus se tam po nem porozhlednout. Nechces preci nechat zdejsi deti smutne, ze ne ?$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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  41. (730022, 2, 0, 10, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 730021, 0, 0, 0, 0, 0, 0, 'Ztraceny spolecnik II', 'Andel Te poslal za nami ?$BTo je dob?e, ze jsi me nasel, ale jsem zde sam. Mikulas se vytratil p?ed notnou dobou a cekam tady uz nejakou tu chvili. Jak jiste vis, ja jsem ten zlobivy a sladkosti ma u sebe Mikulas. Musis jej najit, jinak deti dostanou jenom kupu uhli. Naposledy jsme spolu byli v Cathedral Square $B', 'Najdi mikulase', 'Zdravim te, dobrodruhu.$BJe mile, ze jsi me vyhledal. Vsichni tri jsme sli rozdat detem cukrovi a sladkosti a místo toho jsem se ztratili. Nejprve jsem sel s certem, ale pak se i on nekde zapomel. Hledal jsem je, ale ješt? vic jsem se zatoulal. Nyní se muzu vratit za ostatními a spolecne roznest trochu radosti zdejším detem. A za to, ze jsi nebyl sobecky a chtel pomoct detem, tu pro Tebe mam malou odmenu.', 'Andel Te poslal za nami ?$BTo je dobre, ze jsi me nasel, ale jsem zde sam. Mikulas se vytratil p?ed notnou dobou a cekam tady uz nejakou tu chvili. Jak jiste vis, ja jsem ten zlobivy a sladkosti ma u sebe Mikulas. Musis jej najit, jinak deti dostanou jenom kupu uhli. Naposledy jsme spolu byli v Cathedral Square $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, 12947, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  42. -- Horde
  43. DELETE FROM `creature_questrelation` WHERE `id` IN (730011, 730013);
  44. INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES
  45. (730011, 730023),
  46. (730013, 730024);
  47. DELETE FROM `creature_involvedrelation` WHERE `id` IN (730013, 730015);
  48. INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
  49. (730013, 730023),
  50. (730015, 730024);
  51. DELETE FROM `quest_template` WHERE `entry` IN (730023, 730024);
  52. INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `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`, `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`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES
  53. (730023, 2, 0, 10, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 730024, 0, 730024, 0, 0, 0, 'Ztraceny spolecnik', 'Zdravim Te, priteli.$BPredvanocni obdobi je tady a to znamena spoustu spechu a stresu. Ja a mi dva spolecnici procházíme mesta po celem Azerothu a prinasime detem alespo? trochu klidu v podobe sladkosti a cukratek. I zde v Orgrimmaru jsme se rozhodli deti obdarovat. Bohuzel jsem nekde ztratil Mikulase a Certa a ted nevim co si pocit. Pomohl by jsi mi je najit ? Naposledy jsem je videl nekde ve ctvrti The Cleft of Shadow, zkus se tam po nem porozhlednout. Nechces preci nechat zdejsi deti smutne, ze ne ?$B', 'Najdi Certa a Mikulase.', '', 'Zdravim Te, priteli.$BPredvanocni obdobi je tady a to znamena spoustu spechu a stresu. Ja a mi dva spolecnici procházíme mesta po celem Azerothu a prinasime detem alespon trochu klidu v podobe sladkosti a cukratek. I zde v Orgrimmaru jsme se rozhodli deti obdarovat. Bohuzel jsem nekde ztratil Mikulase a Certa a ted nevim co si pocit. Pomohl by jsi mi je najit ? Naposledy jsem je videl nekde ve ctvrti The Cleft of Shadow, zkus se tam po nem porozhlednout. Nechces preci nechat zdejsi deti smutne, ze ne ?$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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  54. (730024, 2, 0, 10, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 730023, 0, 0, 0, 0, 0, 0, 'Ztraceny spolecnik II', 'Andel Te poslal za nami ?$BTo je dob?e, ze jsi me nasel, ale jsem zde sam. Mikulas se vytratil p?ed notnou dobou a cekam tady uz nejakou tu chvili. Jak jiste vis, ja jsem ten zlobivy a sladkosti ma u sebe Mikulas. Musis jej najit, jinak deti dostanou jenom kupu uhli. Naposledy jsme spolu byli v The Ring of Valor $B', 'Najdi mikulase', 'Zdravim te, dobrodruhu.$BJe mile, ze jsi me vyhledal. Vsichni tri jsme sli rozdat detem cukrovi a sladkosti a místo toho jsem se ztratili. Nejprve jsem sel s certem, ale pak se i on nekde zapomel. Hledal jsem je, ale jeste vic jsem se zatoulal. Nyní se muzu vratit za ostatními a spolecne roznest trochu radosti zdejším detem. A za to, ze jsi nebyl sobecky a chtel pomoct detem, tu pro Tebe mam malou odmenu.', 'Andel Te poslal za nami ?$BTo je dobre, ze jsi me nasel, ale jsem zde sam. Mikulas se vytratil p?ed notnou dobou a cekam tady uz nejakou tu chvili. Jak jiste vis, ja jsem ten zlobivy a sladkosti ma u sebe Mikulas. Musis jej najit, jinak deti dostanou jenom kupu uhli. Naposledy jsme spolu byli v The Ring of Valor $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, 12947, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  55. -- Event
  56. DELETE FROM `game_event_creature` WHERE (`event`)=499;
  57. INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES
  58. (499, '2011-12-06 00:00:00', '2011-12-07 00:00:00', 0, 1440, '');
  59. -- Vložení NPC do eventu
  60. SET @GAMEEVENT := 499;
  61. INSERT IGNORE INTO `game_event_creature` (`guid`, `event`)
  62. SELECT `guid`, @GAMEEVENT FROM `creature` WHERE `guid` BETWEEN 731000 AND 731005;
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!