[Release] Save/Respawn the last player position with MySQL

FiveM Resource Development & Modding Releases
32

Ok sorry I did’nt know !

33

me to I have this problem :\

34

Hello, really nice script but do you have an idea for respawning the player in the saved coord ?

35

Its on his way, please be patient, and read again all the answers before ask a question :slight_smile:

36

It record on the database but when i reconnects i go to the “spawnpoint” and not the last record. :confused:

37

GitHub Updated :wink:
/!\ IMPORTANT Update ALTER column and delete your last position recorded

38

What is the ALTER column ?

39

ALTER the “lastpos” column into MySQL.
More easy, delete the column and use the new sql file to reinstall correctly

41

your column lastpos is empty ?

42

“use the new sql file” What the new sql file sorry I don’t understand !

43

inside the github “lastpos.sql”

44

Thank you working great :slight_smile:

1 Like
45

you’re welcom feared :wink:

46

This script can be optimized but if you make it please share :wink:

47

Sure i just make them save all 5 minutes, and i added the color blue to “Position Sauvegardée” and the green for “Vous voici a voter derniere position”

2 Likes
48

Thanks it work perfectly !!

1 Like
49

One question ?$
I want to change the spawn by default in your script but on mine i have only this :

{ x = -1046.56, y = -2771.78, z = 4.6398 }  I have XYZ

And in yours i have this :slight_smile:
'{-887.48388671875, -2311.68872070313, -3.50776553153992, 142.503463745117}';
And you we have XYZ and ?

50

its azimut, where you see on 360°

1 Like
51

I can delete it ? Or not ?

52

Normaly yes, if error fix the script server side :wink: