public static void WriteLog(int iAccountID, Enums.LogMainType eMainType, Enums.LogSubType eSubType, string sIDParam = "", string sBeforeValue = "", string sNextValue = "")
{
MySqlCommand cCommand = new MySqlCommand();
cCommand.Connection = Connection;
if (null == _cConnection)
{
return;
}
cCommand.CommandText = "INSERT INTO *(*, *, *, *, *, *, *, *) VALUES (@*, @*, @*, @*, @*, @*, @*, @*);";
cCommand.Parameters.Add("@*", MySqlDbType.Int32, 10);
cCommand.Parameters.Add("@*", MySqlDbType.VarChar);
cCommand.Parameters.Add("@*", MySqlDbType.VarChar);
cCommand.Parameters.Add("@*", MySqlDbType.VarChar);
cCommand.Parameters.Add("@*", MySqlDbType.VarChar);
cCommand.Parameters.Add("@*", MySqlDbType.VarChar);
cCommand.Parameters.Add("@*", MySqlDbType.Date);
cCommand.Parameters.Add("@*", MySqlDbType.Time);
cCommand.Parameters[0].Value = iAccountID;
cCommand.Parameters[1].Value = eMainType.ToString();
cCommand.Parameters[2].Value = eSubType.ToString();
cCommand.Parameters[3].Value = sIDParam;
cCommand.Parameters[4].Value = sBeforeValue;
cCommand.Parameters[5].Value = sNextValue;
cCommand.Parameters[6].Value = DateTimeUtil.ToSqlDate(DateTime.Now);
cCommand.Parameters[7].Value = DateTimeUtil.ToSqlTime(DateTime.Now);
try
{
//Debug.Log(" - [MySqlUtil : WriteLog] open : " + iAccountID.ToString());
cCommand.ExecuteNonQuery();
}
catch (Exception ce)
{
FileLogUtil.Log("[MySqlUtil : WriteLog] Exception : " + ce.ToString());
cCommand.Dispose();
//Debug.Log(" - [MySqlUtil : WriteLog] close : " + iAccountID.ToString());
return;
}
cCommand.Dispose();
//Debug.Log(" - [MySqlUtil : WriteLog] close : " + iAccountID.ToString());
}
public static Enums.ErrorCode GetRankingData(out DataSet cDataSet)
{
Shik.LastUpdate();
string sCommand = "select " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".*, " + _sTableName + ".* from " + _sTableName + " where not disable=1;";
MySqlDataAdapter cAdapter = new MySqlDataAdapter(sCommand, Connection);
cDataSet = new DataSet();
try
{
cAdapter.Fill(cDataSet);
}
catch (Exception ce)
{
FileLogUtil.Log("ERROR - GetRankingData" + ce.Message);
cAdapter.Dispose();
return(Enums.ErrorCode.eDB_ExecuteError);
}
cAdapter.Dispose();
return(Enums.ErrorCode.eNone);
}
public static MySqlUtilResult ConnectToDB(ref string sError)
{
_sTableName = "G";
if (Enums.DBTableType.eTestGame == ServerState.Manager.DBTableType)
{
_sTableName = "T";
}
string sConnectionString = "";
switch ((Enums.DBServerType)ServerState.Manager.DBType)
{
case Enums.DBServerType.A:
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
break;
case Enums.DBServerType.B:
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
break;
case Enums.DBServerType.C:
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
sConnectionString += @"*";
break;
}
_cConnection = new MySqlConnection(sConnectionString);
try
{
_cConnection.Open();
}
catch (Exception c)
{
_sListConnectionFailError.Add(c.ToString());
_cConnection = null;
sError = c.ToString();
return(MySqlUtilResult.eConnectionError);
}
FileLogUtil.Log("Reconnection DB - DBType : " + ServerState.Manager.DBType.ToString() + ", DBTableType : " + _sTableName);
return(MySqlUtilResult.eOK);
}