DbConnect - Revision history

Flox: /* Example */

2026-04-02T03:23:30Z

Example

← Older revision		Revision as of 03:23, 2 April 2026
Line 281:		Line 281:
	string tableName,		string tableName,
	string query,		string query,
	~~аргументы через запятую~~		arguments separated by commas
	}		}

Flox: /* Example */

2026-04-02T03:22:54Z

Example

← Older revision		Revision as of 03:22, 2 April 2026
Line 146:		Line 146:

	exports.nameres:dbExec("test", "INSERT INTO ?? (`ID`, `test`) VALUES (?, ?);", '1', '1')		exports.nameres:dbExec("test", "INSERT INTO ?? (`ID`, `test`) VALUES (?, ?);", '1', '1')

			function onPlayerQuit()
			exports.nameres:dbQueryAsync("onPlayerQuitCallback", {}, "test", "SELECT ID FROM ?? WHERE owner = ?", getAccountName(getPlayerAccount(source)))
			end
			function onPlayerQuitCallback(result, args)
			for _, row in ipairs(result) do
			destroyVehicle(vehiclesByID[row.ID])
			end
			end
			addEventHandler("onPlayerQuit", root, onPlayerQuit)

			addEvent("dbCallback", false)
			addEventHandler("dbCallback", resourceRoot, function(queryResult, callbackFunctionName, callbackArguments)
			_G[callbackFunctionName](queryResult, callbackArguments)
			end)
	]]		]]

Flox: /* Example */

2026-04-02T03:20:09Z

Example

← Older revision		Revision as of 03:20, 2 April 2026
Line 129:		Line 129:

	```meta.xml```		```meta.xml```
	[[
	<export function="dbQueryAsync" type="server" />		<export function="dbQueryAsync" type="server" />
	<export function="dbQuery" type="server" />		<export function="dbQuery" type="server" />
Line 136:		Line 135:
	<export function="dbPrepareString" type="server" />		<export function="dbPrepareString" type="server" />
	<export function="dbQueryAsyncMultiple" type="server" />		<export function="dbQueryAsyncMultiple" type="server" />

			```meta.xml end```
	]]		]]
	~~```meta.xml end```~~		--[[

	example exported: =		example exported: =
	exports.nameres:dbQuery(-1, "test", "SELECT ID FROM ?? WHERE ID = ?", 1)		exports.nameres:dbQuery(-1, "test", "SELECT ID FROM ?? WHERE ID = ?", 1)

Flox: /* Example */

2026-04-02T03:19:27Z

Example

@@ Line 126: / Line 126: @@
 The following example illustrates an exemplary approach to utilizing a common resource for database operations, employing exported functions such as '''dbQuery''', '''dbExec''', '''dbQueryAsync''', '''dbPrepareString''', and '''dbQueryAsyncMultiple.''':
 <syntaxhighlight lang="lua">
 host = "IPHost" --"127.0.0.1" -- "localhost"
 --unix_socket = "/var/run/mysqld/mysqld.sock"

Flox: /* Example */

2026-04-02T03:12:02Z

Example

Show changes

Gallardo9956 at 10:23, 25 January 2025

2025-01-25T10:23:43Z

← Older revision		Revision as of 10:23, 25 January 2025
Line 23:		Line 23:
	*** '''dbname''': Name of the database to use e.g. ''dbname=test''		*** '''dbname''': Name of the database to use e.g. ''dbname=test''
	*** '''host''': Host address e.g. ''host=127.0.0.1''		*** '''host''': Host address e.g. ''host=127.0.0.1''
	*** '''port''': Host port e.g. ''port=~~1234~~'' (optional, defaults to standard MySQL port if not used)		*** '''port''': Host port e.g. ''port=3306'' (optional, defaults to standard MySQL port if not used)
	*** '''unix_socket''': Unix socket or named pipe to use (optional)		*** '''unix_socket''': Unix socket or named pipe to use (optional)
	***'''charset''': Communicate with the server using a character which is different from the default e.g. ''charset<nowiki>=</nowiki>utf8'' (optional)		***'''charset''': Communicate with the server using a character which is different from the default e.g. ''charset<nowiki>=</nowiki>utf8'' (optional)

Xenius at 11:21, 13 January 2025

2025-01-13T11:21:15Z

← Older revision		Revision as of 11:21, 13 January 2025
Line 3:		Line 3:
	This function opens a connection to a database and returns an element that can be used with [[dbQuery]]. To disconnect use [[destroyElement]].		This function opens a connection to a database and returns an element that can be used with [[dbQuery]]. To disconnect use [[destroyElement]].
	{{Note\|Connecting and disconnecting many times can have a performance impact on the server. For optimal performance it is recommended that you use dbConnect only once when the resource starts, and share the connection element with the whole script.}}		{{Note\|Connecting and disconnecting many times can have a performance impact on the server. For optimal performance it is recommended that you use dbConnect only once when the resource starts, and share the connection element with the whole script.}}
	{{Note\|In MySQL 8 and later, you can choose between '''`caching_sha2_password`''', '''`sha256_password`''', or '''`mysql_native_password`''' for password management.		{{Note\|In MySQL 8.0 and later, you can choose between '''`caching_sha2_password`''', '''`sha256_password`''', or '''`mysql_native_password`''' for password management.
	* If you opt for '''`caching_sha2_password`''' or '''`sha256_password`''', ~~ensure that~~ SSL is ~~enabled~~ for secure authentication.		* If you opt for '''`caching_sha2_password`''' or '''`sha256_password`''', SSL is not mandatory but recommended for secure authentication.
	* If you choose '''`mysql_native_password`''', you can set it as the default authentication plugin:		* If you choose '''`mysql_native_password`''', you can set it as the default authentication plugin:
	** In the '''`mysqld.cnf`''' configuration file, by adding or modifying the following line: '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>'''		** In the '''`mysqld.cnf`''' configuration file, by adding or modifying the following line: '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>'''
	** Using SQL queries (e.g., ALTER USER).		** Using SQL queries (e.g., ALTER USER).
	** In PHPMyAdmin (via the user settings page).		** In PHPMyAdmin (via the user settings page).
	Please note that starting with MySQL 9, '''`mysql_native_password`''' will no longer be available, and only '''`caching_sha2_password`''' and '''`sha256_password`''' will be supported.		Please note that starting with MySQL 9.0, '''`mysql_native_password`''' will no longer be available, and only '''`caching_sha2_password`''' and '''`sha256_password`''' will be supported.
	}}		}}
	==Syntax==		==Syntax==

Xenius at 11:16, 13 January 2025

2025-01-13T11:16:29Z

← Older revision		Revision as of 11:16, 13 January 2025
Line 7:		Line 7:
	* If you choose '''`mysql_native_password`''', you can set it as the default authentication plugin:		* If you choose '''`mysql_native_password`''', you can set it as the default authentication plugin:
	** In the '''`mysqld.cnf`''' configuration file, by adding or modifying the following line: '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>'''		** In the '''`mysqld.cnf`''' configuration file, by adding or modifying the following line: '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>'''
	** Using SQL queries.		** Using SQL queries (e.g., ALTER USER).
	** In PHPMyAdmin.		** In PHPMyAdmin (via the user settings page).
	Please note that starting with MySQL 9, '''`mysql_native_password`''' will no longer be available, and only '''`caching_sha2_password`''' and '''`sha256_password`''' will be supported.		Please note that starting with MySQL 9, '''`mysql_native_password`''' will no longer be available, and only '''`caching_sha2_password`''' and '''`sha256_password`''' will be supported.
	}}		}}

