Sirius: Added languagemenue

2010-11-26T20:44:42Z

Added languagemenue

MrSugarCube: Created page with 'FORCETOC Using the DB object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in...'

2009-06-07T14:51:49Z

Created page with '__FORCETOC__ Using the DB object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in...'

New page

__FORCETOC__
Using the [[DB]] object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in SphereServer:

'''Note:''' Before the DB object can be used, MySQL must be enabled along with the database host details, in Sphere.ini.

==Properties and Functions==
Here is a list of all database properties and functions. If a function is marked as readable then it can return a value when used as <KEY>. Click on the name for more detailed information such as usage and examples. If an attempt is made to access a property that does not exist on the item, the property from the [[ITEMDEF]] will be accessed instead.

{| border="1" cellspacing="4" cellpadding="4"
| '''Name''' || '''Read/Write''' || '''Description'''
|-
| [[AEXECUTE]] ''function, command'' || R || Executes an SQL command in a background thread, calling ''function'' when complete. Returns 1 if the command is successfully queued.
|-
| [[AQUERY]] ''function, command'' || R || Executes an SQL command in a background thread, calling ''function'' when complete. Returns 1 if the command is successfully queued.
|-
| [[CLOSE]] || W || Closes the connection to the database.
|-
| [[CONNECT]] || W || Opens a connection to the database, using the settings from Sphere.ini.
|-
| [[CONNECTED]] || R || Returns 1 if the database is connected.
|-
| [[ESCAPEDATA]] ''text'' || R || Returns ''text'' as an escaped SQL string.
|-
| [[EXECUTE]] ''command'' || W || Exectutes an SQL command that doesn't return any result.
|-
| [[QUERY]] ''command'' || W || Executes an SQL command that returns results.
|-
| [[ROW]].NUMCOLS || R || Returns the number of columns returned in the last query.
|-
| [[ROW]].NUMROWS || R || Returns the number of rows returned in the last query.
|-
| [[ROW]]''.n.col_index'' || R || Returns the value of the column at index ''col_index'' in the nth row. (zero-based)
|-
| [[ROW]]''.n.col_name'' || R || Returns the value of the column named ''col_name'' in the nth row. (zero-based)
|}

[[Category: Reference Compendium]]
[[Category: Objects]]

← Older revision		Revision as of 20:44, 26 November 2010
Line 1:		Line 1:
		+	{{Languages\|Database}}
		+
	__FORCETOC__		__FORCETOC__
	Using the [[DB]] object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in SphereServer:		Using the [[DB]] object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in SphereServer:

Database - Revision history

Sirius: Added languagemenue

MrSugarCube: Created page with '__FORCETOC__ Using the DB object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in...'

MrSugarCube: Created page with 'FORCETOC Using the DB object reference, scripts can interact with an external MySQL database. The following table details the various properties of the database object in...'