Scripting/Squirrel/Functions/ConnectSQL: Difference between revisions
![Caution icon Caution icon](http://static.vc-mp.org/caution-icon.webp)
(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...") |
(No difference)
|
Revision as of 06:59, 28 July 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
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.