Scripting/Squirrel/Functions/ConnectSQL: Difference between revisions

From Vice City Multiplayer
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing
No edit summary
No edit summary
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.

Revision as of 14:01, 19 September 2015

Usage

To use SQL you need to first download the sqlite plugin from [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

function onScriptLoad()
{
    db <- ConnectSQL( "Database.db" );
}

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.