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.
If you still encounter issues after going through this documentation, review each step once more. After ensuring everything is correct, you can find additional information on common errors in the Common Problems section of this documentation for further assistance.
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!
