Installation

Need Help Join our discord we are always here : https://discord.gg/4SbX4JEUqV

RESOURCE INSTALLATION GUIDE

Download your resource from FiveM's Keymaster.

_{ADD ITEMS}

['backpack'] = {
    label = 'Student Backpack',
    weight = 220,
    stack = false,
    consume = 0,
    description = 'A spacious backpack used to store university materials.',
    client = {
        export = 'nl-university.openBackpack'
    }
},

['student_id'] = {
    label = 'Student ID Card',
    weight = 50,
    stack = false,
    close = true,
    description = 'Official university-issued identification card with photo and student info.'
},

['print_document'] = {
    label = 'Printed Assignment',
    weight = 25,
    stack = true,
    close = true,
    description = 'A printed assignment or form. Don’t lose it!',
    client = {
        export = 'nl-university.useDocument'
    }
},

['printer_paper'] = {
    label = 'Blank Printer Paper',
    weight = 5,
    stack = true,
    close = true,
    description = 'Standard blank A4 paper used in printers.'
},

['chalkboard2'] = {
    label = 'Wall Chalkboard',
    weight = 5000,
    stack = false,
    description = 'A classic wall-mounted chalkboard used in classrooms.'
},
-- Related to the chemistry class
['acetone'] = {
    label = 'Acetone',
    weight = 1,
    stack = true,
    close = true,
    description = 'A flammable solvent.'
},
['hydrochloricacid'] = {
    label = 'Hydrochloric Acid',
    weight = 1,
    stack = true,
    close = true,
    description = 'A dangerous chemical.'
},
['acid'] = {
    label = 'Acid',
    weight = 1,
    stack = true,
    close = true,
    description = 'A dangerous chemical.'
},

['backpack'] = {
    name = 'backpack',
    label = 'Student Backpack',
    weight = 220,
    type = 'item',
    image = 'backpack.png',  -- You may need to replace with your actual image path.
    unique = false,
    useable = true,
    shouldClose = true,
    description = 'A spacious backpack used to store university materials.',
    client = {
        export = 'nl-university.openBackpack'
    }
},

['student_id'] = {
    name = 'student_id',
    label = 'Student ID Card',
    weight = 50,
    type = 'item',
    image = 'student_id.png',  -- You may need to replace with your actual image path.
    unique = true,
    useable = false,
    shouldClose = true,
    description = 'Official university-issued identification card with photo and student info.'
},

['print_document'] = {
    name = 'print_document',
    label = 'Printed Assignment',
    weight = 25,
    type = 'item',
    image = 'print_document.png',  -- You may need to replace with your actual image path.
    unique = false,
    useable = true,
    shouldClose = true,
    description = 'A printed assignment or form. Don’t lose it!',
    client = {
        export = 'nl-university.useDocument'
    }
},

['printer_paper'] = {
    name = 'printer_paper',
    label = 'Blank Printer Paper',
    weight = 5,
    type = 'item',
    image = 'printer_paper.png',  -- You may need to replace with your actual image path.
    unique = false,
    useable = false,
    shouldClose = true,
    description = 'Standard blank A4 paper used in printers.'
},

['chalkboard2'] = {
    name = 'chalkboard2',
    label = 'Wall Chalkboard',
    weight = 5000,
    type = 'item',
    image = 'chalkboard2.png',  -- You may need to replace with your actual image path.
    unique = true,
    useable = true,
    shouldClose = false,
    description = 'A classic wall-mounted chalkboard used in classrooms.'
},

3) ADD THE IMAGES TO YOUR INVENTORY

Open nl-university > install > images
Copy files from the folder and add them into your inventory image folder ox_inventory/web/images

SQL

Run this SQL queries

CREATE TABLE IF NOT EXISTS university_students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL,
    student_id VARCHAR(20) NOT NULL UNIQUE,
    dob DATE NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL,
    address VARCHAR(255) NOT NULL,
    guardian VARCHAR(255) NOT NULL,
    contact VARCHAR(50) NOT NULL,
    grade INT NOT NULL,
    hasAllergies ENUM('Yes', 'No') NOT NULL,
    medical TEXT,
    emergencyName VARCHAR(255),
    emergencyNumber VARCHAR(50)
);

