[Pawn] mysql_query to tquery inline

[Awide]

Your syntax might be incorrect. I think you can't format the string in that function, you need to format it earlier.



Check this:

Code:

new query[1024];

mysql_format(ourConnection, query, sizeof query, "SELECT COUNT(*) FROM vehicles WHERE VehicleOwnerDBID = %d", PlayerInfo[playerid][pDBID]);

inline LoadData() {

new rows;

? ? ? ? if(cache_get_row_count(rows)) {

? ? ? ? ? ? cache_get_value_index_int(0, 0, count);

? ? ? ? }

@return 1;

}

MySQL_TQueryInline(ourConnection, using inline LoadData, query);

Also note tquery is not happening instantly! If you need the data immediately to be handled by a function use non-threaded queries.