ExecuteSQLInsert - Revision history

AlexTMjugador: Changed "DeprecatedWithAlt" template to "Deprecated"

2015-02-13T16:24:14Z

Changed "DeprecatedWithAlt" template to "Deprecated"

← Older revision		Revision as of 16:24, 13 February 2015
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	{{~~DeprecatedWithAlt~~\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent INSERT usage}}		{{Deprecated\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent INSERT usage.}}

	This function adds a row in the database.		This function adds a row in the database.

Ccw at 21:20, 20 July 2012

2012-07-20T21:20:09Z

← Older revision		Revision as of 21:20, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
			{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent INSERT usage}}
	This function adds a row in the database.		This function adds a row in the database.

The Ex: /* Example */

2010-08-09T19:47:23Z

Example

← Older revision		Revision as of 19:47, 9 August 2010
Line 49:		Line 49:
	-- get the clothes data for the player		-- get the clothes data for the player
	result = executeSQLSelect ( "players", "clothes_head_texture, clothes_head_model", "player = '" .. sourcename .. "'" )		result = executeSQLSelect ( "players", "clothes_head_texture, clothes_head_model", "player = '" .. sourcename .. "'" )
	outputChatBox ( "Your head texture is " .. result[1]~~[1]~~ )		outputChatBox ( "Your head texture is " .. result[1].clothes_head_texture )
	outputChatBox ( "Your head model is " .. result[1][2] )		outputChatBox ( "Your head model is " .. result[1]['clothes_head_model'] )
	end		end
	addEventHandler ( "onPlayerSpawn", getRootElement(), addInfoToSQL)		addEventHandler ( "onPlayerSpawn", getRootElement(), addInfoToSQL)

Awwu: /* Example */

2009-08-27T12:24:42Z

Example

← Older revision		Revision as of 12:24, 27 August 2009
Line 34:		Line 34:

	function addInfoToSQL( theSpawnpoint, theTeam )		function addInfoToSQL( theSpawnpoint, theTeam )
	local sourcename = ~~getClientName~~ ( source ) -- get the player's name		local sourcename = getPlayerName ( source ) -- get the player's name

	-- try to retrieve the player data from the db		-- try to retrieve the player data from the db

Talidan: /* Example */

2007-08-26T14:55:06Z

Example

← Older revision		Revision as of 14:55, 26 August 2007
Line 25:		Line 25:

	==Example==		==Example==
	This example creates a SQL table when a map loads, and stores info about ~~the~~ player to that database.		This example creates a SQL table when a map loads, and stores info about a player to that database when he spawns.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	function onMapLoad ()		function onMapLoad ()

Talidan at 14:53, 26 August 2007

2007-08-26T14:53:58Z

← Older revision		Revision as of 14:53, 26 August 2007
Line 25:		Line 25:

	==Example==		==Example==
			This example creates a SQL table when a map loads, and stores info about the player to that database.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	function onMapLoad ()		function onMapLoad ()
Line 32:		Line 33:
	addEventHandler ( "onGamemodeMapStart", getRootElement(), onMapLoad )		addEventHandler ( "onGamemodeMapStart", getRootElement(), onMapLoad )

	function ~~onPlayerSpawn~~ ( theSpawnpoint, theTeam )		function addInfoToSQL( theSpawnpoint, theTeam )
	local sourcename = getClientName ( source ) -- get the player's name		local sourcename = getClientName ( source ) -- get the player's name

Line 51:		Line 52:
	outputChatBox ( "Your head model is " .. result[1][2] )		outputChatBox ( "Your head model is " .. result[1][2] )
	end		end
	addEventHandler ( "onPlayerSpawn", getRootElement(), ~~onPlayerSpawn~~ )		addEventHandler ( "onPlayerSpawn", getRootElement(), addInfoToSQL)
	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}

Arc at 12:34, 21 August 2007

2007-08-21T12:34:15Z

