API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.71 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `creature_template` WHERE `entry` IN ('1020000', '1020001', '1020002', '1020003', '1020003', '1020004', '1020005', '1020006', '1020007');
  2. 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
  3. (1020000, 0, 17068, 0, 17068, 0, 'Julie', 'Pod vlivem lektvaru', '', 73, 73, 819056, 819056, 495321, 1020168, 7560, 1662, 1662, 0, 1, 1, 3, 2632, 5308, 0, 500, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 118, 175, 25, 7, 0, 0, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 1141578560, 0, 'mob_eventai'),
  4. (1020001, 0, 17068, 0, 17068, 0, 'Duch Julie', '', '', 73, 73, 682, 682, 1562, 1562, 0, 35, 35, 3, 1, 1, 0, 1687, 25621, 0, 116, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 118, 175, 25, 7, 0, 0, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 1141578560, 0, 'mob_eventai'),
  5. (1020002, 0, 16241, 0, 16241, 0, 'Iluze zla', NULL, NULL, 71, 71, 28870, 28870, 153200, 153200, 520, 1662, 1662, 0, 1, 1, 1, 200, 300, 0, 115, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 67306064, 0, 'mob_eventai'),
  6. (1020003, 0, 17067, 0, 17067, 0, 'Romeo', 'Vzpominka', NULL, 72, 72, 105321, 105321, 0, 0, 7360, 1662, 1662, 0, 1, 1, 2, 1206, 2567, 0, 1500, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 1, 3, 0, 1, 0, 67306064, 0, 'mob_eventai'),
  7. (1020004, 0, 5556, 0, 5556, 0, 'Kocka', 'Juliin mazlicek', NULL, 70, 71, 1562, 1562, 0, 0, 0, 35, 35, 3, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''),
  8. (1020005, 0, 17067, 0, 17067, 0, 'Romeo', 'Laska Julie', NULL, 72, 72, 105321, 105321, 0, 0, 0, 35, 35, 3, 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, 3, 0, 1, 0, 0, 0, ''),
  9. (1020006, 0, 17068, 0, 17068, 0, 'Julie', 'Laska Romea', NULL, 72, 72, 819056, 819056, 0, 0, 0, 35, 35, 3, 1, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''),
  10. (1020007, 0, 22461, 0, 22461, 0, 'Trpaslik', '"Unosce" Julie', NULL, 72, 72, 5652, 5652, 0, 0, 0, 35, 35, 3, 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, 3, 0, 1, 0, 0, 0, '');
  11. DELETE FROM `eventai_summons` WHERE `id` IN ('10', '11');
  12. INSERT INTO `eventai_summons` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `comment`) VALUES
  13. (10, -11104.8, -1845.89, 229.624, 5.37471, 60000000, ''),
  14. (11, -11103.2, -1848.69, 221.071, 5.39824, 60000000, '');
  15. DELETE FROM `eventai_texts` WHERE `entry` IN ('-522', '-523', '-524');
  16. INSERT INTO `eventai_texts` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`, `sound`, `type`, `language`, `emote`, `comment`) VALUES
  17. (-522, 'Romeo, ach můj Romeo!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
  18. (-523, 'Julie! Jdu ti na pomoc má lásko!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL),
  19. (-524, 'Ach, děkuji vám. Jsem vám velice zavázana. Když si jen pomyslím, co vše jsem mohla způsobit .. Děkuji vám hrdinové, jsem vašim největším dlužníkem.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, NULL);
  20. DELETE FROM `eventai_scripts` WHERE `id` IN ('10200000', '10200001', '10200002', '10200003', '10200004', '10200005', '10200006', '10200007', '10200008', '10200009', '10200010', '10200011', '10200012', '10200013');
  21. INSERT INTO `eventai_scripts` (`id`, `creature_id`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
  22. (10200000, 1020000, 6, 0, 100, 3, 0, 0, 0, 0, 12, 1020001, 0, 120000, 0, 0, 0, 0, 0, 0, 0, 0, 'Julie - Summon Duch Julie'),
  23. (10200009, 1020003, 11, 0, 100, 3, 0, 0, 0, 0, 1, -523, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Romeo - Say'),
  24. (10200013, 1020001, 11, 0, 100, 3, 0, 0, 0, 0, 1, -524, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
  25. (10200004, 1020001, 11, 0, 100, 3, 0, 0, 0, 0, 11, 52970, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Duch Julie - Cast Levitate'),
  26. (10200008, 1020000, 2, 0, 100, 3, 21, 20, 9, 8, 32, 1020003, 1, 11, 1, -522, 0, 0, 0, 0, 0, 0, 'Julie - Summon Vzpominka na Romea and yell'),
  27. (10200006, 1020000, 2, 0, 100, 3, 61, 60, 31, 30, 11, 36127, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Julia - Cast Shadow Nova'),
  28. (10200010, 1020003, 0, 0, 100, 3, 6000, 8000, 6000, 8000, 11, 31754, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Romeo - Cast Strike'),
  29. (10200002, 1020002, 0, 0, 100, 3, 7500, 8000, 7500, 8000, 11, 23331, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Zly Duch - Cast Blast Wave'),
  30. (10200005, 1020000, 0, 0, 100, 3, 10000, 15000, 10000, 15000, 11, 47248, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Julia - Cast Shadowbolt'),
  31. (10200011, 1020003, 0, 0, 100, 3, 13000, 16000, 13000, 16000, 11, 36214, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Romeo - Cast Thunder Clap'),
  32. (10200007, 1020000, 0, 0, 100, 3, 19000, 19100, 19000, 19100, 11, 30854, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Julia - Cast Shadow Word:Pain'),
  33. (10200003, 1020000, 0, 0, 100, 3, 20000, 21000, 20000, 21000, 32, 1020002, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 'Julia - Summon Iluze zla'),
  34. (10200012, 1020003, 0, 0, 100, 3, 30000, 30100, 30000, 30100, 11, 42359, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Romeo - Cast Axe Volley'),
  35. (10200001, 1020000, 0, 0, 100, 3, 32000, 35100, 32000, 351000, 11, 34322, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Julia - Cast Physic Scream');
  36. DELETE FROM `creature` WHERE `guid` IN ('102000000', '102000001', '102000002', '102000003', '102000004');
  37. 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
  38. (10200000, 1020000, 532, 1, 0, 0, -11064.7, -1896.61, 221.071, 2.24107, 25, 0, 0, 360215, 1020168, 0, 0),
  39. (10200001, 1020004, 0, 1, 0, 0, -860.571, -1807.82, 48.6798, 5.19934, 25, 0, 0, 1562, 0, 0, 0),
  40. (10200002, 1020005, 1, 1, 0, 0, -8827, -4757.93, 1.90593, 4.64405, 25, 0, 0, 105321, 0, 0, 0),
  41. (10200003, 1020006, 0, 1, 0, 0, -14425.3, 455.238, 15.3283, 0.562311, 25, 0, 0, 819056, 0, 0, 0),
  42. (10200004, 1020007, 532, 1, 0, 0, -11086.4, -1967.89, 49.8894, 4.4615, 25, 0, 0, 5652, 0, 0, 0);
  43. INSERT IGNORE `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (72, '2010-06-21 08:01:00', '2010-12-31 06:00:00', 525600, 20160, 'Valentýnský event Romeo a Julie');
  44. INSERT IGNORE `game_event_creature` (`guid`, `event`) VALUES
  45. (10200000,72),
  46. (10200001,72),
  47. (10200002,72),
  48. (10200003,72),
  49. (10200004,72);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!