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)

				if(obj.success){
var u = _server.instance.getUserByChannel(SocketChannel);
response.userId = u.getUserId();

					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)
	}
}