Thread: A Boatload of Doors
View Single Post
  #7  
Old 12-24-2006, 12:34 PM
Angelox
AX Classic Developer
  
Join Date: May 2006
Location: filler
Posts: 2,049
Default
This is what worked for me;
Code:
INSERT INTO doors (doorid, zone, name, pos_y, pos_x, pos_z, heading, opentype, guild, lockpick, keyitem, triggerdoor, triggertype, doorisopen, door_param, dest_zone, dest_x, dest_y, dest_z, dest_heading, invert_state, incline, size)
VALUES (1, "abysmal", "SCADOOR800", -182, 34.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(2, "abysmal", "SCADOOR800", -182, -7, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(3, "abysmal", "SCADOOR800", -182, -48.5, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(4, "abysmal", "SCADOOR800", -66.5, -68.3, 137, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(5, "abysmal", "SCADOOR800", -66.5, 68, 137, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(6, "abysmal", "SCADOOR800", -19, 18.2, 154.8, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(7, "abysmal", "SCADOOR800", -19, -18.2, 154.8, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(8, "abysmal", "SCADOOR800", -227.3, 222.2, 111, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(9, "abysmal", "SCADOOR800", -137.5, 244.8, 111, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(10, "abysmal", "SCADOOR800", 83.2, 157, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(11, "abysmal", "SCADOOR800", 83.1, -157, 111, -255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(12, "abysmal", "SCADOOR800", 137.5, -244.5, 111, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(13, "abysmal", "SCADOOR800", -227.5, -222.1, 111, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(14, "abysmal", "SCADOOR800", -264.5, -267, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(15, "abysmal", "SCADOOR800", -264.5, 267, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(16, "abysmal", "SCADOOR800", -264.5, 177.5, 95, -128, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(17, "abysmal", "SCADOOR800", -264.5, -177.5, 95, 128, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(18, "abysmal", "SCADOOR801", -203.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(19, "abysmal", "SCADOOR801", -203.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(20, "abysmal", "SCADOOR801", -153.7, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(21, "abysmal", "SCADOOR801", -153.7, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(22, "abysmal", "SCADOOR801", -103.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(23, "abysmal", "SCADOOR801", -103.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(24, "abysmal", "SCADOOR801", -53.5, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(25, "abysmal", "SCADOOR801", -53.5, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(26, "abysmal", "SCADOOR801", -3.6, 273, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(27, "abysmal", "SCADOOR801", -3.6, -273, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(28, "abysmal", "SCADOOR801", -153.7, -2475., 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(29, "abysmal", "SCADOOR801", -153.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(30, "abysmal", "SCADOOR801", -203.7, 247.5, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(31, "abysmal", "SCADOOR801", -203.7, -247.5, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(32, "abysmal", "SCADOOR801", -53.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(33, "abysmal", "SCADOOR801", -53.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(34, "abysmal", "SCADOOR801", -103.6, 187, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(35, "abysmal", "SCADOOR801", -103.6, -187, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(36, "abysmal", "SCADOOR801", -53.6, -161, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(37, "abysmal", "SCADOOR801", -53.6, 161, 95, 255, 1, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(38, "abysmal", "SCADOOR800", -247, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100),
(39, "abysmal", "SCADOOR800", -131.4, 61, 95, 255, 5, 0, 0, 0, 0, 0, 0, 0, "NONE", 0, 0, 0, 0, 0, 0, 100);
Had to quote "abysmal", "SCADOOR800", "SCADOOR801",and "NONE", too.
Reply With Quote