mariadb get insert id: Difference between revisions
From Onset Developer Wiki
No edit summary |
No edit summary |
||
Line 12: | Line 12: | ||
== Example == | == Example == | ||
Example taken from: https://github.com/BlueMountainsIO/OnsetLuaScripts/blob/master/horizon/server/accounts.lua | |||
<syntaxhighlight lang="Lua> | <syntaxhighlight lang="Lua> | ||
local | function CreatePlayerAccount(player) | ||
print(" | 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 | |||
</syntaxhighlight> | </syntaxhighlight> | ||
{{RelatedFunctions}} | {{RelatedFunctions}} | ||
{{Template:MariaDBFunctions}} | {{Template:MariaDBFunctions}} |
Latest revision as of 08:47, 2 September 2020
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