View Single Post
  #5  
Old 12-04-2008, 12:38 PM
jdam7459
Sarnak
 
Join Date: Mar 2007
Posts: 45
Default

Sorry syntax in that is all messed up.
Gotta love late nights.

Code:
UPDATE zone_points SET target_x = -172.2 WHERE target_zone_id = 25 AND zone = "lavastorm";
UPDATE zone_points SET target_y = -2118.3 WHERE target_zone_id = 25 AND zone = "lavastorm";
UPDATE zone_points SET target_z = -16.9 WHERE target_zone_id = 25 AND zone = "lavastorm";

UPDATE zone_points SET target_x = -1058.2 WHERE target_zone_id = 44 AND zone = "lavastorm";
UPDATE zone_points SET target_y = -939.9 WHERE target_zone_id = 44 AND zone = "lavastorm";
UPDATE zone_points SET target_z = 17 WHERE target_zone_id = 44 AND zone = "lavastorm";

UPDATE zone_points SET target_x = 330 WHERE target_zone_id = 80 AND zone = "lavastorm";
UPDATE zone_points SET target_y = 1351.2 WHERE target_zone_id = 80 AND zone = "lavastorm";
UPDATE zone_points SET target_z = 150.1 WHERE target_zone_id = 80 AND zone = "lavastorm";

UPDATE zone_points SET target_x = 482.8 WHERE target_zone_id = 32 AND zone = "lavastorm";
UPDATE zone_points SET target_y = 906.8 WHERE target_zone_id = 32 AND zone = "lavastorm";
UPDATE zone_points SET target_z = 56.1 WHERE target_zone_id = 32 AND zone = "lavastorm";

UPDATE zone_points SET target_x = 227.3 WHERE target_zone_id = 31 AND zone = "lavastorm";
UPDATE zone_points SET target_y = 784 WHERE target_zone_id = 31 AND zone = "lavastorm";
UPDATE zone_points SET target_z = 131.4 WHERE target_zone_id = 31 AND zone = "lavastorm";

UPDATE zone_points SET target_x = 864.7 WHERE target_zone_id = 27 AND zone = "najena";
UPDATE zone_points SET target_y = -15.2 WHERE target_zone_id = 27 AND zone = "najena";
UPDATE zone_points SET target_z = 4.4 WHERE target_zone_id = 27 AND zone = "najena";

UPDATE zone_points SET target_x = 57.4 WHERE target_zone_id = 27 AND zone = "soltemple";
UPDATE zone_points SET target_y = 247.8 WHERE target_zone_id = 27 AND zone = "soltemple";
UPDATE zone_points SET target_z = 3.4 WHERE target_zone_id = 27 AND zone = "soltemple";

UPDATE zone_points SET target_x = -525.4 WHERE target_zone_id = 27 AND zone = "soldunga";
UPDATE zone_points SET target_y = -441 WHERE target_zone_id = 27 AND zone = "soldunga";
UPDATE zone_points SET target_z = 74.3 WHERE target_zone_id = 27 AND zone = "soldunga";
__________________
-jdam (Developer of the Legacy)
Reply With Quote