Modules/MySQL/MysqlOpen - Revision history

Sebassje at 20:45, 29 September 2009

2009-09-29T20:45:40Z

← Older revision		Revision as of 20:45, 29 September 2009
Line 5:		Line 5:

	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">bool mysqlOpen ( string callback_function, string host, string user, string password, string database_name, int port )</syntaxhighlight>		<syntaxhighlight lang="lua">bool mysqlOpen ( mysql mysqlobj, string callback_function, string host, string user, string password, string database_name, int port )</syntaxhighlight>

	===Required Arguments===		===Required Arguments===
	*'''~~mysql~~''' : mysql object (requires an established connection)		*'''mysqlobj''' : mysql object (requires an established connection)
	*'''callback_function''' : The function that is called if the operation is done (see below)		*'''callback_function''' : The function that is called if the operation is done (see below)
	*'''host''' : The database server hostname or IP address to use		*'''host''' : The database server hostname or IP address to use

IJs at 21:50, 29 January 2007

2007-01-29T21:50:53Z

← Older revision		Revision as of 21:50, 29 January 2007
Line 8:		Line 8:

	===Required Arguments===		===Required Arguments===
	*'''callback_function''' : The function that is called if the operation is done (~~please~~ see below)		*'''mysql''' : mysql object (requires an established connection)
			*'''callback_function''' : The function that is called if the operation is done (see below)
	*'''host''' : The database server hostname or IP address to use		*'''host''' : The database server hostname or IP address to use
	*'''user''' : The database username to use		*'''user''' : The database username to use
Line 17:		Line 18:
	===Callback Arguments===		===Callback Arguments===
	Your callback function has to accept the following arguments:		Your callback function has to accept the following arguments:
	*'''mysql''' mysql : Returns the mysql object
	*'''bool''' result : Returns false on error, true on success		*'''bool''' result : Returns false on error, true on success

Line 26:		Line 26:
	==Example==		==Example==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	function onMySQLOpen ( ~~mysql,~~ result )		function onMySQLOpen ( result )
	if ( result ) then		if ( result ) then
	outputServerLog ( "~~CONNECTED~~" )		outputServerLog ( "MySQL connection established." )
	else		else
	outputServerLog ( "~~DIDNT WORK~~" )		outputServerLog ( "MySQL connection failed." )
	end		end
	end		end

	function mysqltest ()		function mysqltest ()
	mysqlOpen ( "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )		db = mysqlCreate ()
			mysqlOpen ( db, "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )
	end		end
	</syntaxhighlight>		</syntaxhighlight>

EAi at 13:25, 1 November 2006

2006-11-01T13:25:25Z

← Older revision		Revision as of 13:25, 1 November 2006
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{ModuleFunction\|MySQL}}

	This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can read/write to the database by using the [[mysqlQuery]] function.		This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can read/write to the database by using the [[mysqlQuery]] function.

	~~This function is provided by the [[Module functions\|ml_mysql]] module.~~

	==Syntax==		==Syntax==

EAi: MysqlOpen moved to Modules/MySQL/MysqlOpen

2006-11-01T13:12:57Z

MysqlOpen moved to Modules/MySQL/MysqlOpen

← Older revision

Revision as of 13:12, 1 November 2006

EAi at 13:11, 1 November 2006

2006-11-01T13:11:11Z

← Older revision		Revision as of 13:11, 1 November 2006
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	~~==Description==~~
	This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can read/write to the database by using the [[mysqlQuery]] function.		This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can read/write to the database by using the [[mysqlQuery]] function.

IJs: /* Callback Arguments */

2006-11-01T01:26:56Z

Callback Arguments

← Older revision		Revision as of 01:26, 1 November 2006
Line 18:		Line 18:
	===Callback Arguments===		===Callback Arguments===
	Your callback function has to accept the following arguments:		Your callback function has to accept the following arguments:
	*'''[[mysql]]''' mysql : Returns the mysql object		*'''mysql''' mysql : Returns the mysql object
	*'''bool''' result : Returns false on error, true on success		*'''bool''' result : Returns false on error, true on success

IJs at 01:26, 1 November 2006

2006-11-01T01:26:24Z

← Older revision		Revision as of 01:26, 1 November 2006
Line 6:		Line 6:

	==Syntax==		==Syntax==
	bool mysqlOpen ( string callback_function, string host, string user, string password, string database_name, int port )		<syntaxhighlight lang="lua">bool mysqlOpen ( string callback_function, string host, string user, string password, string database_name, int port )</syntaxhighlight>

	===Required Arguments===		===Required Arguments===

IJs at 01:22, 1 November 2006

2006-11-01T01:22:00Z

← Older revision		Revision as of 01:22, 1 November 2006
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	==Description==		==Description==
	This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can ~~(hopefully)~~ read/write to the database by using the [[mysqlQuery]] function.		This function opens a MySQL connection to a specific database on a database server. As soon as a connection is made (or timed out), the callback_function you passed as parameter is called and you can read/write to the database by using the [[mysqlQuery]] function.

	This function is provided by the ~~'''~~ml_mysql~~'''~~ module.		This function is provided by the [[Module functions\|ml_mysql]] module.

	==Syntax==		==Syntax==
Line 26:		Line 26:

	==Example==		==Example==
	function onMySQLOpen ( mysql, result )		<syntaxhighlight lang="lua">
	if ( result )		function onMySQLOpen ( mysql, result )
	~~-- connection succeeded. switch some global boolean or do a query~~		if ( result ) then
	else		outputServerLog ( "CONNECTED" )
	~~-- panic.~~		else
	end		outputServerLog ( "DIDNT WORK" )
	end		end
	~~<...>~~		end
	[[mysqlOpen]] ( "onMySQLOpen", "localhost", "~~user123~~", "~~mypassword~~", "~~testdatabase~~", 3306 );
			function mysqltest ()
			mysqlOpen ( "onMySQLOpen", "localhost", "bastage", "bastage_pw", "test", 3306 )
			end
			</syntaxhighlight>

IJs at 11:51, 22 April 2006

2006-04-22T11:51:32Z

← Older revision		Revision as of 11:51, 22 April 2006
Line 18:		Line 18:
	===Callback Arguments===		===Callback Arguments===
	Your callback function has to accept the following arguments:		Your callback function has to accept the following arguments:
			*'''[[mysql]]''' mysql : Returns the mysql object
	*'''bool''' result : Returns false on error, true on success		*'''bool''' result : Returns false on error, true on success

Line 25:		Line 26:

	==Example==		==Example==
	function onMySQLOpen ( result )		function onMySQLOpen ( mysql, result )
	if ( result )		if ( result )
	-- connection succeeded. switch some global boolean		-- connection succeeded. switch some global boolean or do a query
	else		else
	-- panic.		-- panic.

IJs: /* Example */

2006-04-22T02:45:40Z

Example

← Older revision		Revision as of 02:45, 22 April 2006
Line 33:		Line 33:
	end		end
	<...>		<...>
	[[mysqlOpen]] ( onMySQLOpen, "localhost", "user123", "mypassword", "testdatabase", 3306 );		[[mysqlOpen]] ( "onMySQLOpen", "localhost", "user123", "mypassword", "testdatabase", 3306 );