[Release] Inventory System v2.1 (Personal Menu)

FiveM Resource Development & Modding Releases
, ,
43

i have the same error …

44

Nobody has the solution i think

1 Like
45

PRIMARY KEYit’s really necessary for identifier ?

46

I edit my post for this problem (I think)

47

Yes it is for create foreign key in user_inventory :wink:

48

varchar(255) and int(11) everywere but always the same bug.
#1071 - Specified key was too long; max key length is 767 bytes rip

49

Code to reset player items on death:

in server file:

RegisterServerEvent("item:Reset")
AddEventHandler("item:Reset", function()
    playerId = tonumber(source)
    TriggerEvent('es:getPlayerFromId', playerId, function(user)
        local player = user.identifier
        local executed_query = MySQL:executeQuery("SELECT * FROM user_inventory JOIN items ON `user_inventory`.`item_id` = `items`.`id` WHERE user_id = '@username'", { ['@username'] = player })
        local result = MySQL:getResults(executed_query, { 'quantity', 'libelle', 'item_id' }, "item_id")
        if (result) then
            for _, v in ipairs(result) do
				MySQL:executeQuery("UPDATE user_inventory SET `quantity` = @qty WHERE `user_id` = '@username' AND `item_id` = @id", { ['@username'] = player, ['@qty'] = 0, ['@id'] = tonumber(v.item_id) })
            end
        end
    end)
end)

in client file:

Citizen.CreateThread(function()
    while true do
        Citizen.Wait(0)      
        if IsEntityDead(PlayerPedId()) then
            RegisterNetEvent("item:Reset")
            TriggerServerEvent("item:Reset")
        end
    end
end)
2 Likes
50

Oooooh thank you, I’ll integrate this :heart_eyes:

51

i have the same problem :confused:

52

varchar(255) and int(11) everywere but always the same bug.

1071 - Specified key was too long; max key length is 767 bytes rip

53

I have a problem I can not join my database to give with the server

54

Better with

Citizen.CreateThread(function()
    while true do
        Citizen.Wait(0)      
        if IsEntityDead(PlayerPedId()) then
            RegisterNetEvent("item:Reset")
            TriggerServerEvent("item:Reset")
        end
    end
end)

There is an extra “end” that serves no purpose

1 Like
55

Oops, i’ll fix it in my file, thx.

1 Like
56

Not work db mysql :

Erreur
Requête SQL :

CREATE TABLE `user_inventory` (
  `user_id` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_id`,`item_id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `user_inventory_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`identifier`),
  CONSTRAINT `user_inventory_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#1071 - Specified key was too long; max key length is 767 bytes

pliz fix it thx :slight_smile:

57

guys look the topic !!!

@Vodkhard fix it in the file or add it ont frist topic

58

Error Code: 1068. Multiple primary key defined ?

59

I fix this, if your user line is in Primary key, delete the primary key, and when you will execute this SQL file, it will be good.

@MO_SnipZo

1 Like
60

Screens ? It is possible ?

61

I have exactly the same error

62

You can delete this message :slight_smile: