Installation

Dependencies

• es_extended

• lvl_bridge

• ox_inventory

• ox_lib

• oxmysql

Installation

1

Download all dependencies

2

Download lvl_motel from your portal, extract it to the resources folder

3

In your server.cfg, create a new line and type ensure lvl_motel

4

Configure the script

Police jobs configurate in lvl_bridge

5

And lastly install sql and item you will find in the install folder

SQL

CREATE TABLE `motel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `owner` varchar(99) NOT NULL,
  `labelMotel` varchar(30) NOT NULL,
  `roomNumber` varchar(30) NOT NULL DEFAULT '0',
  `day` longtext NOT NULL,
  `locked` tinyint(1) NOT NULL DEFAULT 1,
  `seal` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `motel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

CREATE TABLE `motel_key` (
  `id` int(11) NOT NULL,
  `identifier` varchar(46) NOT NULL,
  `labelMotel` varchar(30) NOT NULL,
  `roomNumber` varchar(30) NOT NULL DEFAULT '0',
  `playerName` longtext NOT NULL,
  `storage` tinyint(1) NOT NULL DEFAULT 0,
  `cloakroom` tinyint(1) NOT NULL DEFAULT 0,
  `add_days` tinyint(1) NOT NULL DEFAULT 0,
  `add_player` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `motel_key`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `motel_key`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

ALTER TABLE `users` ADD IF NOT EXISTS `roomNumber` varchar(11) DEFAULT -1;
ALTER TABLE `users` ADD IF NOT EXISTS `motelName` longtext ;

Item

Image	Name	Label
police_stormram.png	police_ram	Police ram