public void LoadFromDB(MySqlDataReader reader)
{
if (reader.Read())
{
RegDate = reader.GetDateTime(0);
LastLoginDate = reader.GetDateTime(1);
ContinuousCount = reader.GetByte(2);
DailyCount = reader.GetByte(3);
}
}
public GuildMember(Guild Guild, MySqlDataReader reader)
{
this.Guild = Guild;
CharacterID = reader.GetInt32(1);
Rank = (GuildRank)reader.GetByte(2);
Corp = (ushort)reader.GetInt16(3);
}
private void LoginWithPasswordHashFunction()
{
String saltHash = null;
try
{
connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();
conn = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
conn.Open();
String query = "SELECT userID, slowHashSalt, firstname, middlename, lastname, isPT FROM webAppPersonalFit.userregistration WHERE username=?uname";
cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("?uname", usernameTextBox.Value);
reader = cmd.ExecuteReader();
if (reader.HasRows && reader.Read())
{
String saltHashes = reader.GetString(reader.GetOrdinal("slowHashSalt"));
//Console.WriteLine(saltHashes);
saltHash = saltHashes;
userID = "" + reader.GetInt16(reader.GetOrdinal("userID"));
isPT = Convert.ToInt32(reader.GetByte(reader.GetOrdinal("isPT")));
}
else
{
ValidationTextBoxLabel.Text = "Invalid Username or Password.";
}
if (saltHash != null)
{
bool validUser = PasswordStorage.VerifyPassword(passwordTextBox.Value, saltHash);
if (validUser == true)
{
Session[userID] = userID;
Response.BufferOutput = true;
Server.Transfer("TrainerCatalog.aspx", true);
}
else
{
ValidationTextBoxLabel.Text = "Invalid Username or Password.";
}
}
ValidationTextBoxLabel.Text = "Invalid Username or Password.";
reader.Close();
conn.Close();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
public static byte?GetByteNullable(this MySqlDataReader rdr, string column)
{
if (rdr == null)
{
return(null);
}
if (rdr.IsDBNull(rdr.GetOrdinal(column)))
{
return(null);
}
return(rdr.GetByte(column));
}
public static Pattern Read(MySql.Data.MySqlClient.MySqlDataReader reader)
{
var pattern = new Pattern()
{
ID = reader.GetUInt32("ID"),
Name = reader.GetString("Name"),
Creator = reader.GetString("Creator"),
Tags = reader.GetString("Tags").Split(',', StringSplitOptions.RemoveEmptyEntries),
Code = reader.GetString("Code"),
Type = reader.GetByte("Type"),
};
string folder = System.IO.Path.Combine(pattern.Code.Substring(0, 2), pattern.Code.Substring(2, 2));
if (System.IO.Directory.Exists(folder))
{
string file = System.IO.Path.Combine(folder, pattern.Code + ".acnh");
if (System.IO.File.Exists(file))
{
pattern.Bytes = System.IO.File.ReadAllBytes(file);
}
}
return(pattern);
}
private Character toObject(MySqlDataReader reader)
{
Character character = new Character();
character.Id = reader.GetUInt32(0);
character.Slot = reader.GetByte(2);
character.Name = reader.GetString(3);
character.Faction = reader.GetByte(4);
character.Gender = reader.GetByte(5);
character.Rank = reader.GetUInt32(6);
character.Money = reader.GetUInt32(7);
character.Threat = reader.GetByte(8);
character.Playtime = reader.GetUInt32(9);
character.Clan = reader.GetString(10);
character.Version = reader.GetUInt32(11);
character.Appearence = reader.GetString(12);
character.Custom = reader.GetString(13);
character.WorldId = reader.GetUInt32(14);
return character;
}
private Byte getThreat(MySqlDataReader reader)
{
Byte threat = reader.GetByte(8);
return threat;
}
private Byte getFaction(MySqlDataReader reader)
{
Byte faction = reader.GetByte(4);
return faction;
}
private static ArchiveMedia _readArchiveMedia(MySqlDataReader dataReader, ArchiveDirectory dir)
{
byte typVideo = dataReader.IsDBNull(dataReader.GetOrdinal("typVideo")) ? (byte)0 : dataReader.GetByte("typVideo");
ArchiveMedia media = new ArchiveMedia()
{
idPersistentMedia = dataReader.GetUInt64("idArchiveMedia"),
Directory = dir,
};
_mediaReadFields(dataReader, media);
ThreadPool.QueueUserWorkItem(o => media.Verify());
return media;
}
private static Event _EventRead(Engine engine, MySqlDataReader dataReader)
{
Event aEvent = new Event(engine);
uint flags = dataReader.IsDBNull(dataReader.GetOrdinal("flagsEvent")) ? 0 : dataReader.GetUInt32("flagsEvent");
aEvent._idRundownEvent = dataReader.GetUInt64("idRundownEvent");
aEvent._layer = (VideoLayer)dataReader.GetSByte("Layer");
aEvent._eventType = (TEventType)dataReader.GetByte("typEvent");
aEvent._startType = (TStartType)dataReader.GetByte("typStart");
aEvent._scheduledTime = _readDateTimeField(dataReader, "ScheduledTime");
aEvent._duration = dataReader.IsDBNull(dataReader.GetOrdinal("Duration")) ? default(TimeSpan) : aEvent.Engine.AlignTimeSpan(dataReader.GetTimeSpan("Duration"));
aEvent._scheduledDelay = dataReader.IsDBNull(dataReader.GetOrdinal("ScheduledDelay")) ? default(TimeSpan) : aEvent.Engine.AlignTimeSpan(dataReader.GetTimeSpan("ScheduledDelay"));
aEvent._scheduledTC = dataReader.IsDBNull(dataReader.GetOrdinal("ScheduledTC")) ? TimeSpan.Zero : dataReader.GetTimeSpan("ScheduledTC");
aEvent._mediaGuid = (dataReader.IsDBNull(dataReader.GetOrdinal("MediaGuid"))) ? Guid.Empty : dataReader.GetGuid("MediaGuid");
aEvent._eventName = dataReader.IsDBNull(dataReader.GetOrdinal("EventName")) ? default(string) : dataReader.GetString("EventName");
var psb = dataReader.GetByte("PlayState");
aEvent._playState = (TPlayState)psb;
if (aEvent._playState == TPlayState.Playing || aEvent._playState == TPlayState.Paused)
aEvent._playState = TPlayState.Aborted;
if (aEvent._playState == TPlayState.Fading)
aEvent._playState = TPlayState.Played;
aEvent._startTime = _readDateTimeField(dataReader, "StartTime");
aEvent._startTC = dataReader.IsDBNull(dataReader.GetOrdinal("StartTC")) ? TimeSpan.Zero : dataReader.GetTimeSpan("StartTC");
aEvent._requestedStartTime = dataReader.IsDBNull(dataReader.GetOrdinal("RequestedStartTime")) ? null : (TimeSpan?)dataReader.GetTimeSpan("RequestedStartTime");
aEvent._transitionTime = dataReader.IsDBNull(dataReader.GetOrdinal("TransitionTime")) ? default(TimeSpan) : dataReader.GetTimeSpan("TransitionTime");
aEvent._transitionType = (TTransitionType)dataReader.GetByte("typTransition");
aEvent._audioVolume = dataReader.IsDBNull(dataReader.GetOrdinal("AudioVolume")) ? 0 : dataReader.GetDecimal("AudioVolume");
aEvent._idProgramme = dataReader.IsDBNull(dataReader.GetOrdinal("idProgramme")) ? 0 : dataReader.GetUInt64("idProgramme");
aEvent._idAux = dataReader.IsDBNull(dataReader.GetOrdinal("IdAux")) ? default(string) : dataReader.GetString("IdAux");
aEvent._enabled = (flags & (1 << 0)) != 0;
aEvent._hold = (flags & (1 << 1)) != 0;
EventGPI.FromUInt64(ref aEvent._gPI, (flags >> 4) & EventGPI.Mask);
aEvent._nextLoaded = false;
return aEvent;
}
private Byte getGrpStatus(MySqlDataReader reader)
{
Byte grpstatus = reader.GetByte(5);
return grpstatus;
}
private Byte getGrpPubStatus(MySqlDataReader reader)
{
Byte grppub = reader.GetByte(6);
return grppub;
}
private Byte getGrpInvStatus(MySqlDataReader reader)
{
Byte grpinv = reader.GetByte(7);
return grpinv;
}
private Byte getDistrictType(MySqlDataReader reader)
{
Byte type = reader.GetByte(2);
return type;
}
private Byte getDistrictID(MySqlDataReader reader)
{
Byte disid = reader.GetByte(1);
return disid;
}
public void LoadFromReader(MySqlDataReader _reader)
{
m_id = _reader["id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("id") : 0;
mc_id = false;
m_entity_id = _reader["entity_id"].GetType() != typeof(System.DBNull) ? _reader.GetInt64("entity_id") : 0;
mc_entity_id = false;
m_proto_name = _reader["proto_name"].GetType() != typeof(System.DBNull) ? _reader.GetString("proto_name") : "";
mc_proto_name = false;
m_month = _reader["month"].GetType() != typeof(System.DBNull) ? _reader.GetByte("month") : (byte)0;
mc_month = false;
m_price = _reader["price"].GetType() != typeof(System.DBNull) ? _reader.GetFloat("price") : (double)0;
mc_price = false;
m_comment = _reader["comment"].GetType() != typeof(System.DBNull) ? _reader.GetString("comment") : "";
mc_comment = false;
}
private Byte getLfgStatus(MySqlDataReader reader)
{
Byte lfg = reader.GetByte(4);
return lfg;
}
//
//-------------------------------------------------------------------------------------------------
//
public bool ds2browse(string browse_type_in, string browse_category_in, string browse_actor_in,
string browse_title_in, int batch_size_in, int customerid_out, ref int rows_returned,
ref int[] prod_id_out, ref string[] title_out, ref string[] actor_out, ref decimal[] price_out,
ref int[] special_out, ref int[] common_prod_id_out, ref double rt)
{
// Products table: PROD_ID INT, CATEGORY TINYINT, TITLE VARCHAR(50), ACTOR VARCHAR(50),
// PRICE DECIMAL(12,2), SPECIAL TINYINT, COMMON_PROD_ID INT
int i_row;
int[] category_out = new int[GlobalConstants.MAX_ROWS];
#if (USE_WIN32_TIMER)
long ctr0 = 0, ctr = 0, freq = 0;
#else
TimeSpan TS = new TimeSpan();
DateTime DT0;
#endif
switch(browse_type_in)
{
case "title":
db_query = "select * from PRODUCTS where MATCH (TITLE) AGAINST ('" + browse_title_in + "') LIMIT " +
batch_size_in + ";";
break;
case "actor":
db_query = "select * from PRODUCTS where MATCH (ACTOR) AGAINST ('" + browse_actor_in + "') LIMIT " +
batch_size_in + ";";
break;
case "category":
db_query="select * from PRODUCTS where CATEGORY = " + Convert.ToInt32(browse_category_in) +
" and SPECIAL=1 LIMIT " + batch_size_in + ";";
break;
}
Browse = new MySqlCommand(db_query, objConn);
#if (USE_WIN32_TIMER)
QueryPerformanceFrequency(ref freq); // obtain system freq (ticks/sec)
QueryPerformanceCounter(ref ctr0); // Start response time clock
#else
DT0 = DateTime.Now;
#endif
try
{
Rdr = Browse.ExecuteReader();
i_row = 0;
if (!Rdr.HasRows) // No rows returned
{
//Console.WriteLine("No DVDs Found");
}
else // Rows returned
{
while (Rdr.Read())
{
prod_id_out[i_row] = Rdr.GetInt32(0);
category_out[i_row] = Rdr.GetByte(1);
title_out[i_row] = Rdr.GetString(2);
actor_out[i_row] = Rdr.GetString(3);
price_out[i_row] = Rdr.GetDecimal(4);
special_out[i_row] = Rdr.GetByte(5);
common_prod_id_out[i_row] = Rdr.GetInt32(6);
++i_row;
}
}
Rdr.Close();
rows_returned = i_row;
}
catch (MySqlException e)
{
Console.WriteLine("Thread {0}: Error in Browse: {1}", Thread.CurrentThread.Name, e.Message);
return(false);
}
// Console.WriteLine("Thread {0}: Calling Browse w/ browse_type= {1} batch_size_in= {2} category= {3}" +
// " title= {4} actor= {5}", Thread.CurrentThread.Name, browse_type_in, batch_size_in, browse_category_in,
// browse_title_in, browse_actor_in);
#if (USE_WIN32_TIMER)
QueryPerformanceCounter(ref ctr); // Stop response time clock
rt = (ctr - ctr0)/(double) freq; // Calculate response time
#else
TS = DateTime.Now - DT0;
rt = TS.TotalSeconds; // Calculate response time
#endif
return(true);
}
private Byte getOnlineStatus(MySqlDataReader reader)
{
Byte online = reader.GetByte(3);
return online;
}
private static void _mediaReadFields(MySqlDataReader dataReader, PersistentMedia media)
{
uint flags = dataReader.IsDBNull(dataReader.GetOrdinal("flags")) ? (uint)0 : dataReader.GetUInt32("flags");
byte typVideo = dataReader.IsDBNull(dataReader.GetOrdinal("typVideo")) ? (byte)0 : dataReader.GetByte("typVideo");
media._mediaName = dataReader.IsDBNull(dataReader.GetOrdinal("MediaName")) ? string.Empty : dataReader.GetString("MediaName");
media._duration = dataReader.IsDBNull(dataReader.GetOrdinal("Duration")) ? default(TimeSpan) : dataReader.GetTimeSpan("Duration");
media._durationPlay = dataReader.IsDBNull(dataReader.GetOrdinal("DurationPlay")) ? default(TimeSpan) : dataReader.GetTimeSpan("DurationPlay");
media._folder = dataReader.IsDBNull(dataReader.GetOrdinal("Folder")) ? string.Empty : dataReader.GetString("Folder");
media._fileName = dataReader.IsDBNull(dataReader.GetOrdinal("FileName")) ? string.Empty : dataReader.GetString("FileName");
media._fileSize = dataReader.IsDBNull(dataReader.GetOrdinal("FileSize")) ? 0 : dataReader.GetUInt64("FileSize");
media.idFormat = dataReader.IsDBNull(dataReader.GetOrdinal("idFormat")) ? 0 : dataReader.GetUInt64("idFormat");
media._lastUpdated = _readDateTimeField(dataReader, "LastUpdated");
media._mediaStatus = (TMediaStatus)(dataReader.IsDBNull(dataReader.GetOrdinal("statusMedia")) ? 0 : dataReader.GetInt32("statusMedia"));
media._mediaType = (TMediaType)(dataReader.IsDBNull(dataReader.GetOrdinal("typMedia")) ? 0 : dataReader.GetInt32("typMedia"));
media._tCStart = dataReader.IsDBNull(dataReader.GetOrdinal("TCStart")) ? default(TimeSpan) : dataReader.GetTimeSpan("TCStart");
media._tCPlay = dataReader.IsDBNull(dataReader.GetOrdinal("TCPlay")) ? default(TimeSpan) : dataReader.GetTimeSpan("TCPlay");
media.idProgramme = dataReader.IsDBNull(dataReader.GetOrdinal("idProgramme")) ? 0 : dataReader.GetUInt64("idProgramme");
media._audioVolume = dataReader.IsDBNull(dataReader.GetOrdinal("AudioVolume")) ? 0 : dataReader.GetDecimal("AudioVolume");
media._audioLevelIntegrated = dataReader.IsDBNull(dataReader.GetOrdinal("AudioLevelIntegrated")) ? 0 : dataReader.GetDecimal("AudioLevelIntegrated");
media._audioLevelPeak = dataReader.IsDBNull(dataReader.GetOrdinal("AudioLevelPeak")) ? 0 : dataReader.GetDecimal("AudioLevelPeak");
media._audioChannelMapping = dataReader.IsDBNull(dataReader.GetOrdinal("typAudio")) ? TAudioChannelMapping.Stereo : (TAudioChannelMapping)dataReader.GetByte("typAudio");
media.HasExtraLines = (typVideo & (byte)0x80) > 0;
media._videoFormat = (TVideoFormat)(typVideo & 0x7F);
media._idAux = dataReader.IsDBNull(dataReader.GetOrdinal("idAux")) ? string.Empty : dataReader.GetString("idAux");
media._killDate = _readDateTimeField(dataReader, "KillDate");
media._mediaGuid = dataReader.IsDBNull(dataReader.GetOrdinal("MediaGuid")) ? Guid.Empty : dataReader.GetGuid("MediaGuid");
media._mediaEmphasis = (TMediaEmphasis)((flags >> 8) & 0xF);
media._parental = (TParental)((flags >> 12) & 0xF);
if (media is ServerMedia)
((ServerMedia)media)._doNotArchive = (flags & 0x1) != 0;
media._mediaCategory = (TMediaCategory)((flags >> 4) & 0xF); // bits 4-7 of 1st byte
}
// 往 dr 填充 r 于 i 索引的值
public static void FillValue( DbRow dr, MySqlDataReader r, int i )
{
switch( dr.parent.columns[ i ].dataType )
{
case DbDataTypes.Boolean:
dr[ i ].Assign( r.GetBoolean( i ) ); break;
case DbDataTypes.Int8:
dr[ i ].Assign( r.GetSByte( i ) ); break;
case DbDataTypes.Int16:
dr[ i ].Assign( r.GetInt16( i ) ); break;
case DbDataTypes.Int32:
dr[ i ].Assign( r.GetInt32( i ) ); break;
case DbDataTypes.Int64:
dr[ i ].Assign( r.GetInt64( i ) ); break;
case DbDataTypes.UInt8:
dr[ i ].Assign( r.GetByte( i ) ); break;
case DbDataTypes.UInt16:
dr[ i ].Assign( r.GetUInt16( i ) ); break;
case DbDataTypes.UInt32:
dr[ i ].Assign( r.GetUInt32( i ) ); break;
case DbDataTypes.UInt64:
dr[ i ].Assign( r.GetUInt64( i ) ); break;
case DbDataTypes.Float:
dr[ i ].Assign( r.GetFloat( i ) ); break;
case DbDataTypes.Double:
dr[ i ].Assign( r.GetDouble( i ) ); break;
case DbDataTypes.DateTime:
dr[ i ].Assign( r.GetDateTime( i ) ); break;
case DbDataTypes.String:
dr[ i ].Assign( r.GetString( i ) ); break;
case DbDataTypes.Bytes:
var len = (int)r.GetBytes( i, 0, null, 0, 0 );
var buf = new byte[ len ];
r.GetBytes( i, 0, buf, 0, len );
dr[ i ].Assign( buf );
break;
default:
break;
}
}
private Byte getBanned(MySqlDataReader reader)
{
Byte banned = reader.GetByte(7);
return banned;
}
// 取 dr 中某字段的数据并返回
public static object GetValue( DbColumn col, MySqlDataReader r, int idx )
{
switch( col.dataType )
{
case DbDataTypes.Boolean:
return r.GetBoolean( idx );
case DbDataTypes.Int8:
return r.GetSByte( idx );
case DbDataTypes.Int16:
return r.GetInt16( idx );
case DbDataTypes.Int32:
return r.GetInt32( idx );
case DbDataTypes.Int64:
return r.GetInt64( idx );
case DbDataTypes.UInt8:
return r.GetByte( idx );
case DbDataTypes.UInt16:
return r.GetUInt16( idx );
case DbDataTypes.UInt32:
return r.GetUInt32( idx );
case DbDataTypes.UInt64:
return r.GetUInt64( idx );
case DbDataTypes.Float:
return r.GetFloat( idx );
case DbDataTypes.Double:
return r.GetDouble( idx );
case DbDataTypes.DateTime:
return r.GetDateTime( idx );
case DbDataTypes.String:
return r.GetString( idx );
case DbDataTypes.Bytes:
var len = (int)r.GetBytes( idx, 0, null, 0, 0 );
var buf = new byte[ len ];
r.GetBytes( idx, 0, buf, 0, len );
return buf;
default:
throw new Exception( "unsupported DbType" );
}
}
private Byte getGender(MySqlDataReader reader)
{
Byte gender = reader.GetByte(5);
return gender;
}
private void toObject(MySqlDataReader reader)
{
Id = reader.GetUInt32(0);
Email = reader.GetString(1);
Password = reader.GetString(2);
Verifier = reader.GetString(3);
Salt = reader.GetString(4);
Points = reader.GetUInt32(5);
Admin = reader.GetUInt32(6);
Banned = reader.GetByte(7);
extrn_login = reader.GetByte(8);
token = reader.GetString(9);
canhost = reader.GetByte(10);
}
private void Load(MySqlDataReader reader)
{
CharacterID = reader.GetInt32("ID");
RegisterDate = reader.GetDateTime("RegisterDate");
IsChatBlocked = reader.GetBoolean("ChatBlock");
Rank = (GuildAcademyRank)reader.GetByte("Rank");
}
public void LoadFromReader(MySqlDataReader _reader)
{
m_changeid = _reader["changeid"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("changeid") : 0;
mc_changeid = false;
m_folder = _reader["folder"].GetType() != typeof(System.DBNull) ? _reader.GetString("folder") : "";
mc_folder = false;
m_scriptnumber = _reader["scriptnumber"].GetType() != typeof(System.DBNull) ? _reader.GetInt32("scriptnumber") : 0;
mc_scriptnumber = false;
m_scriptname = _reader["scriptname"].GetType() != typeof(System.DBNull) ? _reader.GetString("scriptname") : "";
mc_scriptname = false;
m_startdate = _reader["startdate"].GetType() != typeof(System.DBNull) ? _reader.GetDateTime("startdate") : DateTime.MinValue;
mc_startdate = false;
m_completedate = _reader["completedate"].GetType() != typeof(System.DBNull) ? _reader.GetDateTime("completedate") : DateTime.MinValue;
mc_completedate = false;
m_appliedby = _reader["appliedby"].GetType() != typeof(System.DBNull) ? _reader.GetString("appliedby") : "";
mc_appliedby = false;
m_scriptstatus = _reader["scriptstatus"].GetType() != typeof(System.DBNull) ? _reader.GetByte("scriptstatus") : (byte)0;
mc_scriptstatus = false;
m_scriptoutput = _reader["scriptoutput"].GetType() != typeof(System.DBNull) ? _reader.GetString("scriptoutput") : "";
mc_scriptoutput = false;
}
