Hardcore

Miembro
 Ver Perfil  Ver actividad

  • Contenido

    17

  • Registrado

  • Última Visita

Posts publicados por Hardcore

  4. Publicado

    On 25/1/2016 at 4:52 PM, Hypnos dijo:

    Pues o lo pone en wowhead en la pagina del npc o en algun comentario de la gente en wowhead. Sino guiate por alguna otra que suele ser similar, los que mas dan (500 por ejemplo) suelen dejar de darla en el antepenultimo nivel....Eso ya es investigacion, a ver si os pensabais que todo es copiar y pegar :P

     

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

  6. Publicado

    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);

  7. Publicado

    -- 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

  9. Publicado

    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'; 

  10. Publicado

    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.

  12. Publicado

    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');

  13. Publicado

    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);

     

    A 1 persona le gusta esto

  14. Publicado

    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');

  15. Publicado

    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'; 

  17. Publicado · Editado por Dahlian

    Moobs:

    -Shan'ze Animator

    -Animated Warrior

    -Shan'ze Bloodseeker

    -Zandalari Colossus

    -Zandalari Stoneshield

    -Zandalari Spearanger

    -Zandalari Spiritbinder

    -Shan'ze Thundercaller

    -Shan'ze Gravekeeper

    -Kaida the Bloodletter

    DELETE FROM `creature_onkill_reputation` WHERE `creature_id`IN(70069,67473,69431,69405,69223,69298,69225,69264,69235,69250,69236,69065,69170,69200,69171,67760,69227,69210,69338,69228,69400,69251,69348,69226,69335,69294,69295,69296,69297,69312,69198,69281,69136,69254);
    INSERT INTO `creature_onkill_reputation` (`creature_id`, `RewOnKillRepFaction1`, `MaxStanding1`, `IsTeamAward1`, `RewOnKillRepValue1`, `TeamDependent`) VALUES
    (70069, 1359, 7, 0, 37, 0),
    (67473, 1359, 7, 0, 50, 1),
    (69431, 1359, 7, 0, 37, 1),
    (69405, 1359, 7, 0, 100, 0),
    (69223, 1359, 7, 0, 25, 0),
    (69298, 1359, 7, 0, 25, 0),
    (69225, 1359, 7, 0, 25, 0),
    (69264, 1359, 7, 0, 25, 0),
    (69235, 1359, 7, 0, 25, 0),
    (69250, 1359, 7, 0, 50, 0),
    (69236, 1359, 7, 0, 25, 0),
    (69065, 1359, 7, 0, 25, 0),
    (69170, 1359, 7, 0, 13, 0),
    (69200, 1359, 7, 0, 50, 0),
    (69171, 1359, 7, 0, 25, 0),
    (67760, 1359, 7, 0, 25, 0),
    (69227, 1359, 7, 0, 25, 0),
    (69210, 1359, 7, 0, 25, 0),
    (69338, 1359, 7, 0, 100, 1),
    (69228, 1359, 7, 0, 25, 0),
    (69400, 1359, 7, 0, 25, 0),
    (69251, 1359, 7, 0, 25, 0),
    (69348, 1359, 7, 0, 25, 0),
    (69226, 1359, 7, 0, 50, 0),
    (69335, 1359, 7, 0, 25, 0),
    (69294, 1359, 7, 0, 25, 0),
    (69295, 1359, 7, 0, 25, 0),
    (69296, 1359, 7, 0, 25, 0),
    (69297, 1359, 7, 0, 25, 0),
    (69312, 1359, 7, 0, 37, 0),
    (69198, 1359, 7, 0, 25, 0),
    (69281, 1359, 7, 0, 50, 0),
    (69136, 1359, 7, 0, 50, 0),
    (69254, 1359, 7, 0, 50, 0);

     

    Es mi primer parche, disculpen si hice algo mal.