AsYetUntitled / Framework

Altis Life RPG mission framework for Arma 3 originally made by @TAWTonic.
Other
247 stars 310 forks source link

Cars wont save in garage when restarting the server #244

Closed ghost closed 7 years ago

ghost commented 7 years ago
### Expected behaviour The cars should go back into the players garage on restart ### Actual behaviour If the car is not in the garage, it will go away ### Steps to reproduce the behaviour 1. took out a car 2. restarted the server ---- Mission version: 5.0 Launcher version: newest Game version: newest Branch: 5.0
CarlosGilbertoHF commented 7 years ago

Did you setup the appropriate account\s that run the sql procedures in your database?

ghost commented 7 years ago

such as?

allstar-uk commented 7 years ago

lol

Jawshy commented 7 years ago

@mur202, thanks for the report. What @NeFShARk is asking is essentially "does the arma3 user at localhost exist in your database?" See altislife.sql, lines 31-68.

Although, I am quite sure I know what issue you are talking about and just need to confirm it on the latest build.

CarlosGilbertoHF commented 7 years ago

If he used the sql file of this repo to create his database, then yes, the user\acc that i'm talking about is indeed arma3 like @Jawshy said above.

Jawshy commented 7 years ago

@mur202, I cannot reproduce this issue on the latest (281ceb2) version of the master branch. When the server is restarted any vehicle with active = 1 is set to active = 0 just as it should. See /life_server/init.sqf, line 70 and /altislife.sql, lines 38-41.

Valdas-Stonkus commented 7 years ago

This problem was to me too, solution is just set Definer to root@127.0.0.1 and save each table in this picture. pakeitimai mysql