mariadb async query - Revision history

BlueMountains at 18:25, 30 August 2020

2020-08-30T18:25:30Z

← Older revision		Revision as of 18:25, 30 August 2020
Line 38:		Line 38:
	</syntaxhighlight>		</syntaxhighlight>
	{{RelatedFunctions}}		{{RelatedFunctions}}
	~~__EDIT_ME__~~		{{MariaDBFunctions}}

BlueMountains at 22:16, 26 January 2020

2020-01-26T22:16:23Z

← Older revision		Revision as of 22:16, 26 January 2020
Line 2:		Line 2:
	{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}		{{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.}}		{{FuncDescription\|Executes a query in different parallel threads. Order of execution cannot be guaranteed. Better use [[mariadb_query]] if you are unsure about it.}}

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

REDRUM at 15:53, 26 January 2020

2020-01-26T15:53:13Z

← Older revision		Revision as of 15:53, 26 January 2020
Line 20:		Line 20:
	for k, v in pairs (GetAllPlayers()) do		for k, v in pairs (GetAllPlayers()) do
	if GetAllPlayers() == true then		if GetAllPlayers() == true then
	local query = mariadb_prepare(sql, "SELECT * FROM accounts WHERE id = '?';",		local query = mariadb_prepare(sql, "SELECT * FROM accounts WHERE id = '?';",
	PlayerData[v].accountid)		PlayerData[v].accountid)
	mariadb_async_query(sql, query, GetPlayerTime, v)		mariadb_async_query(sql, query, GetPlayerTime, v)
	end		end
	end		end
Line 30:		Line 30:

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

REDRUM: /* Example */

2020-01-26T15:44:19Z

Example

@@ Line 15: / Line 15: @@
 == Example ==
-__EDIT_ME__
+<syntaxhighlight lang="Lua">
 {{RelatedFunctions}}
 __EDIT_ME__

BlueMountains at 10:46, 27 October 2019

2019-10-27T10:46:05Z

← Older revision		Revision as of 10:46, 27 October 2019
Line 2:		Line 2:
	{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}		{{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.}}		{{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...])}}		{{FuncSyntax\|mariadb_async_query(handle, query_str [, callback_func, callback_args...])}}
Line 12:		Line 12:
	{{FuncParamOptional\|callback_args\|Multiple arguments to pass to the callback_func.}}		{{FuncParamOptional\|callback_args\|Multiple arguments to pass to the callback_func.}}

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

	== Example ==		== Example ==

BlueMountains at 08:11, 30 August 2019

2019-08-30T08:11:41Z

← Older revision		Revision as of 08:11, 30 August 2019
Line 2:		Line 2:
	{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}		{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}

	{{FuncDescription\|~~__EDIT_ME__~~}}		{{FuncDescription\|Executes a query in different parallel threads. Execution of order can not be guaranteed.}}

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

	{{FuncParameters}}		{{FuncParameters}}
	{{~~FuncNoParam~~}}		{{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\|__EDIT_ME__}}		{{FuncReturnValue\|__EDIT_ME__}}

BlueMountains: Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_async_query()}} {..."

2019-05-19T10:31:12Z

Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_async_query()}} {..."

New page

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

{{FuncDescription|__EDIT_ME__}}

{{FuncSyntax|mariadb_async_query()}}

{{FuncParameters}}
{{FuncNoParam}}

{{FuncReturnValue|__EDIT_ME__}}

== Example ==
__EDIT_ME__

{{RelatedFunctions}}
__EDIT_ME__