View source for mariadb async query

{{Info|Function|Server|1.0}}
{{Notice|This function is provided by the official [[MariaDB]] plugin.}}

{{FuncDescription|Executes a query in different parallel threads. Execution of order can not be guaranteed. Better use [[mariadb_query]] if you are unsure about it.}}

{{FuncSyntax|mariadb_async_query(handle, query_str [, callback_func, callback_args...])}}

{{FuncParameters}}
{{FuncParam|handle|Connection handle.}}
{{FuncParam|query_str |The query to be executed.}}
{{FuncParamOptional|callback_func|The function that will be called when the query was executed.}}
{{FuncParamOptional|callback_args|Multiple arguments to pass to the callback_func.}}

{{FuncReturnValue|Returns '''true''' if the query was successfully queued.}}

== Example ==
<syntaxhighlight lang="Lua">
function GetCurrentPlayTime(player)
   CreateTimer(function(player)
       for k, v in pairs (GetAllPlayers()) do
           if GetAllPlayers() == true then
              local query = mariadb_prepare(sql, "SELECT * FROM accounts WHERE id = '?';",
              PlayerData[v].accountid)
              mariadb_async_query(sql, query, GetPlayerTime, v) 
           end
       end 
   end, 15000, player)
end
AddEvent("OnPackageStart", GetCurrentPlayTime)

function GetPlayerTime(player)
   local result = mariadb_get_assoc(1)
   local playtime = math.tointeger(result['time']) -- total time played on the server without session time.
   PlayerData[player].time = math.floor(PlayerData[player].time + (GetTimeSeconds() - PlayerData[player].play_time)) -- session play time.
   PlayerData[player].play_time = GetTimeSeconds()
   return PlayerData[player].time + playtime -- returns the total play time on the server.
end
</syntaxhighlight>
{{RelatedFunctions}}
__EDIT_ME__