Save cars in database

[zDxvilZ]

Hey Guys, 

I have a question. And if a player buys a car, how do I save it in the database

Thanks for your help!

[sparx]

Have a vehicles table with all of the columns relating to the vehicles properties then a foreign key for the players unique ID (ex. OwnerID). To get the players vehicles just fetch all vehicles where the players unique ID (ID/GUID/Whatever) matches that unique ID on the vehicles table (OwnerID). To save a new vehicle to the database as mentioned above you'll have a vehicle table with the vehicle properties and it's just a matter of doing an INSERT/UPDATE query with the required data. There are other more detailed database design methods but this one is pretty universal. 

[zDxvilZ]

And how do I „park“ the car?

That the car is right in front of me.

Thanks!

[Division]

Loop all vehicles and get the closest one to your player position. 

Take that car object and safe it to the database.

[qdex]

add me on discord i can give you a example

 

discord : qdex#3223

[zDxvilZ]

Can you add me on discord @qdex?

because i get an error that discord don't find your name

Fabio_#5860

Edited June 30, 2020 by zDxvilZ