CREATE TABLE IF NOT EXISTS university_teachers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL,
    teacher_id VARCHAR(20) NOT NULL UNIQUE,
    dob DATE NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL,
    address VARCHAR(255) NOT NULL,
    contact VARCHAR(50) NOT NULL,
    subject VARCHAR(255) NOT NULL,
    qualifications TEXT,
    emergencyName VARCHAR(255),
    emergencyNumber VARCHAR(50)
);

CREATE TABLE IF NOT EXISTS university_announcements (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    message TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create table for university students
CREATE TABLE IF NOT EXISTS university_students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore)',
    name VARCHAR(255) NOT NULL COMMENT 'Student full name',
    student_id VARCHAR(20) NOT NULL UNIQUE COMMENT 'Unique student ID',
    dob DATE NOT NULL COMMENT 'Date of birth',
    gender ENUM('Male', 'Female', 'Other') NOT NULL COMMENT 'Gender of the student',
    address VARCHAR(255) NOT NULL COMMENT 'Residential address',
    guardian VARCHAR(255) NOT NULL COMMENT 'Guardian name',
    contact VARCHAR(50) NOT NULL COMMENT 'Contact number',
    grade INT NOT NULL COMMENT 'Grade or year level',
    hasAllergies ENUM('Yes', 'No') NOT NULL COMMENT 'Whether the student has allergies',
    medical TEXT COMMENT 'Medical information or notes',
    emergencyName VARCHAR(255) COMMENT 'Emergency contact name',
    emergencyNumber VARCHAR(50) COMMENT 'Emergency contact number'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Create table for university teachers
CREATE TABLE IF NOT EXISTS university_teachers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore)',
    name VARCHAR(255) NOT NULL COMMENT 'Teacher full name',
    teacher_id VARCHAR(20) NOT NULL UNIQUE COMMENT 'Unique teacher ID',
    dob DATE NOT NULL COMMENT 'Date of birth',
    gender ENUM('Male', 'Female', 'Other') NOT NULL COMMENT 'Gender of the teacher',
    address VARCHAR(255) NOT NULL COMMENT 'Residential address',
    contact VARCHAR(50) NOT NULL COMMENT 'Contact number',
    subject VARCHAR(255) NOT NULL COMMENT 'Subject taught',
    qualifications TEXT COMMENT 'Educational qualifications or certifications',
    emergencyName VARCHAR(255) COMMENT 'Emergency contact name',
    emergencyNumber VARCHAR(50) COMMENT 'Emergency contact number'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Create table for university announcements
CREATE TABLE IF NOT EXISTS university_announcements (
    id INT AUTO_INCREMENT PRIMARY KEY,
    sender_id VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore) for the sender',
    sender_name VARCHAR(255) NOT NULL COMMENT 'Human-readable name of the sender',
    message TEXT NOT NULL COMMENT 'Announcement message content',
    category VARCHAR(50) NOT NULL COMMENT 'Announcement category (e.g., General, Emergency)',
    priority VARCHAR(50) NOT NULL COMMENT 'Announcement priority (e.g., Low, Medium, High, Critical)',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'Time the announcement was created'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Add the 'school' job to ESX jobs table if it doesn't exist
INSERT IGNORE INTO jobs (name, label) VALUES ('school', 'University of Los Santos');

-- Add job grades for the 'school' job
INSERT IGNORE INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('school', 0, 'student', 'Student', 10, '{}', '{}'),
    ('school', 1, 'professor', 'Professor', 30, '{}', '{}'),
    ('school', 2, 'director', 'Director', 125, '{}', '{}');

Add Job

Example: If you want to set yourself as the Director (grade 2) and your server ID is 1, you would run: /setjob 1 school 2

