ExecuteSQLSelect - Revision history

AlexTMjugador: Changed "DeprecatedWithAlt" template to "Deprecated"

2015-02-13T16:20:59Z

Changed "DeprecatedWithAlt" template to "Deprecated"

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

	This function retrieves rows from a table in the database, if they exist. If you pass the table name, along with the columns you want to retrieve (and any conditions for the row) this function will return a table containing the corresponding values.		This function retrieves rows from a table in the database, if they exist. If you pass the table name, along with the columns you want to retrieve (and any conditions for the row) this function will return a table containing the corresponding values.

2012-07-20T21:21:40Z

← Older revision		Revision as of 21:21, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
			{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent SELECT usage}}
	This function retrieves rows from a table in the database, if they exist. If you pass the table name, along with the columns you want to retrieve (and any conditions for the row) this function will return a table containing the corresponding values.		This function retrieves rows from a table in the database, if they exist. If you pass the table name, along with the columns you want to retrieve (and any conditions for the row) this function will return a table containing the corresponding values.

2012-07-15T19:33:23Z

fixed a typo

← Older revision		Revision as of 19:33, 15 July 2012
Line 16:		Line 16:
	===Required Arguments===		===Required Arguments===
	*'''tableName:''' The table you want to query. No spaces allowed.		*'''tableName:''' The table you want to query. No spaces allowed.
	'''fields:''' The fields you want to query. No ~~spaced~~ allowed. Multiple fields should be separated by a comma (,). Wildcard () allowed to query all fields in the table. If you use wildcards, please pay attention to the order in which you'll have to retrieve your values from the table.		'''fields:''' The fields you want to query. No spaces allowed. Multiple fields should be separated by a comma (,). Wildcard () allowed to query all fields in the table. If you use wildcards, please pay attention to the order in which you'll have to retrieve your values from the table.

	===Optional Arguments===		===Optional Arguments===

2010-07-10T09:15:50Z

2010-06-23T19:57:18Z

← Older revision		Revision as of 19:57, 23 June 2010
Line 11:		Line 11:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	table executeSQLSelect ( string tableName, string fields, [ string conditions ], [ int limit ] )		table executeSQLSelect ( string tableName, string fields, [ string conditions, int limit ] )
	</syntaxhighlight>		</syntaxhighlight>

2009-09-02T19:02:09Z

Example

← Older revision		Revision as of 19:02, 2 September 2009
Line 41:		Line 41:
	-- try to retrieve the player data from the db		-- try to retrieve the player data from the db
	result = executeSQLSelect ( "players", "player", "player = '" .. sourcename .. "'" )		result = executeSQLSelect ( "players", "player", "player = '" .. sourcename .. "'" )
	if ( type( result ) == "table" and #~~table~~ == 0 ) or not result then -- see if any data was found at all		if ( type( result ) == "table" and #result == 0 ) or not result then -- see if any data was found at all
	outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source )		outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source )
	executeSQLInsert ( "players", "'none', 'none', '" .. sourcename .. "'" )		executeSQLInsert ( "players", "'none', 'none', '" .. sourcename .. "'" )

2009-09-02T19:00:13Z

← Older revision		Revision as of 19:00, 2 September 2009
Line 23:		Line 23:

	===Returns===		===Returns===
	~~On success: the~~ 2-dimensional table where the results are stored as table [row_index] [column_name].		Returns a 2-dimensional table where the results are stored as table [row_index] [column_name]. Please note that table may be empty.

	~~On failure: ''false''~~.

			If invalid arguments were passed, returns ''false''.

	==Example==		==Example==
Line 42:		Line 41:
	-- try to retrieve the player data from the db		-- try to retrieve the player data from the db
	result = executeSQLSelect ( "players", "player", "player = '" .. sourcename .. "'" )		result = executeSQLSelect ( "players", "player", "player = '" .. sourcename .. "'" )
	if ( result == ~~false~~ ) then -- see if any data was found at all		if ( type( result ) == "table" and #table == 0 ) or not result then -- see if any data was found at all
	outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source )		outputChatBox ( "This is your first time here! Welcome " .. sourcename .. "!", source )
	executeSQLInsert ( "players", "'none', 'none', '" .. sourcename .. "'" )		executeSQLInsert ( "players", "'none', 'none', '" .. sourcename .. "'" )

2009-08-27T12:20:45Z

Example

← Older revision		Revision as of 12:20, 27 August 2009
Line 38:		Line 38:

	function addInfoToSQL( theSpawnpoint, theTeam )		function addInfoToSQL( theSpawnpoint, theTeam )
	sourcename = ~~getClientName~~ ( source ) -- get the player's name		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

2009-08-24T11:03:17Z

Two variants of using this.

← Older revision		Revision as of 11:03, 24 August 2009
Line 54:		Line 54:
	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].clothes_head_texture )		outputChatBox ( "Your head texture is " .. result[1].clothes_head_texture )
	outputChatBox ( "Your head model is " .. result[1].clothes_head_model )		outputChatBox ( "Your head model is " .. result[1]['clothes_head_model'] )
	end		end
	addEventHandler ( "onPlayerSpawn", getRootElement(), addInfoToSQL )		addEventHandler ( "onPlayerSpawn", getRootElement(), addInfoToSQL )

2009-08-23T11:42:34Z

← Older revision		Revision as of 11:42, 23 August 2009
Line 23:		Line 23:

	===Returns===		===Returns===
	On success: the 2-dimensional table where the results are stored as table [row_index] [~~column_index~~]~~. In DP2 and earlier, if the query returns no data, the return value is ''false'' instead~~.		On success: the 2-dimensional table where the results are stored as table [row_index] [column_name].

	On failure: ''false''.		On failure: ''false''.
Line 53:		Line 53:
	-- 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 )