• 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Pawn] Data loading
#2
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:



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.
  Reply


Messages In This Thread
Data loading - by AdamWorkshop - 2020-12-23, 04:35 PM
RE: Data loading - by AdamWorkshop - 2020-12-23, 04:47 PM
RE: Data loading - by Radical - 2020-12-25, 06:31 PM
RE: Data loading - by Pinch - 2020-12-25, 07:51 PM
RE: Data loading - by Epureanu - 2020-12-27, 09:10 AM

Forum Jump: