Автор Тема: [World Event][372]Brewfest  (Прочетена 15318 пъти)

0 Потребители и 1 Гост преглежда(т) тази тема.

Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #15 -: Септември 26, 2013, 07:38:03 am »
Статичен спаун на http://wotlk.openwow.com/object=189989 / http://wotlk.openwow.com/object=189990 / http://wotlk.openwow.com/npc=23872:
DELETE FROM `creature` WHERE `id`=23872;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(NULL,23872,230,1,1,0,0,890.618,-130.363,-49.7448,5.17385,300,0,0,302400,0,0,0,0,0);
DELETE FROM `gameobject` WHERE `id` IN (189989,189990);
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(NULL,189990,1,1,1,1213.47,-4327.53,21.1917,1.9878,0,0,0.83816,0.545424,300,0,1),
(NULL,189989,0,1,1,-5172.38,-580.041,397.471,1.16898,0,0,0.551776,0.833993,300,0,1);

BTW, тези два куеста(http://wotlk.openwow.com/quest=11407 / http://wotlk.openwow.com/quest=11408) е невъзможно да са с такива изисквания :X
« Последна редакция: Септември 26, 2013, 07:39:37 am от untaught »


Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #16 -: Септември 26, 2013, 09:11:47 am »
HACKFIX за http://wotlk.openwow.com/quest=11294 / http://wotlk.openwow.com/quest=11407 / http://wotlk.openwow.com/quest=11408 :
UPDATE `quest_template` SET `LimitTime`=240,`PrevQuestId`=0 WHERE `id` IN (11294,11407,11408);
UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry` IN (24202,24203,24204,24205);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24202,24203,24204,24205) 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
(24202,0,0,0,10,0,100,0,1,20,200,200,11,43259,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),
(24203,0,0,0,10,0,100,0,1,20,200,200,11,43260,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),
(24204,0,0,0,10,0,100,0,1,20,200,200,11,43261,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),
(24205,0,0,0,10,0,100,0,1,20,200,200,11,43262,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit');
DELETE FROM `creature` WHERE `id` IN (24202,24203,24204,24205);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(NULL,24202,1,1,1,0,0,1650.9,-4413.9,16.8934,0.475121,300,0,0,42,0,0,0,0,0),
(NULL,24202,0,1,1,0,0,-4910.58,-945.233,501.494,4.28465,300,0,0,42,0,0,0,0,0),
(NULL,24203,1,1,1,0,0,1933.13,-4673.86,27.5538,5.49774,300,0,0,42,0,0,0,0,0),
(NULL,24203,0,1,1,0,0,-4970.87,-1210.18,503.625,0.954555,300,0,0,42,0,0,0,0,0),
(NULL,24204,1,1,1,0,0,1922.97,-4287.9,28.8533,2.99625,300,0,0,42,0,0,0,0,0),
(NULL,24204,0,1,1,0,0,-4695.36,-1231.63,503.9,0.636425,300,0,0,42,0,0,0,0,0),
(NULL,24205,1,1,1,0,0,1576.06,-4208.81,43.669,2.88944,300,0,0,42,0,0,0,0,0),
(NULL,24205,0,1,1,0,0,-4662.75,-958.585,500.377,1.9473,300,0,0,42,0,0,0,0,0);
« Последна редакция: Септември 26, 2013, 09:22:32 am от untaught »


Неактивен admin

  • Owner
  • Challenger
  • *****
  • Публикации: 11572
  • EVO Karma: 316
  • Think of will!
    • Peycho's Blog - Think of will!
  • ISP: AWS
  • Герой: Alein
Re: [World Event][372]Brewfest
« Отговор #17 -: Септември 26, 2013, 02:27:44 pm »
Добавено. Благодаря.
A systems programmer will know what to do when society breaks down, because the systems programmer already lives in a world without laws.

EVOWOW Private Wow Server
WOTLK Database

Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #18 -: Септември 26, 2013, 03:34:11 pm »
HACKFIX за http://wotlk.openwow.com/quest=11120:
DELETE FROM `smart_scripts` WHERE `entryorguid`=24657 AND `source_type`=0 AND `id` IN (2,3);
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
(24657,0,2,3,62,0,100,0,9016,1,0,0,11,66592,0,0,0,0,0,7,0,0,0,0,0,0,0,'Glodrak Huntsniper - On gossip option select - cast spell'),
(24657,0,3,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Glodrak Huntsniper - On gossip option select - close gossip');
DELETE FROM `gossip_menu_option` WHERE `menu_id`=9016 AND `id`=1;
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
(9016,1,0,'I\'d like a pair of Synthebrew Goggles.',1,1,0,0,0,0,NULL);


Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #19 -: Септември 26, 2013, 03:38:32 pm »
FIX за http://wotlk.openwow.com/quest=11431 от http://wotlk.openwow.com/npc=24657:
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
(24657,11431);
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
(24657,11431);


Неактивен admin

  • Owner
  • Challenger
  • *****
  • Публикации: 11572
  • EVO Karma: 316
  • Think of will!
    • Peycho's Blog - Think of will!
  • ISP: AWS
  • Герой: Alein
Re: [World Event][372]Brewfest
« Отговор #20 -: Септември 26, 2013, 04:22:45 pm »
Добавено за тест.
A systems programmer will know what to do when society breaks down, because the systems programmer already lives in a world without laws.

EVOWOW Private Wow Server
WOTLK Database

Неактивен The Aspect

  • Challenger
  • *******
  • Публикации: 2679
  • EVO Karma: 166
  • Sweet Desire
    • Night Legion
  • ISP: BGLan
  • Side: For The Alliance
  • Герой: Winlight, Frozenrose
Re: [World Event][372]Brewfest
« Отговор #21 -: Септември 26, 2013, 04:47:44 pm »
Следният проблем възникна.
Шевчето - Coren Direbrew трябва да дропва тези айтъми Direbrew's Dire Brew Alliance id : 38280 и съответно Direbrew's Dire Brew Horde id : 38281.
Проблемът е там, че той дропва всеки път айтъмът, който дава куест за ордата.
Минах поне 10-тина пъти днес инса, с надеждата да падне алинаският куест айтъм, но уви.
Ще може ли да се погледне ?
« Последна редакция: Септември 26, 2013, 04:49:21 pm от The Aspect »
I'm everything you can imagine. And a little more.
   Winlight          Frozenrose          Saladin          Chaoswizard

Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #22 -: Септември 26, 2013, 05:42:31 pm »
Като добавям липсващите NPC-та за последното постижение, ще ги сложа на 50% и двете.


Неактивен The Aspect

  • Challenger
  • *******
  • Публикации: 2679
  • EVO Karma: 166
  • Sweet Desire
    • Night Legion
  • ISP: BGLan
  • Side: For The Alliance
  • Герой: Winlight, Frozenrose
Re: [World Event][372]Brewfest
« Отговор #23 -: Септември 26, 2013, 05:58:42 pm »
Благодарим!
I'm everything you can imagine. And a little more.
   Winlight          Frozenrose          Saladin          Chaoswizard

Неактивен *Blood_Prince*

  • Emperor
  • ***
  • Публикации: 366
  • EVO Karma: 9
  • I'm a Pitbull...The Dog of The Dogs
Re: [World Event][372]Brewfest
« Отговор #24 -: Септември 26, 2013, 10:28:26 pm »
http://wotlk.openwow.com/quest=11120
Една питанка имам към този куест - трябва ли да се реска всяка година? Понеже преди съм го минавал, а в момента не може да се вземе.
Благодаря за фиксовете. :clover:
Всеки човек е луна и има тъмна страна, която никога не показва никому.

Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #25 -: Септември 27, 2013, 12:07:12 pm »
FIX за http://wotlk.openwow.com/item=38280 / http://wotlk.openwow.com/item=38281 / http://wotlk.openwow.com/quest=12491:
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=23872;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(1,23872,38280,0,0,16,0,1101,0,0,0,0,0,'',NULL),
(1,23872,38281,0,0,16,0,690,0,0,0,0,0,'',NULL);
UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=12491;

Това добавя 2xBrewfest Prize Token дроп от боса:
DELETE FROM `creature_loot_template` WHERE `entry`=23872 AND `item`=37829;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(23872,37829,100,1,0,2,2);
Компенсация, защото не работи RDF наградата.

Остава да се добавят още 2 NPC-та, за да можете да си минете http://wotlk.openwow.com/achievement=2796 ;)

@*Blood_Prince* на питанката не мога да ти отговоря.


Неактивен untaught

  • Duelist
  • *****
  • Публикации: 1045
  • EVO Karma: 96
  • wow user
  • ISP: Vivacom
  • Герой: Volodq
Re: [World Event][372]Brewfest
« Отговор #26 -: Септември 27, 2013, 01:07:31 pm »
Добавяне на http://wotlk.openwow.com/npc=27478:
DELETE FROM `creature` WHERE `id`=27478;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(NULL,27478,0,1,1,22396,1,-4849.64,-862.325,501.916,4.79358,300,0,0,2215,0,0,0,0,0);
Хордската версия си е на мястото.


Неактивен The Aspect

  • Challenger
  • *******
  • Публикации: 2679
  • EVO Karma: 166
  • Sweet Desire
    • Night Legion
  • ISP: BGLan
  • Side: For The Alliance
  • Герой: Winlight, Frozenrose
Re: [World Event][372]Brewfest
« Отговор #27 -: Септември 27, 2013, 01:45:18 pm »
Дано да пиеш виски  :flehan:
I'm everything you can imagine. And a little more.
   Winlight          Frozenrose          Saladin          Chaoswizard

Неактивен Roguetype

  • Gladiator
  • ****
  • Публикации: 575
  • EVO Karma: -5
  • wow user
  • Side: For The Horde
  • Герой: Roguetype
Re: [World Event][372]Brewfest
« Отговор #28 -: Септември 27, 2013, 04:38:44 pm »
Да се къпеш с виски! :flehan:

Неактивен n0Lan

  • Gladiator
  • ****
  • Публикации: 699
  • EVO Karma: -75
  • Evo cyx
Re: [World Event][372]Brewfest
« Отговор #29 -: Септември 27, 2013, 05:16:58 pm »
какво се радвате,че то още не е минал рестарта на сървъра,ако ще има такъв в близките дни,че да проработят кръпките  :freak:
Трудното го правя веднага,за невъзможното ми трябва малко време