You will find the query file in the[SQL] folder, or if you lost it you can copy it from here:
player_skills.sql
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `player_skills`;
CREATE TABLE `player_skills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`job` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`skill_points` int(11) NULL DEFAULT 0,
`level` int(4) NOT NULL DEFAULT 0,
`xp` int(16) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `citizen_id`(`identifier`, `job`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 619 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
3
Add all required items and images found in [requirements] folder
You can either use the included images , or your own , but the names have to match the ones given in the included images.
4
Install Dependencies
This script requires ox_lib & oxmysql
You have to ensure this script AFTER both dependencies !
5
Add the resource in your server.cfg file
ensure ip_herb
6
That's it , you can now join your server and make sure everything works!
If you have any issues, you can contact us on our !