Can anyone help
why impound menu it not show up
bug popui always show, it’s better to just use the context menu
garage already does that, but your emergency vehicle must be a job vehicle
in owned_vehicles.job column == ‘police’ or ambulance
if its civ or empty, it will show on normal garage
@Nicky_Jerry
open a github issue with proper repro steps and screen shots of F8 and server.
@Free_Coding
latest garage have a floatingtext option. to disable popui.
Has anyone else had issues where you two people working same job, IE polce, of the same car out? It despawns one even while the other is being driven.
Is this about the free or the default cars?
Its possible since its using Dupe plate “ROLEPLAY”
1 Like
Cars I added in as default. I think I may just have misunderstood the intentions of the default vehicles.
did you checked the job column> what it saved there?
we could make Emergency Vehicle not to show in public, but thats the only restriction.
1 Like
1 Like
Update
Is there a way to compile and clean up the map blip list? So each garage isn’t listed by itself. I almost have more garages listed than anything else. 
1 Like
Update (New Impound System) BETA available in DEV Branch GITHUB
New Impound System Details
same /impound
officer needs to Fill up the Required details when impounding a vehicle.
Location:
Duration
Fees:
New Configurable ImpoundedLostVehicle
outside vehicle is now cannot be retrieved in garage menus,
Outside/Lost Vehicles
can be retrieved from Impound MRPD as default. (table 1 identifier)
Impound System now support multiple impound garage.
if officer send it to Vespucci , Player can only retrieve it there after the Impound Duration.
Impound Fees default are 10000
Player can see the remaining impound duration time.
players can see what impound garage.
created a conf folder.
to easily manage all config one by one.
impound garage now shows the following:
Officer in charge:
Fee:
Reason:
etc..
Make sure to import the new impound_garage table.
By Default it uses impound column from MYSQL
it will show no specified if vehicle is not saved yet in impound_garage table.
1 Like
hello, i got a problem with the sql import
im using mysql 8.x if i try to import the sql i get following error
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT 'A'' at line 2
[Err] ALTER TABLE owned_vehicles
ADD garage_id varchar(32) NOT DEFAULT 'A';
[Msg] Finished - Unsuccessfully
if i delete this line, the same happen to the next line
ESX Legacy
Insert the Column one by one.
if its a duplicate column you can ignore it.
ALTER TABLE owned_vehicles
ADD garage_id varchar(32) NOT NULL DEFAULT 'A';
ALTER TABLE owned_vehicles
ADD impound int(1) NOT NULL DEFAULT 0;
ALTER TABLE owned_vehicles
ADD stored int(1) NOT NULL DEFAULT 0;
ALTER TABLE owned_vehicles
ADD `type` varchar(32) NOT NULL DEFAULT 'car';
ALTER TABLE owned_vehicles
ADD `job` varchar(32) NOT NULL DEFAULT 'civ';
ALTER TABLE owned_vehicles
ADD park_coord LONGTEXT NULL;
ALTER TABLE owned_vehicles
ADD isparked int(1) NULL DEFAULT 0;
CREATE TABLE IF NOT EXISTS `impound_garage` (
`garage` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`data` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`garage`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `private_garage` (
`identifier` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`vehicles` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
`garage` VARCHAR(64) NULL COLLATE 'utf8mb4_general_ci',
`inventory` LONGTEXT NULL COLLATE 'utf8mb4_general_ci'
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOT EXISTS `parking_meter` (
`identifier` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`plate` VARCHAR(32) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`vehicle` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
`coord` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
`park_coord` LONGTEXT NULL COLLATE 'utf8mb4_general_ci'
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
thank you worked nearly.
[Err] 1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
[Err] CREATE TABLE IF NOT EXISTS `impound_garage` (
`garage` VARCHAR(64) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`data` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`garage`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
[Msg] Finished - Unsuccessfully
and
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stored int(1) NOT NULL DEFAULT 0' at line 2
[Err] ALTER TABLE owned_vehicles
ADD stored int(1) NOT NULL DEFAULT 0;
[Msg] Finished - Unsuccessfully
use this for impound table
CREATE TABLE IF NOT EXISTS `impound_garage` (
`garage` VARCHAR(64) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`data` LONGTEXT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`garage`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
as for 2nd error ,
ALTER TABLE owned_vehicles
ADD `stored` int(1) NOT NULL DEFAULT 0;
thank you all worked only the stored makes problems but it tells dublicate so i can ignore it
[Err] 1060 - Duplicate column name 'stored'
[Err] ALTER TABLE owned_vehicles
ADD `stored` int(1) NOT NULL DEFAULT 0;
[Msg] Finished - Unsuccessfully
yea you can ignore it,
thank you for your time
1 Like