Alberto Alonso at 17:44, 5 January 2011

2011-01-05T17:44:59Z

← Older revision		Revision as of 17:44, 5 January 2011
Line 1:		Line 1:
			<pageclass class="#AA7592" subcaption="MTA-MySQL Module"></pageclass>
	__NOTOC__		__NOTOC__
	{{ModuleFunction\|MTA-MySQL}}		{{ModuleFunction\|MTA-MySQL}}

Ryden at 18:01, 14 January 2008

2008-01-14T18:01:33Z

← Older revision		Revision as of 18:01, 14 January 2008
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MTA-MySQL}}
	Returns the value generated for an AUTO_INCREMENT field in the last query.		Returns the value generated for an AUTO_INCREMENT field in the last query.

Ryden: New page: NOTOC Returns the value generated for an AUTO_INCREMENT field in the last query. For more information about when is this value updated visit http://dev.mysql.com/doc/refman/5.0/en/mys...

2008-01-13T18:00:23Z

New page: __NOTOC__ Returns the value generated for an AUTO_INCREMENT field in the last query. For more information about when is this value updated visit http://dev.mysql.com/doc/refman/5.0/en/mys...

New page

__NOTOC__
Returns the value generated for an AUTO_INCREMENT field in the last query.

For more information about when is this value updated visit http://dev.mysql.com/doc/refman/5.0/en/mysql-insert-id.html

==Syntax==
<syntaxhighlight lang="lua">
int mysql_insert_id ( MySQLConnection handler )
</syntaxhighlight>
===Required arguments===
* '''handler:''' A valid MySQL link

===Returns===
The value generated for an AUTO_INCREMENT field in the last query.

==Example==
'''Example 1:''' This example creates an account for a player when they use /register, and tells them their database id.
<syntaxhighlight lang="lua">
function RegisterPlayer(playerSource, commandName, _password)
local name = mysql_escape_string(handler, getPlayerName(playerSource)) -- Escape the strings to avoid SQL-Injection
local password = mysql_escape_string(handler, _password)
local query = "INSERT INTO account SET name='" .. name .. "', password=MD5('" .. password .. "')"

if (mysql_query(handler, query)) then
outputChatBox("Account created successfuly with id #" .. mysql_insert_id(handler), playerSource)
else
outputChatBox("An error has occured when trying to create your account.", playerSource)
end
end

addCommandHandler("register", RegisterPlayer)
</syntaxhighlight>

==See also==
{{Modules/MTA-MySQL/Handler_functions}}

Modules/MTA-MySQL/mysql insert id - Revision history

Alberto Alonso at 17:44, 5 January 2011

Ryden at 18:01, 14 January 2008

Ryden: New page: __NOTOC__ Returns the value generated for an AUTO_INCREMENT field in the last query. For more information about when is this value updated visit http://dev.mysql.com/doc/refman/5.0/en/mys...

Ryden: New page: NOTOC Returns the value generated for an AUTO_INCREMENT field in the last query. For more information about when is this value updated visit http://dev.mysql.com/doc/refman/5.0/en/mys...