My Pastes
Public Pastes
Layout Width
Share Pastebin
Guest
Public paste!

Barney

By: a guest | Feb 9th, 2010 | Syntax: SQL | Size: 3.40 KB | Hits: 81 | Expires: Never
Download | Raw | Embed | Report abuse
This paste has a previous version, view the difference. Copy text to clipboard
  1. -- Quest ****************[Threat From Above]****************
  2. -- npc [Chillmaw slain]
  3. UPDATE creature_template SET spell1=65248, spell2=65260, MovementType=1, InhabitType=7, movementId=211 WHERE entry=33687;
  4. INSERT INTO `creature_template_addon` VALUES('33687','0','0','50331648','1','0','0',NULL);
  5. -- spawn
  6. DELETE FROM creature WHERE id=33687;
  7.  
  8. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33687','571','1','1','27982','0','8000.68','2538.82','504.983','3.7267','180','0','0','107848','4169','0','1');
  9.  
  10. -- npc [Cultist Bombardier slain]
  11. UPDATE creature_template SET spell1=65128, spell2=65130, unit_flags=8, type_flags=8 WHERE entry=33695;
  12. -- spawn
  13. DELETE FROM creature WHERE id=33695;
  14.  
  15. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8110.42','2666.42','552.524','4.3527','25','0','0','25200','3994','0','1');
  16. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8134.76','2602.6','546.467','3.31441','25','0','0','25200','3994','0','1');
  17. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8107.62','2533.54','524.323','3.09057','25','0','0','25200','3994','0','1');
  18. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8025.74','2485.1','480.213','2.0672','25','0','0','25200','3994','0','1');
  19. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','17963','57','8055.13','2534.66','496.722','4.20113','25','0','0','25200','3994','0','1');
  20. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8064.15','2613.1','520.385','0.241152','25','0','0','25200','3994','0','1');
  21. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES('33695','571','1','1','0','57','8070.92','2671.72','538.977','4.96139','25','0','0','25200','3994','0','1');
create new paste | create new version of this paste RAW Paste Data