Clothingshop System Installation
CREATE TABLE IF NOT EXISTS `S_Warehouse` (
`index` int(11) NOT NULL AUTO_INCREMENT,
`id` int(20) DEFAULT NULL,
`identifier` varchar(50) DEFAULT NULL,
`information` text DEFAULT NULL,
`whitelistet` text DEFAULT "{}",
`cache` text DEFAULT "{}",
PRIMARY KEY (`id`),
KEY `index` (`index`),
KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `S_Workbench` (
`index` int(11) NOT NULL AUTO_INCREMENT,
`id` int(20) DEFAULT NULL,
`tabindex` int(20) DEFAULT NULL,
`identifier` varchar(50) DEFAULT NULL,
`information` text DEFAULT "{}",
PRIMARY KEY (`index`),
KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
-- For some items
INSERT INTO `items`(name, label, `weight`, `rare`, `can_remove`) VALUES
("metall", "Metall", 1, 1 ,2),
("waffenteile", "Waffenteile", 1, 1 ,2),
("aufsatzteile", "Aufsatzteile", 1, 1 ,2),
("flashlight", "Flashlight", 1, 1 ,2),
("luxuryfinish", "Luxuryfinish", 1, 1 ,2),
("suppressor", "Suppressor", 1, 1 ,2),
("extendedclip", "Extendedclip", 1, 1 ,2);
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