Hi, i have an issue with the give keys system
When i try to give key to another player the list of the neatby player is empty i don't have any error in the console. I see than i'm not alone to have this issue but i don't find solution. Thanks for your help !

Describe the bug
It is impossible to Give a Key outside of a Property.
Logically this isnt the biggest "issue" but.

You still have the Option to give a Key outside. If you press the Button you receive several server-errors.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'any (outside) Position of a House with a second player'
2. Click on 'Key-Management and Give Key'
3. See theres nothing happen
4. See errors serverside (property/server)

Expected behavior
If Possible to Give a Key outside of a Property -> it should work
Otherwise (ist more logically) hide the Option to Give a Key while outside of a property, to avoid server-errors:

[ script:esx_property] SCRIPT ERROR: @esx_property/server/main.lua:762: attempt to index a nil value (field '?')
[ script:esx_property] > TriggerServerCallback (@es_extended/server/functions.lua:167)
[ script:esx_property] > handler (@es_extended/server/common.lua:112)
[ script:es_extended] SCRIPT ERROR: error object is not a string

Screenshots
Not possible atm

Debug Info (please complete the following information):

• OS: ( Windows)
• FiveM Artifact latest recommended
• ESX Version: 1.8.5

Additional Context:
I already tried the Optimizations from Mycroft in his PR`s - but its not a solution. If i apply his code - esx_property is complete broken

Describe the bug
Currently the PropertyId is the iteration / position of the property within the "properies.json" file.
When removing a property all existing properties greater then the one that has been removed will decrease one in value creating issues with OX_Inventory stashes. In order for OX_inventory stashes to work the Property id needs to be a static id.

To Reproduce

1. Create two or more properties.
2. Enter house number two and notice the stash id: (property-2)
3. Leave house number two and remove house number one using the admin menu.
4. Enter house number two again and notice the stash id: (property-1)

Expected behavior
When deleting a property all properties with a greater property id should keep their property ID in order not to lose their stashes/storage contents.

Screenshots

Debug Info (please complete the following information):

• OS: Ubuntu
• FiveM Artifact latest recommended
• ESX Version: 1.9.4

Additional information:
Fixed it on our project by adding a static Id for each property.

Describe the bug
When you use the CCTV in a house you can not rotate the camera to the right, it only works left, up and down

To Reproduce
Steps to reproduce the behavior:

1. Go to paleto house or any
2. Click on 'CCTV'
3. press D
4. See error

Expected behavior
make the camera rotate to the right

Screenshots

Debug Info (please complete the following information):

• OS: Windows
• FiveM Artifact: 6163
• ESX Version: 1.9.0

Additional context
Nothing

MySQL should be used instead of loading and saving resource files, because using resource files is extremely sloppy and very out of date.

Loading every single data for every player ever purchasing a property slows down the server permanently also.
Just loading the data needed would be much smarter. This is a change that should be done to all resources over time.

Also manipulating data while the server is running is impossible using the current save method.

Cela serait sympa de pouvoir prendre des Bay comme dans la vraie vie, par exemple louer avec une signature une maison au lieu de directement l’acheter, par exemple tous les 6h ils doivent payer leur loyer.

It would be awesome if the storage would work with the default menu context.

I am getting the following error causing esx_property to not work at all.

The code is not changed and is exactly how it came from github

Hello everyone and sorry for my english, is it possible to have a version with the native inventory of esx_addoninventory and not the ox-inventory only please? Like esx_police we can choose ox-inventory or not (using esx_context)

Good afternoon, is it possible to disable friends from having access to our house inventory?

je ne est pas d erreur mes il mes impossible de donner des clé a un autre joueur alors qu'il et devant moi

I noticed every time my server start's the script esx_property creates a row in my datastore_data table on the database that is empty and null. I tryed and fixed that to check if the row exists then to not create it and create the row only if not exist.

`CreateThread(function()
Wait(3000)
PropertiesRefresh()

MySQL.query("ALTER TABLE `users` ADD COLUMN IF NOT EXISTS `last_property` LONGTEXT NULL", function(result)
    if result.affectedRows > 0 then
        print("[^2INFO^7] Added ^5last_property^7 column to users table")
    end
end)

-- Check if datastore table exists before inserting values.
if MySQL.scalar.await("SELECT EXISTS (SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_TYPE LIKE 'BASE TABLE' AND TABLE_NAME = 'datastore')") > 0 then
    if MySQL.scalar.await("SELECT COUNT(*) FROM `datastore` WHERE name = 'property'") == 0 then
        MySQL.insert("INSERT INTO `datastore` (name, label, shared) VALUES ('property', 'Property', 1)", function(affectedRows)
            if affectedRows > 0 then
                print("[^2INFO^7] Added ^5Property^7 into ^5datastore^7 table")
            end
        end)
    else
        print("[^2INFO^7] Row with name ^5Property^7 already exists in the ^5datastore^7 table")
    end

    if MySQL.scalar.await("SELECT COUNT(*) FROM `datastore_data` WHERE name = 'property'") == 0 then
        MySQL.insert("INSERT INTO `datastore_data` (name, owner, data) VALUES ('property', NULL, '{}')", function(affectedRows)
            if affectedRows > 0 then
                print("[^2INFO^7] Added ^5Property^7 into ^5datastore_data^7 table")
            end
        end)
    else
        print("[^2INFO^7] Row with name ^5Property^7 already exists in the '^5datastore_data' table")
    end
end

end)`

After i bought a House i wantend to give a key to a friend but every time he says he can´t find any Players nearby, although he is standing next to me.

• We have no errors in the Server or Client console.

Would be awesome to have the ability to set up multiple Wardrobes and Storages.

As an example if you are in relationship or have multiple room mates
and if there are two visual wardrobes - we can set up two, etc.

For storages i ant to have a "Storage" if you have a visual safe or crate etc.
Aswell as a Storage at the Cooler in the kitchen for food etc.

Hello i have a problem. Since the new mod menu versions came out people keep deleting my properties because the owned properties are in the server folder. Is there any way i could move the property thing to the database so the modders cant keep deleting my players houses ?

Describe the bug
When I buy a house with I can open and close it from the outside. If a stranger comes to my house, he can also open and close it from the outside and go in and out as he pleases. Please help !

To Reproduce
Steps to reproduce the behavior:

1. by porperty
2. Open and lock outside
3. anyone can open and lock my house
4. Anyone can go in and out without having a key

Expected behavior
If I buy a property that only I as the owner can open and close or the one who got a key to go in.

Screenshots
NO ERROR

Debug Info (please complete the following information):

• OS: (Linux)
• FiveM Artifact : 6046
• ESX Version: legacy 1.8.5