mariadb get insert id

Description

Retrieves the ID generated for an AUTO_INCREMENT column by the sent query (usually INSERT).

Syntax

mariadb_get_insert_id()

Parameters

• This function has no parameters.

Return Value

• new ID generated for an AUTO_INCREMENT column, false on error.

Example

Example taken from: https://github.com/BlueMountainsIO/OnsetLuaScripts/blob/master/horizon/server/accounts.lua

function CreatePlayerAccount(player)
	local query = mariadb_prepare(sql, "INSERT INTO accounts (id, steamid, steam_name, game_version, locale, registration_time, registration_ip) VALUES (NULL, '?', '?', ?, '?', UNIX_TIMESTAMP(), '?');",
		tostring(GetPlayerSteamId(player)),
		GetPlayerName(player),
		GetPlayerGameVersion(player),
		GetPlayerLocale(player),
		GetPlayerIP(player))

	mariadb_query(sql, query, OnAccountCreated, player)
end


function OnAccountCreated(player)
	local new_id = mariadb_get_insert_id()

	if new_id == false then
		KickPlayer(player, "An error occured while creating your account 😨")
	else
		PlayerData[player].accountid = mariadb_get_insert_id()

		SetPlayerLoggedIn(player)

		print("Account ID "..PlayerData[player].accountid.." created for "..player)

		AddPlayerChat(player, '<span color="#ffff00aa" style="bold italic" size="15">SERVER: Welcome to the community, '..GetPlayerName(player)..', have fun and play fair!</>')
		AddPlayerChatAll('<span color="00ee00ff">We now have'..PlayerData[player].accountid..' accounts registered</>')
	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