Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /****************
- Sunken Treasure
- ****************/
- -- Spawn game objects
- SET @Object :=xxxxx;
- DELETE FROM `gameobject` WHERE `id`=203090 LIMIT 1;
- INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
- (@Object+0, 203090, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
- (@Object+1, 203090, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
- (@Object+2, 203090, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
- (@Object+3, 203090, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
- (@Object+4, 203090, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
- (@Object+5, 203090, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
- (@Object+6, 203090, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
- (@Object+7, 203090, 0, 1, -5908.208008, -4139.554688, -94.333839, 0, 120);
- -- Script
- DELETE FROM `gameobject_template` WHERE `entry`=203090 LIMIT 1;
- INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`,
- `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`,
- `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`,
- `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`,
- `data29`, `data30`, `data31`, `WDBVerified`) VALUES
- (203090, 3, 259, 'Sunken Treasure Chest', 0, 4, 2, 55138, 0, 0, 0, 0, 0, 1691, 203090, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19676,
- 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
- -- Assigm
- UPDATE `gameobject_questrelation` SET `id`=55138, `quest`=25609;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement