Концерт переехал в дуротар
Code
DELETE FROM `game_event` WHERE (`entry`=333);
INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `description`) VALUES (333, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 30, 5, 'L70ETC in Durotar by Barrt');
DELETE FROM `game_event_creature` WHERE abs(`event`) = 333;
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES
(1679,333),
(1680,333),
(1685,333),
(1686,333),
(1678,333),
(1690,333);
DELETE FROM `game_event_gameobject` WHERE abs(`event`) = 333;
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES
(534,333);
Code
INSERT INTO `creature` VALUES ('1679', '23623', '1', '1', '1', '0', '0', '1334.18', '-4414.9', '33.9409', '1.69876', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `creature` VALUES ('1680', '23619', '1', '1', '1', '0', '0', '1338.28', '-4407.21', '30.3032', '1.68305', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `creature` VALUES ('1685', '23624', '1', '1', '1', '0', '0', '1328.59', '-4409.64', '30.3032', '1.67127', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `creature` VALUES ('1686', '23626', '1', '1', '1', '0', '0', '1330.82', '-4409.42', '30.3032', '1.6752', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `creature` VALUES ('1678', '23625', '1', '1', '1', '0', '0', '1332.88', '-4406.35', '30.3034', '1.7027', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `creature` VALUES ('1690', '23830', '1', '1', '1', '0', '0', '1334.18', '-4414.9', '33.9393', '1.69876', '1', '0', '0', '500000', '0', '0', '0');
INSERT INTO `gameobject` VALUES ('534', '186300', '1', '1', '1', '1333.79', '-4412.59', '27.0395', '1.70271', '0', '0', '0.752172', '0.658966', '1', '0', '1');