SHOW:
|
|
- or go back to the newest paste.
| 1 | /******************************** | |
| 2 | Trespassers in the Water | |
| 3 | ********************************/ | |
| 4 | ||
| 5 | -- Script | |
| 6 | ||
| 7 | - | SET @Guid := 155690; |
| 7 | + | SET @Guid := xxxxx; |
| 8 | ||
| 9 | DELETE FROM `creature_template` WHERE `entry`=46868 LIMIT 1; | |
| 10 | INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `family`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `skinloot`, `mingold`, `maxgold`, `InhabitType`, `Health_mod`, `WDBVerified`) VALUES | |
| 11 | (46868, 36385, 36386, 'Stillwater Slitherer', '', '', 82, 83, 2, 14, 14, 509, 683, 805, 2000, 1, 6, 371, 535, 146, 1, 46868, 46868, 15, 33, 1, 4, 13623); | |
| 12 | -- Spawn npc | |
| 13 | ||
| 14 | DELETE FROM `creature` WHERE `guid`=@Guid LIMIT 1; | |
| 15 | INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES | |
| 16 | (@Guid+0, 46868, 1, -9572.615234, -954.506775, 95.397865, 5.599866, 120), | |
| 17 | (@Guid+1, 46868, 1, -9590.443359, -986.574646, 98.248528, 4.300032, 120), | |
| 18 | (@Guid+2, 46868, 1, -9615.254492, -1018.995911, 75.530235, 4.174367, 120), | |
| 19 | (@Guid+3, 46868, 1, -9638.652344, -973.499451, 66.062775, 1.123875, 120), | |
| 20 | (@Guid+4, 46868, 1, -9625.760742, -935.184814, 74.333282, 2.582364, 120), | |
| 21 | (@Guid+5, 46868, 1, -9662.057617, -932.829834, 61.588886, 2.582364, 120), | |
| 22 | (@Guid+6, 46868, 1, -9636.456055, -883.977722, 69.701294, 0.642431, 120), | |
| 23 | (@Guid+7, 46868, 1, -9591.530273, -883.344788, 75.508575, 6.170848, 120), | |
| 24 | (@Guid+8, 46868, 1, -9560.581055, -853.524536, 81.527946, 2.000385, 120), | |
| 25 | (@Guid+9, 46868, 1, -9548.017578, -812.676331, 80.923653, 3.370120, 120), | |
| 26 | (@Guid+10, 46868, 1, -9519.665039, -778.673828, 82.698929, 0.433515, 120), | |
| 27 | (@Guid+11, 46868, 1, -9589.807617, -822.883911, 75.842155, 1.732563, 120); |
