🧠INSTALLATION

=> Download and install to server path

1) You download it from Tebex's e-mail address or from the (current) github address we shared with you.

(If you see a text like "lab-crew-master" or "bla bla -master" when you download it from github, don't forget to delete that part.)

2) There will be 4 folders inside the file: PolyZone, bt-polyzone, cd_keymaster and lab-crew, you assign them to the resource file.

ensure PolyZone
ensure bt-polyzone
ensure cd_keymaster
ensure lab-crew

then you process the code block in your cfg as I mentioned above.

3) Then you process the SQL file that comes in it into your own database.

crew.sql

CREATE TABLE IF NOT EXISTS `lab_crews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` varchar(50) NOT NULL,
  `crewTag` varchar(50) NOT NULL,
  `crewLeader` varchar(50) NOT NULL,
  `crewMainBase` varchar(50) DEFAULT NULL,
  `crewGrade` longtext NOT NULL DEFAULT '{"Rookie":{"sendAnnounce":false,"crewUseGarage":false,"crewInvite":false,"crewChangeGrade":false,"crewUseInventory":false,"crewSetColour":false,"crewKickMember":false,"setGarage":false,"setInventory":false}}',
  `crewMember` longtext DEFAULT NULL,
  `crewCase` int(11) unsigned NOT NULL DEFAULT 0,
  `crewInventoryCoords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'vector3(0,0,0)',
  `crewGarageCoords` varchar(255) NOT NULL DEFAULT 'vector3(0,0,0)',
  `crewInventory` longtext DEFAULT NULL,
  `inventoryPassword` varchar(50) NOT NULL DEFAULT '0000',
  `crewGarage` longtext NOT NULL,
  `garagePassword` varchar(50) NOT NULL DEFAULT '0000',
  `crewColourID` varchar(50) DEFAULT '1',
  `crewColourHex` varchar(50) DEFAULT '0,0,0',
  `crewPlaces` longtext NOT NULL DEFAULT '[]',
  `crewIMG` longtext NOT NULL DEFAULT 'https://cdn.discordapp.com/attachments/938533769210654780/998130701994049606/IMG_4664.png',
  PRIMARY KEY (`id`),
  UNIQUE KEY `crewName` (`crewName`),
  UNIQUE KEY `crewTag` (`crewTag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crews`;
CREATE TABLE IF NOT EXISTS `lab_crew_announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` varchar(50) DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `announcements` longtext DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  KEY `int` (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crew_announcements`;

CREATE TABLE IF NOT EXISTS `lab_crew_garage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` varchar(50) NOT NULL,
  `vehiclePlate` varchar(50) NOT NULL,
  `vehicleLabel` varchar(50) NOT NULL,
  `vehicleModel` varchar(50) DEFAULT NULL,
  `vehicleProperties` longtext NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  UNIQUE KEY `vehiclePlate` (`vehiclePlate`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crew_garage`;
CREATE TABLE IF NOT EXISTS `lab_crew_invites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` varchar(50) DEFAULT NULL,
  `targetPlayer` varchar(50) DEFAULT NULL,
  `sender` varchar(50) DEFAULT NULL,
  `sendDate` varchar(50) DEFAULT NULL,
  `sendTime` longtext DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crew_invites`;

CREATE TABLE IF NOT EXISTS `lab_crew_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` mediumtext NOT NULL,
  `messages` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crew_messages`;

CREATE TABLE IF NOT EXISTS `lab_crew_sides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `crewName` varchar(50) NOT NULL DEFAULT '',
  `locName` varchar(50) NOT NULL DEFAULT '',
  `x` float(8,4) NOT NULL,
  `y` float(8,4) NOT NULL,
  `z` float(8,4) NOT NULL,
  `rx` float(8,4) NOT NULL,
  `ry` float(8,4) NOT NULL,
  `rz` float(8,4) NOT NULL,
  `scale` float(8,4) unsigned zerofill NOT NULL,
  `text` varchar(32) NOT NULL,
  `font` varchar(32) NOT NULL,
  `color` int(3) NOT NULL,
  `interior` varchar(50) NOT NULL DEFAULT '',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DELETE FROM `lab_crew_sides`;

CREATE TABLE IF NOT EXISTS `lab_crew_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `warSender` varchar(50) DEFAULT NULL,
  `warTarget` varchar(50) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'waiting',
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DELETE FROM `lab_crew_wars`;

The installation of the system is that simple.