Here is a link to a fixed transistep.sql
There were a few errors in the syntax.
(Note: You will have to uncomment the last part if you are using his customized esx_advanced_garage)
Will that fix the not being able to buy trucks problem?
Quand nous allons récupérer notre trailer, le menu de voiture est vide c’est normal? On doit en acheter en tant que société et en restaurer une ou bien ?
Merci pour l’addon super boulot sinon ma patrie <3
how fix the “store” error? lol i have the sql correctly registered
great script but I have a error that I want to pull out a vehicle:
es_extended: TriggerServerCallback => [esx_vehicleshop:retrieveJobVehicles] does not exist
how do we fix this?
Hi all,
I updated the repository, check the changes in the commit messages.
-Remove mafia utilities;
-Re-adapt to the original esx_service and own_vehicle sql table;
-Completed the fr.lua local (EN local SOON)
All the best and thank’s for your interest 
Salut, seul le patron de l’entreprise peut acheter des véhicules d’entreprise (camions), donc mets toi le grade boss et va check le garage.
Sinon tout les employés peuvent sortir / rentrer les camions du garage.
Thank’s
You need to be the boss to buy vehicles and have them in your garage 
/* Erro SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘(‘society_transistep_depot’, ‘Transistep Dépôt’, 1)’ at line 2 /
/ Erro SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘varchar(255)’ at line 4 */
I was the boss, nothing happens when u do buy them.
Check that out mate
Explain this job by video please…
Hi all,
Fixed the script client/main.lua and the transistep.lua, there was few errors, now everything works !
Enjoy and thank’s for your feedbacks !
There’s a little mistake in server.lua :
You have to edit line 260 :
From :
TriggerEvent('esx_addoninventory:getSharedInventory', 'society_transistep_depot', function(inventory)
To :
TriggerEvent('esx_addoninventory:getSharedInventory', 'society_transistep_warehouse', function(inventory)
==============================================
I’ve also added a blip to get trailer location when you register in a convoy :
Client\main.lua, line 937 :
local blip = AddBlipForCoord(Config.Blip2.Pos.x, Config.Blip2.Pos.y, Config.Blip2.Pos.z)
SetBlipSprite(blip, 208)
SetBlipDisplay(blip, 4)
SetBlipScale(blip, 0.7)
SetBlipColour(blip, 56)
SetBlipAsShortRange(blip, true)
BeginTextCommandSetBlipName("STRING")
AddTextComponentString('Cargaison')
EndTextCommandSetBlipName(blip)
Config.lua, line 14 :
Config.Blip2 = {
Pos = { x = 92.84, y = 6334.78, z = 31.37 },
}
2 Likes
Hello!
We got this error in server log:e[31m[ERROR] [MySQL] [transistep] An error happens on MySQL for query "INSERT INTOconvoy_registered_list(identifier, is_trailer_stored, convoy_id) VALUES ('steam:11000010a93aecd', false, 0)": ER_DUP_ENTRY: Duplicate entry '0' for key 'PRIMARY'e[0m
How can we fix this?
error after buy a Truck
[ERROR] [MySQL] [esx_transistep] An error happens on MySQL for query “INSERT INTO owned_vehicles (owner, vehicle, plate, type, job, stored) VALUES (‘steam:xxxxxxxxxxxxxx’, ‘{"modArchCover":-1,"modShifterLeavers":-1,"modRoof":-1,"modTank":-1,"modHydrolic":-1,"modGrille":-1,"modBrakes":-1,"dirtLevel":11.0,"plate":"BZL 316","modSpoilers":-1,"modLivery":-1,"bodyHealth":1000.0,"modRightFender":-1,"modOrnaments":-1,"modStruts":-1,"modSpeakers":-1,"modTurbo":false,"modWindows":-1,"modDashboard":-1,"windowTint":-1,"modDoorSpeaker":-1,"model":2053223216,"modRearBumper":-1,"modSeats":-1,"modTrimB":-1,"modBackWheels":-1,"modSteeringWheel":-1,"modSuspension":-1,"modVanityPlate":-1,"modEngineBlock":-1,"modFender":-1,"fuelLevel":80.0,"wheelColor":156,"modAerials":-1,"modFrame":-1,"modAPlate":-1,"modAirFilter":-1,"modXenon":false,"modSmokeEnabled":false,"modTransmission":-1,"modArmor":-1,"neonColor":[255,0,255],"modEngine":-1,"neonEnabled":[false,false,false,false],"color2":0,"modPlateHolder":-1,"modTrimA":-1,"modFrontWheels":-1,"modSideSkirt":-1,"modDial":-1,"modFrontBumper":-1,"color1":0,"plateIndex":0,"tyreSmokeColor":[255,255,255],"extras":{"5":false,"6":false,"7":false,"1":false,"2":false,"3":false,"4":true,"10":true,"11":false,"12":false},"wheels":0,"modHorns":-1,"modExhaust":-1,"pearlescentColor":0,"modTrunk":-1,"modHood":-1,"engineHealth":1000.0}’, ‘BZL 316’, ‘car’, ‘transistep’, true)”: ER_PARSE_ERROR: 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) VALUES (‘steam:110000107blurxxx’, ‘{"modArchCover":-1,"modShifterLeave’ at line 1
My DB
What’s wrong?
where can i buy a truck? i dont have that option.
@Don_Cano You have to setup your own truck shop I have found.
Quite a bit of this code wasn’t ready out of the box, I had to do quite a bit of modifications to get it working.
1 Like