← Older revision		Revision as of 12:34, 21 August 2007
Line 30:		Line 30:
	executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )		executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
	end		end
	addEventHandler ( "onGamemodeMapStart", onMapLoad )		addEventHandler ( "onGamemodeMapStart", getRootElement(), onMapLoad )

	function onPlayerSpawn ( theSpawnpoint, theTeam )		function onPlayerSpawn ( theSpawnpoint, theTeam )
Line 51:		Line 51:
	outputChatBox ( "Your head model is " .. result[1][2] )		outputChatBox ( "Your head model is " .. result[1][2] )
	end		end
	addEventHandler ( "onPlayerSpawn", onPlayerSpawn )		addEventHandler ( "onPlayerSpawn", getRootElement(), onPlayerSpawn )
	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}

Arc at 12:29, 21 August 2007

2007-08-21T12:29:51Z

← Older revision		Revision as of 12:29, 21 August 2007
Line 11:		Line 11:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool executeSQLInsert ( string ~~table~~, string values, ( [string columns] ) )		bool executeSQLInsert ( string tableName, string values, ( [string columns] ) )
	</syntaxhighlight>		</syntaxhighlight>

	===Required Arguments===		===Required Arguments===
	*'''~~table~~:''' The name of the table you want to modify.		*'''tableName:''' The name of the table you want to modify.
	*'''values:''' The values that need to be inserted for each field in the table. The ' character is used to specify a value and , is used as a delimiter for multiple values (e.g. '' 'value1','value2','value3' ''. The value order corresponds to either the default column order in the table, or the optional column argument (see below).		*'''values:''' The values that need to be inserted for each field in the table. The ' character is used to specify a value and , is used as a delimiter for multiple values (e.g. '' 'value1','value2','value3' ''. The value order corresponds to either the default column order in the table, or the optional column argument (see below).

Line 22:		Line 22:

	===Returns===		===Returns===
	The function returns ~~a ''boolean'' which is~~ ''true'' on success, and ''false'' on failure.		The function returns ''true'' on success, and ''false'' on failure.

	==Example==		==Example==
Line 30:		Line 30:
	executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )		executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
	end		end
			addEventHandler ( "onGamemodeMapStart", onMapLoad )

	function onPlayerSpawn ( ~~spawnpoint~~, ~~team~~ )		function onPlayerSpawn ( theSpawnpoint, theTeam )
	sourcename = getClientName ( source ) -- get the player's name		local sourcename = getClientName ( source ) -- get the player's name

	-- try to retrieve the player data from the db		-- try to retrieve the player data from the db
Line 46:		Line 47:

	-- get the clothes data for the player		-- get the clothes data for the player
	result = executeSQLSelect ( "players", "clothes_head_texture, clothes_head_model", "player = '" .. sourcename .. "'" )		result = executeSQLSelect ( "players", "clothes_head_texture, clothes_head_model", "player = '" .. sourcename .. "'" )
	outputChatBox ( "Your head texture is " .. result[1][1] )		outputChatBox ( "Your head texture is " .. result[1][1] )
	outputChatBox ( "Your head model is " .. result[1][2] )		outputChatBox ( "Your head model is " .. result[1][2] )
	end		end
			addEventHandler ( "onPlayerSpawn", onPlayerSpawn )
	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}

Erorr404 at 01:45, 5 August 2007

2007-08-05T01:45:50Z

← Older revision		Revision as of 01:45, 5 August 2007
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{Server function}}
	This function adds a row in the database.		This function adds a row in the database.

AlienX: /* Syntax */

2007-07-17T13:29:08Z

Syntax

← Older revision		Revision as of 13:29, 17 July 2007
Line 10:		Line 10:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool executeSQLInsert ( string table, string values, [string columns] )		bool executeSQLInsert ( string table, string values, ( [string columns] ) )
	</syntaxhighlight>		</syntaxhighlight>

Line 22:		Line 22:
	===Returns===		===Returns===
	The function returns a ''boolean'' which is ''true'' on success, and ''false'' on failure.		The function returns a ''boolean'' which is ''true'' on success, and ''false'' on failure.


	==Example==		==Example==