using (IQueryAdapter dbClient = MainEnvironment.GetDatabaseManager().getQueryreactor())
{
if (!useSso || !MainEnvironment.useSSO)
{
dbClient.setQuery("SELECT userid " +
"FROM users " +
"WHERE users.auth_ticket = @sso LIMIT 1");
}
else
{
dbClient.setQuery("SELECT userid " +
"FROM users " +
"WHERE users.auth_ticket = @sso " +
"AND ip_last = @
iPaddress ");
}
dbClient.addParameter("sso", sessionTicket);
dbClient.addParameter("ipaddress", ip);
userid = (uint)dbClient.getInteger();
if (userid == 0)
{
errorCode = 1;
return null;
//Logging.LogException("No user found. Debug data: [" + sessionTicket + "], [" + ip + "]");
//throw new UserDataNotFoundException(string.Format("No user found with ip {0} and sso {1}. Use SSO: {2} ", ip, sessionTicket, MainEnvironment.useSSO.ToString()));
}
userData = MainEnvironment.GetGame().GetClientManager().GetHabboData(userid);
if (userData == null)
{
errorCode = 1;
return null;
}
//if (ip != "127.0.0.1")
//{
// dbClient.setQuery("DELETE FROM user_tickets WHERE sessionticket = @
Sessionticket");
// dbClient.addParameter("sessionticket", sessionTicket);
// dbClient.runQuery();
//}