YTDB

YTDB (http://ytdb.ru/index.php)
-   Корзина / Trash can (http://ytdb.ru/forumdisplay.php?f=21)
-   -   [2882] Золото Куэрго (http://ytdb.ru/showthread.php?t=8871)

NeatElves 20.11.2010 13:54

[2882] Золото Куэрго
 
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', '');

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


Текущее время: 09:54. Часовой пояс GMT +4.

YTDB - MaNGOS DataBase