2020-12-23, 04:47 PM
Sorry for doubleposting, but I am using this script:
https://github.com/pBlueG/SA-MP-MySQL/bl...-cache.pwn
It is shame, but I copied it, so everything is exactly the same (all the proceses), except the MULTI_STATEMENT tunning. Basically the query in OnPlayerConnect looks somewhat like this:
The fields in table "first" are loaded just perfectly. But the fields in 2nd and 3rd seem to not exist (according to mysql.txt) in error logs.
https://github.com/pBlueG/SA-MP-MySQL/bl...-cache.pwn
It is shame, but I copied it, so everything is exactly the same (all the proceses), except the MULTI_STATEMENT tunning. Basically the query in OnPlayerConnect looks somewhat like this:
Code:
mysql_format(g_SQL, query, sizeof query, "SELECT * FROM `first` WHERE `username` = '%e' LIMIT 1 ; SELECT * FROM `second` WHERE `username` = '%e' LIMIT 1 ; SELECT * FROM `third` WHERE `username` = '%e' LIMIT 1", Player[playerid][Name], Player[playerid][Name], Player[playerid][Name]);
The fields in table "first" are loaded just perfectly. But the fields in 2nd and 3rd seem to not exist (according to mysql.txt) in error logs.