Mystiq.org - forum: A Plague Upon Thee -> Questy -> Bugreport

http://www.mystiq.or.../db/?quest=6389 (z insomnia databáze)

q nejde odevzdat té krabici na konci

/* 
ID: 6389
Loc: Western Plaguelands
Name: Plague Upon Thee
Fix: Vytvořen script
*/

UPDATE `quest_template` SET `QuestFlags` = '2',
`SpecialFlags` = '2',
`EndText` = 'Plagueland Termites Released' WHERE `quest_template`.`entry` =6389;

/*
Lumber Mill Crate = ID: 77490 (GUID_OBJECT == 45507) - zkontrolovat
Termites Object = ID: 177491 (GUID_TERMITES) - přiřadit
*/

UPDATE `gameobject_template` SET `type` = '1',
`data0` = '1',
`data2` = '60000',
`data3` = '0' WHERE `gameobject_template`.`entry` =177490;

INSERT INTO `gameobject_scripts` (
`id` ,
`delay` ,
`command` ,
`datalong` ,
`datalong2` ,
`dataint` ,
`x` ,
`y` ,
`z` ,
`o`
)
VALUES (
'45507', '0', '9', 'GUID_TERMITES', '10', '0', '0', '0', '0', '0'
), (
'45507', '10', '7', '6389', '30', '0', '0', '0', '0', '0'
);

INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(GUID_TERMITES, 177491, 0, 1, 1, 2449.38, -1662.37, 104.37, 1.66444, 0, 0, 0.739427, 0.673237, -1, 0, 1);

Po kliknutí na bednu se objeví termiti a quest se splní

Upravuji status na: Opraví nová revize
Upravuji vážnost na: 2 - Normální

Upravuji status na: Opravené!