Category:SQLite

From SA-MP Wiki

About

SQLite is a open source SQL database system built into the SA:MP server. No additional plugins are required to use SQLite. This feature of SA:MP was introduced in version 0.2.2. The database files of SQLite files are commonly stored in .db files and are accessed in the servers \scriptfiles\ directory. The SQLite version is 3.7.0.1

Functions

SQLite currently has 18 native functions. These functions introduced the DB and DBResult tags to SA:MP. The tag DB is used on variables which will store the databases handle ("identifier/ID") and the tag DBResult is for use on variables which store the results of queries. A small guide has also been posted to roughly explain SQL injection and how to patch it, see Escaping Strings SQLite.

Articles in category "SQLite"

There are 18 articles in this category.

D Db close Db debug openfiles Db debug openresults Db field name Db free result Db get field

D cont. Db get field assoc Db get field assoc float Db get field assoc int Db get field float Db get field int Db get mem handle Db get result mem handle

D cont. Db next row Db num fields Db num rows Db open Db query