school = {
label = 'University of Los Santos',
type = 'education',
defaultDuty = true,
offDutyPay = false,
grades = {
    ['0'] = {
        name = 'Student',
        payment = 10
    },
    ['1'] = {
        name = 'Professor',
        payment = 30
    },
    ['2'] = {
        name = 'Director',
        isboss = true,
        bankAuth = true,
        payment = 125
        },
    },
},

    ['school'] = {
    label = 'University of Los Santos',
    type = 'education',
    defaultDuty = true,
    offDutyPay = false,
    grades = {
        [0] = {
            name = 'Student',
            payment = 10
        },
        [1] = {
            name = 'Professor',
            payment = 30
        },
        [2] = {
            name = 'Director',
            isboss = true,
            bankAuth = true,
            payment = 125
            },
        },
    },

Bell Sound Setup

Install xsound and copy the bell.ogg sound from nl-university/install/sound to xsound\html\sounds

INSTALL COMPLETE

Customize the script to match your server’s setup.

PreviousMain config

Last updated 7 months ago

-- Create table for university students CREATE TABLE IF NOT EXISTS university_students ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore)', name VARCHAR(255) NOT NULL COMMENT 'Student full name', student_id VARCHAR(20) NOT NULL UNIQUE COMMENT 'Unique student ID', dob DATE NOT NULL COMMENT 'Date of birth', gender ENUM('Male', 'Female', 'Other') NOT NULL COMMENT 'Gender of the student', address VARCHAR(255) NOT NULL COMMENT 'Residential address', guardian VARCHAR(255) NOT NULL COMMENT 'Guardian name', contact VARCHAR(50) NOT NULL COMMENT 'Contact number', grade INT NOT NULL COMMENT 'Grade or year level', hasAllergies ENUM('Yes', 'No') NOT NULL COMMENT 'Whether the student has allergies', medical TEXT COMMENT 'Medical information or notes', emergencyName VARCHAR(255) COMMENT 'Emergency contact name', emergencyNumber VARCHAR(50) COMMENT 'Emergency contact number' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Create table for university teachers CREATE TABLE IF NOT EXISTS university_teachers ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore)', name VARCHAR(255) NOT NULL COMMENT 'Teacher full name', teacher_id VARCHAR(20) NOT NULL UNIQUE COMMENT 'Unique teacher ID', dob DATE NOT NULL COMMENT 'Date of birth', gender ENUM('Male', 'Female', 'Other') NOT NULL COMMENT 'Gender of the teacher', address VARCHAR(255) NOT NULL COMMENT 'Residential address', contact VARCHAR(50) NOT NULL COMMENT 'Contact number', subject VARCHAR(255) NOT NULL COMMENT 'Subject taught', qualifications TEXT COMMENT 'Educational qualifications or certifications', emergencyName VARCHAR(255) COMMENT 'Emergency contact name', emergencyNumber VARCHAR(50) COMMENT 'Emergency contact number' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Create table for university announcements CREATE TABLE IF NOT EXISTS university_announcements ( id INT AUTO_INCREMENT PRIMARY KEY, sender_id VARCHAR(255) NOT NULL COMMENT 'Stores the player identifier (ESX or QBCore) for the sender', sender_name VARCHAR(255) NOT NULL COMMENT 'Human-readable name of the sender', message TEXT NOT NULL COMMENT 'Announcement message content', category VARCHAR(50) NOT NULL COMMENT 'Announcement category (e.g., General, Emergency)', priority VARCHAR(50) NOT NULL COMMENT 'Announcement priority (e.g., Low, Medium, High, Critical)', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'Time the announcement was created' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Add the 'school' job to ESX jobs table if it doesn't exist INSERT IGNORE INTO jobs (name, label) VALUES ('school', 'University of Los Santos'); -- Add job grades for the 'school' job INSERT IGNORE INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('school', 0, 'student', 'Student', 10, '{}', '{}'), ('school', 1, 'professor', 'Professor', 30, '{}', '{}'), ('school', 2, 'director', 'Director', 125, '{}', '{}');

hashtagRESOURCE INSTALLATION GUIDE

hashtagRESOURCE INSTALLATION GUIDE

hashtagADD ITEMS

hashtagSQL

hashtagAdd Job

hashtagBell Sound Setup

hashtagINSTALL COMPLETE

RESOURCE INSTALLATION GUIDE

RESOURCE INSTALLATION GUIDE

_{ADD ITEMS}

SQL

Add Job

Bell Sound Setup

INSTALL COMPLETE