var dbase;
var userName;
var passWord;
var SocketChannel;
function init() {
	dbase = _server.getDatabaseManager();
}
function destroy() {
	delete dbase;
	delete userName;
	delete passWord;
	delete SocketChannel;
}
function handleInternalEvent(evt) {
	trace(evt);
	if (evt.name == "loginRequest") {
		var error = "";
		userName = evt["nick"];
		//It could be evt.nick
		passWord = evt["pass"];
		//It could be evt.pass
		SocketChannel = evt["chan"];
		//It could be evt.chan
		var sql = "SELECT COUNT (NAME) FROM USERS WHERE NAME='"+userName+"' AND PASS='"+passWord+"'";
		var queryRes = dbase.executeQuery(sql);
		var response = {};
		if (queryRes != null) {
			var Row = queryRes.get(0);
			var count = Row.getItem("COUNT(NAME)");
			if (count == 1) {
				trace("SUCCESSFULL LOGIN");
				var obj = _server.loginUser(userName, passWord, SocketChannel);
				var u = _server.instance.getUserByChannel(chan);
response.userId = u.getUserId();

				if (obj.success) {
					response._cmd = "logOK";
					response.name = userName;
				} else {
					error = obj.error;
					response._cmd = "logKO";
				}
			} else if (count == 0) {
				trace("FAILED LOGIN");
				response._cmd = "logKO";
				error = "Wrong username or password";
			}
		} else {
			response._cmd = "logKO";
			error = "Error connecting to the database";
		}
		response.error = error;
		_server.sendResponse(response, -1, null, SocketChannel);
		}
}