Guest User

Untitled

a guest
Nov 9th, 2011
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.98 KB | None | 0 0
  1. UPDATE creature_template SET faction_A=35, faction_H=35 WHERE entry=18672;
  2.  
  3. DELETE FROM `creature` WHERE `id`=18672;
  4. INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
  5. (93376, 18672, 560, 3, 1, 18064, 0, 2580.05, 884.161, 67.5717, 3.06924, 7200, 0, 0, 1753, 0, 2, 0, 0, 0);
  6.  
  7. DELETE FROM `creature_addon` WHERE (`guid`=93376);
  8. INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (93376, 93376, 0, 0, 4097, 0, '');
  9.  
  10. DELETE FROM `waypoint_data` WHERE (`id`=93376);
  11. INSERT INTO `waypoint_data` VALUES ('93376', '11', '2609.72', '882.316', '68.3741', '0', '0', '0', '0', '100', '0');
  12. INSERT INTO `waypoint_data` VALUES ('93376', '10', '2573.92', '885.057', '67.0394', '0', '0', '0', '0', '100', '0');
  13. INSERT INTO `waypoint_data` VALUES ('93376', '9', '2488.56', '882.378', '63.5147', '0', '0', '0', '0', '100', '0');
  14. INSERT INTO `waypoint_data` VALUES ('93376', '8', '2441.9', '874.547', '60.8262', '0', '0', '0', '0', '100', '0');
  15. INSERT INTO `waypoint_data` VALUES ('93376', '7', '2348.3', '846.762', '54.2485', '0', '0', '0', '0', '100', '0');
  16. INSERT INTO `waypoint_data` VALUES ('93376', '6', '2285.2', '820.031', '54.5439', '0', '10000', '0', '0', '100', '0');
  17. INSERT INTO `waypoint_data` VALUES ('93376', '5', '2341.72', '844.637', '54.092', '0', '0', '0', '0', '100', '0');
  18. INSERT INTO `waypoint_data` VALUES ('93376', '4', '2431.15', '872.255', '59.9974', '0', '0', '0', '0', '100', '0');
  19. INSERT INTO `waypoint_data` VALUES ('93376', '3', '2492.82', '883.647', '63.6521', '0', '0', '0', '0', '100', '0');
  20. INSERT INTO `waypoint_data` VALUES ('93376', '2', '2561.89', '885.274', '65.5244', '0', '0', '0', '0', '100', '0');
  21. INSERT INTO `waypoint_data` VALUES ('93376', '1', '2603.46', '882.149', '68.2024', '0', '0', '0', '0', '100', '0');
  22.  
Advertisement
Add Comment
Please, Sign In to add comment