• Страница 1 из 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • »
Архив - только для чтения
Модератор форума: andycrowz  
Тема фиксов!
SecWOW
Рыцарь
Ушёл на переквалификацию.
Сообщение # 1 отредактировано SecWOW - Воскресенье, 22.05.2011, 15:39
lanc
The Hurt Locker
не работает квест у дренеев http://ru.wowhead.com/quest=9544 ключи с мобов выбиваються но склетки не открываються!Без этого квеста не будет работать одна линия квестов
http://ru.wowhead.com/quest=9711 Квест на Матиса Круэла не работает!Гвард вызываеться но квест не защитываеться
в Красногорье не работает квест на сопровождение! пол пути идет потом теряеться в текстурах http://ru.wowhead.com/quest=219

что вы можете сделать с этими квестами чтоб заработал нормально либо приблизительно к нормальности ?

использую YTDB 549

Сообщение # 2 отредактировано lanc - Суббота, 05.06.2010, 10:36
SecWOW
Рыцарь
lanc, Укажи это должен быть хак или исправление?

Добавлено (05.06.2010, 10:53)
---------------------------------------------
Квест на матиса.

Code
DELETE FROM `creature_questrelation` WHERE `quest` = 9711;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9711;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9711;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17843, 9711);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17843;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9711;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9711;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17843, 9711);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17843;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (9711, 2, 3525, 0, 15, 18, 1, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 130, 2, 0, 0, 0, 0, 0, 0, 0, 5, 24278, 1, 0, 'Matis the Cruel', 'Matis will be brought to justice, $N; and I want you to be the one to find him and bring him back to the Triumvirate.$B$BScour the island for this killer. Should you find him, use this flare gun. When my trackers see the flare, they\'ll come and assist in capturing Matis. Return to me after he\'s been captured.', 'Vindicator Kuros at Blood Watch wants you to capture Matis the Cruel.', 'The Triumvirate has decided to try Matis immediately. You have brought an arch-criminal to justice on this day, young $r.$B$BYou have performed admirably for two of three; only Aesom remains.
', 'Yes?', 'Matis the Cruel Captured', 'Return to Vindicator Kuros at Blood Watch in Bloodmyst Isle.', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17664, 0, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 26007, 26021, 26033, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 930, 54, 47, 72, 0, 0, 0, 0, 0, 6, 128, 6, 6, 6, 0, 0, 0, 8100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Замени тот кв на этот.

На капрала.

Code
DELETE FROM `creature_questrelation` WHERE `quest` = 219;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 219;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 219;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (349, 219);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 349;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 219;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 219;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (382, 219);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=382;
DELETE FROM `quest_start_scripts` WHERE `id`=219;
INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES     
(219, 1, 0, 0, 0, '2000000021', 0, 0, 0, 0),
(219, 2, 3, 0, 3000, '0', -8768.99, -2185.77, 141.974, 3.11605),
(219, 5, 3, 0, 5000, '0', -8779.5, -2196.64, 140.465, 3.94465),
(219, 10, 3, 0, 13000, '0', -8806.11, -2183.92, 142.16, 2.69586),
(219, 53, 3, 0, 9000, '0', -8830.5, -2189.22, 138.971, 3.3556),
(219, 102, 3, 0, 10000, '0', -8821.39, -2212.62, 143.126, 5.08347),
(219, 112, 3, 0, 6000, '0', -8808.27, -2230.77, 143.359, 5.33873),
(219, 118, 3, 0, 3000, '0', -8800.72, -2238.32, 146.397, 5.4958),
(219, 121, 3, 0, 5000, '0', -8792.75, -2254.35, 146.569, 5.17379),
(219, 126, 3, 0, 9000, '0', -8768.02, -2261.19, 150.383, 6.01023),
(219, 155, 3, 0, 6000, '0', -8747.59, -2250.73, 153.343, 0.473176),
(219, 181, 3, 0, 6000, '0', -8732.42, -2251.82, 154.516, 6.21051),
(219, 187, 3, 0, 6000, '0', -8717, -2244.74, 154.686, 0.42998),
(219, 193, 3, 0, 3000, '0', -8703.68, -2245.71, 154.613, 6.21051),
(219, 196, 3, 0, 3000, '0', -8693, -2239.02, 153.039, 0.559569),
(219, 199, 3, 0, 5000, '0', -8677.93, -2246.16, 155.782, 5.87672),
(219, 224, 3, 0, 4000, '0', -8663.44, -2252.4, 154.695, 5.87672),
(219, 228, 3, 0, 5000, '0', -8672.77, -2265.43, 156.949, 4.05852),
(219, 233, 3, 0, 10000, '0', -8675.63, -2300.83, 156.658, 4.63186),
(219, 243, 3, 0, 18000, '0', -8719.53, -2348.39, 155.916, 3.9682),
(219, 291, 3, 0, 17000, '0', -8756.98, -2374.78, 157.107, 3.75615),
(219, 338, 3, 0, 15000, '0', -8782.75, -2424.16, 155.601, 4.36875),
(219, 353, 3, 0, 15000, '0', -8797.96, -2477.42, 134.003, 4.45514),
(219, 368, 3, 0, 13000, '0', -8837.09, -2500.27, 131.891, 3.78363),
(219, 421, 3, 0, 12000, '0', -8865.81, -2530.12, 134.531, 3.98783),
(219, 473, 3, 0, 3000, '0', -8868.95, -2539.23, 131.656, 4.42373),
(219, 496, 3, 0, 13000, '0', -8907.91, -2570.4, 131.267, 3.81897),
(219, 509, 3, 0, 10000, '0', -8944.97, -2600.59, 132.446, 0.152715),
(219, 529, 3, 0, 15000, '0', -8991.57, -2606.98, 131.1, 3.35951),
(219, 544, 3, 0, 7000, '0', -9015.35, -2595.84, 127.123, 2.73368),
(219, 551, 3, 0, 18000, '0', -9061.77, -2547.68, 123.581, 2.33706),
(219, 569, 3, 0, 15000, '0', -9086.73, -2539.15, 118.953, 2.77688),
(219, 584, 3, 0, 19000, '0', -9131.13, -2479.09, 114.616, 2.20747),
(219, 623, 3, 0, 6000, '0', -9159.75, -2416.33, 104.534, 2.00326),
(219, 629, 3, 0, 13000, '0', -9152.94, -2390.45, 99.9893, 1.37102),
(219, 672, 3, 0, 20000, '0', -9189.57, -2359.44, 89.2926, 2.43916),
(219, 702, 3, 0, 16000, '0', -9283.07, -2287.16, 67.5126, 2.7651),
(219, 719, 0, 0, 0, '2000000022', 0, 0, 0, 0),
(219, 719, 7, 219, 10, '0', 0, 0, 0, 0),
(219, 725, 3, 0, 16000, '0', -8762.98, -2185.92, 141.016, 3.11605);
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (219, 2, 44, 0, 19, 25, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 2, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0, 'Missing In Action', 'At last, friends of the Alliance!$b$bHelp... please... $b$bThe last thing I remember these foul Orcs overpowered our regiment.  Most the men were killed. I took a strong blow to the head and everything went black. Now I am held captive in this cave.  Help me, I am hurt badly.$b$bI\'ll need help getting back to town... please... you\'re my last hope...', 'Protect Corporal Keeshan on the journey back to Redridge.', 'You have served the Kingdom well, $C. Thank you for assisting Corporal Keeshan with his escape from those dreaded Blackrock Orcs. You shall be rewarded for your brave acts this day.', '', 'Escort Corporal Keeshan back to Redridge', 'Return to Marshal Marris at Lakeshire in Redridge Mountains.', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3555, 1275, 3431, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 930, 54, 47, 72, 0, 0, 0, 0, 0, 87, 87, 87, 87, 87, 0, 0, 0, 15300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 219, 0);

Для дренеев.

Code
DELETE FROM `creature_questrelation` WHERE `quest` = 9544;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 9544;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 9544;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (17364, 9544);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 17364;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 9544;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 9544;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (17114, 9544);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=17114;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (9544, 2, 3524, 0, 8, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 9542, 0, 0, 0, 7, 0, 0, 0, 'The Prophecy of Akida', 'The images on this totem depict a war between the Stillpine and the Bristlelimb furbolg tribes. The etchings show that the Bristlelimb have done unconscionable things to the furbolgs of Stillpine.$B$BAmidst the chaos, a prophecy has begun to unfold: A hero will rise - not of furbolg blood - and save the Stillpine tribe.$B$BSlay Bristlelimb furbolgs at Bristlelimb Village for their keys. Use the keys to free the Stillpine captives. Return to Arugoo of the Stillpine when you have freed them all!$B', 'Free 8 Stillpine Captives from cages found in Bristlelimb Village. Return to Arugoo of the Stillpine at Azure Watch when you have completed this task.', 'The prophecy spoke of one that would rise and deliver us from the oppressive grasp of Bristlelimb -- that the spirits themselves would herald the arrival of this hero.$B$BAnd now, you have come.$B$BI humble myself before you, great one.', '[Furbolg] So the prophecy of Akida is true... A hero has been delivered to us.', '', 'Return to Arugoo of the Stillpine at Azure Watch in Azuremyst Isle.', 'Stillpine Captive Freed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -181714, 0, 0, 0, 8, 0, 0, 0, 30406, 0, 0, 0, 27399, 27403, 27401, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 930, 0, 0, 0, 0, 0, 0, 0, 0, 0, 500, 0, 0, 0, 0, 0, 0, 0, 780, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Добавил спелл http://ru.wowhead.com/spell=30406.
Если не зароботает скажи.
Я создам итем ключ и добалю туда спелл.Не забудь отблагодорить.
Заказываем

Сообщение # 3 отредактировано SecWOW - Суббота, 05.06.2010, 11:09
lanc
The Hurt Locker
не должны быть хаками!!! взял проверить если будут работать хотябы один + с меня гарантирован
Сообщение # 4 написано 05.06.2010 в 11:08
SecWOW
Рыцарь
lanc, Это я выложил не хаки ,а исправления.
Сообщение # 5 написано 05.06.2010 в 11:09
lanc
The Hurt Locker
[9544] не открываются клетки в режиме гм есть вторые виды клеток они открываются но он не видны игрокам

[9711] защитывается +
[219] так же как и было нпц около выхода из пещеры пропадает в текстурах думаю тут не вы не я не кто либо в базе не исправят тут в скрипте видать неверные координаты точек прописаны

Сообщение # 6 написано 05.06.2010 в 11:40
freestyler771
Скаут
1) - Вот ссыль на КВ
2) - Тупо подхожу к Маназмею кастую Волшебный поток и нечего не происходит wacko ! Сам спелл работает отлично! biggrin
3) - (а)
Сообщение # 7 написано 05.06.2010 в 15:34
SecWOW
Рыцарь
lanc, [219]сейчас ещё попрбую.
Если что ещё обращайся.
freestyler771,
Code
DELETE FROM `creature_questrelation` WHERE `quest` = 8346;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 8346;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 8346;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (15297, 8346);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 15297;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 8346;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 8346;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (15297, 8346);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=15297;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (8346, 2, 3431, 0, 2, 3, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 524424, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 'Thirst Unending', 'If there is only one lesson you deign to remember from your time on Sunstrider Isle, let it be this - control your thirst for magic.  It is a thirst unending, $N - what you absorb must be controlled and released via Arcane Torrent.  Failure is to become one of the Wretched... hopelessly addicted and insane.$B$BSeek out a mana wyrm and unleash your Arcane Torrent upon it.  Learn to master your power. When you have sufficiently released an Arcane Torrent, return to me.', 'Use your Arcane Torrent racial ability on a Mana Wyrm, then return to Arcanist Helion.', 'You\'ve done well today, $N. Your willingness to learn shows that you may very well rise above the unyielding cravings you must endure as a $R.$B$BRest not on your laurels, young one, but instead seek to master what you have learned. Only through diligence will we as a race survive.$B$BTake this ', 'Ah $N. Have you completed your task?', '', 'Return to Arcanist Helion at Sunstrider Isle in Eversong Woods.', 'Arcane Torrent unleashed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15468, 0, 0, 0, 1, 0, 0, 0, 28730, 0, 0, 0, 20999, 21000, 21001, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 911, 0, 0, 0, 0, 0, 0, 0, 0, 0, 250, 0, 0, 0, 0, 0, 0, 0, 150, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Исправил вроде должно работать.Если пашет с тебя +

lanc, В квесте где нужно было провести тоже были прописанны точки.

Добавлено (05.06.2010, 19:54)
---------------------------------------------
lanc, А сам спелл на открывание двери кастуется?

Добавлено (05.06.2010, 19:56)
---------------------------------------------
lanc, Я могу сделать чтоб просто взял ключи 8 шт. и здал.Подойдёт?

Сообщение # 8 написано 05.06.2010 в 19:56
Agetron
Скаут
не работает квест http://ru.wowhead.com/quest=14444 то, что знают драконы. Подходишь к НПС, надо с ним поговорить, а он не хочит.
Сообщение # 9 написано 06.06.2010 в 07:43
SecWOW
Рыцарь
Agetron, Вот сделал.
Code
DELETE FROM `creature_questrelation` WHERE `quest` = 14444;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 14444;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 14444;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (36624, 14444);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 36624;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 14444;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 14444;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (36669, 14444);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=36669;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (14444, 2, 210, 0, 80, 80, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 14443, 14457, 0, 14457, 5, 0, 0, 0, 'What The Dragons Know', 'There\'s no mistaking it - this hilt comes from a powerful, ancient weapon, but which one? I do not recall seeing or hearing of a sword with these markings, but that doesn\'t mean that all is lost.$B$BKorialstrasz, better known as Krasus, has long been a friend to the quel\'dorei and the Kirin Tor. With his vast knowledge and resources, he\'s certain to know something. Travel to the top of Wyrmrest Temple and seek his counsel, then report to Arcanist Tybalin inside the Silver Enclave in Dalaran.', 'Speak to Krasus at the top of Wyrmrest Temple.', 'We can\'t let that book remain in Sunreaver hands. If we hope to identify the sword and use it to our advantage, we have to find a way to capture the book Krasus lent them.', '', '', 'Return to Arcanist Tybalin at the Silver Enclave in Dalaran.', 'Ask Krasus about the hilt\'s origins', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36715, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Насколько я понял ты не мог с квестёром говрить?Если да ,то я сделал.

Добавлено (06.06.2010, 08:56)
---------------------------------------------
lanc, Вот Пророчество Акиды

Code
UPDATE `gameobject_template` SET `flags` = 32 WHERE `entry` = 181714;

P.S перед этим почисти кеш игры.

Добавлено (06.06.2010, 09:23)
---------------------------------------------
Поздравляю всех с закрепление темы!

Сообщение # 10 написано 06.06.2010 в 09:23
freestyler771
Скаут
SecWOW, Потом проверю если робит конечно же ставлю +! wink
Сообщение # 11 написано 06.06.2010 в 09:48
Agetron
Скаут
а случайно чтоб эвент запускался в ИК не можешь сделать, а то к НПС в инсте подходишь а он просто с тобой здоровается))
Сообщение # 12 написано 06.06.2010 в 09:54
SecWOW
Рыцарь
Agetron, Не я не знаю такого...
Сообщение # 13 написано 06.06.2010 в 10:07
Agetron
Скаут
Не, квест не робит) т.е. там как...берёшь квест, затем надо поговорить с красс id 27990. а он просто привет и всё) квест не принемает. Получается так что если убьёшь краса id 27990, то квест защитывается, но по квесту его не убить надо а поговорить.))
Сообщение # 14 отредактировано Agetron - Воскресенье, 06.06.2010, 10:43
SecWOW
Рыцарь
Agetron, Я щас поставлю чтоб надо было его убить сойдёт?

