Wintergrasp [ОЛО] - Форум

Страница 1 из 1 1	Архив - только для чтения
Модератор форума: andycrowz

Wintergrasp [ОЛО] (помогите,плз,ошибка)

Wintergrasp [ОЛО]

WalkerGrim

Скаут

Репутация: 19

Когда заливаю патч на оло через Квас выкидывает ошибку
SQL Error: Unknown column 'modelid_A' in 'field list'

и вот такую

SQL Error: Column count doesn't match value count at row 1

Плиз скажите что делать + с меня!!

вот патч
REPLACE INTO game_event VALUES ( 89, '2009-04-15 13:00:00', '2020-12-31 12:00:00', 120, 30, 0, 'WinterGrasp Aliance Battle');
-- удаление неэвентовых пушек
DELETE FROM creature WHERE id = 28366;
DELETE FROM gameobject WHERE guid IN (49914, 51165);
-- растановка осадных машин альанса
REPLACE INTO creature VALUES (7789000,28312,571,1,1,0,0,4359.46,2347.07,380.122,6,25239,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789001,28312,571,1,1,0,0,4950.46,2389.07,324.252,1.41748,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789002,28312,571,1,1,0,0,4954.46,3384.07,381.122,4.30381,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789003,28312,571,1,1,0,0,4354.46,3301.07,376.182,6.14164,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789004,28312,571,1,1,0,0,5017.46,2813.07,387.682,0.09065,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789005,28312,571,1,1,0,0,5026.46,2897.07,385.092,5.82799,900,0,0,102000,0,0,0);
-- растановка пушек в крепости орды
REPLACE INTO creature VALUES (7789006,32629,571,1,1,0,0,5147.46,2861.07,421.642,3.18799,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789007,32629,571,1,1,0,0,5148.46,2862.07,421.642,3.18792,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789008,32629,571,1,1,0,0,5264.46,2861.07,421.592,3.20075,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789009,32629,571,1,1,0,0,5265.46,2819.07,421.662,3.03974,900,0,0,50000,0,0,0);
-- квестеры на хонор
DELETE FROM `creature_template` WHERE (`entry`=99901);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (99901, 0, 0, 0, 0, 0, 24075, 0, 24075, 0, 'WinterGrasp horde', 'event', '', 0, 80, 80, 17890, 17890, 0, 0, 10023, 1979, 1979, 3, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
DELETE FROM `creature_template` WHERE (`entry`=99902);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (99902, 0, 0, 0, 0, 0, 25950, 0, 25950, 0, 'WinterGrasp alliance', 'event', '', 0, 80, 80, 17890, 17890, 0, 0, 10023, 1891, 1891, 3, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
-- растановка квестгиверов
REPLACE INTO creature VALUES (7789010,99902,571,1,1,0,0,4611.46,2847.07,396.902,0.26799,900,0,0,17890,0,0,0);
REPLACE INTO creature VALUES (7789011,99901,571,1,1,0,0,5337.46,2841.07,409.252,3.15362,900,0,0,17890,0,0,0);
-- квесты на хонор (альанс)
DELETE FROM `creature_questrelation` WHERE `quest` = 77771;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 77771;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 77771;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99902, 77771);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99902;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 77771;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 77771;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99902, 77771);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99902;
DELETE FROM `quest_template` WHERE `entry` = 77771;
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 (77771, 2, 0, 0, 77, 80, 41, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest 1', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30739, 31151, 31107, 0, 5, 2, 1, 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, 0, 34, 5, 20759, 0, 0, 46618, 0, 0, 0, 0, 0, 0, 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` = 77772;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 77772;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 77772;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99901, 77772);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99901;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 77772;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 77772;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99901, 77772);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99901;
DELETE FROM `quest_template` WHERE `entry` = 77772;
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 (77772, 2, 0, 0, 77, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest 2', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30740, 28312, 0, 0, 10, 2, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 34, 5, 20759, 0, 0, 46618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- телепорт в даларан по окончании квеста
DELETE FROM `areatrigger_teleport` WHERE (`id`=46618);
REPLACE INTO `areatrigger_teleport` (`id`, `name`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46618', 'Portal to Dalaran', '571', '5804.12', '627.5347', '648.767', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46618);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46618', '571', '5804.12', '627.5347', '648.767', '2.520039');
DELETE FROM `areatrigger_teleport` WHERE (`id`=46617);
REPLACE INTO `areatrigger_teleport` (`id`, `name`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46617', 'Portal to Wintergrasp', '571', '4561.12', '2835.5347', '389.807', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46617);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46617', '571', '4561.12', '2835.5347', '389.807', '2.520039');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (800000, 22, 6955, 'Portal to Wintergrasp', '', '', '', 35, 0, 1, 0, 0, 0, 0, 0, 0, 46617, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE `id`=800000;
DELETE FROM `gameobject` WHERE `quid`=828282;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(828282, 800000, 0, 0, 0, -8831.57, 626.921, 93.960, 0, 0, 0, 0, 0, 600, 0, 0);
DELETE FROM `areatrigger_teleport` WHERE (`id`=46616);
REPLACE INTO `areatrigger_teleport` (`id`, `name`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46616', 'Portal to Wintergrasp', '571', '5348.12', '2841.5347', '409.257', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46616);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46616', '571', '5348.12', '2841.5347', '409.257', '2.520039');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (800000, 22, 6955, 'Portal to Wintergrasp', '', '', '', 35, 0, 1, 0, 0, 0, 0, 0, 0, 46617, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE `id`=800001;
DELETE FROM `gameobject` WHERE `quid`=828283;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(828283, 800001, 1, 0, 0, 1530.57, -4414.921, 12.840, 0, 0, 0, 0, 0, 600, 0, 0);
-- русификация
DELETE FROM `locales_creature` WHERE (`entry`=99901);
INSERT INTO `locales_creature` VALUES ('99901', '', '', '', '', '', '', '', 'Ордынский наемщик', null, null, null, null, null, null, null, 'Озеро Ледяных Оков');
DELETE FROM `locales_creature` WHERE (`entry`=99902);
INSERT INTO `locales_creature` VALUES ('99902', '', '', '', '', '', '', '', 'наемщик Альанса', null, null, null, null, null, null, null, 'Озеро Ледяных Оков');
DELETE FROM `locales_quest` WHERE (`entry`=77771);
INSERT INTO `locales_quest` VALUES ('77771', null, null, null, null, null, null, null, 'Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Оторвитесь по полной в битве за Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Убейте всех!', null, null, null, null, null, null, null, 'Возвращайтесь еще!', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ОЛО', null, null, null, null, null, null, null, 'Вернитесь к Наемнику.', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '');
DELETE FROM `locales_quest` WHERE (`entry`=77772);
INSERT INTO `locales_quest` VALUES ('77772', null, null, null, null, null, null, null, 'Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Оторвитесь по полной в битве за Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Убейте всех!', null, null, null, null, null, null, null, 'Возвращайтесь еще!', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ОЛО', null, null, null, null, null, null, null, 'Вернитесь к Наемнику.', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '');

Сообщение # 1 отредактировано WalkerGrim - Среда, 25.05.2011, 17:14

staford11

^s†af0rd f0rever^

Репутация: 7880

WalkerGrim, вот переписанный мною хак:

Code

REPLACE INTO game_event VALUES ( 89, '2009-04-15 13:00:00', '2020-12-31 12:00:00', 120, 30, 0, 'WinterGrasp Aliance Battle');
DELETE FROM creature WHERE id = 28366;
DELETE FROM gameobject WHERE guid IN (49914, 51165);
REPLACE INTO creature VALUES (7789000,28312,571,1,1,0,0,4359.46,2347.07,380.122,6,25239,900,0,0,102000,0,0);
REPLACE INTO creature VALUES (7789001,28312,571,1,1,0,0,4950.46,2389.07,324.252,1.41748,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789002,28312,571,1,1,0,0,4954.46,3384.07,381.122,4.30381,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789003,28312,571,1,1,0,0,4354.46,3301.07,376.182,6.14164,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789004,28312,571,1,1,0,0,5017.46,2813.07,387.682,0.09065,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789005,28312,571,1,1,0,0,5026.46,2897.07,385.092,5.82799,900,0,0,102000,0,0,0);
REPLACE INTO creature VALUES (7789006,32629,571,1,1,0,0,5147.46,2861.07,421.642,3.18799,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789007,32629,571,1,1,0,0,5148.46,2862.07,421.642,3.18792,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789008,32629,571,1,1,0,0,5264.46,2861.07,421.592,3.20075,900,0,0,50000,0,0,0);
REPLACE INTO creature VALUES (7789009,32629,571,1,1,0,0,5265.46,2819.07,421.662,3.03974,900,0,0,50000,0,0,0);
DELETE FROM `creature_template` WHERE (`entry`=99901);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (99901, 0, 0, 0, 0, 0, 24075, 0, 24075, 0, 'Wintergrasp Horde', 'Wintergrasp Quest', '', 0, 80, 80, 17890, 17890, 0, 0, 10023, 1979, 1979, 3, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
DELETE FROM `creature_template` WHERE (`entry`=99902);
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (99902, 0, 0, 0, 0, 0, 25950, 0, 25950, 0, 'Wintergrasp Alliance', 'Wintergrasp Quest', '', 0, 80, 80, 17890, 17890, 0, 0, 10023, 1891, 1891, 3, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');
REPLACE INTO creature VALUES (7789010,99902,571,1,1,0,0,4611.46,2847.07,396.902,0.26799,900,0,0,17890,0,0,0);
REPLACE INTO creature VALUES (7789011,99901,571,1,1,0,0,5337.46,2841.07,409.252,3.15362,900,0,0,17890,0,0,0);
DELETE FROM `creature_questrelation` WHERE `quest` = 77771;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 77771;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 77771;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99902, 77771);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99902;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 77771;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 77771;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99902, 77771);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99902;
DELETE FROM `quest_template` WHERE `entry` = 77771;
INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`,`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 (77771, 2, 0, 77, 80, 41, 1101, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest 1', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30739, 31151, 31107, 0, 5, 2, 1, 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, 0, 34, 5, 20759, 0, 0, 46618, 0, 0, 0, 0, 0, 0, 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` = 77772;
DELETE FROM `gameobject_questrelation` WHERE `quest` = 77772;
UPDATE `item_template` SET `StartQuest`=0 WHERE `StartQuest` = 77772;
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (99901, 77772);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry` = 99901;
DELETE FROM `creature_involvedrelation` WHERE `quest` = 77772;
DELETE FROM `gameobject_involvedrelation` WHERE `quest` = 77772;
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (99901, 77772);
UPDATE `creature_template` SET `npcflag`=`npcflag`|2 WHERE `entry`=99901;
DELETE FROM `quest_template` WHERE `entry` = 77772;
INSERT INTO `quest_template` (`entry`, `Method`, `ZoneOrSort`, `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 (77772, 2, 0, 77, 80, 41, 690, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Quest 2', '', '', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30740, 28312, 0, 0, 10, 2, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 34, 5, 20759, 0, 0, 46618, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
DELETE FROM `areatrigger_teleport` WHERE (`id`=46618);
REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46618', 'Portal to Dalaran', '571', '5804.12', '627.5347', '648.767', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46618);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46618', '571', '5804.12', '627.5347', '648.767', '2.520039');
DELETE FROM `areatrigger_teleport` WHERE (`id`=46617);
REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46617', 'Portal to Wintergrasp', '571', '4561.12', '2835.5347', '389.807', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46617);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46617', '571', '4561.12', '2835.5347', '389.807', '2.520039');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (800000, 22, 6955, 'Portal to Wintergrasp', '', '', '', 35, 0, 1, 0, 0, 0, 0, 0, 0, 46617, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE `id`=800000;
DELETE FROM `gameobject` WHERE `guid`=828282;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(828282, 800000, 0, 0, 0, -8831.57, 626.921, 93.960, 0, 0, 0, 0, 0, 600, 0, 0);
DELETE FROM `areatrigger_teleport` WHERE (`id`=46616);
REPLACE INTO `areatrigger_teleport` (`id`, `name`,  `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46616', 'Portal to Wintergrasp', '571', '5348.12', '2841.5347', '409.257', '2.520039');
DELETE FROM `spell_target_position` WHERE (`id`=46616);
REPLACE INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
('46616', '571', '5348.12', '2841.5347', '409.257', '2.520039');
REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (800000, 22, 6955, 'Portal to Wintergrasp', '', '', '', 35, 0, 1, 0, 0, 0, 0, 0, 0, 46617, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
DELETE FROM `gameobject` WHERE `id`=800001;
DELETE FROM `gameobject` WHERE `guid`=828283;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(828283, 800001, 1, 0, 0, 1530.57, -4414.921, 12.840, 0, 0, 0, 0, 0, 600, 0, 0);
DELETE FROM `locales_creature` WHERE (`entry`=99901);
INSERT INTO `locales_creature` VALUES ('99901', '', '', '', '', '', '', '', 'Ордынский наемщик', null, null, null, null, null, null, null, 'Озеро Ледяных Оков');
DELETE FROM `locales_creature` WHERE (`entry`=99902);
INSERT INTO `locales_creature` VALUES ('99902', '', '', '', '', '', '', '', 'наемщик Альанса', null, null, null, null, null, null, null, 'Озеро Ледяных Оков');
DELETE FROM `locales_quest` WHERE (`entry`=77771);
INSERT INTO `locales_quest` VALUES ('77771', null, null, null, null, null, null, null, 'Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Оторвитесь по полной в битве за Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Убейте всех!', null, null, null, null, null, null, null, 'Возвращайтесь еще!', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ОЛО', null, null, null, null, null, null, null, 'Вернитесь к Наемнику.', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '');
DELETE FROM `locales_quest` WHERE (`entry`=77772);
INSERT INTO `locales_quest` VALUES ('77772', null, null, null, null, null, null, null, 'Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Оторвитесь по полной в битве за Озеро Ледяных Оков', null, null, null, null, null, null, null, 'Убейте всех!', null, null, null, null, null, null, null, 'Возвращайтесь еще!', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'ОЛО', null, null, null, null, null, null, null, 'Вернитесь к Наемнику.', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '', null, null, null, null, null, null, null, '');

Победоносная @ Галакронд
Мои сборки под 3.3.5а 12340
Исправительные работы: в наличии.

Сообщение # 2 написано 26.05.2011 в 07:43

WalkerGrim

Скаут

Репутация: 19

Сейчас проверю

Добавлено (26.05.2011, 13:30)
---------------------------------------------
SQL Error: Unknown column 'rotatio n3' in 'field list' вот=(( ошибка

Добавлено (26.05.2011, 13:40)
---------------------------------------------
Я не пойму где её исправлять...=(

Сообщение # 3 написано 26.05.2011 в 13:40

mailby

Скаут

Репутация: 0

Замени "rotatio n3" на "rotation3"

Сообщение # 4 написано 06.09.2011 в 17:43

sartiratior

Скаут

Репутация: 33

Вот как бы отредактированный мной скрипт я его залил в бд, но что должно произойти в самой игре?

Размер подписи не должен превышать 470х250

Сообщение # 5 написано 25.12.2011 в 12:07

Dinoza

para bellum

Репутация: 3438

Данная тема была перемещена из раздела Патчи / Моды / Фиксы CMaNGOS.
Причина перемещения: 1.0 Создавать темы вопросительного характера, типа: "Как настроить quice?".

Переместил: Dinoza.

Сообщение # 6 написано 16.03.2013 в 01:07

Wintergrasp [ОЛО] (помогите,плз,ошибка)

Страница 1 из 1
1

Вход на портал