Архив - только для чтения | |
Модератор форума: andycrowz |
Форум Корзина форума Корзина Тема фиксов! |
Тема фиксов! |
не работает квест у дренеев http://ru.wowhead.com/quest=9544 ключи с мобов выбиваються но склетки не открываються!Без этого квеста не будет работать одна линия квестов
http://ru.wowhead.com/quest=9711 Квест на Матиса Круэла не работает!Гвард вызываеться но квест не защитываеться в Красногорье не работает квест на сопровождение! пол пути идет потом теряеться в текстурах http://ru.wowhead.com/quest=219 что вы можете сделать с этими квестами чтоб заработал нормально либо приблизительно к нормальности ? использую YTDB 549 |
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. |
[9544] не открываются клетки в режиме гм есть вторые виды клеток они открываются но он не видны игрокам
[9711] защитывается +
Сообщение # 6 написано 05.06.2010 в 11:40
|
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) Добавлено (05.06.2010, 19:56)
Сообщение # 8 написано 05.06.2010 в 19:56
|
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) Code UPDATE `gameobject_template` SET `flags` = 32 WHERE `entry` = 181714; P.S перед этим почисти кеш игры. Добавлено (06.06.2010, 09:23)
Сообщение # 10 написано 06.06.2010 в 09:23
|
Не, квест не робит) т.е. там как...берёшь квест, затем надо поговорить с красс id 27990. а он просто привет и всё) квест не принемает. Получается так что если убьёшь краса id 27990, то квест защитывается, но по квесту его не убить надо а поговорить.))
|
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
|
да можно конечно чтоб краса можно было убить, но я дальше проследил ципочку квестов и там далее квест не робит, а именно http://ru.wowhead.com/quest=20439 (накидку не дали, и нпс не даёт книгу) понял о чём я..)) а вот этот код что ты мне дал он чем отличается от первого? id 36670 Магистр Хаторель
|
Вводи в поле сервер : 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
|
Квест "доброта" не правельно работает, не могу накормить драконов, квест зашитываеться только если их убиваеш, убиваю иду дальще и дальше по кв цепи появляеться еше баг кв каторый уже н могу обойти"Силы Нельтараку" камень респаю, дракон освобаждаеться меняеться на дружескую фракцию начинает есть врагов вокруг себя ,но мне не зашитываеться что я его освобадил(((,
Дайте пожалуста фикс на эти два кв!!!
Сообщение # 24 написано 06.06.2010 в 18:59
|
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) Добавлено (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
|
к слову о [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 фикс на Демонический круг : не мой ли там патчик*? |
| |||