SQL import order and placement in the server.cfg

I hope it will help a lot of peoples if someone see some mistakes you can say here, ty

(Depends on ESX dependencies)

Important note:

  • It is important to add set es_enableCustomData 1 at the top of your server.cfg

  • For proper operation, essentialmode must start before esplugin_mysql, MySQLAsync must start before essentialmode.

The tagged plugins -SQL contain a database to import.

Les plugins tagués –SQL contain a database to import.

  1. essentialmode + es_admin2 => [Release] EssentialMode base start essentialmode start es_admin2

  2. esplugin_mysql–SQL [Release] EssentialMode base
    start esplugin_mysql

  3. es_extended–SQL https://github.com/ESX-Org/fxserver-es_extended
    start es_extended start esx_menu_default start esx_menu_list start esx_menu_dialog

  4. cron https://github.com/ESX-Org/fxserver-cron
    start cron

(It is important to place it at the beginning, so that it is started before the scripts that need it (par exemple : esx_society for whitening))

  1. esx_addonaccount–SQL https://github.com/ESX-Org/fxserver-esx_addonaccount
    start esx_addonaccount

  2. esx_society–SQL https://github.com/ESX-Org/fxserver-esx_society
    start esx_society

  3. esx_phone–SQL https://github.com/ESX-Org/fxserver-esx_phone
    start esx_phone

  4. esx_jobs–SQL https://github.com/ESX-Org/fxserver-esx_jobs
    start esx_jobs

  5. esx_addoninventory–SQL https://github.com/ESX-Org/fxserver-esx_addoninventory
    start esx_addoninventory

  6. esx_ambulancejob–SQL https://github.com/ESX-Org/fxserver-esx_ambulancejob
    start baseevents start esx_ambulancejob

  7. esx_bankerjob–SQL https://github.com/ESX-Org/fxserver-esx_bankerjob
    start esx_bankerjob

  8. esx_billing–SQL https://github.com/ESX-Org/fxserver-esx_billing
    start esx_billing

  9. esx_vehicleshop–SQL https://github.com/ESX-Org/fxserver-esx_vehicleshop
    start esx_vehicleshop

  10. esx_garage–SQL https://github.com/ESX-Org/fxserver-esx_garage
    start esx_garage

  11. esx_taxijob–SQL https://github.com/ESX-Org/fxserver-esx_taxijob
    start esx_taxijob

  12. esx_status–SQL https://github.com/ESX-Org/fxserver-esx_status
    start esx_status

  13. esx_basicneeds–SQL https://github.com/ESX-Org/fxserver-esx_basicneeds
    start esx_basicneeds

  14. esx_datastore–SQL https://github.com/ESX-Org/fxserver-esx_datastore
    start esx_datastore

  15. esx_mask–SQL https://github.com/ESX-Org/fxserver-esx_mask
    start baseevents (attention, already added with esx ambulance job, if the resource is installed) start esx_mask

  16. esx_shops–SQL https://github.com/ESX-Org/fxserver-esx_shops
    start esx_shops

  17. esx_license–SQL https://github.com/ESX-Org/esx_license
    start esx_license

  18. esx_weashops–SQL https://github.com/ESX-Org/fxserver-esx_weashops
    start esx_weashops

  19. esx_property–SQL https://github.com/ESX-Org/fxserver-esx_property
    start esx_property

  20. esx_offices–SQL The esx_offices-SQL database is in the folder esx_property.

  21. esx_realestateagentjob–SQL https://github.com/ESX-Org/fxserver-esx_realestateagentjob
    start esx_realestateagentjob

  22. esx_policejob–SQL https://github.com/ESX-Org/fxserver-esx_policejob
    start esx_policejob

  23. esx_drugs–SQL https://github.com/ESX-Org/fxserver-esx_drugs
    start esx_drugs

  24. esx_mecanojob–SQL https://github.com/ESX-Org/fxserver-esx_mecanojob
    start esx_mecanojob

  25. esx_identity–SQL https://github.com/ESX-Org/esx_identity
    start esx_identity

  26. esx_whitelist–SQL https://github.com/ESX-Org/esx_whitelist
    start esx_whitelist

  27. esx_dmvschool-SQL https://github.com/ESX-Org/esx_dmvschool
    start esx_dmvschool

  28. esx_lscustom https://github.com/ESX-Org/fxserver-esx_lscustom
    start esx_lscustom

  29. esx_joblisting https://github.com/ESX-Org/fxserver-esx_joblisting
    start esx_joblisting

  30. skinchanger https://github.com/ESX-Org/fxserver-skinchanger
    start skinchanger

  31. esx_skin https://github.com/ESX-Org/fxserver-esx_skin
    start esx_skin

  32. esx_clotheshop https://github.com/ESX-Org/fxserver-esx_clotheshop
    start esx_clotheshop

  33. es_camera https://github.com/ESX-Org/fxserver-es_camera
    start es_camera

  34. instance https://github.com/ESX-Org/fxserver-instance
    start instance

  35. esx_service https://github.com/ESX-Org/fxserver-esx_service
    start esx_service

  36. esx_holdup https://github.com/ESX-Org/fxserver_esx_holdup
    start esx_holdup

  37. esx_atm https://github.com/ESX-Org/fxserver-esx_atm
    start esx_atm

  38. esx_barbershop https://github.com/ESX-Org/fxserver-esx_barbershop
    start esx_barbershop

  39. esx_optionalneeds https://github.com/ESX-Org/fxserver-esx_optionalneeds
    start esx_optionalneeds

  40. esx_animations https://github.com/ESX-Org/fxserver-esx_animations
    start esx_animations

  41. esx_sit https://github.com/ESX-Org/fxserver-esx_sit
    start esx_sit

  42. esx_voice https://github.com/ESX-Org/esx_voice
    start esx_voice

(If you have the base client, you already have voice range limiter !, make a choice )
47. esx_rpchat https://github.com/ESX-Org/esx_rpchat
start esx_rpchat

  1. esx_thief https://gitlab.com/Deediezi/gta5_scripts/tree/master/[ESX]/esx_thief/esx_thief
    start esx_rpchat

  2. esx_cruisecontrol https://github.com/ESX-Org/esx_cruisecontrol
    start esx_thief


Also add:
esx_menu_default https://github.com/ESX-Org/fxserver-esx_menu_default

esx_menu_dialog https://github.com/ESX-Org/fxserver-esx_menu_dialog

esx_menu_list https://github.com/ESX-Org/fxserver-esx_menu_list

Les « start » were added when you added es_extended

async https://github.com/ESX-Org/fxserver-async

It is not necessary to add a “start” for async. Add also start baseevents

12 Likes

nice share

1 Like

how I import it to the database

4 Likes

Thank you

2 Likes

should import all resources sql manually?

Error: (node:15424) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:15424) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
what happen ? how can i do this

For anyone getting errors while importing jobs (not esx_jobs, individual ones) to their database, import esx_datastore first, then the jobs, instead of the posted order. This prevented me from getting errors. For instance, when importing esx_ambulancejob, it was missing esx_datastore. This was fixed by adding esx_datastore before any jobs, since they are dependent on the database entries. If you don’t do this, you won’t have the proper tables for certain jobs, you’ll get database import errors, and subsequently, your scripts won’t work.

2 Likes