public bool LoadByUsername(DatabaseManager database, string sUsername)
{
DataRow result = null;
using (DatabaseClient dbClient = database.GetClient())
{
dbClient.AddParamWithValue("@username", sUsername);
result = dbClient.ReadDataRow("SELECT * FROM users WHERE username = @username LIMIT 1;");
}
return CheckoutUserParams(ref result);
}
public bool LoadByID(DatabaseManager database, uint ID)
{
DataRow result = null;
using (DatabaseClient dbClient = database.GetClient())
{
dbClient.AddParamWithValue("@id", ID);
result = dbClient.ReadDataRow("SELECT * FROM users WHERE id = @id LIMIT 1;");
}
return CheckoutUserParams(ref result);
}
public bool LoadBySsoTicket(DatabaseManager database, string sTicket)
{
DataRow result = null;
using (DatabaseClient dbClient = database.GetClient())
{
dbClient.AddParamWithValue("@ticket", sTicket);
result = dbClient.ReadDataRow("SELECT * FROM users WHERE ssoticket = @ticket;");
if (result != null)
{
//dbClient.ExecuteQuery("UPDATE users SET ssoticket = NULL WHERE ssoticket = @ticket LIMIT 1;");
}
}
return CheckoutUserParams(ref result);
}
/// <summary>
/// Initializes the Ion server environment.
/// </summary>
public static void Initialize()
{
mLog.MinimumLogImportancy = LogType.Debug;
mLog.WriteLine("Initializing Ion environment.");
try
{
// Try to initialize configuration
try
{
mConfig = ConfigurationModule.LoadFromFile("settings");
}
catch (FileNotFoundException ex)
{
mLog.WriteError("Failed to load configuration file, exception message was: " + ex.Message);
IonEnvironment.Destroy();
return;
}
// Initialize database and test a connection by getting & releasing it
DatabaseServer pDatabaseServer = new DatabaseServer(
IonEnvironment.Configuration["db1.server.host"],
IonEnvironment.Configuration.TryParseUInt32("db1.server.port"),
IonEnvironment.Configuration["db1.server.uid"],
IonEnvironment.Configuration["db1.server.pwd"]);
Database pDatabase = new Database(
IonEnvironment.Configuration["db1.name"],
IonEnvironment.Configuration.TryParseUInt32("db1.minpoolsize"),
IonEnvironment.Configuration.TryParseUInt32("db1.maxpoolsize"));
mDatabaseManager = new DatabaseManager(pDatabaseServer, pDatabase);
mDatabaseManager.SetClientAmount(2);
mDatabaseManager.ReleaseClient(mDatabaseManager.GetClient().Handle);
mDatabaseManager.StartMonitor();
// Initialize TCP listener
mTcconnectionManager = new IonTcpConnectionManager(
IonEnvironment.Configuration["net.tcp.localip"],
IonEnvironment.Configuration.TryParseInt32("net.tcp.port"),
IonEnvironment.Configuration.TryParseInt32("net.tcp.maxcon"));
mTcconnectionManager.GetListener().Start();
// Try to initialize Habbo Hotel
mHabboHotel = new Ion.HabboHotel.HabboHotel();
IonEnvironment.GetLog().WriteLine("Initialized Ion environment.");
}
catch (Exception ex) // Catch all other exceptions
{
mLog.WriteError("Unhandled exception occurred during initialization of Ion environment. Exception message: " + ex.Message);
}
}
