Главная Форум Файлы
Вы находитесь: Wow-Good.Ru » WoW » Mists of Pandaria




Страница 1 из 11
Модератор форума: Влад 
Форум » TrinityCore » Фиксы » Фикс квеста Давно забытые воспоминания
Фикс квеста Давно забытые воспоминания
Влад Дата: Четверг, 12.04.2012, 20:06 | Сообщение # 1





Code
DELETE FROM `creature_questrelation` WHERE `quest` = 8305;  
DELETE FROM `gameobject_questrelation` WHERE `quest` = 8305;  
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 8305;  
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (15192, 8305);  
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 15192;  
DELETE FROM `creature_involvedrelation` WHERE `quest` = 8305;  
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 8305;  
INSERT INTO `gameobject_involvedrelation` (`id`, `quest`) VALUES (180633, 8305);  
DELETE FROM `quest_start_scripts` WHERE `id`=8305;  
INSERT INTO `quest_start_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES   
(8305, 5, 15, 25201, 0, '0', 0, 0, 0, 0);  
DELETE FROM `quest_template` WHERE `Id` = 8305;  
INSERT INTO `quest_template` (`Id`, `Method`, `Level`, `MinLevel`, `MaxLevel`, `ZoneOrSort`, `Type`, `SuggestedPlayers`, `LimitTime`, `RequiredClasses`, `RequiredRaces`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredFactionId1`, `RequiredFactionId2`, `RequiredFactionValue1`, `RequiredFactionValue2`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestIdChain`, `RewardXPId`, `RewardOrRequiredMoney`, `RewardMoneyMaxLevel`, `RewardSpell`, `RewardSpellCast`, `RewardHonor`, `RewardHonorMultiplier`, `RewardMailTemplateId`, `RewardMailDelay`, `SourceItemId`, `SourceItemCount`, `SourceSpellId`, `Flags`, `SpecialFlags`, `RewardTitleId`, `RequiredPlayerKills`, `RewardTalents`, `RewardArenaPoints`, `RewardItemId1`, `RewardItemId2`, `RewardItemId3`, `RewardItemId4`, `RewardItemCount1`, `RewardItemCount2`, `RewardItemCount3`, `RewardItemCount4`, `RewardChoiceItemId1`, `RewardChoiceItemId2`, `RewardChoiceItemId3`, `RewardChoiceItemId4`, `RewardChoiceItemId5`, `RewardChoiceItemId6`, `RewardChoiceItemCount1`, `RewardChoiceItemCount2`, `RewardChoiceItemCount3`, `RewardChoiceItemCount4`, `RewardChoiceItemCount5`, `RewardChoiceItemCount6`, `RewardFactionId1`, `RewardFactionId2`, `RewardFactionId3`, `RewardFactionId4`, `RewardFactionId5`, `RewardFactionValueId1`, `RewardFactionValueId2`, `RewardFactionValueId3`, `RewardFactionValueId4`, `RewardFactionValueId5`, `RewardFactionValueIdOverride1`, `RewardFactionValueIdOverride2`, `RewardFactionValueIdOverride3`, `RewardFactionValueIdOverride4`, `RewardFactionValueIdOverride5`, `PointMapId`, `PointX`, `PointY`, `PointOption`, `Title`, `Objectives`, `Details`, `EndText`, `OfferRewardText`, `RequestItemsText`, `CompletedText`, `RequiredNpcOrGo1`, `RequiredNpcOrGo2`, `RequiredNpcOrGo3`, `RequiredNpcOrGo4`, `RequiredNpcOrGoCount1`, `RequiredNpcOrGoCount2`, `RequiredNpcOrGoCount3`, `RequiredNpcOrGoCount4`, `RequiredSourceItemId1`, `RequiredSourceItemId2`, `RequiredSourceItemId3`, `RequiredSourceItemId4`, `RequiredSourceItemCount1`, `RequiredSourceItemCount2`, `RequiredSourceItemCount3`, `RequiredSourceItemCount4`, `RequiredItemId1`, `RequiredItemId2`, `RequiredItemId3`, `RequiredItemId4`, `RequiredItemId5`, `RequiredItemId6`, `RequiredItemCount1`, `RequiredItemCount2`, `RequiredItemCount3`, `RequiredItemCount4`, `RequiredItemCount5`, `RequiredItemCount6`, `RequiredSpellCast1`, `RequiredSpellCast2`, `RequiredSpellCast3`, `RequiredSpellCast4`, `Unknown0`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `DetailsEmote1`, `DetailsEmote2`, `DetailsEmote3`, `DetailsEmote4`, `DetailsEmoteDelay1`, `DetailsEmoteDelay2`, `DetailsEmoteDelay3`, `DetailsEmoteDelay4`, `EmoteOnIncomplete`, `EmoteOnComplete`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `OfferRewardEmoteDelay1`, `OfferRewardEmoteDelay2`, `OfferRewardEmoteDelay3`, `OfferRewardEmoteDelay4`, `StartScript`, `CompleteScript`, `WDBVerified`) VALUES (8305, 2, 60, 60, 0, 1377, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 910, 0, 0, 0, 8303, 0, 0, 8519, 5, 0, 5700, 0, 0, 0, 0, 0, 0, 0, 0, 0, 589824, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 910, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Long Forgotten Memories', 'Locate the Crystalline Tear in Silithus and gaze into its depths.', 'In the southern desert of Silithus, near the sacred barrier, exists a single crystalline tear. This tear serves as a symbol of the great losses beset upon us during the War of the Shifting Sands. Locate this tear and gaze into its depths to gain enlightenment.$B', '', 'You can feel a great sorrow revolving around this crystal. The force is so powerful that you feel as if you might collapse and die of sadness.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1, 0, 0, 0, 0, 0, 0, 0, 0, 8305, 0, 12340);

 


Shuni Дата: Пятница, 13.04.2012, 12:42 | Сообщение # 2
Скаут
Сообщений: 11
Репутация: 11
Награды: 0
OOPs



Сборка серверов Trinity{linux,Windows}
Обращаться в скайп barmaley282


Сообщение отредактировал Shuni - Пятница, 13.04.2012, 15:51
 
root Дата: Пятница, 13.04.2012, 12:45 | Сообщение # 3
HellCore Dev
Сообщений: 100
Репутация: 27
Награды: 1
Quote (Shuni)
не через базу.

Буду знать...

 
Shuni Дата: Пятница, 13.04.2012, 13:15 | Сообщение # 4
Скаут
Сообщений: 11
Репутация: 11
Награды: 0
sad в mysql вы не добьетесь точной реализации,поэтому и будет считаться хаком,лучшая реализация через C++



Сборка серверов Trinity{linux,Windows}
Обращаться в скайп barmaley282
 
Форум » TrinityCore » Фиксы » Фикс квеста Давно забытые воспоминания
Страница 1 из 11
Поиск: