public void Initialize(MySql.Data.MySqlClient.MySqlDataReader pReader)
{
UserID = pReader.GetInt32("userid");
ID = pReader.GetInt32("id");
InternalID = pReader.GetInt32("internal_id");
Name = pReader.GetString("name");
WorldID = pReader.GetByte("world_id");
AccountID = AccountDataCache.Instance.KnownUserlist[UserID];
SlotHashes = new Dictionary<int, Dictionary<short, int>>();
}
public static bool ReadViaOrdianal(MySql.Data.MySqlClient.MySqlDataReader rdr, string Column, out string Result)
{
try {
var ordinal = rdr.GetOrdinal(Column);
var tmp = rdr.GetString(ordinal);
Result = tmp;
return true;
} catch {
Result = "";
return false;
}
}
public static bool ReadViaOrdianal(MySql.Data.MySqlClient.MySqlDataReader rdr, string Column, out DateTime Result)
{
try {
var ordinal = rdr.GetOrdinal(Column);
var tmp = rdr.GetString(ordinal);
DateTime dt;
DateTime.TryParse(tmp, out dt);
Result = dt;
return true;
} catch {
Result = DateTime.Now;
return false;
}
}
public static String GetDBString(String sqlFieldName, MySql.Data.MySqlClient.MySqlDataReader reader)
{
return reader[sqlFieldName].Equals(DBNull.Value) ? String.Empty : reader.GetString(sqlFieldName);
}