GNG2017
1
I have that query: SELECT `SpawnCharacter` FROM `Players` WHERE (`Id` = @Id)
If I use it in MySQL Workbench or in the command line MySQL it works, but with the mysql async script it’s not working. I use the v2.1.2 fivem-mysql-aync script.
[MySQL] [C: 94ms, Q: 0ms, R: 100ms] SELECT `SpawnCharacter` FROM `Players` WHERE (`Id` = @Id) {@Id=1}
*******(#1) has default character id: null
The response is null but I don’t know why.
The same in command line:
mysql> set @Id = 1;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT `SpawnCharacter` FROM `Players` WHERE (`Id` = @Id);
+----------------+
| SpawnCharacter |
+----------------+
| 4 |
+----------------+
1 row in set (0.00 sec)
My database setup:
(This is my first post sry if I’m wrong in something)