mariadb query

Description

Executes a query in a thread. Execution of order is as called.

Syntax

mariadb_query(handle, query_str [, callback_func, callback_args...])

Parameters

• handle
  Connection handle.
• query_str
  The query to be executed.
• callback_func (optional)
  The function that will be called when the query was executed.
• callback_args (optional)
  Multiple arguments to pass to the callback_func.

Return Value

• Returns true if the query was successfully queued.

Example

function cmd_iplookup(player, ip)
	if (PlayerData[player].admin < 4) then
		return AddPlayerChat(player, "Insufficient permission")
	end

	if (ip == nil) then
		return AddPlayerChat(player, "Usage: /iplookup <ip>")
	end

	local query = mariadb_prepare(sql, "SELECT DISTINCT(id) FROM log_login WHERE ip = '?';", ip)

	mariadb_query(sql, query, OnIpLookup, player, ip)
end
AddCommand("iplookup", cmd_iplookup)

function OnIpLookup(player, ip)
	local rows = mariadb_get_row_count()

	if (rows == 0) then
		AddPlayerChat(player, "No account found for that IP")
	else
		for i=1, rows do
			local id = mariadb_get_value_index_int(i, 1)

			AddPlayerChat(player, "Account ID: "..id)
		end
	end
end

See also

• OnQueryError
• mariadb_log
• mariadb_connect
• mariadb_connect_file
• mariadb_close
• mariadb_unprocessed_queries
• mariadb_async_query
• mariadb_query
• mariadb_await_query
• mariadb_query_file
• mariadb_await_query_file
• mariadb_errno
• mariadb_error
• mariadb_escape_string
• mariadb_prepare
• mariadb_set_charset
• mariadb_get_charset
• mariadb_stat
• mariadb_get_row_count
• mariadb_get_field_count
• mariadb_get_result_count
• mariadb_get_field_name
• mariadb_set_result
• mariadb_get_value_index
• mariadb_get_value_index_int
• mariadb_get_value_index_float
• mariadb_get_value_name
• mariadb_get_value_name_int
• mariadb_get_value_name_float
• mariadb_save_result
• mariadb_delete_result
• mariadb_set_active_result
• mariadb_unset_active_result
• mariadb_is_any_result_active
• mariadb_is_valid_result
• mariadb_get_affected_rows
• mariadb_get_warning_count
• mariadb_get_insert_id
• mariadb_get_query_exec_time
• mariadb_get_query_string
• mariadb_get_row
• mariadb_get_assoc