π§°Installation
Welcome to the Yoda Reputation System installation guide, here you can learn how to install our script step by step.
If you are a novate in progamming, we recommend that you read each step paying atention, all the documentation is important and you should not ignore that.
Data Base
The database must be set up for the Yoda Reputation System to work.
CREATE TABLE IF NOT EXISTS `yt_reputation_jobs` (
`job_id` int(11) NOT NULL AUTO_INCREMENT,
`job_label` varchar(255) NOT NULL,
`job_name` varchar(255) NOT NULL,
`max_points` int(11) NOT NULL,
`level_thresholds` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`level_thresholds`)),
PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE IF NOT EXISTS `yt_user_reputation` (
`user_id` varchar(255) NOT NULL,
`job_id` int(11) NOT NULL,
`points` int(11) DEFAULT 0,
`level` int(11) DEFAULT 0,
PRIMARY KEY (`user_id`, `job_id`),
CONSTRAINT `yt_user_reputation_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `yt_reputation_jobs` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE IF NOT EXISTS `yt_user_rewards` (
`user_id` varchar(255) NOT NULL,
`job_id` int(11) NOT NULL,
`reward_level` int(11) NOT NULL,
PRIMARY KEY (`user_id`, `job_id`, `reward_level`),
CONSTRAINT `yt_user_rewards_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `yt_reputation_jobs` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Download
If you want to update the script, you should download it again.
Dependencies
This script relies on functionalities from other scripts to work properly. Therefore, you need to install the scripts that Yoda Reputation System depends on. If you don't install these dependencies, the script may start, but you will likely see errors in the console, and the script will not function correctly!
ox_inventory or qb-inventory
Ensure/Start Order
Visit the page Ensure/Start Order
Last updated
Was this helpful?