Hi All, hope everyone is well and if possible I’m after a little bit of advise
extended_garage, I have an issue where citizens purchase a vehicle, or a boat etc they pop that into a garage, the owned_vehicles is updated to show that it is stored but then when they go to take it out it says there are no owned vehicles, I’ve dropped the owned_vehicles table, ran the script below which others have advised worked for them, changed the order in the server config but still nothing seems to fix this.
Is there anything else that I can try that might point me in the right direction as it is getting frustrating now and what little hair I have left may well be pulled out?
USE essentialmode
;
CREATE TABLE owned_vehicles
(
owner
varchar(22) NOT NULL,
plate
varchar(12) NOT NULL,
vehicle
longtext NOT NULL,
type
VARCHAR(20) NOT NULL DEFAULT ‘car’,
job
VARCHAR(20) NOT NULL DEFAULT ‘’,
stored
TINYINT(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`plate`)
);
I know there is a link between this and the esx_vehicleshop side, but cannot see where this is failing.
Any help or ideas greatly appreciated.
Thanks
Rich