Quote:
Originally Posted by LoneAngelIbesu
The boolean in requestsql() is probably for whether or not you want the SQL commands to return a value.
|
I suppose I should have said that I already had a good idea.
Edit: After looking up SQLite documentation, I have a few more suggestions.
I suggest instead of having the global
requestsql() functions that instead there be an
sqlopen(str filename) function that returns an sql database object that can be used to execute sql queries and such. This is so there can be multiple databases opened simultaneously.
PHP Code:
db = sqlopen("data/factions.db");
req = db.exec("typical sql statement here");
// do stuff with req
db.close();
I don't want the whole server to use a single database, it's too easy for someone to just drop all the tables with a single command. I also don't think it would be too much trouble to add a
waitforcompleted() function to the request object, which would return immediately if the request is completed or wait until it is completed.
Along with this, I noticed that before I have been unable to load files from disk during the
onInitialized() in the Control-NPC, I'd like that fixed so there is no problem opening databases the instant the server starts.