View difference between Paste ID: 4e417tRJ and LjDgpEJh
SHOW: | | - or go back to the newest paste.
1
/****************
2
 Sunken Treasure
3
****************/
4
5
-- Spawn game objects
6
7-
SET @Object :=19990344;
7+
SET @Object :=xxxxx;
8
9
DELETE FROM `gameobject` WHERE  `id`=55138 LIMIT 1;
10
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
11
(@Object+0, 55138, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
12
(@Object+1, 55138, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
13
(@Object+2, 55138, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
14
(@Object+3, 55138, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
15
(@Object+4, 55138, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
16
(@Object+5, 55138, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
17
(@Object+6, 55138, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
18
(@Object+7, 55138, 0, 1, -5908.208008, -4139.554688, -94.333839, 0, 120);
19
20
-- Script
21
22
DELETE FROM `gameobject_template` WHERE  `entry`=203090 LIMIT 1;
23
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
24
(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);
25
26
-- Assign 
27
28
UPDATE `gameobject_questrelation` SET `id`=55138, `quest`=25609;