SHOW:
|
|
- or go back to the newest paste.
| 1 | /**************** | |
| 2 | Sunken Treasure | |
| 3 | ****************/ | |
| 4 | ||
| 5 | -- Spawn game objects | |
| 6 | ||
| 7 | SET @Object :=19990344; | |
| 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`, |
| 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 | - | `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, |
| 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 | - | `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, |
| 25 | + | |
| 26 | - | `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, |
| 26 | + | -- Assign |
| 27 | - | `data29`, `data30`, `data31`, `WDBVerified`) VALUES |
| 27 | + | |
| 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, |
| 28 | + |
