[xxmitsu]

@andreT

It's a completely threaded plugin, there is no chance you can run a query without threading it.

IF you set the cache parameter to 'true', then anything will be done in the thread: Store result -> fetch row -> free result without needing to call them for yourself.

@stewie : from main post, mysql_format is a native function added in version 6-2

Код:

mysql_format( connectionHandle, output[], format[], {Float,_}:... )
Supported formats: (precisions such as %2.f/%10.s are not supported yet)
- %e (escapes data directly without the need to call mysql_escape_string() before)
- %s (string)
- %d / %i (integer)
- %f (float)

new szDestination[100];
mysql_format(connectionHandle, szDestination, "SELECT * FROM `%s` WHERE `bar` = '%e' AND `foobar` = '%f' LIMIT %d", "foobar", "escape'me\"please", 1.2345, 1337);
// the variable 'szDestination' contains now the formatted query (including the escaped string)