Xenius: Update password management note

2025-01-13T10:58:53Z

Update password management note

← Older revision		Revision as of 10:58, 13 January 2025
Line 3:		Line 3:
	This function opens a connection to a database and returns an element that can be used with [[dbQuery]]. To disconnect use [[destroyElement]].		This function opens a connection to a database and returns an element that can be used with [[dbQuery]]. To disconnect use [[destroyElement]].
	{{Note\|Connecting and disconnecting many times can have a performance impact on the server. For optimal performance it is recommended that you use dbConnect only once when the resource starts, and share the connection element with the whole script.}}		{{Note\|Connecting and disconnecting many times can have a performance impact on the server. For optimal performance it is recommended that you use dbConnect only once when the resource starts, and share the connection element with the whole script.}}
	{{Note\|If you ~~use MySQL 8~~ or ~~newer~~, you ~~should add this line to~~ mysqld.cnf '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>''' ~~in the case where you're unable to authenticate~~ with ~~your~~ MySQL ~~server~~.}}		{{Note\|In MySQL 8 and later, you can choose between '''`caching_sha2_password`''', '''`sha256_password`''', or '''`mysql_native_password`''' for password management.
			* If you opt for '''`caching_sha2_password`''' or '''`sha256_password`''', ensure that SSL is enabled for secure authentication.
			* If you choose '''`mysql_native_password`''', you can set it as the default authentication plugin:
			** In the '''`mysqld.cnf`''' configuration file, by adding or modifying the following line: '''<nowiki>default-authentication-plugin=mysql_native_password</nowiki>'''
			** Using SQL queries.
			** In PHPMyAdmin.
			Please note that starting with MySQL 9, '''`mysql_native_password`''' will no longer be available, and only '''`caching_sha2_password`''' and '''`sha256_password`''' will be supported.
			}}
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">

Fernando187: Remove obsolete Requirements section

2024-11-07T15:34:41Z

Remove obsolete Requirements section

← Older revision		Revision as of 15:34, 7 November 2024
Line 116:		Line 116:
	end		end
	</syntaxhighlight>		</syntaxhighlight>

	~~==Requirements==~~
	~~{{Requirements\|1.1.1-9.03328\|n/a}}~~

	==Changelog==		==Changelog==
	{{ChangelogHeader}}		{{ChangelogHeader}}