Installations
Step 1 ➡ Dependencies
Step 2 ➡ Resources in server.cfg
Step 3 ➡ Database
Step 4 ➡ Click on Config
Last updated
Last updated
ensure sfcraftingCREATE TABLE `crafting` (
`id` int NOT NULL,
`name` varchar(64) NOT NULL,
`invid` varchar(64) NOT NULL,
`job` varchar(128) NOT NULL,
`itemid` varchar(64) NOT NULL,
`products` text NOT NULL,
`display` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `crafting` ADD PRIMARY KEY (`id`);
ALTER TABLE `crafting` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
INSERT INTO `crafting` (`name`, `invid`, `job`, `itemid`, `products`, `display`) VALUES ('table2', 'client', 'none', 'cocaine', '[{\"amount\":\"1\",\"item\":\"drug_white\"}]', 0);
INSERT INTO `crafting` (`name`, `invid`, `job`, `itemid`, `products`, `display`) VALUES ('table1', 'client', 'none', 'heartstopper', '[ {\"amount\":\"1\",\"item\":\"bun\"},{\"amount\":\"3\",\"item\":\"patty\"},{\"amount\":\"3\",\"item\":\"cheese\"},{\"amount\":\"1\",\"item\":\"tomato\"},{\"amount\":\"1\",\"item\":\"lettuce\"},{\"amount\":\"1\",\"item\":\"sauce\"}, ]', 1);