Добавлено (06.06.2010, 10:53)
---------------------------------------------
Вот у кого он берётся.
Вот у кого сдаётся .
У меня написанно что надо убить того который рассказывает.

Добавлено (06.06.2010, 10:55)
---------------------------------------------

Code
DELETE FROM `creature_questrelation` WHERE `quest` = 14444;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 14444;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 14444;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (36624, 14444);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 36624;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 14444;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 14444;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (36669, 14444);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=36669;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `RewXPId`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValueId1`, `RewRepValueId2`, `RewRepValueId3`, `RewRepValueId4`, `RewRepValueId5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewHonorAddition`, `RewHonorMultiplier`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (14444, 2, 210, 0, 80, 80, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 14443, 14457, 0, 14457, 5, 0, 0, 0, 'What The Dragons Know', 'There\'s no mistaking it - this hilt comes from a powerful, ancient weapon, but which one? I do not recall seeing or hearing of a sword with these markings, but that doesn\'t mean that all is lost.$B$BKorialstrasz, better known as Krasus, has long been a friend to the quel\'dorei and the Kirin Tor. With his vast knowledge and resources, he\'s certain to know something. Travel to the top of Wyrmrest Temple and seek his counsel, then report to Arcanist Tybalin inside the Silver Enclave in Dalaran.', 'Speak to Krasus at the top of Wyrmrest Temple.', 'We can\'t let that book remain in Sunreaver hands. If we hope to identify the sword and use it to our advantage, we have to find a way to capture the book Krasus lent them.', '', '', 'Return to Arcanist Tybalin at the Silver Enclave in Dalaran.', 'Ask Krasus about the hilt\'s origins', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 74000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Вот кв чтоб он не с кем не говорил а с Ледяной Короны в Даларан шёл....

Добавлено (06.06.2010, 10:57)
---------------------------------------------
Ну вообщем можно сделать два квеста что один раз погорил с тем ,а другой чтоб в даларан летел...

Сообщение # 15 написано 06.06.2010 в 10:57
Agetron
Скаут
да можно конечно чтоб краса можно было убить, но я дальше проследил ципочку квестов и там далее квест не робит, а именно http://ru.wowhead.com/quest=20439 (накидку не дали, и нпс не даёт книгу) понял о чём я..)) а вот этот код что ты мне дал он чем отличается от первого? id 36670 Магистр Хаторель
Сообщение # 16 отредактировано Agetron - Воскресенье, 06.06.2010, 11:12
freestyler771
Скаут
SecWOW, Скажи плиз куда именно в навикате залить!? surprised
Сообщение # 17 написано 06.06.2010 в 11:16
SecWOW
Рыцарь
SecWOW, Да там не кого убивать не надо а просто из Ледяной короны в Даларан поехать..

Добавлено (06.06.2010, 11:18)
---------------------------------------------
freestyler771, Не через навикат а через Quice

Сообщение # 18 написано 06.06.2010 в 11:18
freestyler771
Скаут
SecWOW, Как? Я квайсом не разу не пользовался sad tongue
Сообщение # 19 написано 06.06.2010 в 11:19
SecWOW
Рыцарь
Ты его скачал?
Сообщение # 20 написано 06.06.2010 в 11:29
freestyler771
Скаут
SecWOW, Да
Сообщение # 21 написано 06.06.2010 в 11:32
SecWOW
Рыцарь
Вводи в поле сервер : localhost
login : mangos
password :mangos
Characters : characters
realmd : realmd
mangos : mangos
script : scriptsev2
Hosts : ничего не пиши.
Потом жми quests
sql-script и копируй nуда мой скрипт и жми execute script.
Сообщение # 22 написано 06.06.2010 в 11:38
lanc
The Hurt Locker
SecWOW, нет хаковый вариант открытия клеток не нужен написал в YTDB может помогут
Сообщение # 23 написано 06.06.2010 в 13:25
seregad
Скаут
Квест "доброта" не правельно работает, не могу накормить драконов, квест зашитываеться только если их убиваеш, убиваю иду дальще и дальше по кв цепи появляеться еше баг кв каторый уже н могу обойти"Силы Нельтараку" камень респаю, дракон освобаждаеться меняеться на дружескую фракцию начинает есть врагов вокруг себя ,но мне не зашитываеться что я его освобадил(((,
Дайте пожалуста фикс на эти два кв!!!
Сообщение # 24 написано 06.06.2010 в 18:59
SecWOW
Рыцарь
seregad, Добавил спелл всё должо работать...
Code
DELETE FROM `creature_questrelation` WHERE `quest` = 10804;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 10804;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 10804;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (22113, 10804);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 22113;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 10804;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 10804;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (22113, 10804);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=22113;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (10804, 2, 3520, 0, 70, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10811, 0, 10811, 0, 0, 0, 'Kindness', 'Something has them spooked, $r.$B$B<Mordenai points to the nether drakes flying overhead.>$B$BThey won\'t even come down to feed. I have seen several fall to the earth, dead from exhaustion before their bodies hit the ground.$B$BWe must save them! The Rocknail flayers that are found near the crystals are their natural prey. Kill flayers and take their carcasses. Place a carcass in the field and stand extremely still. As long as you do not make any aggressive motions, they will not attack you.', 'Mordenai at Netherwing Fields in Shadowmoon Valley wants you to feed 8 Mature Netherwing Drakes.', 'You are a kind and compassionate $R, friend.', 'I cannot save them by myself, $N!', '', 'Mature Netherwing Drake fed', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31372, 31373, 0, 0, 8, 40, 0, 0, 21648, 0, 0, 0, 8, 0, 0, 0, 38439, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Добавлено (06.06.2010, 21:24)
---------------------------------------------
lanc, Там был такой вопрос.

Добавлено (06.06.2010, 21:31)
---------------------------------------------
Силы Нельтараку

Code
DELETE FROM `creature_questrelation` WHERE `quest` = 10854;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 10854;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 10854;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (21657, 10854);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 21657;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 10854;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 10854;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (21657, 10854);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=21657;
REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqSourceId1`, `ReqSourceId2`, `ReqSourceId3`, `ReqSourceId4`, `ReqSourceCount1`, `ReqSourceCount2`, `ReqSourceCount3`, `ReqSourceCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `ReqSpellCast1`, `ReqSpellCast2`, `ReqSpellCast3`, `ReqSpellCast4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewOrReqMoney`, `RewMoneyMaxLevel`, `RewSpell`, `RewSpellCast`, `RewMailTemplateId`, `RewMailDelaySecs`, `PointMapId`, `PointX`, `PointY`, `PointOpt`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`) VALUES (10854, 2, 3520, 0, 70, 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 10837, 10858, 0, 10858, 31652, 1, 0, 'The Force of Neltharaku', 'Take this enchanted nethervine crystal and make your way back to Dragonmaw Fortress. Once there, seek out the enslaved drakes and invoke the magic of the nethervine crystal. My own energies will pour forth, causing the drakes to break free from the bond of their captors. When you see that the drake has broken free, help it defeat its captor! It will most assuredly be weak from the imprisonment.$B$BRelease all that you can find and return to me, $N.', 'Neltharaku, flying high above Netherwing Fields in Shadowmoon Valley, wants you to free 5 Enslaved Netherwing Drakes.', '<Neltharaku laughs.>$B$BThe orcs must have been shocked to see the drakes turn on them in such a manner. Well done, $N. Perhaps you truly are the hero of our flight.', 'Waste no time, we have much work to do!', '', 'Enslaved Netherwing Drake freed', '', '', '', 31652, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22316, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 75900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Должно работать...
Если не будет тогда проблемы в ядре.
Сообщение # 25 написано 06.06.2010 в 21:31
lanc
The Hurt Locker
к слову о [9544] квесте
Code
UPDATE `gameobject_template` SET `flags` = 32 WHERE `entry` = 181714;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '-50' WHERE `item` =23801;

взято из YTDB.ru
--------------------------------------------------------------------------------------
SecWOW,
Quote
фикс на Демонический круг :

не мой ли там патчик*? smile
Сообщение # 26 отредактировано lanc - Воскресенье, 06.06.2010, 22:51
SecWOW
Рыцарь
lanc, Нет. Ru-mangos.ru это патч.
Сообщение # 27 написано 07.06.2010 в 08:38
lanc
The Hurt Locker
старый вариант он, каратель написал новый
Сообщение # 28 написано 07.06.2010 в 13:59
SecWOW
Рыцарь
lanc, Ну не знаю...
(сорри офф топ)
Сообщение # 29 написано 07.06.2010 в 14:46
Blooms
~Убийца Чудовищ~
кул стораешся
[/url]
Сообщение # 30 отредактировано Blooms - Пятница, 11.06.2010, 10:05
  • Страница 1 из 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • »
Поиск: