You’d have to downgrade your version or edit the code to meet your needs
Hello everyone! I’m kinda new to developing FiveM servers so I may be doing some stupid stuff here but when I try to import the SQL for the Police Job I get this
INSERT INTO addon_account (name, label, shared) VALUES
(‘society_police’, ‘Police’, 1)
MySQL said:
#1146 - Table ‘es_extended.addon_account’ doesn’t exist
Here is the SQL also:
USE es_extended;
INSERT INTO addon_account (name, label, shared) VALUES
(‘society_police’, ‘Police’, 1)
;
INSERT INTO datastore (name, label, shared) VALUES
(‘society_police’, ‘Police’, 1)
;
INSERT INTO addon_inventory (name, label, shared) VALUES
(‘society_police’, ‘Police’, 1)
;
INSERT INTO jobs (name, label) VALUES
(‘police’, ‘LSPD’)
;
INSERT INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
(‘police’,0,‘recruit’,‘Recrue’,20,’{}’,’{}’),
(‘police’,1,‘officer’,‘Officier’,40,’{}’,’{}’),
(‘police’,2,‘sergeant’,‘Sergent’,60,’{}’,’{}’),
(‘police’,3,‘lieutenant’,‘Lieutenant’,85,’{}’,’{}’),
(‘police’,4,‘boss’,‘Commandant’,100,’{}’,’{}’)
;
CREATE TABLE fine_types (
id int NOT NULL AUTO_INCREMENT,
label varchar(255) DEFAULT NULL,
amount int DEFAULT NULL,
category int DEFAULT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO fine_types (label, amount, category) VALUES
(‘Usage abusif du klaxon’,30,0),
(‘Franchir une ligne continue’,40,0),
(‘Circulation à contresens’,250,0),
(‘Demi-tour non autorisé’,250,0),
(‘Circulation hors-route’,170,0),
(‘Non-respect des distances de sécurité’,30,0),
(‘Arrêt dangereux / interdit’,150,0),
(‘Stationnement gênant / interdit’,70,0),
(‘Non respect de la priorité à droite’,70,0),
(‘Non-respect à un véhicule prioritaire’,90,0),
(‘Non-respect d’un stop’,105,0),
(‘Non-respect d’un feu rouge’,130,0),
(‘Dépassement dangereux’,100,0),
(‘Véhicule non en état’,100,0),
(‘Conduite sans permis’,1500,0),
(‘Délit de fuite’,800,0),
(‘Excès de vitesse < 5 kmh’,90,0),
(‘Excès de vitesse 5-15 kmh’,120,0),
(‘Excès de vitesse 15-30 kmh’,180,0),
(‘Excès de vitesse > 30 kmh’,300,0),
(‘Entrave de la circulation’,110,1),
(‘Dégradation de la voie publique’,90,1),
(‘Trouble à l’ordre publique’,90,1),
(‘Entrave opération de police’,130,1),
(‘Insulte envers / entre civils’,75,1),
(‘Outrage à agent de police’,110,1),
(‘Menace verbale ou intimidation envers civil’,90,1),
(‘Menace verbale ou intimidation envers policier’,150,1),
(‘Manifestation illégale’,250,1),
(‘Tentative de corruption’,1500,1),
(‘Arme blanche sortie en ville’,120,2),
(‘Arme léthale sortie en ville’,300,2),
(‘Port d’arme non autorisé (défaut de license)’,600,2),
(‘Port d’arme illégal’,700,2),
(‘Pris en flag lockpick’,300,2),
(‘Vol de voiture’,1800,2),
(‘Vente de drogue’,1500,2),
(‘Fabriquation de drogue’,1500,2),
(‘Possession de drogue’,650,2),
(‘Prise d’ôtage civil’,1500,2),
(‘Prise d’ôtage agent de l’état’,2000,2),
(‘Braquage particulier’,650,2),
(‘Braquage magasin’,650,2),
(‘Braquage de banque’,1500,2),
(‘Tir sur civil’,2000,3),
(‘Tir sur agent de l’état’,2500,3),
(‘Tentative de meurtre sur civil’,3000,3),
(‘Tentative de meurtre sur agent de l’état’,5000,3),
(‘Meurtre sur civil’,10000,3),
(‘Meurte sur agent de l’état’,30000,3),
(‘Meurtre involontaire’,1800,3),
(‘Escroquerie à l’entreprise’,2000,2)
;
it is the esx_service mod. remove it and done
isnt that needed for esx_policejob to function?
anytime i confiscate from someone when there dead they get revived they still have there weapons and items
Can someone help me how to fix it?
for i=1, #items, 1 do
table.insert(elements, {label = 'x' .. items[i].count .. ' ' .. items[i].label, value = items[i].name})
end
do you happen to have ranks set up in the database and have all vehicles spawning as the specific rank you want like i have here
Also does anyone know how to add bags into the config for uniforms. We have some badges that are under bags but cant figure out how to add them in.
This is what we have tried but it doesnt work
how can i make police vehicles always in the garage without having to make players buy them?
they have to buy them, but you can do what i did and make them for $1 each
I am stuck in the vehicle shop when I try to navigate to an addon car.
I am getting:
SCRIPT ERROR: @esx_garage/client/main.lua:299: attempt to index a nil value (local 'garage')
> fn (@esx_garage/client/main.lua:424
SCRIPT ERROR: @esx_garage/client/main.lua:299: attempt to index a nil value (local 'garage')
> fn (@esx_garage/client/main.lua:439
Not sure if it is esx_garage or esx_policejob as it is in the police vehicle shop
It literally says that in the error message 
1 Like
Could you maybe tell me what the problem is? I just started creating my own server
to fix this you need to go to your DB and delete the job grades and and job its self, once you have done this you will be able to add the SQL
have it bags_1 and bags_2
Hello
You make a valid point for RP. i was just having a concern about them leaving PD and than still being able to access the cars. I currently am configuring EdenGarage2, is there another garage you recommend? if not do you know if police vehicles have an identifier? or do i have to blacklist them individually
did you ever figure out how to make police cars not spawn in public garage?
Is there any way to make the police cars free, and so the player doesn’t actually own the vehicle?
Could u tell me what u did there ? Cause im searching for such a script for a couple days now and im not that good in scripting it by myself. Would be great if u can help out 
1 Like
I want in my police vehicle store, changing the names. i see only police cruiser. but i want to name it how i want
When i click “e” when im in blip nothing happens and script kind crashes. Anyone hava a solve?