Share this post

Link to post

Because you need first the data and then you set the condition/filter.

LEFT JOIN `Item` ON `Player`.serial =`Item`.serial WHERE true

It worked, thanks again

I need to ask about moment when server prepare string with function dbPrepareString, this is the moment when table is created/re-created. I was thinking it's possible that due of timing this will be executed at same time, so data for another player wouldn't save (script re-creates tables). Not sure if it's only my imagination.

1

Share this post

Link to post

I need to ask about moment when server prepare string with function dbPrepareString, this is the moment when table is created/re-created. I was thinking it's possible that due of timing this will be executed at same time, so data for another player wouldn't save (script re-creates tables). Not sure if it's only my imagination.

dbPrepareString does not apply changes to the database.

The most logic reason I can think of for the dbPrepareString databaseConnection argument, are the string escape rules. But that is also where my knowledge ends.

A database has a query queue, so if your timing is correct on Lua, the timing on the database is also correct.