- Included in Very Vanilla
-
Included! No need to download.
- Server Type
- Live, Emu, TLP, Test Server
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"> QUERYExample:
/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) |
/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.
