🛠️Installation

Welcome to our installation guide! In this section, we'll walk you through the steps to effortlessly set up the Script S-Admin!

Admin System Installation

Follow this steps to install the script:

1. Download the Script from Keymaster

2. Drag the Script into your resources

3. Add this to you your server.cfg: start S-Admin

4. If the SQL file doesn't insert automatically, insert the SQL file in your database by hand.

CREATE TABLE IF NOT EXISTS `Admin_Settings` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shortmenusettings` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT "left",
  `openeddefaultpanel` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT "home",
  `paneluisize` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT "1.0",
  `uicolor` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT "red",  
  `openspectate` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT "false",
  `openedadminuiaduty` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT "no",
  PRIMARY KEY (`index`) USING BTREE,
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

ALTER TABLE users
ADD `marked` varchar(10) DEFAULT "false",
ADD `playtime` varchar(100) DEFAULT "0",
ADD `warns` varchar(100) DEFAULT "0";

CREATE TABLE IF NOT EXISTS `Admin_Bans` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Playername` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BannedBy` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BanDate` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `BanUntil` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  
  `Reason` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Steam` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `License` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Discord` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Xbox` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IP` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Live` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Tokens` varchar(5000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,    
  PRIMARY KEY (`index`) USING BTREE,
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE IF NOT EXISTS `Admin_Logs` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Playername` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ActionBy` varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ActionDate` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TypeOfAction` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,  
  `Reason` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`index`) USING BTREE,
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE IF NOT EXISTS `Admin_Notes` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `MadeBy` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Date` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Message` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`index`) USING BTREE,
  KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE IF NOT EXISTS `Admin_Stats` (
  `index` int(11) NOT NULL AUTO_INCREMENT,
  `typeofspeicher` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Date` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`index`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

1. For ESX 1.1 and 1.2 insert this in <es_extended> > <server> > <functions.lua> under ESX.GetPlayers

function ESX.GetExtendedPlayers(key, val)
	local xPlayers = {}
	for k, v in pairs(ESX.Players) do
		if key then
			if (key == 'job' and v.job.name == val) or v[key] == val then
				xPlayers[#xPlayers + 1] = v
			end
		else
			xPlayers[#xPlayers + 1] = v
		end
	end
	return xPlayers
end

1. Restart the Server and play S-Admin on your Server!

Thats All! Enjoy the Script on your Server!