Database:Zones

Table Breakdown

• 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

You now need to enter the follow fields into an insert statement:

• spawn_id - the spawn id from above

• type - the type is a 'Zone' sign

• description - the description that will show when you hover over the spawn

• zone_id - the target zone ID (get this from /zone list)

Optional:

• zone_x - x position on the other side

• zone_y - y position on the other side

• zone_z - z position on the other side

• zone_heading - direction to face on the other side

Sample Sign for Spawn 94:

Note that this sign can be clicked from any distance if left to the default of 0. If you wish to set a distance for the sign/portal be sure to update the sign_distance field

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