[RE-RELEASE] esx_eden garage2: 3 in 1 garage

FiveM Releases
,
845

Here you are the video: https://streamable.com/839ld

846

Show me console server side and your database

847

This is how my owned vehicles db are

db
db1452×560 126 KB

848

I am using esx_edengaarage2. Is that what you meant by society garage?

849

first of all your database is completely wrong, secondly i meant society vehicles with garage 2 (last 15 lines) are society garages

850

hey Jager,
Thanks for the reply. That database above is not mine. Here is mine.

owned-vehicles
owned-vehicles369×772 7.61 KB
owned-vehicles-2
owned-vehicles-21372×68 6.81 KB

Yes I do use society vehicles for police where they can buy (esx_police) and for ambulance where they can also buy (esx_ambulance). I see the data for those LOST vehicles is stored in my ‘owned vehicle’ database. How can I remove this to make sure it just goes to the impound (Yellow circle)?

Sorry I’m not a very experienced FiveM guy, basic knowledge only. Hopefully you can understand the above :slight_smile:

851

youre database is incorrect too…
and with society garages on owner there will be written the job name instead of steamid

852

I see. That second screenshot is taken out of ‘Owned_Vehicles’ where they buy from esx_vehicleshop. So the society job vehicle shouldn’t be there in the first place. Is there a particular script I need to delete/edit to stop society bought vehicles to go into ‘OWNED_VEHICLES’ database. Will I also need another database for IMPOUNDED vehicles?

Here’s my ‘owned_vehicles’ database table.

v3
v31423×576 67.9 KB

appreciate your time in replying my comments!

853

well yes id column and job column must be deleted… just reinsert table or look what is different.

dans society vehicles are in owned vehicles table but instead of steam id there is name of job

854

which database is wrong, mine?

1 Like
855

Both of you

856

which sql do i must import

857

sql given by default

858

in you script i supose?

859

db
db962×418 70.4 KB

Is this one okey?

860

not good either :sunny:

861

could you give me the good code, dont find it

862

The differences between esx_eden_garage2 sql and my owned_vehicle database is I’m missing index_owned_vehicle_owner. So I just add another column?

ALTER TABLE owned_vehicles
[DONE]> ADD state BOOLEAN NOT NULL DEFAULT FALSE COMMENT ‘Etat de la voiture’ AFTER owner,
[DONE]> ADD fourrieremecano BOOLEAN NOT NULL DEFAULT FALSE,
[DONE]> ADD vehiclename varchar(50) NOT NULL DEFAULT ‘voiture’,
> ADD INDEX index_owned_vehicles_owner (owner)
;

After adding this is what I need to have right? Not fully understand what you mean by ‘instead of steam id there is name of job’

test
test1552×830 418 KB

863

Can anyone who is getting esx_jb_eden garage2 work, share his owned_vehicles sql?

864

How to fix that?

[ERROR] [MySQL] An critical error happens on MySQL for query "SELECT * FROM owne
d_vehicles INNER JOIN characters ON owned_vehicles.owner = characters.identifier
 WHERE fourrieremecano = TRUE {=}": An item with the same key has already been a
dded. Key: id   at System.Collections.Generic.Dictionary`2[TKey,TValue].TryInser
t (TKey key, TValue value, System.Collections.Generic.InsertionBehavior behavior
) [0x0015a] in <fbc4ec45371543bfba3678ebb82caf6d>:0
  at System.Collections.Generic.Dictionary`2[TKey,TValue].Add (TKey key, TValue
value) [0x00000] in <fbc4ec45371543bfba3678ebb82caf6d>:0
  at MySQLAsync.FetchAll.ReaderAsync (MySql.Data.MySqlClient.MySqlCommand comman
d) [0x000e9] in <6f835765886c4fada3e5ffb1ffcd6998>:0
  at MySQLAsync.Operation`1[TResult].ExecuteAsync (System.String query, System.C
ollections.Generic.IDictionary`2[TKey,TValue] parameters, CitizenFX.Core.Callbac
kDelegate callback, System.Boolean debug) [0x00169] in <6f835765886c4fada3e5ffb1
ffcd6998>:0