Ok added SQLite support, when using the requestsql-commands then the default database is now a sqlite database
PHP Code:
requestsql("CREATE TABLE test (account varchar not null default '' primary key, age int not null default 1)", false);
requestsql("INSERT INTO test VALUES ('Stefan', 33)", false);
requestsql("INSERT INTO test VALUES ('Graal', 11)", false);
requestsql("INSERT INTO test VALUES ('Unixmad', 42)", false);
temp.req = requestsql("SELECT * FROM test", true);
if (!temp.req.completed)
waitfor(temp.req,"onReceiveData",60);
echo("Accounts in database: " @ temp.req.rows.size());
for (temp.row: temp.req.rows)
echo(" Account: " @ temp.row.account @ ", age: " @ temp.row.age);
Right now it's experimental (not checking for flooding etc.) so I can enable it on request.
To build the query string use string.escape() to avoid SQL injection.
The full list of supported SQL statements is available at
http://www.sqlite.org/lang.html