Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Step 1 :
- Add a new column limitation to your item table name (not null)
- Step 2 :
- add "i1.limitation AS raw_lim, i2.limitation AS treat_lim" in SQL request and add "'raw_lim', 'treat_lim'" in getResults (server.lua in vdk_recolt : jobs:getJobs event handler)
- Step 3 :
- You can use this piece of code if you want (from CitizenThread in vdkrec.lua):
- if (exports.vdk_inventory:notFull() == true) then
- if (near == 'field' and exports.vdk_inventory:getQuantity(item.raw_id) < item.raw_lim ) then
- recolt('Récolte', item, '+1')
- elseif (near == 'treatment' and exports.vdk_inventory:getQuantity(item.raw_id) > 0 and exports.vdk_inventory:getQuantity(item.treat_id) < item.treat_lim) then
- recolt('Traitement', item, '+1')
- elseif (near == 'seller' and exports.vdk_inventory:getQuantity(item.treat_id) > 0) then
- recolt('Vente', item, '-1')
- end
- else
- if (near == 'treatment' and exports.vdk_inventory:getQuantity(item.raw_id) > 0 and exports.vdk_inventory:getQuantity(item.treat_id) < item.treat_lim) then
- recolt('Traitement', item, '+1')
- elseif (near == 'seller' and exports.vdk_inventory:getQuantity(item.treat_id) > 0) then
- recolt('Vente', item, '-1')
- end
- end
- Step 4 :
- In vdkinv.lua, change getQuantity function to :
- function getQuantity(itemId)
- if(not ITEMS[tonumber(itemId)]) then
- return 0
- else
- return ITEMS[tonumber(itemId)].quantity
- end
- end
- Step 5 (if you have vdk_recolt 1.5) :
- In server.lua, there is the giveItem event modified
- AddEventHandler("player:giveItem", function(item, name, qty, target)
- local player = getPlayerID(target)
- local executed_query = MySQL:executeQuery("SELECT SUM(quantity) as total FROM user_inventory WHERE user_id = '@username'", { ['@username'] = player })
- local result = MySQL:getResults(executed_query, { 'total' })
- local executed_query2 = MySQL:executeQuery("SELECT quantity, limitation FROM `items` JOIN user_inventory ON items.id = user_inventory.item_id WHERE user_id = '@user' AND id = '@id'", { ['@user'] = player, ['@id'] = item })
- local result2 = MySQL:getResults(executed_query2, { 'quantity', 'limitation' })
- if(result and result2) then
- local total = result[1].total
- if (total + qty <= 60 and result2[1].quantity < result2[1].limitation) then
- TriggerClientEvent("player:looseItem", source, item, qty)
- TriggerClientEvent("player:receiveItem", target, item, qty)
- TriggerClientEvent("es_freeroam:notify", target, "CHAR_MP_STRIPCLUB_PR", 1, "Mairie", false, "Vous venez de recevoir " .. qty .. " " .. name)
- end
- end
- end)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement