Personally I'd do something like this instead
PHP Code:
/**
SQL Query Interface
*/
public function executeSQL(db, query, result, doecho) {
temp.init = timevar2;
temp.results = requestsql2(db, query, result);
if (result) {
// Check Results
if (results.error != "") {
echo(format("SQL Error: %s", results.error));
savelog2("sqlerrors.txt", results.error NL query);
return NULL;
}
else if (results.rows.size() > 0 || query.starts("SELECT")) {
if (doecho) echo(format("SQL returned %s rows.", results.rows.size()));
}
else if (results.affectedrows.size() > 0) {
if (doecho) echo(format("SQL affected %s rows.", results.affectedrows.size()));
}
else if (results.completed) {
if (doecho) echo(format("SQL %s Query completed successfully.", query.tokenize()[0].upper()));
}
temp.taken = timevar2 - temp.init;
// Uncomment to log queries (for checking performance, etc.)
//savelog2("sqlqueries.txt", query NL "Took " @ temp.taken @ " seconds");
return results;
}
}
Small change, but it lets you use multiple databases.
Example:
PHP Code:
function onCreated() {
temp.query = "SELECT Username,Password,EZ,Level,X,Y,Exp FROM Accounts";
temp.result = SQL.executeSQL("default", temp.query, true);
if (temp.result.rows.size() > 0) {
for (temp.row: temp.result.rows) {
echo(temp.row.Username);
}
}
}