1
-- Notes
-- This is for ESX ONLY and purely example
-- You must create a job for each sheriff job with 'off' in front of the exact name and
-- create the same amount of grade numbers as you have with that job.
-- Below is an example of off duty for a job named 'sheriff' with 4 grades:
INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
('offsheriff', 'LSSD', 1);
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
('offsheriff', 0, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 1, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 2, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 3, 'offsheriff', 'Off Duty', 50, '{}', '{}');
-- Notes
-- Here is an additional example of a job named 'sheriff' with 4 grades:
INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
('offsheriff', 'Sheriff', 1);
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
('offsheriff', 0, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 1, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 2, 'offsheriff', 'Off Duty', 50, '{}', '{}'),
('offsheriff', 3, 'offsheriff', 'Off Duty', 50, '{}', '{}');
-- 注释
-- 这段代码仅适用于 ESX，并且只是一个示例
-- 你必须为每个警长职位创建一个名称前缀为 'off' 的工作，并且
-- 根据该职位的等级数量创建相同数量的等级。
-- 以下是一个名为 'sheriff' 的职位的下班状态示例，具有 4 个等级：
INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
('offsheriff', 'LSSD', 1);
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
('offsheriff', 0, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 1, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 2, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 3, 'offsheriff', '下班', 50, '{}', '{}');
-- 注释
-- 这里是另一个示例，职位名称为 'sheriff'，具有 4 个等级：
INSERT INTO `jobs` (`name`, `label`, `whitelisted`) VALUES
('offsheriff', '警长', 1);
INSERT INTO `job_grades` (`job_name`, `grade`, `name`, `label`, `salary`, `skin_male`, `skin_female`) VALUES
('offsheriff', 0, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 1, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 2, 'offsheriff', '下班', 50, '{}', '{}'),
('offsheriff', 3, 'offsheriff', '下班', 50, '{}', '{}');
这段代码应放置在数据库初始化的 SQL 文件中，而不是 `server.lua` 或 `client.lua` 中。它主要用于设置工作和工作等级的信息。
页:
[1]