Codex Studios
Visit our Tebex StoreOur Discord
  • ๐Ÿ‘‹Welcome to Codex Studios
  • Overview
    • ๐Ÿ’กAbout Us
    • โœจOur Features
  • ๐Ÿ’…RedM-Scripts
    • ๐ŸŒ[Codex Studios] : Core
      • Client Side
      • Server Side - CodexCore API
      • Config
      • ๐Ÿ“ Client Side (clientside.lua)
      • ๐Ÿงพ Server Side (serverside.lua)
      • ๐Ÿ›ก๏ธCodexCore Security Module
      • ๐Ÿ—’๏ธSecurity Detailed Explanation
      • ๐Ÿ”Client-Side: Securing Event Triggers
      • ๐Ÿ”’Server-Side: Securing Event Triggers
    • ๐Ÿ’ช[Codex Studios] : Trust Level
      • Client Side
      • Config
      • SQL
  • ๐Ÿ“ฆ[Codex Studios]: Supplies System
    • Client Side
    • Server-Side Town Supplies
    • Config
    • ๐Ÿช›Examples and Commands
    • Sql Updated
Powered by GitBook
On this page

Was this helpful?

  1. RedM-Scripts
  2. [Codex Studios] : Trust Level

SQL

Simple Copy and paste it

Create The SQL TABLE :

CREATE TABLE IF NOT EXISTS `trustlevel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(255) NOT NULL,
  `charidentifier` varchar(255) NOT NULL,
  `trust` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`trust`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `identifier` (`identifier`,`charidentifier`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

Just in case you need it , or check how looks like :

INSERT IGNORE INTO `trustlevel` (`id`, `identifier`, `charidentifier`, `trust`) VALUES
	(1, 'steam:xxx', '11', '{"drugcooker":10,"moonshine":0,"breaker":263,"boost":10,"gunner":10,"drugfarmer":10}'),
	
PreviousConfigNext[Codex Studios]: Supplies System

Last updated 1 month ago

Was this helpful?

๐Ÿ’…
๐Ÿ’ช