[NeatElves]

Что смог по 1-у посту:

# http://ru.wowhead.com/?quest=14101
# спавн евентом, предмет
DELETE FROM `creature` WHERE `guid` = 131257;
UPDATE `quest_template` SET `ReqItemId1` = 47006, `ReqItemCount1` = 1 WHERE `entry` = 14101;
# http://ru.wowhead.com/?quest=14104
# спавн евентом, предмет
DELETE FROM `creature` WHERE `guid` = 131259;
UPDATE `quest_template` SET `ReqItemId1` = 47029, `ReqItemCount1` = 1 WHERE `entry` = 14104;
# http://ru.wowhead.com/?quest=14102
# спавн евентом, предмет
DELETE FROM `creature` WHERE `guid` = 131258;
UPDATE `quest_template` SET `ReqItemId1` = 47009, `ReqSourceId1` = 1 WHERE `entry` = 14102;
# го для суммона
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES 
(x, 401012, 571, 1, 1, 10004.5, 639.901, 10.1031, 5.87042, 0, 0, 0.204921, -0.978779, 120, 0, 1),
(x, 401010, 571, 1, 1, 10401.6, 941.647, 124.123, 5.6128, 0, 0, 0.328952, -0.944347, 120, 0, 1),
(x, 401011, 571, 1, 1, 10178.3, 1186.56, 76.2968, 0.0215496, 0, 0, 0.0107746, 0.999942, 120, 0, 1);
# квестшанс
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '-45' WHERE `entry` =34728 AND `item` =46895;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '-45' WHERE `entry` =34734 AND `item` =46895;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '-35' WHERE `entry` =34838 AND `item` =46859;
UPDATE `creature_loot_template` SET `ChanceOrQuestChance` = '-30' WHERE `entry` =34839 AND `item` =46859;
# один из группы
UPDATE `quest_template` SET `ExclusiveGroup` = '14107' WHERE `entry` =14107;
UPDATE `quest_template` SET `ExclusiveGroup` = '14107' WHERE `entry` =14108;
UPDATE `quest_template` SET `ExclusiveGroup` = '14101' WHERE `entry` =14101;
UPDATE `quest_template` SET `ExclusiveGroup` = '14101' WHERE `entry` =14102;
UPDATE `quest_template` SET `ExclusiveGroup` = '14101' WHERE `entry` =14104;
UPDATE `quest_template` SET `ExclusiveGroup` = '14101' WHERE `entry` =14105;
# http://www.wowhead.com/?quest=14107
UPDATE `quest_template` SET `ReqCreatureOrGOId1` = '35055' WHERE `entry` =14107;
REPLACE INTO `creature_ai_texts` VALUES ('-312491', 'It was awful.. I dreamt I was fighting against my friends.', '', '', '', '', '', '', '', '', '0', '0', '0', '0', 'ytdb-q14107');
REPLACE INTO `creature_ai_texts` VALUES ('-312492', 'I can\'t hear the screams anymore. Is this the end?', '', '', '', '', '', '', '', '', '0', '0', '0', '0', 'ytdb-q14107');
REPLACE INTO `creature_ai_texts` VALUES ('-312493', 'My nightmare, is it finally over?', '', '', '', '', '', '', '', '', '0', '0', '0', '0', 'ytdb-q14107');
REPLACE INTO `creature_ai_scripts` VALUES ('3214951', '32149', '8', '0', '100', '1', '66719', '-1', '0', '0', '33', '35055', '6', '0', '41', '0', '0', '0', '30', '-312491', '-312492', '-312493', 'ytdb-q14107');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '32149';
UPDATE `quest_template` SET `ReqItemId1` = 47033, `ReqItemCount1` = 1 WHERE `entry` = 14107;
# http://ru.wowhead.com/?quest=14077
# http://ru.wowhead.com/?quest=14144
UPDATE `quest_template` SET `ReqSpellCast1` = '0' WHERE `entry` in (14077,14144);
REPLACE INTO `creature_ai_scripts` VALUES ('3485251', '34852', '8', '0', '100', '1', '66390', '-1', '0', '0', '33', '34852', '6', '0', '41', '0', '0', '0', '0', '0', '0', '0', 'ytdb-q14077,14144');
UPDATE `creature_template` SET `AIName` = 'EventAI' WHERE `entry` = '34852';