Database:Zones

Table

• name - the /zone list name of the zone

• file - the zone file to load, if a zone is missing just add a new entry

• description - the description of the zone (used on the loading screen)

• safe_x - the x location you will be placed at by default

• safe_y - the y location you will be placed at by default

• safe_z - the z location you will be placed at by default

• safe_heading - the direction you will face at by default

• min_status - Sets the minimum admin status required

• zone_motd - the message you will receive on entering the zone

Transporters

Read LethalEncounters post on Transporters

List based Transporters (Mariners Bell)

INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('2','1','Zone','Nettleville','233','684.31','-35.4','339.18','0','0','-1','-1','-1','-1','0',NULL);
INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('3','1','Zone','The Baubbleshire','238','966.52','-18.2','-436.97','0','0','-1','-1','-1','-1','0',NULL);
INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('4','1','Zone','Qeynos Harbor','221','999.14','-25.79','27.04','0','0','-1','-1','-1','-1','0',NULL);
INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('5','1','Zone','Graystone Yard','235','950.74','-25.22','-156.65','0','0','-1','-1','-1','-1','0',NULL);
INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('6','1','Zone','The Willow Wood','237','829.24','-20.36','-780.82','0','0','-1','-1','-1','-1','0',NULL);
INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('7','1','Zone','Starcrest Commune','234','724.88','-35.2','325.29','0','0','-1','-1','-1','-1','0',NULL);

Warp Transporters

INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('8','2','Location','N/A','0','719.8','35.22','123.31','0','231','725.48','-20.36','125.77','0.6','0',NULL);

INSERT INTO "transporters" ("id", "transport_id", "transport_type", "display_name", "destination_zone_id", "destination_x", "destination_y", "destination_z", "destination_heading", "trigger_location_zone_id", "trigger_location_x", "trigger_location_y", "trigger_location_z", "trigger_radius", "cost", "message") VALUES
   ('9','3','Location','N/A','0','721.09','-19.64','118.38','0','231','721.29','35.22','117.68','0.6','0',NULL);

Spawns/Signs as Teleporters

Another method is to use Signs. Signs allow spawns in the world to display messages and teleport you to a target zone id/location

You must have a Spawn to enable a sign

Get your spawn ID

SELECT id,name FROM spawn WHERE name LIKE '%My door%'; 

For example the ID might be 94.

Or target your spawn and type /spawn details and get it's NPC ID

insert into spawn_signs (spawn_id, type, description, zone_id) values (94, 'Zone', 'enter this building', 414);