[Pawn] mysql_query to tquery inline

[Zow]

this one work

Code:

GetVehicleCount(playerid) { ? ? new threadCheck[128], count; ? ? mysql_format(ourConnection, threadCheck, sizeof(threadCheck), "SELECT COUNT(*) FROM vehicles WHERE VehicleOwnerDBID = %d", PlayerInfo[playerid][pDBID]); ? ? new Cache: result = mysql_query(ourConnection, threadCheck); ? ? cache_get_value_index_int(0, 0, count); ? ? cache_delete(result); ? ? return count; }

this is first time to using inline but its not work as I expect

Code:

GetVehicleCountEx(playerid) { ? ? new count; ? ? inline _CountVehicle() ? ? { ? ? ? ? new rows; ? ? ? ? if(cache_get_row_count(rows)) ? ? ? ? { ? ? ? ? ? ? cache_get_value_index_int(0, 0, count); ? ? ? ? } ? ? } ? ? MySQL_TQueryInline(ourConnection, using inline _CountVehicle, "SELECT COUNT(*) FROM vehicles WHERE VehicleOwnerDBID = %d", PlayerInfo[playerid][pDBID]); ? ? return count; }

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