Closed oumuamuax closed 4 years ago
Hey! i don't use vertors in this script.. so you got maybe another version? or you didn't gave a correct position in config file
This is my config.
start mysql-async start async
add_ace resource.essentialmode command.sets allow add_ace resource.essentialmode command.add_principal allow add_ace resource.essentialmode command.add_ace allow start essentialmode start esplugin_mysql start es_ui start es_admin2 start es_extended start ft_libs start bob74_ipl start fivem-ipl start fivem-speedometer start es_camera
start esx_addons_gcphone start gcphone
start esx_menu_default start esx_menu_dialog start esx_menu_list start esx_addonaccount start skinchanger start esx_skin start esx_jobs start esx_joblisting start esx_shops start esx_extraitems start esx_clotheshop start esx_atm start esx_license start esx_weaponshop start esx_dmvschool start cron start esx_addoninventory start esx_billing start esx_society start esx_vehicleshop start instance start esx_status start esx_basicneeds start esx_jb_migrate start esx_jb_eden_garage2 start esx_jb_migrate start esx_datastore start esx_property start esx_barbershop start esx_identity start esx_service
start esx_policejob start esx_ambulancejob start esx_bankerjob start esx_mechanicjob start esx_realestateagentjob start esx_taxijob
start esx_illegal start esx_optionalneeds start esx_rpchat start esx_voice start esx_animations start esx_boat start esx_boilerplate start esx_cruisecontrol start esx_holdup start esx_lscustom start esx_sit start esx_doorlock start esx_moneywash start esx_nightclub start esx_bike-rental start esx_jb_advanced_truck_inventory start esx_vehiclelock
The police, boats and others do not work
USE essentialmode
;
licenses
(type
, label
) VALUES
('boat', 'Licencia Maritima')
ALTER TABLE owned_vehicles add vehicle_type varchar(10) not null default 'boat'
ALTER TABLE owned_vehicles add garage_name varchar(50) not null default 'stored'
;The police, boats and others do not work
USE
essentialmode
;INSERT INTO
licenses
(type
,label
) VALUES('boat', 'Licencia Maritima') ALTER TABLE owned_vehicles add vehicle_type varchar(10) not null default 'boat' ALTER TABLE owned_vehicles add garage_name varchar(50) not null default 'stored' ;
there is no lisnece needed for garage script 🤔
That is the sql of the boats, and it gives error. You can't buy any ship, the same goes for the police
lol no, you need to edit your sellers script to put in the table with correct information. you cannot add 2 or more default values to one column... look into some tutorial how to fill the database with correct values :)
Can you pass it to me please, or if you can give me your discord and explain it to me a little, I will not bother you again :3
an example just for you ...
MySQL.Async.execute( 'INSERT INTO owned_vehicles (vehicle, owner, vehicle_type) VALUES (@vehicle, @owner, @vehicle_type)', { ['@vehicle'] = json.encode(watervehicleProps), ['@owner'] = xPlayer.identifier, ['@vehicle_type'] = "boat", }, function (rowsChanged) TriggerClientEvent('esx:showNotification', _source, _U('watervehicle').. watervehicleProps.plate .. _('belongs')) end )
Where should i add that
Thx
¿How to fix? :3rd_place_medal: