View difference between Paste ID: WXPNsZQ3 and m4P7q5we
SHOW: | | - or go back to the newest paste.
1
/****************
2
 Sunken Treasure
3
****************/
4
5
-- Spawn game objects
6
7
SET @Object :=xxxxx;
8
9
DELETE FROM `gameobject` WHERE  `id`=203090 LIMIT 1;
10
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
11
(@Object+0, 203090, 0, 1, -5919.012207, -4167.396973, -107.655624, 0, 120),
12
(@Object+1, 203090, 0, 1, -5919.567871, -4189.332520, -111.045128, 0, 120),
13
(@Object+2, 203090, 0, 1, -5908.170410, -4197.998047, -92.071098, 0, 120),
14
(@Object+3, 203090, 0, 1, -5897.161621, -4223.054199, -119.458977, 0, 120),
15
(@Object+4, 203090, 0, 1, -5925.237305, -4252.893066, -185.162155, 0, 120),
16
(@Object+5, 203090, 0, 1, -5895.654297, -4261.860352, -159.134842, 0, 120),
17
(@Object+6, 203090, 0, 1, -5887.202148, -4295.677734, -170.276978, 0, 120),
18
(@Object+7, 203090, 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`,  
24
`size`,  `questItem1`,  `questItem2`,  `questItem3`,  `questItem4`,  `questItem5`,  `questItem6`,  `data0`,  `data1`,  `data2`,  `data3`,  
25
`data4`,  `data5`,  `data6`,  `data7`,  `data8`,  `data9`,  `data10`,  `data11`,  `data12`,  `data13`,  `data14`,  `data15`,  `data16`,  
26
`data17`,  `data18`,  `data19`,  `data20`,  `data21`,  `data22`,  `data23`,  `data24`,  `data25`,  `data26`,  `data27`,  `data28`,  
27
`data29`,  `data30`,  `data31`,  `WDBVerified`) VALUES
28
(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,
29
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13329);
30
31
-- Assigm 
32
33-
UPDATE `gameobject_questrelation` SET `id`=55138, `quest`=25609;
33+
UPDATE `gameobject_questrelation` SET `id`=203090, `quest`=25609;