Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.12 KB | None | 0 0
  1. -- Mistery of Melee
  2. UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '33229' WHERE `entry` = 13828;
  3. UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '33229' WHERE `entry` = 13829;
  4.  
  5. -- Infiltrarse en Voltarus
  6. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28666' WHERE `entry` = 12664;
  7. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28666' WHERE `entry` = 12663;
  8.  
  9. -- Cimientos de venganza
  10. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28747' WHERE `entry` = 12668;
  11.  
  12. -- Ira de mujer...
  13. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28752', `ReqCreatureOrGOId1` = '28754', `ReqCreatureOrGOId1` = '28756' WHERE `entry` = 12674;
  14.  
  15. -- El peso de la justicia
  16. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28861' WHERE `entry` = 12707;
  17.  
  18. -- La llave del señor de la guerra Zol'Maz
  19. DELETE FROM `gameobject` WHERE `guid` = 46841;
  20.  
  21. -- El corazón de la Tormenta
  22. DELETE FROM `creature` WHERE `guid` = 9999001;
  23. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES ('9999001', '30299', '571', '1', '1', '0', '0', '7308.86', '-736.81', '791.609', '1.55884', '300', '5', '0', '11770', '0', '0', '0');
  24.  
  25. -- Encontrar al culpable (Horda y Alianza)
  26. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29695' WHERE `entry` = 12910;
  27. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29695' WHERE `entry` = 12855;
  28.  
  29. -- Amarga partida
  30. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12832;
  31.  
  32. -- Luchar contra los elementales
  33. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30120' WHERE `entry` = 12967;
  34.  
  35. -- Forjando una Alianza
  36. UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '30099' WHERE `entry` = 12924;
  37.  
  38. -- El juramento terráneo
  39. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29984' WHERE `entry` = 13005;
  40. UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '29978' WHERE `entry` = 13005;
  41.  
  42. -- La venganza
  43. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13047;
  44.  
  45. -- Thorim (30390)
  46. DELETE FROM `creature` WHERE `guid` = 88419;
  47. DELETE FROM `creature` WHERE `guid` = 9999002;
  48. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES ('9999002', '30390', '571', '1', '4', '0', '0', '7879.33', '-3241.43', '849.608', '3.44673', '300', '5', '0', '13481', '0', '0', '0');
  49.  
  50. -- A Jack le gusta la bebida
  51. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '24788', `ReqCreatureOrGOCount1` = '1', `ReqItemId1` = '0', `ReqItemCount1` = '0' WHERE `entry` = 11466;
  52.  
  53. -- Entrega de cobardes en menos de 30 minutos... o será gratis
  54. DELETE FROM `creature` WHERE `guid` = 110390;
  55. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '25759' WHERE `entry` = 11711;
  56.  
  57. -- Las almas de los desembrujados
  58. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '25814' WHERE `entry` = 11899;
  59.  
  60. -- Vuelo de reconocimiento
  61. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12671;
  62.  
  63. -- El cazador y el príncipe
  64. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13361;
  65. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13400;
  66.  
  67. -- El arte de ser un terror de agua
  68. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30632' WHERE `entry` = 13091;
  69.  
  70. -- Encuentra al antiguo héroe
  71. UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30924' WHERE `entry` = 13133;
  72. DELETE FROM `creature` WHERE `guid` = 9999003;
  73. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES ('9999003', '30924', '571', '1', '1', '0', '2261', '7304.61', '3817.48', '604.688', '2.40221', '300', '5', '0', '50400', '0', '0', '0');
  74.  
  75. -- La Luz del Alba
  76. UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12801;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement