|
Архив - только для чтения |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина Мои Фиксы для Сервером 3.1.х (Team FreeSpell) (Ставим + если помог) |
| Мои Фиксы для Сервером 3.1.х (Team FreeSpell) |
Я щас Занимаюсь Локацыей Ледяная Корона Так что Покамисто тут все фиксы (для этой Локи)
[blizz]Мобы[/blizz] Code REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (30281, 0, 22474, 0, 22474, 0, 'Silver Covenant Hippogryph', '', '', 80, 80, 37800, 37800, 0, 0, 4190, 1094, 2025, 35, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''); REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (33479, 0, 28707, 0, 28749, 28748, 'Stormwind Valiant', '', 'Directions', 80, 80, 25200, 25200, 0, 0, 5250, 1078, 1078, 35, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''); REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (33565, 0, 28705, 0, 28712, 0, 'Darnassus Valiant', '', 'Directions', 80, 80, 25200, 25200, 0, 0, 5250, 35, 35, 0, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''); REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (33643, 0, 28756, 0, 28754, 28755, 'Silver Covenant Guardian', '', '', 80, 80, 126000, 126000, 0, 0, 5250, 35, 35, 0, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''); REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (33463, 0, 28704, 0, 28714, 0, 'Gnomeregan Valiant', '', '', 80, 80, 25200, 25200, 0, 0, 5250, 35, 35, 0, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, '');
Code REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (33566, 0, 28709, 0, 28713, 0, 'Exodar Valiant', '', 'Directions', 80, 80, 25200, 25200, 0, 0, 5250, 35, 35, 0, 1, 1, 0, 275, 322, 0, 256, 2000, 1500, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 0, ''); [blizz]Квесты[/blizz] Code DELETE FROM `creature_questrelation` WHERE `quest` = 13838; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13838; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13838; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (33659, 13838); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 33659; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13838; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13838; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (33659, 13838); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33659; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13838, -241, 0, 80, 80, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mastery Of The Shield-Breaker', 'You\'ll need to learn how to break through an opponent\'s defenses to succeed in mounted combat. Take this lance and mount the stabled Sunreaver hawkstrider just outside the pavilion.$B$BOnce you\'re mounted, seek out Valis Windchaser. He\'ll be on the northern edge of the tournament grounds at the training area east of the Aspirants\' Ring. Valis will teach you the basics of using a ranged shield breaker attack to make a ranged target vulnerable.', 'Equip your lance and mount the Stabled Sunreaver Hawkstrider. Speak to Valis Windchaser and use Shield-Breaker on 2 vulnerable Ranged Targets, then return to Galathia Brightdawn at the Argent Tournament Grounds.', 'Commit Valis\'s lesson to memory, $N. It will mean the difference between winning and losing your mounted combat matches.', '', '', 'Valis Windchaser\'s advice', 'Use Shield-Breaker on vulnerable Ranged Target', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33974, '', 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, 1124, 0, 0, 0, 0, 75, 0, 0, 0, 0, 37000, 66300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Code DELETE FROM `creature_questrelation` WHERE `quest` = 13677; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13677; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13677; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (33659, 13677); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 33659; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13677; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13677; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (33659, 13677); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33659; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13677, -241, 0, 77, 80, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4232, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Learning The Reins', 'Most of the tournament\'s competitions require competitors to master the command of a mount in battle. In order to familiarize you with mounted combat, we\'ve put up training dummies all over the northern part of the tournament grounds.$B$BVisit the stables outside the pavilion, equip your lance, and mount up on the Sunreaver hawkstrider. Familiarize yourself with the mount and use its abilities to defeat the three different kinds of training dummies. $B', 'Strike a Melee Target with Thrust 5 times, use Shield-Breaker on 2 vulnerable Ranged Targets, use Charge on 2 vulnerable Charge Targets, and then return to Galathia Brightdawn at the Argent Tournament Grounds.$B$BIf you lose your lance, you can get another from any of the Lance Racks near the stables or the Sunreaver Pavilion.', 'Well done, $N. Mounted combat is often hard to pick up for those accustomed to fighting on foot. I have no doubt that you\'ll continue to improve with practice, which is more than I can say for some warriors.', '', '', 'Use Thrust on Melee Target', 'Use Shield-Breaker on vulnerable Ranged Target', 'Use Charge on vulnerable Charge Target', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33272, 33243, 33229, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 45192, 0, 0, 0, 2, 0, 0, 0, 1124, 0, 0, 0, 0, 250, 0, 0, 0, 0, 58000, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Все наши Сборки тут Наш сайт Добавлено (24.06.2009, 00:40) Code Квесты Code DELETE FROM `creature_questrelation` WHERE `quest` = 13839; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13839; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13839; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (33658, 13839); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 33658; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13839; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13839; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (33658, 13839); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33658; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13839, -241, 0, 80, 80, 0, 690, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Mastery Of The Charge', 'Your strongest attack in mounted combat is undoubtedly the charge. Take this lance and mount the stabled Sunreaver hawkstrider just outside the pavilion.$B$BOnce you\'re mounted, speak with Rugan Steelbelly. He\'s on the northern edge of the tournament grounds at the training area east of the Aspirants\' Ring. Rugan will tell you how to use this powerful ability and teach you some basic strategies.', 'Equip your lance and mount the Stabled Sunreaver Hawkstrider outside the pavilion. Speak to Rugan Steelbelly and Charge 2 vulnerable Charge Targets, then return to Amariel Sunsworn at the Argent Tournament Grounds.', 'With experience and practice, you will become deadly with the charge.', '', '', 'Rugan Steelbelly\'s advice', 'Charge vulnerable Charge Target', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33272, 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, 1124, 0, 0, 0, 0, 75, 0, 0, 0, 0, 37000, 66300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Code DELETE FROM `creature_questrelation` WHERE `quest` = 13809; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13809; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13809; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (33759, 13809); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 33759; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13809; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13809; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (33759, 13809); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33759; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13809, -241, 0, 80, 80, 1, 690, 0, 0, 0, 0, 0, 0, 0, 3, 0, 4232, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Threat From Above', 'Highlord Tirion Fordring has doubled the guard since your exposure of the Cult of the Damned\'s infiltrator. He doesn\'t believe that they will stop just because their Black Knight has been defeated.$B$BOur skytalon scouts have reported sighting a frost wyrm named Chillmaw leading a cult raiding party. If we don\'t intercept them, the tournament will come under attack. The scouts reporting seeing Chillmaw to the southwest, flying over the area between the Ironwall Rampart and Aldur\'thar.', 'Eadric the Pure at the Argent Tournament wants you to defeat Chillmaw and 3 Cultist Bombardiers.', '$N, you and your allies have spared the tournament from a devastating attack. Though our skytalon riders are brave, they have their hands full keeping the peace on the tournament grounds and would be hard-pressed to defend the skies against the cult\'s attack. You have the thanks of the Argent Crusade and all who have gathered here to compete.', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46114, 45724, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 44990, 0, 0, 0, 2, 0, 0, 0, 1124, 1106, 0, 0, 0, 250, 250, 0, 0, 0, 0, 132300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); DELETE FROM `creature_questrelation` WHERE `quest` = 13828; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13828; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13828; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (33625, 13828); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 33625; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13828; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13828; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (33625, 13828); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=33625; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13828, -241, 0, 77, 80, 0, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 0, 136, 0, 0, 13667, 0, 0, 0, 0, 0, 0, 'Mastery Of Melee', 'The heart of tournament competition is mounted melee combat. Take this lance and mount the stabled Quel\'dorei steed just outside the pavilion.$B$BOnce you\'re mounted, seek out Jeran Lockwood. He\'s on the northern edge of the tournament grounds at the training area east of the Aspirants\' Ring. Jeran will instruct you on how to use your defenses to keep you safe while attacking a melee target at close range.', 'Equip your lance, then mount the Stabled Quel\'dorei Steed outside the pavilion. Speak to Jeran Lockwood and use Thrust 5 times on a Melee Target, then return to Arcanist Taelis at the Argent Tournament Grounds.', 'Keep the words of the master in mind as you practice with the training dummies.', '', '', 'Jeran Lockwood\'s advice', 'Use Thrust on Melee Target', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33229, 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, 1094, 0, 0, 0, 0, 75, 0, 0, 0, 0, 37000, 66300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); [blizz]Здесь 2 квеста http://ru.wowhead.com/?quest=13828 2 сылку забыл.[/blizz] [notice]Это еще Квесты Которые нельзя зделать. Зделал так чтоб их просто можно было здать.[/notice]
Code UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13745; UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13772;UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13809;UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13788;UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13788;UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13788;
Code UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13376;  Регистрируй аккаунт, нажав на картинку помощь на x125 uwow.biz Horde /w Roline помогу всем!
Сообщение # 1 написано 24.06.2009 в 00:40
|
кул))) + лови)
Сообщение # 2 написано 24.06.2009 в 03:18
|
Almazo,
уже давно занялся (нужно токо порты поченить в Ульдаре) проблема сними (если есть фиксы на Ульдар вылажуй сюда буду блогодарен. Добавлено (26.06.2009, 01:35) Code DELETE FROM `creature_questrelation` WHERE `quest` = 13119; DELETE FROM `gameobject_questrelation` WHERE `quest` = 13119; UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 13119; INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (30631, 13119); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 30631; DELETE FROM `creature_involvedrelation` WHERE `quest` = 13119; DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 13119; INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (30631, 13119); UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=30631; REPLACE INTO `quest_template` (`entry`, `ZoneOrSort`, `SkillOrClass`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `RequiredSkillValue`, `RepObjectiveFaction`, `RepObjectiveValue`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepFaction`, `RequiredMaxRepValue`, `SuggestedPlayers`, `LimitTime`, `QuestFlags`, `SpecialFlags`, `CharTitleId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `NextQuestInChain`, `SrcItemId`, `SrcItemCount`, `SrcSpell`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `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`, `IncompleteEmote`, `CompleteEmote`, `OfferRewardEmote1`, `OfferRewardEmote2`, `OfferRewardEmote3`, `OfferRewardEmote4`, `StartScript`, `CompleteScript`) VALUES (13119, 210, 0, 77, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Destroying the Altars', 'So they\'re summoning in their workers and warriors at those altars?$B$BThey\'ll need to be the first thing to go. The master summoner should have a staff which allows him to activate the portal. If you kill the master summoner and take the staff, you can use it to overload the summoning portal and destroy its altar.$B$BDo this at all four of the altars and return to me once they\'ve been destroyed.', 'Kill Master Summoner Zarod and use his Summoning Stave to destroy the First, Second, Third, and Fourth Summoning Altars. When you\'ve completed this task, report to Darkrider Arly at Blackwatch.', '<Darkrider Arly nods in approval.>$B$BGood. Now, we can focus our efforts on shutting down the rest of the Fleshwerks.', '', '', 'First Summoning Altar destroyed', 'Second Summoning Altar destroyed', 'Third Summoning Altar destroyed', 'Fourth Summoning Altar destroyed', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30742, 30744, 30745, '', 1, 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, 1098, 0, 0, 0, 0, 250, 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); http://ru.wowhead.com/?quest=13119 Добавлено (26.06.2009, 01:36) Code UPDATE `quest_template` SET `Method` = 0 WHERE `entry` = 13119; Добавлено (26.06.2009, 01:55) Code DELETE FROM `creature_loot_template` WHERE (`entry`=30921); INSERT INTO `creature_loot_template` VALUES (30921, 33366, 0.053, 0, 1, 1, 0, 0, 0), (30921, 33367, 0.0668, 0, 1, 1, 0, 0, 0), (30921, 33368, 0.0609, 0, 1, 1, 0, 0, 0), (30921, 33369, 0.0511, 0, 1, 1, 0, 0, 0), (30921, 33370, 0.0707, 0, 1, 1, 0, 0, 0), (30921, 33371, 0.0648, 0, 1, 1, 0, 0, 0), (30921, 33379, 0.0629, 0, 1, 1, 0, 0, 0), (30921, 33380, 0.0746, 0, 1, 1, 0, 0, 0), (30921, 33381, 0.0884, 0, 1, 1, 0, 0, 0), (30921, 33382, 0.0786, 0, 1, 1, 0, 0, 0), (30921, 33383, 0.0845, 0, 1, 1, 0, 0, 0), (30921, 33384, 0.0668, 0, 1, 1, 0, 0, 0), (30921, 33385, 0.0609, 0, 1, 1, 0, 0, 0), (30921, 33397, 0.0668, 0, 1, 1, 0, 0, 0), (30921, 33398, 0.0609, 0, 1, 1, 0, 0, 0), (30921, 33399, 0.0845, 0, 1, 1, 0, 0, 0), (30921, 33400, 0.0746, 0, 1, 1, 0, 0, 0), (30921, 33401, 0.0805, 0, 1, 1, 0, 0, 0), (30921, 33402, 0.0491, 0, 1, 1, 0, 0, 0), (30921, 33403, 0.055, 0, 1, 1, 0, 0, 0), (30921, 33412, 0.0648, 0, 1, 1, 0, 0, 0), (30921, 33413, 0.0511, 0, 1, 1, 0, 0, 0), (30921, 33414, 0.0707, 0, 1, 1, 0, 0, 0), (30921, 33415, 0.0727, 0, 1, 1, 0, 0, 0), (30921, 33416, 0.0629, 0, 1, 1, 0, 0, 0), (30921, 33417, 0.0609, 0, 1, 1, 0, 0, 0), (30921, 33419, 0.055, 0, 1, 1, 0, 0, 0), (30921, 33422, 0.1296, 0, 1, 1, 0, 0, 0), (30921, 33423, 0.1355, 0, 1, 1, 0, 0, 0), (30921, 33424, 0.1179, 0, 1, 1, 0, 0, 0), (30921, 33425, 0.1512, 0, 1, 1, 0, 0, 0), (30921, 33426, 0.1336, 0, 1, 1, 0, 0, 0), (30921, 33427, 0.1395, 0, 1, 1, 0, 0, 0), (30921, 33428, 0.1552, 0, 1, 1, 0, 0, 0), (30921, 33429, 0.1198, 0, 1, 1, 0, 0, 0), (30921, 33430, 0.1375, 0, 1, 1, 0, 0, 0), (30921, 33431, 0.1552, 0, 1, 1, 0, 0, 0), (30921, 33433, 0.0845, 0, 1, 1, 0, 0, 0), (30921, 33434, 0.0707, 0, 1, 1, 0, 0, 0), (30921, 33435, 0.0904, 0, 1, 1, 0, 0, 0), (30921, 33436, 0.0668, 0, 1, 1, 0, 0, 0), (30921, 33445, 2.5947, 0, 1, 1, 0, 0, 0), (30921, 33447, 1.5949, 0, 1, 1, 0, 0, 0), (30921, 33448, 0.7287, 0, 1, 1, 0, 0, 0), (30921, 33470, 40.4757, 0, 1, 4, 0, 0, 0), (30921, 35947, 4.991, 0, 1, 1, 0, 0, 0), (30921, 36035, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36036, 0.0295, 0, 1, 1, 0, 0, 0), (30921, 36037, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36038, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36039, 0.0255, 0, 1, 1, 0, 0, 0), (30921, 36040, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36041, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36042, 0.0255, 0, 1, 1, 0, 0, 0), (30921, 36043, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36044, 0.0295, 0, 1, 1, 0, 0, 0), (30921, 36045, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36046, 0.0314, 0, 1, 1, 0, 0, 0), (30921, 36047, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36048, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36049, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36050, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36051, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36052, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36053, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36054, 0.0295, 0, 1, 1, 0, 0, 0), (30921, 36055, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36056, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36057, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36058, 0.0255, 0, 1, 1, 0, 0, 0), (30921, 36147, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36149, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36150, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36152, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36153, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36154, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36155, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36156, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36157, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36158, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36160, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36161, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36162, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36163, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36164, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36166, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36167, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36168, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36170, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36259, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36260, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36261, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36262, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36263, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36264, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36265, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36266, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36267, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36268, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36269, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36270, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36271, 0.0275, 0, 1, 1, 0, 0, 0), (30921, 36272, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36273, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36274, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36275, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36277, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36278, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36279, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36280, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36281, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36282, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36371, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36372, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36373, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36374, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36375, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36377, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36378, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36379, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36380, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36381, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36382, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36384, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36385, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36386, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36387, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36388, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36389, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36391, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36392, 0.0177, 0, 1, 1, 0, 0, 0), (30921, 36393, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36394, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36413, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36414, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36427, 0.0412, 0, 1, 1, 0, 0, 0), (30921, 36428, 0.0707, 0, 1, 1, 0, 0, 0), (30921, 36429, 0.0471, 0, 1, 1, 0, 0, 0), (30921, 36441, 0.0314, 0, 1, 1, 0, 0, 0), (30921, 36442, 0.0236, 0, 1, 1, 0, 0, 0), (30921, 36443, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36455, 0.0118, 0, 1, 1, 0, 0, 0), (30921, 36456, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36457, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36469, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36470, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36471, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36484, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36485, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36497, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36498, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36499, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36511, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36512, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36525, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36526, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36527, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36539, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36553, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36554, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36567, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36568, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36569, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36581, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36583, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36596, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36597, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36623, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36624, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36638, 0.002, 0, 1, 1, 0, 0, 0), (30921, 36639, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36651, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36652, 0.002, 0, 1, 1, 0, 0, 0), (30921, 36653, 0.0039, 0, 1, 1, 0, 0, 0), (30921, 36665, 0.0157, 0, 1, 1, 0, 0, 0), (30921, 36666, 0.0196, 0, 1, 1, 0, 0, 0), (30921, 36667, 0.0275, 0, 1, 1, 0, 0, 0), (30921, 36680, 0.0373, 0, 1, 1, 0, 0, 0), (30921, 36681, 0.0354, 0, 1, 1, 0, 0, 0), (30921, 36693, 0.0137, 0, 1, 1, 0, 0, 0), (30921, 36694, 0.0216, 0, 1, 1, 0, 0, 0), (30921, 36695, 0.0098, 0, 1, 1, 0, 0, 0), (30921, 36707, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 36709, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 36722, 0.002, 0, 1, 1, 0, 0, 0), (30921, 37091, 0.1571, 0, 1, 1, 0, 0, 0), (30921, 37093, 0.1964, 0, 1, 1, 0, 0, 0), (30921, 37097, 0.1414, 0, 1, 1, 0, 0, 0), (30921, 37254, 0.002, 0, 1, 1, 0, 0, 0), (30921, 37331, 0.4, 0, 1, 1, 7, 333, 1), (30921, 37760, 0.002, 0, 1, 1, 0, 0, 0), (30921, 37770, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 37771, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 37793, 0.0039, 0, 1, 1, 0, 0, 0), (30921, 37794, 0.0079, 0, 1, 1, 0, 0, 0), (30921, 37824, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 37835, 0.002, 0, 1, 1, 0, 0, 0), (30921, 39152, 0.05, 0, 1, 1, 7, 129, 1), (30921, 42108, -1, 0, 1, 1, 0, 0, 0), (30921, 42172, 0.0059, 0, 1, 1, 0, 0, 0), (30921, 42178, 0.0039, 0, 1, 1, 0, 0, 0), (30921, 43291, -29, 0, 1, 1, 0, 0, 0), (30921, 43297, -1, 0, 1, 1, 0, 0, 0), (30921, 43463, 0.1375, 0, 1, 1, 0, 0, 0), (30921, 43465, 0.1571, 0, 1, 1, 0, 0, 0), (30921, 43467, 0.1512, 0, 1, 1, 0, 0, 0), (30921, 43851, 19.8499, 0, 1, 1, 0, 0, 0), (30921, 43852, 14.0399, 0, 1, 1, 0, 0, 0), (30921, 44559, 0.167, 0, 1, 1, 0, 0, 0), (30921, 44565, 0.2, 0, 1, 1, 7, 171, 1), (30921, 43291, 0.053, 0, 1, 1, 0, 0, 0), (30921, 43291, 0.053, 0, 1, 1, 0, 0, 0), (30921, 43291, 100, 0, 1, 1, 0, 0, 0); Извините что я не все фиксы вылажую (Так как я и для Команды нашей делаю (то буду делать вылаживать туда и сюда не кто не будет качать наши сборки) Добавлено (26.06.2009, 02:00) Code DELETE FROM `creature_template` WHERE (`entry`=31428); Регистрируй аккаунт, нажав на картинку помощь на x125 uwow.biz Horde /w Roline помогу всем!
Сообщение # 5 написано 26.06.2009 в 02:00
|
Quote (Almaz) пока цепочку квестов не пройдете из Акеруса не вылезти, птицы работают нет я все кв сам проходил с самого начало и дошол до этого меня отправили на верх я здал кв и мне надоблыло идти вниз здавать кв но птицы пропали и видно их только в гм я папробывал паставить такую же но оно меня повезла но на землю не спустилась зделала круг и вернулась на балкон
помог ставь +
|
На
Code update `creature_template` SET `ScriptName`='' WHERE `ScriptName`='npc_acherus_taxi'; DELETE FROM npc_spellclick_spells WHERE npc_entry IN ('29501', '29488', '29154'); insert into `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) values('29154','53335','0','0','0','3'); insert into `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) values('29501','54575','0','0','0','3'); insert into `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) values('29488','54568','0','0','0','3'); Заслужил плюс??
Сообщение # 15 написано 05.07.2009 в 16:38
|
Quote (Staf) На Code update `creature_template` SET `ScriptName`='' WHERE `ScriptName`='npc_acherus_taxi'; DELETE FROM npc_spellclick_spells WHERE npc_entry IN ('29501', '29488', '29154'); Заслужил плюс?? не не пашет но всервоно на + за старание помочь ))
помог ставь +
Сообщение # 16 написано 05.07.2009 в 18:16
|
А фикс на вот этот квест есть?
 Там, где большинство пеняет на невезение, мы видим следствие... Они винят обстоятельства, мы находим закономерность... Они кричат кризис, мы говорим возмездие... Гордыня... Зависть... Чревоугодие... Блуд.. Гнев... Алчность... Уныние... 7 смертных грехов человечества... И там где большинство видет неизбежность конца, мы обретаем БЕССМЕРТИЕ!!!
Сообщение # 17 написано 08.07.2009 в 14:48
|
Hime, Держи!=)) с тебя +++++
Прикрепления:
4901237.sql
(0.1 Kb)
 Привычка читать в процессе каканья, может легко перерасти в привычку какать в процессе чтения!=)
Сообщение # 18 написано 08.07.2009 в 20:38
|
Monsteer,
хаха лол ты поченить квест а не так зделать чтоб здал и все.Чинить надо а не этой херней страдать..... Hime, как будет у меня время зделаю тебе этот квест жди. Регистрируй аккаунт, нажав на картинку помощь на x125 uwow.biz Horde /w Roline помогу всем!
|
Roline, буду очень благодарен
Там, где большинство пеняет на невезение, мы видим следствие... Они винят обстоятельства, мы находим закономерность... Они кричат кризис, мы говорим возмездие... Гордыня... Зависть... Чревоугодие... Блуд.. Гнев... Алчность... Уныние... 7 смертных грехов человечества... И там где большинство видет неизбежность конца, мы обретаем БЕССМЕРТИЕ!!! |
zurander, а ясно спс
Там, где большинство пеняет на невезение, мы видим следствие... Они винят обстоятельства, мы находим закономерность... Они кричат кризис, мы говорим возмездие... Гордыня... Зависть... Чревоугодие... Блуд.. Гнев... Алчность... Уныние... 7 смертных грехов человечества... И там где большинство видет неизбежность конца, мы обретаем БЕССМЕРТИЕ!!!
Сообщение # 22 написано 20.07.2009 в 23:20
|
Данная тема была перемещена из раздела Фиксы к MaNGOS.
Причина перемещения: устарело Переместил: ph3n.
Сообщение # 27 написано 16.10.2012 в 19:54
|
Данная тема была перемещена из раздела Фиксы к MaNGOS.
Причина перемещения: устарело Переместил: ph3n.
Сообщение # 28 написано 16.10.2012 в 20:00
|
| |||
| |||