FivePD SQL Edit for ESX

[Moose 0]

Hello, my name is Moose and I am a FiveM developer. I am getting into FivePD and have just completed the basic setup on a dev server for FivePD. I searched on the forums that FivePD is available with ESX and I happen to run an ESX server. My issue that I'm having with the SQL portion of the FivePD is I want to alter the users table instead of dropping it and added the requried SQL needed for FivePD because ESX runs off of its own user column. I'm not good with writing code otherwise I would've done it myself and altered the input to make it alter the table. If someone can help me with a work around so I can just add the needed column to my already existing users column in my ESX server that would be very helpful!

Down below I'll leave a example of what I'm trying to accomplish don't laugh at me I'm a noob xD.

[Conway 162]

Hello @Moose,

 

As stated by @Natixco - no one on the GPM Development Team has ever stated ESX will work with FivePD - in the FivePD FAQs it says the opposite. 
 

As someone who did manage to get FivePD to "work" with ESX/VRP - I suggest you heavily heavily understand what you are doing before you attempt it. It's not easy, nor something GPM/FivePD or the ESX Team can provide support on.

[Moose 0]

This is what I'm trying to accomplish without dropping my existing users column I just want to add on to it.

[TheCipher01 153]

23 hours ago, Moose said:

I searched on the forums that FivePD is available with ESX

FivePD hasn't been tested with ESX. They weren't really designed to be used together either. You would likely have to make it so the ESX tables are named different from the FivePD tables. You could also try creating separate databases but I'm not sure if that would work as intended either.

[Moose 0]

1 hour ago, TheCipher01 said:

FivePD hasn't been tested with ESX. They weren't really designed to be used together either. You would likely have to make it so the ESX tables are named different from the FivePD tables. You could also try creating separate databases but I'm not sure if that would work as intended either.

The forums says its supported I just need the command altered

[TheCipher01 153]

3 hours ago, Moose said:

The forums says its supported I just need the command altered

Which forums because it's been said on here and in discord before that FivePD has not been tested with nor was it designed to be used with ESX.

[NotCamSlice 321]

3 hours ago, Moose said:

The forums says its supported I just need the command altered

FivePD is not supported with ESX. FivePD is its own game-mode which does not run with other game modes..

[Natixco 242]

Nobody has ever said that FivePD is compatible with ESX. 

Straight from the README file (which you can find in the downloaded rar file): "It can run alongside ESX, but there is NO integration with it and they can conflict with each other, so we don’t suggest you to play with both together"