0r_lib/server.main.lua
There are some problems, add some and let's put it together.
Resmon = {}
Resmon.Callbacks = {}
Resmon.UsableItems = {}
-...
go to 0r-craft and go to the bottom of page and replace this code, it is working without the lib, make sure you insert database file
function Koci.Server.Craft:InsertQueueToDB(xPlayer, item, canItBeCraftable)
if not xPlayer or not item then return -1 end
local user = xPlayer.identifier or xPlayer.PlayerData.citizenid or "unknown"
local name = item.name or "unknown"
local label = item.label or "Without name"
local count = item.count or 1
local image = item.image or ""
local ingredients = item.ingredients or {}
local encodedIngredients = json.encode(ingredients)
local propModel = item.propModel or ""
local price = item.price or 0
local canCraft = canItBeCraftable and 1 or 0
local status = item.status or "waiting"
local timestamp = os.date('%Y-%m-%d %H:%M:%S')
local insertId = -1
exports.oxmysql:insert([[
INSERT INTO `0r_crafting_queue`
(`user`, `name`, `label`, `count`, `image`, `ingredients`, `propModel`, `price`, `canItBeCraftable`, `status`, `created_at`, `updated_at`)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
]], {
user, name, label, count, image, encodedIngredients, propModel, price, canCraft, status, timestamp, timestamp
}, function(id)
insertId = id or -1
print(('[Crafting] Inserting in database %s | Item: %s | ID: %s'):format(user, name, insertId))
end)
return insertId
end[/crafting][/item][/itemname][/name][/name][/name]
