PDA

Просмотр полной версии : [2882] Золото Куэрго


NeatElves
20.11.2010, 13:54
http://ru.wowhead.com/quest=2882
При юзе http://ru.wowhead.com/object=142189 должен идти спавн и сундука и мобов
http://www.wowhead.com/?object=142194
http://www.wowhead.com/npc=7902
http://www.wowhead.com/npc=7901
http://www.wowhead.com/npc=7899
Спеллы
http://www.wowhead.com/spell=11485
http://www.wowhead.com/spell=11487
http://www.wowhead.com/spell=11463
http://www.wowhead.com/spell=11462
у нас все сразу в мире
DELETE FROM `gameobject` WHERE `guid` = 20863;
DELETE FROM `creature` WHERE `id` in (7899,7901,7902);
UPDATE `creature_template` SET `flags_extra` = '130' WHERE `entry` =7898;

NeatElves
22.11.2010, 14:36
Для теста
UPDATE `gameobject_template` SET `data2` = '142189' WHERE `entry` =142189;
DELETE FROM `event_scripts` WHERE `id` = 142189;
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '0', '15', '11463', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '4', '15', '11463', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '3', '15', '11462', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '1', '15', '11487', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '2', '15', '11485', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '5', '15', '11487', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');
INSERT INTO `event_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `datalong3`, `datalong4`, `data_flags`, `dataint`, `dataint2`, `dataint3`, `dataint4`, `x`, `y`, `z`, `o`, `comments`) VALUES ('142189', '6', '15', '11485', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '');

Это - хаковая реализация!