Архив - только для чтения | |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина Тема фиксов! |
| Тема фиксов! |
Не пашт :
Code Битва за Черный оплот http://ru.wowhead.com/quest=13166 нету Лоскута и другие мобы ( не выходят ) дай фиксы плиз с меня + Добавлено (01.09.2010, 08:16) Code DELETE FROM `creature_questrelation` WHERE `quest` = 11913; DELETE FROM `gameobject_questrelation` WHERE `quest` = 11913; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 11913; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (26085, 11913); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 26085; DELETE FROM `creature_involvedrelation` WHERE `quest` = 11913; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 11913; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (26085, 11913); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=26085; REPLACE INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `MinLevel`, `MaxLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RepObjectiveFaction2`, `RepObjectiveValue2`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PlayersSlain`, `BonusTalents`, `RewardArenaPoints`, `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`, `unk0`, `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`, `WDBVerified`) VALUES (11913, 2, 3537, 68, 0, 71, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 35491, 1, 0, 'Take No Chances', 'I heard what you told Gerald and I don\'t like it one bit. If cultists managed to poison the grain in the mines with their foul plague, they could\'ve easily done the same with the grain outside.$B$BWe don\'t have time to sort the good grain from the bad. We must act quickly and burn it all.$B$BTake this torch and set fire to any sacks of grain you find out here. It would be a tragedy if we survived this attack only to succumb to the plague afterwards.', 'Wendy Darren wants you to use Wendy\'s Torch to burn 8 sacks of Farshire Grain.', 'I thank you, $N. I would hate to see survivors of the attack on Farshire stumble upon plagued grain.', 'Have you done what I asked of you, $N? ', '', 'Return to Wendy Darren at Farshire in Borean Tundra.', 'Farshire Grain burnt', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35491, 0, 0, 0, 1, 0, 0, 26161, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 37205, 37404, 37524, 37481, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1050, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 47000, 24000, 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, 12340); |
Blooms,
Code DELETE FROM `creature_questrelation` WHERE `quest` = 11913; DELETE FROM `gameobject_questrelation` WHERE `quest` = 11913; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 11913; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (26085, 11913); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 26085; DELETE FROM `creature_involvedrelation` WHERE `quest` = 11913; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 11913; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (26085, 11913); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=26085; 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 (11913, 2, 3537, 0, 68, 71, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 0, 0, 5, 35491, 1, 0, 'Take No Chances', 'I heard what you told Gerald and I don\'t like it one bit. If cultists managed to poison the grain in the mines with their foul plague, they could\'ve easily done the same with the grain outside.$B$BWe don\'t have time to sort the good grain from the bad. We must act quickly and burn it all.$B$BTake this torch and set fire to any sacks of grain you find out here. It would be a tragedy if we survived this attack only to succumb to the plague afterwards.', 'Wendy Darren wants you to use Wendy\'s Torch to burn 8 sacks of Farshire Grain.', 'I thank you, $N. I would hate to see survivors of the attack on Farshire stumble upon plagued grain.', 'Have you done what I asked of you, $N? ', '', 'Return to Wendy Darren at Farshire in Borean Tundra.', 'Farshire Grain burnt', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35491, 0, 0, 0, 1, 0, 0, 26161, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 37205, 37404, 37524, 37481, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1050, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 47000, 120600, 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);
Сообщение # 95 написано 03.09.2010 в 17:40
|
Нужно исправление на квест "Благословления вождя" (13189)
Можно хаком, но желательно правильным исправлением. Добавлено (09.09.2010, 15:43)
Quote #смерть подбирается с высоты UPDATE quest_template SET questflags='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoid2='0', ReqCreatureOrGoid3='0', ReqCreatureOrGoid4='0', ReqCreatureOrGoCount1='0', ReqCreatureOrGoCount2='0', ReqCreatureOrGoCount3='0', ReqCreatureOrGoCount4='0' WHERE entry='12641'; #подарок с подвохом UPDATE quest_template SET Method='0', SrcItemId='0', SrcItemCount='0', ReqItemId1='0', ReqItemCount1='0' WHERE entry='12698'; #побоище у заставы света UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12701'; #путь в долину теней UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12687'; #конец всему UPDATE quest_template SET Method='0', ReqItemId1='0', ReqItemCount1='0' WHERE entry='12779'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12779'; #шаги короля... (альянс - до короля не дойти - убивают и с королем не поговорить) UPDATE creature_template SET faction_A='122', faction_H='122' WHERE entry in ('1748', '1756', '29611'); #Благословение вождя (орда - до трала не дойти - убивают и с тралом не поговорить) UPDATE creature_template SET faction_A='126', faction_H='126' WHERE entry in ('4949', '3296', '14375', '14304', '10540'); #вызов смерти (пвп с ДК-нпсами не работают ) UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12733'; #как завоевать друзей... (добыть нужную информацию в боях с мобами нельзя) UPDATE quest_template SET Method='0', Reqitemid1='0', ReqitemCount1='0' WHERE entry='12720'; #приятный сюрприз (указаного моба нельзя атаковать, он умирает сам, а квест не засчитывается.) #орда UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12739'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12742'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12747'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12748'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12749'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12750'; #альянс UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12742'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12743'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12744'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12745'; UPDATE quest_template SET Method='0', ReqCreatureOrGoid1='0', ReqCreatureOrGoCount1='0' WHERE entry='12746'; #сияние рассвета (подходя к Могрейну, штурм не начинается) #великикй угонщик ======================================================= Хаки для чистого ядра Хаки для тех кто Юзает сборки Карателя. Code
------------------------------------------------------------------------------------
Для кого баги, а кому исходные данные ... Приглашу на Офф сервер! Помощь в игре! Мой перс.
Сообщение # 98 написано 09.09.2010 в 15:43
|
Quote (Sorvanec) Нужно исправление на квест "Благословления вождя" (13189) Можно хаком, но желательно правильным исправлением. Попытался исправить....пробуй... Code DELETE FROM `quest_template` WHERE `quest_template`.`entry` = 13189; INSERT 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 (13189, 2, -372, 0, 55, -1, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 262528, 0, 0, 0, 0, 13166, 0, 0, 0, 7, 43441, 1, 0, 'Warchief''s Blessing', 'You are now, and forever will be, a Knight of the Ebon Blade, $N, but know this: you were once a hero of the Horde.$B$B<Darion stares at you.>$B$BThis order must establish allies for itself if it is to survive. You must represent the Knights of the Ebon Blade to the Horde.$B$BOn the platform, southeast of me, is a portal to Orgrimmar. Take this letter, given to me on your behalf by Lord Fordring, and deliver it to Thrall. Use the portal.', 'Deliver the letter to Thrall, Warchief of the Horde at Orgrimmar.', 'Eitrigg is alive because of this paladin. He would have been executed had Lord Fordring not broken him out of Stratholme.$B$BTirion Fordring, to have sacrificed everything to save the life of an orc... I have ever only known one other human to make such a sacrifice.$B$B<Thrall blinks back a tear.>$B$BYou will be in my heart always, Taretha.$B$BYes. For Tirion Fordring and for Eitrigg! We will accept you as a member of the Horde and your order as allies.$B$BBlood and honor! For the Horde!', 'An interesting turn of events.', '', 'Return to Thrall in Orgrimmar.', '', '', '', '', 43441, 0, 0, 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, 0, 76, 0, 0, 0, 0, 8, 0, 0, 0, 0, 600000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 25, 1, 1, 15, 25, 0, 0, 0, 0, 0, 0);
Сообщение # 99 написано 09.09.2010 в 22:27
|
Привет, сделай пожалуйста фикс на "Битва за чёрный оплот!" или ваще что угодно, главное чтобы работало!
Добавлено (11.09.2010, 08:30)
Ищю пост ГМ, опыт работы с серверами: с выхода 3.0.9
Адекватен. Умею общаться с людьми. Версия wow: 3.3.5а Хорошая фантазия (для эвент мастера). Имееста микро и вебка! Писать в ICQ 628368531 или скайп Leeroi_djenkins
Сообщение # 100 написано 11.09.2010 в 08:30
|
Quote (Достан) Привет, сделай пожалуйста фикс на "Битва за чёрный оплот!" или ваще что угодно, главное чтобы работало! Попробуй фикс... Code DELETE FROM `quest_template` WHERE `quest_template`.`entry` = 13166; INSERT 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 (13166, 2, -372, 0, 55, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128, 0, 0, 0, 0, 13165, 0, 0, 0, 7, 0, 0, 0, 'The Battle For The Ebon Hold', 'The Hall of Command has been secured, but the Lich King has left us a little present in the Heart of Acherus. The stitched terror, Patchwerk, and a horde of abominations have taken over the second floor.$B$BUse the teleporter to get to the second floor and destroy the Scourge forces that remain. Do not engage Patchwerk alone! You must fight the monstrosity with other death knights of Acherus!$B$BGo, $N. You have my strength to carry you!', 'Slay 10 Scourge and help kill Patchwerk. Return to Highlord Darion Mograine should you succeed.', 'Well done, death knight. The remaining Scourge will be dealt with in short order and the rebuilding process will begin anew.$B$BI have but one last task for you.\n', 'Acherus will be ours!', '', 'Return to Highlord Darion Mograine in Ebon Hold.', '', 'Scourge slain', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 31099, 31100, 0, 0, 1, 10, 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, 1098, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25000, 7500, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 25, 0, 0, 0, 0, 0, 0); Или хак Code UPDATE `quest_template` SET `Method` = '0' WHERE `entry` =13166; |
http://ru.wowhead.com/quest=13279 нерабит квест "Основы химии"при нажание на жыдкость около колта нечего не происходит.
http://ru.wowhead.com/quest=13357 нерабит квест "Все переиграть" на wowhead показано что котел должен находится в залах отражения но он то по заданию в Алдур"таре. Итемы собираются 10 штук ->потом собираются в 1 итем но при нажатие у одного из котлов неработает нечего.
Сообщение # 103 написано 16.09.2010 в 10:01
|
Нужен фикс для квеста "Сжечь! Во имя Орды!" - http://ru.wowhead.com/quest=10087 (подбегаю к башням, юзаю факел, каст проходит, эффекта 0)
и квест "Воскрешение" у палов, эльф крови. - http://ru.wowhead.com/quest=9685 (нпц, которого надо воскресить, воскрешается, но квест не защитывается, иногда нпц этого просто нет, иногда он есть, но стоит живой.) ЗАранее спасибо. + ставлю. |
nnnix,
Code UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '18849',`ReqCreatureOrGOId2` = '19008',`ReqSpellCast1` = '0',`ReqSpellCast2` = '0' WHERE `entry` =10087; UPDATE `creature_template` SET `flags_extra` = '130' WHERE `entry` =18849; UPDATE `creature_template` SET `flags_extra` = '130' WHERE `entry` =19008; UPDATE `creature` SET `spawndist` = '0',`MovementType` = '0' WHERE `guid` =59288; UPDATE `creature` SET `spawndist` = '0',`MovementType` = '0' WHERE `guid` =59292; UPDATE `creature` SET `spawndist` = '0',`MovementType` = '0' WHERE `guid` =59264; UPDATE `creature` SET `spawndist` = '0',`MovementType` = '0' WHERE `guid` =59266; REPLACE INTO `creature_ai_scripts` VALUES ('1884951', '18849', '8', '0', '100', '0', '33067', '-1', '0', '0', '33', '18849', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'ytdb-q10087'); UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '18849'; REPLACE INTO `creature_ai_scripts` VALUES ('1900851', '19008', '8', '0', '100', '0', '33067', '-1', '0', '0', '33', '19008', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'ytdb-q10087'); UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '19008'; 
Сообщение # 107 написано 02.10.2010 в 10:56
|
grom243, спасибо, +1.
Добавлено (11.10.2010, 02:41)
Сообщение # 108 написано 11.10.2010 в 02:41
|
FeySon,
Code DELETE FROM `creature_loot_template` WHERE (`entry`=11583); INSERT INTO `creature_loot_template` VALUES (11583, 1203, 7.0597, 0, -1203, 1, 0, 0, 0), (11583, 1973, 7.7874, 0, -1973, 1, 0, 0, 0), (11583, 2564, 8.6609, 0, -2564, 1, 0, 0, 0), (11583, 3395, 1.2372, 0, -3395, 1, 0, 0, 0), (11583, 5266, 11.4993, 0, -5266, 1, 0, 0, 0), (11583, 5267, 8.8064, 0, -5267, 1, 0, 0, 0), (11583, 6660, 2.6201, 0, -6660, 1, 0, 0, 0), (11583, 7734, 10.5531, 0, -7734, 1, 0, 0, 0), (11583, 7976, 1.6012, 0, 1, 1, 0, 0, 0), (11583, 7991, 0.9461, 0, 1, 1, 0, 0, 0), (11583, 8028, 0.5822, 0, 1, 1, 0, 0, 0), (11583, 8269, 1.6, 0, -8269, 1, 0, 0, 0), (11583, 8283, 6.99, 0, -8283, 1, 0, 0, 0), (11583, 8289, 6.55, 0, -8289, 1, 0, 0, 0), (11583, 8303, 12.35, 0, -8303, 1, 0, 0, 0), (11583, 9402, 12.8821, 0, -9402, 1, 0, 0, 0), (11583, 10135, 10.04, 0, -10135, 1, 0, 0, 0), (11583, 10141, 22.45, 0, -10141, 1, 0, 0, 0), (11583, 10246, 15.57, 0, -10246, 1, 0, 0, 0), (11583, 10367, 1.31, 0, 1, 1, 0, 0, 0), (11583, 10608, 0.2911, 0, 1, 1, 0, 0, 0), (11583, 11226, 0.5822, 0, 1, 1, 0, 0, 0), (11583, 11302, 10.3348, 0, -11302, 1, 0, 0, 0), (11583, 12684, 2.9113, 0, -12684, 1, 0, 0, 0), (11583, 12693, 0.5822, 0, -12693, 1, 0, 0, 0), (11583, 12698, 0.2183, 0, 1, 1, 0, 0, 0), (11583, 12702, 0.5095, 0, 1, 1, 0, 0, 0), (11583, 12703, 0.3639, 0, 1, 1, 0, 0, 0), (11583, 12711, 0.7278, 0, 1, 1, 0, 0, 0), (11583, 12717, 0.5095, 0, 1, 1, 0, 0, 0), (11583, 12720, 0.2911, 0, 1, 1, 0, 0, 0), (11583, 12728, 0.655, 0, 1, 1, 0, 0, 0), (11583, 13000, 13.61, 0, -13000, 1, 0, 0, 0), (11583, 13001, 8.2969, 0, -13001, 1, 0, 0, 0), (11583, 13003, 14.8472, 0, -13003, 1, 0, 0, 0), (11583, 13004, 15.7932, 0, -13004, 1, 0, 0, 0), (11583, 13036, 8.1514, 0, -13036, 1, 0, 0, 0), (11583, 13075, 1.8195, 0, 1, 1, 0, 0, 0), (11583, 14497, 0.1456, 0, 1, 1, 0, 0, 0), (11583, 14501, 0.8006, 0, 1, 1, 0, 0, 0), (11583, 14507, 0.1827, 0, 1, 1, 0, 0, 0), (11583, 14510, 0.2183, 0, 1, 1, 0, 0, 0), (11583, 14982, 1.31, 0, 1, 1, 0, 0, 0), (11583, 15742, 0.5095, 0, 1, 1, 0, 0, 0), (11583, 16897, 0, 2, 1, 1, 0, 0, 0), (11583, 16905, 0, 2, 1, 1, 0, 0, 0), (11583, 16916, 0, 1, 1, 1, 0, 0, 0), (11583, 16923, 0, 2, 1, 1, 0, 0, 0), (11583, 16931, 0, 3, 1, 1, 0, 0, 0), (11583, 16942, 0, 1, 1, 1, 0, 0, 0), (11583, 16950, 0, 3, 1, 1, 0, 0, 0), (11583, 16958, 0, 3, 1, 1, 0, 0, 0), (11583, 16966, 0, 1, 1, 1, 0, 0, 0), (11583, 17962, 14.3377, 0, 1, 1, 0, 0, 0), (11583, 17963, 14.1921, 0, 1, 1, 0, 0, 0), (11583, 17964, 14.7016, 0, 1, 1, 0, 0, 0), (11583, 17965, 15.8661, 0, 1, 1, 0, 0, 0), (11583, 17969, 11.7904, 0, 1, 1, 0, 0, 0), (11583, 19002, 100, 0, 1, 1, 6, 67, 0), (11583, 19003, 100, 0, 1, 1, 6, 469, 0), (11583, 19356, 0, 3, 1, 1, 0, 0, 0), (11583, 19360, 0, 4, 1, 1, 0, 0, 0), (11583, 19363, 0, 4, 1, 1, 0, 0, 0), (11583, 19364, 0, 2, 1, 1, 0, 0, 0), (11583, 19375, 0, 2, 1, 1, 0, 0, 0), (11583, 19376, 0, 4, 1, 1, 0, 0, 0), (11583, 19377, 0, 1, 1, 1, 0, 0, 0), (11583, 19378, 0, 4, 1, 1, 0, 0, 0), (11583, 19379, 0, 4, 1, 1, 0, 0, 0), (11583, 19380, 0, 4, 1, 1, 0, 0, 0), (11583, 19381, 0, 1, 1, 1, 0, 0, 0), (11583, 19382, 0, 3, 1, 1, 0, 0, 0), (11583, 21138, -100, 0, 1, 1, 0, 0, 0), (11583, 21142, -10, 0, 1, 1, 0, 0, 0), (11583, 22388, 0.2911, 0, 1, 1, 0, 0, 0), (11583, 22389, 0.2436, 0, 1, 1, 0, 0, 0), (11583, 22390, 0.1218, 0, 1, 1, 0, 0, 0); 
Сообщение # 114 написано 01.11.2010 в 16:05
|
ScullFucker,
Code REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `ExtraFlags`) VALUES (39253, 12, 0, 0, 'Gift of the Harvester', 34872, 1, 64, 1, 0, 0, 0, -1, -1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 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, 52481, 0, 0, 0, 0, 1149, 6000, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 4, 0, 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); Вот вещь.
Сообщение # 119 написано 19.11.2010 в 17:06
|
| |||