[Release][ESX] Properties

FiveM Resource Development & Modding Releases
354

To buy or store weapons ?

355

store

356

you must have esx addoninventory in order to be able to store items and weapons in houses.

357

Hello again! Iā€™m still looking for help showing the buy and rent prices when interacting with the property. Any help with this would be amazing :slight_smile:

358

I have esx_addoninventory but it is not working for meā€¦

359

Make sure youā€™re using the english sql for the propertiesā€¦ Check my comment from a few days ago with the proper sql file. I was having the same problems. itā€™s located in the Localization folder.

USE `essentialmode`;

ALTER TABLE `users`
  ADD COLUMN `last_property` VARCHAR(255) NULL
;

INSERT INTO `addon_account` (name, label, shared) VALUES
  ('property_black_money','Money Sale Property',0)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
  ('property','Property',0)
;

INSERT INTO `datastore` (name, label, shared) VALUES
  ('property','Property',0)
;

CREATE TABLE `owned_properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `rented` int(11) NOT NULL,
  `owner` varchar(60) NOT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entering` varchar(255) DEFAULT NULL,
  `exit` varchar(255) DEFAULT NULL,
  `inside` varchar(255) DEFAULT NULL,
  `outside` varchar(255) DEFAULT NULL,
  `ipls` varchar(255) DEFAULT '[]',
  `gateway` varchar(255) DEFAULT NULL,
  `is_single` int(11) DEFAULT NULL,
  `is_room` int(11) DEFAULT NULL,
  `is_gateway` int(11) DEFAULT NULL,
  `room_menu` varchar(255) DEFAULT NULL,
  `price` int(11) NOT NULL,

  PRIMARY KEY (`id`)
);
360

thanks it is working now :smiley:

361

Did you solve this?

362

Hi im still looking a fix/solution to prevent this duping method , anyone knows how by anychance ? Or is it just FiveM sycning problem

363

any ideia how to make properties unique so no house can be bought 2 times while not sold first? i thought in a available houses collumn in mysql property collumn and a script who would just pick that ones for show on map blips instead of all whole property list ā€¦ problem is to remove a house automaticly from available houses table when bought :Xā€¦ and then when sold script must get it to available houses again

364

You could set it to only sell houses if a real estate agent is on, then you can just sell/rent the houses you wish.

365

Anyone knows if the /givekeys to their houses is part of this addon or an other resources?, cant seem to find it, i dont wanna invite them i wanna be able to give them keys so i they can enter it whenever they want

366

I canā€™t store things in house please help me

367

Can someone say me how to change the Rent payment from daily to weekly??

368

Use the english SQL from the LOCALIZATION folder. It should look something like this below.

USE `essentialmode`;

ALTER TABLE `users`
  ADD COLUMN `last_property` VARCHAR(255) NULL
;

INSERT INTO `addon_account` (name, label, shared) VALUES
  ('property_black_money','Money Sale Property',0)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
  ('property','Property',0)
;

INSERT INTO `datastore` (name, label, shared) VALUES
  ('property','Property',0)
;

CREATE TABLE `owned_properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `rented` int(11) NOT NULL,
  `owner` varchar(60) NOT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entering` varchar(255) DEFAULT NULL,
  `exit` varchar(255) DEFAULT NULL,
  `inside` varchar(255) DEFAULT NULL,
  `outside` varchar(255) DEFAULT NULL,
  `ipls` varchar(255) DEFAULT '[]',
  `gateway` varchar(255) DEFAULT NULL,
  `is_single` int(11) DEFAULT NULL,
  `is_room` int(11) DEFAULT NULL,
  `is_gateway` int(11) DEFAULT NULL,
  `room_menu` varchar(255) DEFAULT NULL,
  `price` int(11) NOT NULL,

  PRIMARY KEY (`id`)
);
369

i want to put one of those item storage and clothes changing things in a house you cant buy, how can i do this?

370

Find the xyz coordinates you want that stuff to go, go in the data base under properties, find the house you want the inventory/clothes menu to go, and add the XYZ coordinates to the section in the house/property called room_menu. Room menu is the inventory/clothing menu.

372

Anyone know why I canā€™t add anything to my home inventory besides dirty cash and weapons? I tried to put items in and it takes it from my inventory but wont load into the database

373

yes, use this sql fileā€¦ or look in the LOCALIZATION folder of the addon and use the en.sql file

USE `essentialmode`;

ALTER TABLE `users`
  ADD COLUMN `last_property` VARCHAR(255) NULL
;

INSERT INTO `addon_account` (name, label, shared) VALUES
  ('property_black_money','Money Sale Property',0)
;

INSERT INTO `addon_inventory` (name, label, shared) VALUES
  ('property','Property',0)
;

INSERT INTO `datastore` (name, label, shared) VALUES
  ('property','Property',0)
;

CREATE TABLE `owned_properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` double NOT NULL,
  `rented` int(11) NOT NULL,
  `owner` varchar(60) NOT NULL,

  PRIMARY KEY (`id`)
);

CREATE TABLE `properties` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `entering` varchar(255) DEFAULT NULL,
  `exit` varchar(255) DEFAULT NULL,
  `inside` varchar(255) DEFAULT NULL,
  `outside` varchar(255) DEFAULT NULL,
  `ipls` varchar(255) DEFAULT '[]',
  `gateway` varchar(255) DEFAULT NULL,
  `is_single` int(11) DEFAULT NULL,
  `is_room` int(11) DEFAULT NULL,
  `is_gateway` int(11) DEFAULT NULL,
  `room_menu` varchar(255) DEFAULT NULL,
  `price` int(11) NOT NULL,

  PRIMARY KEY (`id`)
);
374

ok thank you, ill try it!