Database - Revision history

FileEX at 10:54, 13 July 2024

2024-07-13T10:54:07Z

← Older revision		Revision as of 10:54, 13 July 2024
Line 7:		Line 7:
	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

			[[Category:Scripting Concepts]]

EOFIK: Форматирование

2021-04-11T17:02:14Z

Форматирование

← Older revision		Revision as of 17:02, 11 April 2021
Line 2:		Line 2:
	==Files==		==Files==
	There are two main database files for storing data:		There are two main database files for storing data:
	*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.		*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions).
	*'''registry.db:''' this is the main database file, the scripting function [[executeSQLQuery]] work with this file.		*'''registry.db:''' this is the main database file, the scripting function [[executeSQLQuery]] work with this file.

	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

Danilo: updated old information containing executeSQL* functions which is deprecated

2020-07-04T00:58:24Z

updated old information containing executeSQL* functions which is deprecated

← Older revision		Revision as of 00:58, 4 July 2020
Line 3:		Line 3:
	There are two main database files for storing data:		There are two main database files for storing data:
	*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.		*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.
	'''registry.db:''' this is the main database file, ~~all~~ the executeSQL scripting ~~functions~~ work with this file.		*'''registry.db:''' this is the main database file, the scripting function [[executeSQLQuery]] work with this file.

	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

Myonlake at 21:08, 1 August 2019

2019-08-01T21:08:23Z

← Older revision		Revision as of 21:08, 1 August 2019
Line 2:		Line 2:
	==Files==		==Files==
	There are two main database files for storing data:		There are two main database files for storing data:
	*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.		*'''internal.db:''' this contains user account data (usernames, hashed passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.
	'''registry.db:''' this is the main database file, all the executeSQL scripting functions work with this file.		'''registry.db:''' this is the main database file, all the executeSQL scripting functions work with this file.

	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

Citizen: Fixed typo

2017-07-09T17:12:49Z

Fixed typo

← Older revision		Revision as of 17:12, 9 July 2017
Line 3:		Line 3:
	There are two main database files for storing data:		There are two main database files for storing data:
	*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.		*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.
	'''registry.db:''' this is the main database file, all the executeSQL ~~scrtipting~~ functions work with this file.		'''registry.db:''' this is the main database file, all the executeSQL scripting functions work with this file.

	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

Arran Fortuna: Typo

2012-05-26T18:09:27Z

Typo

← Older revision		Revision as of 18:09, 26 May 2012
Line 3:		Line 3:
	There are two main database files for storing data:		There are two main database files for storing data:
	*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.		*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.
	'''~~regystry~~.db:''' this is the main database file, all the executeSQL scrtipting functions work with this file.		'''registry.db:''' this is the main database file, all the executeSQL scrtipting functions work with this file.
	==Functions==		==Functions==
	{{SQL_functions}}		{{SQL_functions}}

Kzman: Page about db files created. Please expand it

2012-05-24T03:04:28Z

Page about db files created. Please expand it

New page

MTA uses a database system based on files. This system is sqlite, an embedded relational database management system.
==Files==
There are two main database files for storing data:
*'''internal.db:''' this contains user account data (usernames, passwords and account data stored by using the [[setAccountData]] and [[getAccountData]] functions.
*'''regystry.db:''' this is the main database file, all the executeSQL* scrtipting functions work with this file.
==Functions==
{{SQL_functions}}