• IS THIS SITE UGLY? Click "RG3" at the very bottom-left of this page to change it. To dismiss this notice, click the X --->
MQ2SQLite

MQ2SQLite 1.0

Included in Very Vanilla
Very Vanilla Included! No need to download.

382px-SQLite370.svg[1].png

A plugin for MQ2

This plugin allows you to interact with a SQLite database. A SQLite database is just a file that can be accessed using SQL commands. This plugin gives you access to the SQLite API and adds a TLO for viewing the results.

Since the results of the query are stored in memory, this can take up a lot of memory if you use unique query names and do not clear your results from memory. So, don't do that. Be sure to use the .clear function when you're done accessing the results or continue to use the same name for your query which will clear the results for you before each run.

Usage:
/sqlite <"Path to Database File"> QUERY
Example:
/sqlite C:\Test.db myquery SELECT * FROM Table;
Available TLOs:

${sqlite.status[QueryName]}

String

Current status - Either Active, Success, or Failed

${sqlite.rows[QueryName]}

Int

The number of rows returned for results

${sqlite.clear[QueryName]}

Bool

Clears memory of the query results

${sqlite.result[QueryName Row ColumnName]}

String

String containing results (or Failed)


Example:

/echo ${sqlite.result[myquery 1 Name]}
The above would return the value of the column named "Name" for the first row of results from myquery.
Server Type
Live, Emu, TLP, Test Server
Author
Knightly
Downloads
25
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from Knightly

Top