Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Mistery of Melee
- UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '33229' WHERE `entry` = 13828;
- UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '33229' WHERE `entry` = 13829;
- -- Infiltrarse en Voltarus
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28666' WHERE `entry` = 12664;
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28666' WHERE `entry` = 12663;
- -- Cimientos de venganza
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28747' WHERE `entry` = 12668;
- -- Ira de mujer...
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28752', `ReqCreatureOrGOId1` = '28754', `ReqCreatureOrGOId1` = '28756' WHERE `entry` = 12674;
- -- El peso de la justicia
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '28861' WHERE `entry` = 12707;
- -- La llave del señor de la guerra Zol'Maz
- DELETE FROM `gameobject` WHERE `guid` = 46841;
- -- El corazón de la Tormenta
- DELETE FROM `creature` WHERE `guid` = 9999001;
- 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');
- -- Encontrar al culpable (Horda y Alianza)
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29695' WHERE `entry` = 12910;
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29695' WHERE `entry` = 12855;
- -- Amarga partida
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12832;
- -- Luchar contra los elementales
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30120' WHERE `entry` = 12967;
- -- Forjando una Alianza
- UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '30099' WHERE `entry` = 12924;
- -- El juramento terráneo
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '29984' WHERE `entry` = 13005;
- UPDATE `quest_template` SET `ReqCreatureOrGOId2` = '29978' WHERE `entry` = 13005;
- -- La venganza
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13047;
- -- Thorim (30390)
- DELETE FROM `creature` WHERE `guid` = 88419;
- DELETE FROM `creature` WHERE `guid` = 9999002;
- 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');
- -- A Jack le gusta la bebida
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '24788', `ReqCreatureOrGOCount1` = '1', `ReqItemId1` = '0', `ReqItemCount1` = '0' WHERE `entry` = 11466;
- -- Entrega de cobardes en menos de 30 minutos... o será gratis
- DELETE FROM `creature` WHERE `guid` = 110390;
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '25759' WHERE `entry` = 11711;
- -- Las almas de los desembrujados
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '25814' WHERE `entry` = 11899;
- -- Vuelo de reconocimiento
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12671;
- -- El cazador y el príncipe
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13361;
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 13400;
- -- El arte de ser un terror de agua
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30632' WHERE `entry` = 13091;
- -- Encuentra al antiguo héroe
- UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '30924' WHERE `entry` = 13133;
- DELETE FROM `creature` WHERE `guid` = 9999003;
- 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');
- -- La Luz del Alba
- UPDATE `quest_template` SET `Method` = '0' WHERE `entry` = 12801;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement