Hardcore

De acuerdo, tengo 4-5 parches para MoP re-añadirlos Ayudaría en Wod, pero quiero el mismo desarrollo. e.e

Algo muy bueno, esperemos que no se daña al paso del tiempo.

Ok, intentare revisarlos y ponerlos aquí.

Claro que no, ojala fuera así de sencillo, ya te digo que trabajo en algunos parches de Wod

No drop no lo tiene muy establecido, puesto que es un server x5 sólo lotea 1 objeto nada más. Lo re-añadí para corregirlo.

http://es.wowhead.com/item=94158/gran-bolsa-de-suministros-zandalari#contains DELETE FROM `item_loot_template` WHERE `entry`=94158; INSERT INTO `item_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (94158, 74248, 17, 1, 1, 1, 1), (94158, 74247, 17, 1, 0, 2, 6), (94158, 72238, 17, 1, 0, 15, 20), (94158, 74250, 17, 1, 0, 8, 16), (94158, 82441, 17, 1, 0, 10, 20), (94158, 38426, 17, 1, 0, 12, 18), (94158, 72986, 17, 1, 0, 16, 20), (94158, 74249, 17, 1, 0, 14, 20), (94158, 72988, 17, 1, 0, 16, 20), (94158, 72094, 16, 1, 0, 2, 19), (94158, 72103, 16, 1, 0, 3, 19), (94158, 72092, 16, 1, 0, 1, 13), (94158, 72093, 16, 1, 0, 40, 60), (94158, 72163, 15, 1, 0, 1, 2), (94158, 72120, 15, 1, 0, 12, 20), (94158, 79011, 15, 1, 0, 15, 20), (94158, 72234, 15, 1, 0, 15, 20), (94158, 72237, 15, 1, 0, 15, 20), (94158, 72235, 15, 1, 0, 15, 20), (94158, 79010, 15, 1, 0, 15, 20), (94158, 76141, 5, 1, 0, 3, 7), (94158, 76131, 5, 1, 0, 3, 10), (94158, 76138, 5, 1, 0, 3, 10), (94158, 76142, 5, 1, 0, 3, 7), (94158, 76140, 5, 1, 0, 3, 10), (94158, 76139, 5, 1, 0, 3, 10), (94158, 76137, 3, 1, 0, 8, 12), (94158, 76133, 3, 1, 0, 8, 12), (94158, 76136, 3, 1, 0, 8, 12), (94158, 76135, 3, 1, 0, 8, 12), (94158, 76130, 3, 1, 0, 8, 12), (94158, 87642, 2, 1, 1, 1, 1), (94158, 87650, 2, 1, 1, 1, 1), (94158, 87641, 2, 1, 1, 1, 1), (94158, 76134, 2, 1, 0, 8, 12), (94158, 87646, 1.9, 1, 1, 1, 1), (94158, 87652, 1.9, 1, 1, 1, 1), (94158, 87651, 1.9, 1, 1, 1, 1), (94158, 87649, 1.9, 1, 1, 1, 1), (94158, 90724, 1.9, 1, 1, 1, 1), (94158, 90722, 1.9, 1, 1, 1, 1), (94158, 90721, 1.8, 1, 1, 1, 1), (94158, 87643, 1.8, 1, 1, 1, 1), (94158, 90717, 1.8, 1, 1, 1, 1), (94158, 90718, 1.8, 1, 1, 1, 1), (94158, 90723, 1.6, 1, 1, 1, 1), (94158, 90725, 1.6, 1, 1, 1, 1), (94158, 90719, 1.6, 1, 1, 1, 1), (94158, 90720, 1.5, 1, 1, 1, 1);

-- Lothos Riftwaker SET @npc=14387; UPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; DELETE FROM `smart_scripts` WHERE (`entryorguid`=@ENTRY AND `source_type`=0); INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES (@npc,0,0,1,62,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Close Gossip'), (@npc,0,1,0,61,0,100,0,5750,0,0,0,62,409,0,0,0,0,0,7,0,0,0,1096,-467,-104.6,3.64,'teleport player'); DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (5750); INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`)VALUES (5750,0,0,'Teleport me to the Molten Core, Lothos.',1,1,0,0,0,0,''); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (5750); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES (15,5750,0,0,0,8,7848,0,0,0,0,'','Gossip Condi'); UPDATE `smart_scripts` SET `event_param1`=5750 WHERE `entryorguid`=14387 AND `id`=0; UPDATE `smart_scripts` SET `event_param1`=0 WHERE `entryorguid`=14387 AND `id`=1; -- SAI FIx

I had not noticed

http://es.wowhead.com/quest=12017/carne-en-el-anzuelo con los textos añadidos. --Quest: Meat on The Hook UPDATE `quest_template` SET `RequestItemsText`='I thought I might have spotted some thrashing... is Tu''u''gwar dead?' WHERE `Id`='12017'; UPDATE `quest_template` SET `OfferRewardText`='We shall rejoice at your success, my young friend! There''s blood in the water and it is our enemy''s!$BYou have the eternal gratitude of this old fisherman, $n, and most certainly all of the Kalu''ak once I spread the word!$BHere now, I insist, take something as a reward, please.' WHERE `Id`='12017';

Misión relevante http://es.wowhead.com/quest=26536/cataratas-del-trueno UPDATE `quest_template` SET `RequiredItemId`='58899', `RequiredItemCount`='4', `RequiredRaces`='2098253', `RewardSkillId`='185', `RewardSkillPoints`='1' WHERE `Id`='26536'; -- Quest: Thunder Falls -- Assign Fish to quest, all alliance races, +1 skill point fishing. INSERT INTO `fishing_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES (61,58899,-80,1,0,1,1), (61,11000,100,1,1,-11000,1); P.D: La misión falla, porque permite capturar muchos otros peces y esto hace imposible completarla.

http://es.wowhead.com/quest=11582/observar-la-falla-sima-quebrada UPDATE `quest_template` SET `SourceSpellId`=7178 WHERE `Id`=11582;

http://es.wowhead.com/quest=14069/el-buen-servicio-es-dificil-de-encontrar -- Good Help is Hard to Find (14069) SET @ENTRY := 34830; -- Взбунтовавшийся тролль SET @SPELL := 66306; -- Гоблинский все-в-одном-чудо-пояс SET @ENTRY00 := 3483000; -- Script Id UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='', `npcflag`=16777216, `unit_flags`=256, `IconName`='openhandglow' WHERE `entry`=@ENTRY; UPDATE `creature_template_addon` SET `emote`=0, `auras`='' WHERE `entry`=@ENTRY; UPDATE `creature_addon` SET `emote`=0, `auras`='' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id`=@ENTRY); DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY, @ENTRY00+1, @ENTRY00+2, @ENTRY00+3, @ENTRY00+4); INSERT INTO `smart_scripts` VALUES (@ENTRY, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 87, @ENTRY00+1, @ENTRY00+2, @ENTRY00+3, @ENTRY00+4, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Respawn - Random Actionlist'), (@ENTRY, 0, 1, 2, 73, 0, 100, 1, 0, 0, 0, 0, 28, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Spellclick - Remove Aura Enrage'), (@ENTRY, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - Remove Emote'), (@ENTRY, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - Random Say Text'), (@ENTRY, 0, 4, 5, 52, 0, 0, 0, 0, 0, 0, 0, 33, @ENTRY, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Text Over - Give Kill Credit'), (@ENTRY, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 10000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - Forced Despawn'), (@ENTRY00+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Cast Aura Enrage'), (@ENTRY00+1, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 5, 412, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Play Emote Exclaim'), (@ENTRY00+2, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Cast Aura Enrage'), (@ENTRY00+2, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 5, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Play Emote Sleep'), (@ENTRY00+3, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Cast Aura Enrage'), (@ENTRY00+3, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 5, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Play Emote Dance'), (@ENTRY00+4, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 11, 45111, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Cast Aura Enrage'), (@ENTRY00+4, 9, 1, 0, 0, 0, 100, 0, 500, 500, 0, 0, 5, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Defiant Troll - On Script - Play Emote None'); DELETE FROM `creature_text` WHERE `entry`=@ENTRY; INSERT INTO `creature_text` VALUES (@ENTRY, 0, 0, 'Oops, break''s over.', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 1, 'Don''t tase me, mon!', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 2, 'I report you to HR!', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 3, 'Work was bettah in da Undermine!', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 4, 'I''m going. I''m going!', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 5, 'Sorry, mon. It won''t happen again.', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 6, 'What I doin'' wrong? Don''t I get a lunch and two breaks a day, mon?', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'), (@ENTRY, 0, 7, 'Ouch! Dat hurt!', 12, 0, 100, 1, 0, 0, 'Defiant troll - Good help is hard to find'); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=@ENTRY; INSERT INTO `npc_spellclick_spells` VALUES (@ENTRY, @SPELL, 1, 0); DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=@ENTRY; INSERT INTO `conditions` VALUES (18, @ENTRY, @SPELL, 0, 0, 9, 0, 14069, 0, 0, 0, 0, 0, '', 'Required quest active for spellclick'), (18, @ENTRY, @SPELL, 0, 0, 1, 1, 45111, 0, 0, 0, 0, 0, '', 'Spell casted only if aura is present');

Npc's en los cuales las misiones no se completan bien: 1° http://es.wowhead.com/quest=31376/ataque-al-templo-del-dragon-de-jade 2° http://es.wowhead.com/quest=31377/ataque-al-templo-del-dragon-de-jade 3° http://es.wowhead.com/quest=31379/desafio-en-el-templo-de-la-grulla-roja 4° http://es.wowhead.com/quest=31378/desafio-en-el-templo-de-la-grulla-roja 5° http://es.wowhead.com/quest=31383/defensa-del-templo-de-niuzao 6° http://es.wowhead.com/quest=31382/defensa-del-templo-de-niuzao 7° http://es.wowhead.com/quest=31381/prueba-en-el-templo-del-tigre-blanco 8° http://es.wowhead.com/quest=31380/prueba-en-el-templo-del-tigre-blanco Parche del error corregido. -- Attack at Jade serpent H DELETE FROM `creature_involvedrelation` WHERE `id`=64001 AND `quest`=31377; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (57324, 31377); -- Attack at Jade serpent A DELETE FROM `creature_involvedrelation` WHERE `id`=64032 AND `quest`=31376; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (57324, 31376); -- Challenge at The Temple of The Red Crane H DELETE FROM `creature_involvedrelation` WHERE `id`=64001 AND `quest`=31379; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (60506, 31379); -- Challenge at The Temple of the Red Crane A DELETE FROM `creature_involvedrelation` WHERE `id`=64032 AND `quest`=31378; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (60506, 31378); -- Defense At Niuzao Temple H DELETE FROM `creature_involvedrelation` WHERE `id`=64001 AND `quest`=31383; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (61580, 31383); -- Defense At Niuzao Temple A DELETE FROM `creature_involvedrelation` WHERE `id`=64032 AND `quest`=31382; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (61580, 31382); -- Trial At The Temple of the White Tiger H DELETE FROM `creature_involvedrelation` WHERE `id`=64001 AND `quest`=31381; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (60968, 31381); -- Trial At The Temple of the White Tiger A DELETE FROM `creature_involvedrelation` WHERE `id`=64032 AND `quest`=31380; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (60968, 31380);

http://es.wowhead.com/item=87841/granadas-experimentales-de-korven Corrección del ítem de la misión. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`='127506'; INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 127506, 0, 0, 31, 1, 3, 64982, 0, 0, 952, '', 'Korven\'s Experimental Grenades Only On Zan\'thik Amberhusk');

http://es.wowhead.com/quest=12011/signos-de-importantes-disturbios-acuaticos con el progreso. -- Quest: Signs of Big Watery Trouble UPDATE `quest_template` SET `Details`='This crab trap appears to have been destroyed by something much larger than the nearby circling sharks.$BPerhaps Tua''kea, the fisherman at Moa''ki Harbor, should be told about this?' WHERE `Id`='12011'; UPDATE `quest_template` SET `OfferRewardText`='That''s not the news I wanted to hear, $r.&BNo, no... it''s good that you told me, but I fear my old nemesis has returned to these waters.' WHERE `Id`='12011';