ExecuteSQLDropTable - Revision history

ThePiotrek at 22:08, 1 October 2016

2016-10-01T22:08:29Z

← Older revision		Revision as of 22:08, 1 October 2016
Line 7:		Line 7:
	The executed SQL query is the following:		The executed SQL query is the following:

	<syntaxhighlight ~~lang="lua"~~>~~[sql]~~DROP TABLE <table></syntaxhighlight>		<syntaxhighlight>DROP TABLE table</syntaxhighlight>

	==Syntax==		==Syntax==

2015-02-13T16:24:12Z

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 DROP TABLE usage}}		{{Deprecated\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DROP TABLE usage.}}

	This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.		This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.

2012-07-20T21:22:03Z

← Older revision		Revision as of 21:22, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{Server function}}
	{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DROP TABLE usage}}		{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DROP TABLE usage}}
	~~{{Server function}}~~
	This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.		This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.

2012-07-20T21:21:38Z

← Older revision		Revision as of 21:21, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent DROP TABLE usage}}
	{{Server function}}		{{Server function}}
	This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.		This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.

2010-08-08T13:22:23Z

← Older revision		Revision as of 13:22, 8 August 2010
Line 19:		Line 19:

	===Example===		===Example===
	This ~~page does not currently have~~ an ~~example~~		This example lets you drop an SQL table with the command: dropsqltable. Note: This command should be restricted to admins if you use it.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	--~~enter~~ an ~~example here~~		function removeSQLTable(thePlayer, command, SQLtable)
			if (SQLtable) then -- Make sure the player entered an argument.
			success = executeSQLDropTable(SQLtable) -- Drop the table
			if (success) then -- If executeSQLDropTable returns true, it passes this if check to display a confirmation message
			outputChatBox("SQL Table "..SQLtable.." successfully dropped.", thePlayer, 0, 255, 0)
			else
			outputChatBox("SQL Table "..SQLtable.." was not successfully dropped.", thePlayer, 255, 0, 0)
			end
			end
			end
			addCommandHandler("dropsqltable", removeSQLTable)
	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}
	~~[[Category:Needs_Example]]~~

2010-02-26T18:51:37Z

← Older revision		Revision as of 18:51, 26 February 2010
Line 5:		Line 5:
	The executed SQL query is the following:		The executed SQL query is the following:

	<syntaxhighlight lang="lua">[sql]DROP TABLE ~~IF EXISTS~~ <table></syntaxhighlight>		<syntaxhighlight lang="lua">[sql]DROP TABLE <table></syntaxhighlight>

	==Syntax==		==Syntax==

2007-08-26T15:36:07Z

2007-08-26T14:52:26Z

← Older revision		Revision as of 14:52, 26 August 2007
Line 17:		Line 17:
	===Returns===		===Returns===
	The function returns ''true'' on success, and ''false'' on failure.		The function returns ''true'' on success, and ''false'' on failure.

			===Example===
			This page does not currently have an example
			<syntaxhighlight lang="lua">
			--enter an example here
			</syntaxhighlight>

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

2007-08-21T12:26:15Z

← Older revision		Revision as of 12:26, 21 August 2007
Line 9:		Line 9:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool executeSQLDropTable ( string ~~table~~ )		bool executeSQLDropTable ( string tableName )
	</syntaxhighlight>		</syntaxhighlight>

	===Required Arguments===		===Required Arguments===
	*'''~~table~~:''' The name of the table you want to drop.		*'''tableName:''' The name of the table you want to drop.

	===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.

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

2007-08-05T01:46:45Z

← Older revision		Revision as of 01:46, 5 August 2007
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{Server function}}
	This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.		This function drops a table in the registry. This function doesn't do anything when the table doesn't exist.