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