Scripting/Squirrel/Functions/ConnectSQL - Revision history

Dracc: /* Usage */

2019-04-26T10:14:21Z

Usage

← Older revision		Revision as of 10:14, 26 April 2019
Line 1:		Line 1:
	== Usage ==		== Usage ==
	To use ~~SQL~~ you need to first download the sqlite plugin from [https://bitbucket.org/stormeus/0.4-sqlite/downloads[here]]. Once you have downloaded it place the plugin in your plugins folder and load the plugin in your server.cfg by adding a line in plugins that is for 32 bit users it is '''sqlite04rel32''' and for 64 bit users it is '''sqlite04rel64'''		To use SQLite you need to first download the sqlite plugin from [https://bitbucket.org/stormeus/0.4-sqlite/downloads[here]]. Once you have downloaded it place the plugin in your plugins folder and load the plugin in your server.cfg by adding a line in plugins that is for 32 bit users it is '''sqlite04rel32''' and for 64 bit users it is '''sqlite04rel64'''

	== Syntax ==		== Syntax ==

Thijn at 19:01, 30 January 2017

2017-01-30T19:01:25Z

← Older revision		Revision as of 19:01, 30 January 2017
Line 15:		Line 15:

	The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.		The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.

			== Related Functions ==

			{{Scripting/Squirrel/Functions/SQLite Functions}}
			[[Category:Scripting/Squirrel/Functions/SQLite _Functions]]

Ysc3839 at 07:43, 13 February 2016

2016-02-13T07:43:19Z

← Older revision		Revision as of 07:43, 13 February 2016
Line 4:		Line 4:
	== Syntax ==		== Syntax ==
	To connect a database you need to use something like		To connect a database you need to use something like
			<source lang=javascript>function onScriptLoad()
	<source lang=js>function onScriptLoad()
	{		{
	db <- ConnectSQL( "Database.db" );		db <- ConnectSQL( "Database.db" );
Line 13:		Line 12:
	You can add a table to your database by using the following function that is		You can add a table to your database by using the following function that is

	<source lang=js>QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );</source>		<source lang=javascript>QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );</source>

	The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.		The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.

Ysc3839 at 14:01, 19 September 2015

2015-09-19T14:01:33Z

← Older revision		Revision as of 14:01, 19 September 2015
Line 5:		Line 5:
	To connect a database you need to use something like		To connect a database you need to use something like

	<~~pre~~>function onScriptLoad()		<source lang=js>function onScriptLoad()
	{		{
	db <- ConnectSQL( "Database.db" );		db <- ConnectSQL( "Database.db" );
	}</~~pre~~>		}</source>

	== Adding tables to your database ==		== Adding tables to your database ==
	You can add a table to your database by using the following function that is		You can add a table to your database by using the following function that is

	<~~pre~~>QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );</~~pre~~>		<source lang=js>QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );</source>

	The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.		The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.

KAKAN at 18:54, 21 August 2015

2015-08-21T18:54:55Z

← Older revision		Revision as of 18:54, 21 August 2015
Line 5:		Line 5:
	To connect a database you need to use something like		To connect a database you need to use something like

	~~'''~~db <- ConnectSQL( "Database.db" );~~''' on your '''onScriptLoad''' event~~		<pre>function onScriptLoad()
			{
			db <- ConnectSQL( "Database.db" );
			}</pre>

	== Adding tables to your database ==		== Adding tables to your database ==
	You can add a table to your database by using the following function that is		You can add a table to your database by using the following function that is

	~~'''~~QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );~~'''~~		<pre>QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );</pre>

	The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.		The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.

Mashreq: Created page with "== Usage == To use SQL you need to first download the sqlite plugin from [https://bitbucket.org/stormeus/0.4-sqlite/downloads[here]]. Once you have downloaded it place the plu..."

2015-07-28T06:59:46Z

Created page with "== Usage == To use SQL you need to first download the sqlite plugin from [https://bitbucket.org/stormeus/0.4-sqlite/downloads[here]]. Once you have downloaded it place the plu..."

New page

== Usage ==
To use SQL you need to first download the sqlite plugin from [https://bitbucket.org/stormeus/0.4-sqlite/downloads[here]]. Once you have downloaded it place the plugin in your plugins folder and load the plugin in your server.cfg by adding a line in plugins that is for 32 bit users it is '''sqlite04rel32''' and for 64 bit users it is '''sqlite04rel64'''

== Syntax ==
To connect a database you need to use something like

'''db <- ConnectSQL( "Database.db" );''' on your '''onScriptLoad''' event

== Adding tables to your database ==
You can add a table to your database by using the following function that is

'''QuerySQL( db, "CREATE TABLE IF NOT EXISTS YOUR_TABLE_NAME( COLUMN1 TEXT, COLUMN2 TEXT )" );'''

The Argument for your column can be used according to what you are storing/inserting to it. If you wished to insert/store a number you can change the TEXT to NUMERIC. If its a text you can use TEXT.