var dbase;
function init() {
	dbase = _server.getDatabaseManager();
}
function destroy() {
	delete dbase;
}

    function handleInternalEvent(evt) {}; //not used
	function handleRequest(cmd, params, user, fromRoom) {
		if (cmd == "register") {
			trace("starting registration proccess");
			var userName = params.uName;
			var passWord = params.pass;
			var email = params.email;
			var response = {_cmd:cmd};
			var error = "";
			var success = false;
			var sql = "SELECT COUNT (NAME) FROM USERS WHERE NAME='"+_server.escapeQuotes(userName)+"'";
			var queryRes = dbase.executeQuery(sql);
			if (queryRes != null) {
				var Row = queryRes.get(0);
				var count = Row.getItem("COUNT(NAME)");
				if (count == 0) {
					trace("USERNAME NOT REGISTERED, REGISTERING");
					sql = "INSERT INTO USERS (NAME, PASS, EMAIL) VALUES ('"+userName+"', '"+passWord+"', '"+email+"')";
					queryRes = dbase.executeCommand(sql);
					success = true;
				} else {
					trace("USERNAME ALREADY REGISTERED!");
					error = "The username entered is already registered.";
				}
			} else {
				error = "Error connecting to the database";
			}
			response.error = error;
			response.success = success;
			_server.sendResponse(response, -1, null, [user]);
		}

}