public void ImportDataFromExcelEquity()
{
string excelFilePath = "C:/Users/ahksysuser06/Desktop/EDISData/International_Equity_Daily_Closing_Price_20131211.xlsx";
// make sure your sheet name is correct, here sheet name is sheet1, so you can change the sheet name if have different
string excelQuery = "select SecId,Name,Symbol from [Sheet1$]";
try
{
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath +
";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'";
OleDbConnection oleConn = new OleDbConnection(excelConnectionString);
oleConn.Open();
OleDbDataReader oleReader = new OleDbCommand(excelQuery, oleConn).ExecuteReader();
//while (oleReader.Read())
//{
// Domain.Portfolio.AggregateRoots.Asset.Equity equity = new AustralianEquity(edisRepo)
// {
// Name = oleReader.GetString(1),
// Sector = oleReader.GetString(0),
// Ticker = oleReader.GetString(2),
// EquityType = EquityTypes.AustralianEquity,
// };
// edisRepo.InsertEquityData(equity);
//}
while (oleReader.Read())
{
Domain.Portfolio.AggregateRoots.Asset.Equity equity = new InternationalEquity(edisRepo)
{
Name = oleReader.GetString(1),
Sector = oleReader.GetString(0),
Ticker = oleReader.GetString(2),
EquityType = EquityTypes.InternationalEquity,
};
edisRepo.InsertEquityData(equity);
}
oleReader.Close();
oleConn.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public object[] DLookupA(string table, string fieldName, string clauses, string[] orderByFieldNames, bool orderByAsc)
{
List<object> data = new List<object>();
bool connectedP = isConnectedDo;
string query = "";
try
{
query = "SELECT " + fieldName + " FROM " + table + " WHERE (" + clauses + ")" + ((orderByFieldNames.Length > 0) ? " ORDER BY " + getOrderByData(orderByFieldNames) + " " + ((orderByAsc) ? "ASC" : "DESC") : "");
if (dbType == DatabaseType.MSSQL)
{
getQueryDbChanger(query, SqlTypes.SELECT);
SqlDataReader Dr = new SqlCommand(query, MSSQLConn).ExecuteReader();
while (Dr.Read())
{
data.Add(Dr[0]);
}
Dr.Close();
}
else if (dbType == DatabaseType.MYSQL)
{
MySqlDataReader Dr = new MySqlCommand(query, MySQLConn).ExecuteReader();
while (Dr.Read())
{
data.Add(Dr[0]);
}
Dr.Close();
}
else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007)
{
OleDbDataReader Dr = new OleDbCommand(query, MSDBSQLConn).ExecuteReader();
while (Dr.Read())
{
data.Add(Dr[0]);
}
Dr.Close();
}
}
catch (Exception eee)
{
OnError(eee);
data.Clear();
data.Add("ERROR: " + eee.Message);
data.Add("ERRORI: " + table);
data.Add("ERRORI: " + fieldName);
data.Add("ERRORI: " + clauses);
data.Add("ERRORI: " + query);
}
finally
{
if (!connectedP)
closeConnection();
}
return data.ToArray();
}
public object DLookup(string table, string fieldName, string clauses, string[] orderByFieldNames, bool orderByAsc)
{
object data = null;
bool connectedP = isConnectedDo;
try
{
string query = "SELECT TOP 1 " + fieldName + " FROM " + table + " WHERE (" + clauses + ")" + ((orderByFieldNames.Length > 0) ? " ORDER BY " + getOrderByData(orderByFieldNames) + " " + ((orderByAsc) ? "ASC" : "DESC") : "");
if (dbType == DatabaseType.MSSQL)
{
getQueryDbChanger(query, SqlTypes.SELECT);
SqlDataReader Dr = new SqlCommand(query, MSSQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
else if (dbType == DatabaseType.MYSQL)
{
MySqlDataReader Dr = new MySqlCommand(query, MySQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007)
{
OleDbDataReader Dr = new OleDbCommand(query, MSDBSQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
}
catch (Exception eee)
{
OnError(eee);
data = eee.Message;
}
finally
{
if (!connectedP)
closeConnection();
}
return data;
}
public object DLookup(string sqlQuery)
{
object data = null;
bool connectedP = isConnectedDo;
try
{
if (dbType == DatabaseType.MSSQL)
{
getQueryDbChanger(sqlQuery, SqlTypes.SELECT);
SqlDataReader Dr = new SqlCommand(sqlQuery, MSSQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
else if (dbType == DatabaseType.MYSQL)
{
MySqlDataReader Dr = new MySqlCommand(sqlQuery, MySQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
else if (dbType == DatabaseType.MSACCESS2003 | dbType == DatabaseType.MSACCESS2007)
{
OleDbDataReader Dr = new OleDbCommand(sqlQuery, MSDBSQLConn).ExecuteReader();
if (Dr.Read())
{
data = Dr[0];
}
Dr.Close();
}
}
catch (Exception eee)
{
OnError(eee);
data = eee.Message;
}
finally
{
if (!connectedP)
closeConnection();
}
return data;
}
public void Logined1()
{
OleDbCommand oleDbCommand = new OleDbCommand("SELECT * FROM Player Where Id=" + Conversions.ToString(this._My_Id), Data.conn_Account);
OleDbDataReader oleDbDataReader = oleDbCommand.ExecuteReader();
if (oleDbDataReader.Read())
{
this._My_Name = Conversions.ToString(oleDbDataReader["Name"]);
this._My_Lv = Conversions.ToInteger(oleDbDataReader["Lv"]);
this._My_Hp = Conversions.ToInteger(oleDbDataReader["Hp"]);
this._My_HpMax = Conversions.ToInteger(oleDbDataReader["Hpmax"]);
this._My_Sp = Conversions.ToInteger(oleDbDataReader["Sp"]);
this._My_SpMax = Conversions.ToInteger(oleDbDataReader["Spmax"]);
this._My_Point = Conversions.ToInteger(oleDbDataReader["Point"]);
this._My_SkillPoint = Conversions.ToInteger(oleDbDataReader["SkillPoint"]);
this._My_Int = Conversions.ToInteger(oleDbDataReader["Int"]);
this._My_Atk = Conversions.ToInteger(oleDbDataReader["Atk"]);
this._My_Def = Conversions.ToInteger(oleDbDataReader["Def"]);
this._My_Hpx = Conversions.ToInteger(oleDbDataReader["Hpx"]);
this._My_Spx = Conversions.ToInteger(oleDbDataReader["Spx"]);
this._My_Agi = Conversions.ToInteger(oleDbDataReader["Agi"]);
this._My_Int2 = Conversions.ToInteger(oleDbDataReader["Int2"]);
this._My_Atk2 = Conversions.ToInteger(oleDbDataReader["Atk2"]);
this._My_Def2 = Conversions.ToInteger(oleDbDataReader["Def2"]);
this._My_Hpx2 = Conversions.ToInteger(oleDbDataReader["Hpx2"]);
this._My_Spx2 = Conversions.ToInteger(oleDbDataReader["Spx2"]);
this._My_Agi2 = Conversions.ToInteger(oleDbDataReader["Agi2"]);
this._My_Texp = Conversions.ToInteger(oleDbDataReader["TExp"]);
this._My_MapId = Conversions.ToInteger(oleDbDataReader["MapId"]);
this._My_MapX = Conversions.ToInteger(oleDbDataReader["MapX"]);
this._My_MapY = Conversions.ToInteger(oleDbDataReader["MapY"]);
this._My_Reborn = Conversions.ToInteger(oleDbDataReader["Reborn"]);
this._My_Job = Conversions.ToInteger(oleDbDataReader["Job"]);
this._My_Sex = Conversions.ToInteger(oleDbDataReader["Sex"]);
this._My_Hair = Conversions.ToInteger(oleDbDataReader["Hair"]);
this._My_Thuoctinh = Conversions.ToInteger(oleDbDataReader["Thuoctinh"]);
this._My_Ghost = Conversions.ToInteger(oleDbDataReader["Ghost"]);
this._My_God = Conversions.ToInteger(oleDbDataReader["God"]);
this._My_Color = Conversions.ToString(oleDbDataReader["Color"]);
this._My_Gold = Conversions.ToInteger(oleDbDataReader["Gold"]);
this._My_Tiengtam = Conversions.ToInteger(oleDbDataReader["Tiengtam"]);
this._My_Gocnhin = Conversions.ToInteger(oleDbDataReader["Gocnhin"]);
this._My_SttPetXuatChien = Conversions.ToInteger(oleDbDataReader["SttPetXuatChien"]);
this._My_Pk = Conversions.ToInteger(oleDbDataReader["Pk"]);
this._My_ThamChien = Conversions.ToInteger(oleDbDataReader["ThamChien"]);
}
oleDbDataReader.Close();
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._hpx, this._My_Hpx);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._spx, this._My_Spx);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._atk, this._My_Atk);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._def, this._My_Def);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._Int, this._My_Int);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._agi, this._My_Agi);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._Hp, this._My_Hp);
Data.PlayerUpdateStatus(this._My_Id, DataStructure.Type_Status._Sp, this._My_Sp);
string text = "";
string text2 = "";
DataStructure.HomdoInfo homdoInfo = Data.TrangbiGetDataItem(this.conn, 1);
DataStructure.HomdoInfo homdoInfo2 = Data.TrangbiGetDataItem(this.conn, 2);
DataStructure.HomdoInfo homdoInfo3 = Data.TrangbiGetDataItem(this.conn, 3);
DataStructure.HomdoInfo homdoInfo4 = Data.TrangbiGetDataItem(this.conn, 4);
DataStructure.HomdoInfo homdoInfo5 = Data.TrangbiGetDataItem(this.conn, 5);
DataStructure.HomdoInfo homdoInfo6 = Data.TrangbiGetDataItem(this.conn, 6);
int iD = homdoInfo._ID;
int iD2 = homdoInfo2._ID;
int iD3 = homdoInfo3._ID;
int iD4 = homdoInfo4._ID;
int iD5 = homdoInfo5._ID;
int iD6 = homdoInfo6._ID;
int doben = homdoInfo._Doben;
int doben2 = homdoInfo2._Doben;
int doben3 = homdoInfo3._Doben;
int doben4 = homdoInfo4._Doben;
int doben5 = homdoInfo5._Doben;
int doben6 = homdoInfo6._Doben;
int @long = homdoInfo._Long;
int long2 = homdoInfo2._Long;
int long3 = homdoInfo3._Long;
int long4 = homdoInfo4._Long;
int long5 = homdoInfo5._Long;
int long6 = homdoInfo6._Long;
int giatriLong = homdoInfo._GiatriLong;
int giatriLong2 = homdoInfo2._GiatriLong;
int giatriLong3 = homdoInfo3._GiatriLong;
int giatriLong4 = homdoInfo4._GiatriLong;
int giatriLong5 = homdoInfo5._GiatriLong;
int giatriLong6 = homdoInfo6._GiatriLong;
int khang = homdoInfo._Khang;
int khang2 = homdoInfo2._Khang;
int khang3 = homdoInfo3._Khang;
int khang4 = homdoInfo4._Khang;
int khang5 = homdoInfo5._Khang;
int khang6 = homdoInfo6._Khang;
int tExp = homdoInfo._TExp;
int tExp2 = homdoInfo2._TExp;
int tExp3 = homdoInfo3._TExp;
int tExp4 = homdoInfo4._TExp;
int tExp5 = homdoInfo5._TExp;
int tExp6 = homdoInfo6._TExp;
checked
{
if (iD > 0)
{
text += Class5.smethod_11(iD);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD),
doben.ToString("X2"),
@long.ToString("X2"),
(giatriLong + 100).ToString("X2"),
khang.ToString("X2"),
Class5.smethod_12(tExp)
});
}
if (iD2 > 0)
{
text += Class5.smethod_11(iD2);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD2),
doben2.ToString("X2"),
long2.ToString("X2"),
(giatriLong2 + 100).ToString("X2"),
khang2.ToString("X2"),
Class5.smethod_12(tExp2)
});
}
if (iD3 > 0)
{
text += Class5.smethod_11(iD3);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD3),
doben3.ToString("X2"),
long3.ToString("X2"),
(giatriLong3 + 100).ToString("X2"),
khang3.ToString("X2"),
Class5.smethod_12(tExp3)
});
}
if (iD4 > 0)
{
text += Class5.smethod_11(iD4);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD4),
doben4.ToString("X2"),
long4.ToString("X2"),
(giatriLong4 + 100).ToString("X2"),
khang4.ToString("X2"),
Class5.smethod_12(tExp4)
});
}
if (iD5 > 0)
{
text += Class5.smethod_11(iD5);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD5),
doben5.ToString("X2"),
long5.ToString("X2"),
(giatriLong5 + 100).ToString("X2"),
khang5.ToString("X2"),
Class5.smethod_12(tExp5)
});
}
if (iD6 > 0)
{
text += Class5.smethod_11(iD6);
text2 = string.Concat(new string[]
{
text2,
Class5.smethod_11(iD6),
doben6.ToString("X2"),
long6.ToString("X2"),
(giatriLong6 + 100).ToString("X2"),
khang6.ToString("X2"),
Class5.smethod_12(tExp6)
});
}
this.UpdateStatusWhenUseItem();
this.Sendpacket("F44402001408F4440300142100");
this.Sendpacket(string.Concat(new string[]
{
"F444",
Class5.smethod_11(33 + (int)Math.Round((double)text.Length / 2.0) + this._My_Name.Length),
"03",
Class5.smethod_12(this._My_Id),
this._My_Sex.ToString("X2"),
this._My_Ghost.ToString("X2"),
this._My_God.ToString("X2"),
Class5.smethod_11(this._My_MapId),
Class5.smethod_11(this._My_MapX),
Class5.smethod_11(this._My_MapY),
this._My_Gocnhin.ToString("X2"),
Class5.smethod_11(this._My_Hair),
this._My_Color,
((int)Math.Round((double)text.Length / 4.0)).ToString("X2"),
text,
"0000000005",
this._My_Reborn.ToString("X2"),
this._My_Job.ToString("X2"),
Class5.smethod_13(this._My_Name)
}));
this.Sendpacket(string.Concat(new string[]
{
"F444",
Class5.smethod_11((int)Math.Round((double)this.GetlistSkill().Length / 2.0) + 113),
"0503",
this._My_Thuoctinh.ToString("X2"),
Class5.smethod_11(this._My_Hp),
Class5.smethod_11(this._My_Sp),
Class5.smethod_11(this._My_Int),
Class5.smethod_11(this._My_Atk),
Class5.smethod_11(this._My_Def),
Class5.smethod_11(this._My_Agi),
Class5.smethod_11(this._My_Hpx),
Class5.smethod_11(this._My_Spx),
this._My_Lv.ToString("X2"),
Class5.smethod_12(this._My_Texp),
Class5.smethod_11(this._My_SkillPoint),
Class5.smethod_11(this._My_Point),
Class5.smethod_12(this._My_Tiengtam),
Class5.smethod_11(this._My_HpMax),
Class5.smethod_11(this._My_SpMax),
Class5.smethod_12(this._My_Atk2),
Class5.smethod_12(this._My_Def2),
Class5.smethod_12(this._My_Int2),
Class5.smethod_12(this._My_Agi2),
Class5.smethod_12(this._My_Hpx2),
Class5.smethod_12(this._My_Spx2),
"F401F401F401F401F40100000000000000000000000000000000000000000000000000000000000000000000000000000000000000",
this.GetlistSkill()
}));
Server.ServerSend_PlayerOnline(this._My_Id, this._My_Sex, this._My_Thuoctinh, this._My_Lv, this._My_Ghost, this._My_God, this._My_MapId, this._My_MapX, this._My_MapY, this._My_Gocnhin, this._My_Hair, this._My_Color, Conversions.ToInteger(iD.ToString()), Conversions.ToInteger(iD2.ToString()), Conversions.ToInteger(iD3.ToString()), Conversions.ToInteger(iD4.ToString()), Conversions.ToInteger(iD5.ToString()), Conversions.ToInteger(iD6.ToString()), this._My_Reborn, this._My_Job, this._My_Name, this._My_SttPetXuatChien, this._My_Pk, this._My_ThamChien);
Server.SendPalyerOnline(this._My_Id);
Data.SendStatusAllPet(this._My_Id);
Server.SendAllParty(this._My_Id);
if (this._My_SttPetXuatChien > 0 & this._My_SttPetXuatChien <= 4)
{
Server.SendToClient(this._My_Id, "F44406001301" + Class5.smethod_12(Data.PetGetData(this.conn, this._My_SttPetXuatChien, DataStructure.Type_Pet._ID)));
}
Data.UpdateStatusPetWhenUseItemLogin(this._My_Id);
this.Sendpacket("F44404002102" + this._My_Pk.ToString("X2") + this._My_ThamChien.ToString("X2"));
string text3 = "";
string text4 = "";
string text5 = "";
OleDbDataReader oleDbDataReader2 = new OleDbCommand("SELECT * FROM Homdo Where Id > 0", this.conn).ExecuteReader();
while (oleDbDataReader2.Read())
{
int num = Conversions.ToInteger(oleDbDataReader2["Slot"]);
int int_ = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._ID]);
int num2 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Count]);
int num3 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Doben]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Thuoctinh]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriThuoctinh]);
int num4 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Long]);
int num5 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriLong]);
int num6 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Khang]);
int int_2 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._TExp]);
text3 = string.Concat(new string[]
{
text3,
num.ToString("X2"),
Class5.smethod_11(int_),
num2.ToString("X2"),
num3.ToString("X2"),
num4.ToString("X2"),
(num5 + 100).ToString("X2"),
num6.ToString("X2"),
Class5.smethod_12(int_2)
});
}
oleDbDataReader2.Close();
oleDbDataReader2 = new OleDbCommand("SELECT * FROM Tuideo Where Id > 0", this.conn).ExecuteReader();
while (oleDbDataReader2.Read())
{
int num7 = Conversions.ToInteger(oleDbDataReader2["Slot"]);
int int_3 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._ID]);
int num8 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Count]);
int num9 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Doben]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Thuoctinh]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriThuoctinh]);
int num10 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Long]);
int num11 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriLong]);
int num12 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Khang]);
int int_4 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._TExp]);
text4 = string.Concat(new string[]
{
text4,
num7.ToString("X2"),
Class5.smethod_11(int_3),
num8.ToString("X2"),
num9.ToString("X2"),
num10.ToString("X2"),
(num11 + 100).ToString("X2"),
num12.ToString("X2"),
Class5.smethod_12(int_4)
});
}
oleDbDataReader2.Close();
oleDbDataReader2 = new OleDbCommand("SELECT * FROM Luulang Where Id > 0", this.conn).ExecuteReader();
while (oleDbDataReader2.Read())
{
int num13 = Conversions.ToInteger(oleDbDataReader2["Slot"]);
int int_5 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._ID]);
int num14 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Count]);
int num15 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Doben]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Thuoctinh]);
Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriThuoctinh]);
int num16 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Long]);
int num17 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._GiatriLong]);
int num18 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._Khang]);
int int_6 = Conversions.ToInteger(oleDbDataReader2[DataStructure.Type_Homdo._TExp]);
text5 = string.Concat(new string[]
{
text5,
num13.ToString("X2"),
Class5.smethod_11(int_5),
num14.ToString("X2"),
num15.ToString("X2"),
num16.ToString("X2"),
(num17 + 100).ToString("X2"),
num18.ToString("X2"),
Class5.smethod_12(int_6)
});
}
oleDbDataReader2.Close();
string text6 = "";
if (text3.Length > 0)
{
text6 = "F444" + Class5.smethod_11(2 + (int)Math.Round((double)text3.Length / 2.0)) + "1705" + text3;
}
if (text4.Length > 0)
{
text6 = string.Concat(new string[]
{
text6,
"F444",
Class5.smethod_11(2 + (int)Math.Round((double)text4.Length / 2.0)),
"172F",
text4
});
}
if (text5.Length > 0)
{
text6 = string.Concat(new string[]
{
text6,
"F444",
Class5.smethod_11(2 + (int)Math.Round((double)text5.Length / 2.0)),
"1766",
text5
});
}
if (text6.Length > 0)
{
this.Sendpacket(text6);
}
this.Sendpacket("F444" + Class5.smethod_11(2 + (int)Math.Round((double)text2.Length / 2.0)) + "170B" + text2);
this.Sendpacket("F4440A001A04" + Class5.smethod_12(this._My_Gold) + "00000000");
string text7 = Class5.smethod_17("TSVN");
this.Sendpacket(string.Concat(new string[]
{
"F444",
Class5.smethod_11(text7.Length + 11),
"2709",
Class5.smethod_12(this._My_Id),
"C4000000",
text7.Length.ToString("X2"),
Class5.smethod_13(text7)
}));
this.Sendpacket("F44402000504F44402000F0A");
this.Sendpacket("F4441000020B00000000323031322F30382F3136");
string text8 = Class5.smethod_17("http://tsonline.ns01.us");
this.Sendpacket("F444" + Class5.smethod_11(text8.Length + 6) + "020B00000000" + Class5.smethod_13(text8));
text8 = Class5.smethod_17("Chúc các bạn vui vẻ!");
this.Sendpacket("F444" + Class5.smethod_11(text8.Length + 6) + "020B00000000" + Class5.smethod_13(text8));
string text9 = "";
int num19 = 1;
do
{
int num20 = this.SkillSaveGetId(num19);
if (num20 > 0)
{
text9 = text9 + "02" + Class5.smethod_11(num20) + num19.ToString("X2");
}
num19++;
}
while (num19 <= 10);
if (text9.Length > 0)
{
text9 = "2801" + text9;
this.Sendpacket("F444" + Class5.smethod_11((int)Math.Round((double)text9.Length / 2.0)) + text9);
}
Data.GetDataItemOnMap(this._My_Id);
this.method_0(9999999);
if (this._My_Hp <= 0)
{
Data.PlayerUpdateDataId(this._My_Id, DataStructure.Type_Player._Hp, 1);
}
int num21 = 1;
do
{
if (Data.PetGetData(this.conn, num21, DataStructure.Type_Pet._ID) > 0 && Data.PetGetData(this.conn, num21, DataStructure.Type_Pet._Hp) <= 0)
{
Data.PetUpdateData(this._My_Id, num21, DataStructure.Type_Pet._Hp, 1);
}
num21++;
}
while (num21 <= 4);
this._My_Logined = 1;
}
}
public virtual string getFieldList(string argString)
{
string cmdText = argString;
string argObject = "";
try
{
string connStr = this.connStr;
string argRoutestr = cls.getParameter(connStr, "Data Source");
string newValue = HttpContext.Current.Server.MapPath(cls.getActualRoute(argRoutestr));
OleDbConnection connection = new OleDbConnection(connStr.Replace(argRoutestr, newValue));
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
argObject = argObject + reader.GetName(i) + "|";
}
if (!cls.isEmpty(argObject))
{
argObject = cls.getLRStr(argObject, "|", "leftr");
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
argObject = "";
this.eMessage = exception.Message;
}
return argObject;
}
public virtual object[] getDataAry(string argString)
{
this.rState = 0;
string cmdText = argString;
object[] objArray = null;
try
{
string connStr = this.connStr;
string argRoutestr = cls.getParameter(connStr, "Data Source");
string newValue = HttpContext.Current.Server.MapPath(cls.getActualRoute(argRoutestr));
OleDbConnection connection = new OleDbConnection(connStr.Replace(argRoutestr, newValue));
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
object[,] objArray2 = null;
while (reader.Read())
{
objArray2 = new object[fieldCount, 2];
for (int i = 0; i < fieldCount; i++)
{
objArray2[i, 0] = reader.GetName(i);
objArray2[i, 1] = reader.GetValue(i);
}
objArray = cls.mergeAry(objArray, objArray2);
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
this.rState = 1;
objArray = null;
this.eMessage = exception.Message;
}
return objArray;
}
public virtual string getFieldList(string argString)
{
string cmdText = argString;
string argObject = "";
try
{
OleDbConnection connection = new OleDbConnection(this.connStr);
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
argObject = argObject + reader.GetName(i) + "|";
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
argObject = "";
this.eMessage = exception.Message;
}
return argObject;
}
public virtual Dictionary<string, object>[] getDataAry(string strSQL)
{
this.rState = 0;
Dictionary<string, object>[] rsArray = null;
if ((string)strSQL != "")
{
try
{
OleDbConnection connection = new OleDbConnection(this.connStr);
connection.Open();
OleDbDataReader reader = new OleDbCommand(strSQL, connection).ExecuteReader();
Dictionary<int, object> rsList = new Dictionary<int, object>();
int fieldCount = reader.FieldCount;
int num = 0;
while (reader.Read())
{
Dictionary<string, object> rec = new Dictionary<string, object>();
for (int i = 0; i < fieldCount; i++)
{
rec.Add(reader.GetName(i), reader.GetValue(i));
}
rsList.Add(num, rec);
num ++;
}
reader.Close();
connection.Close();
rsArray = new Dictionary<string, object>[num];
foreach (var kv in rsList)
{
rsArray[kv.Key] = (Dictionary<string, object>)kv.Value;
}
}
catch (Exception exception)
{
this.rState = 1;
var errMsg = new Dictionary<string, object>();
errMsg.Add("msg", "Operate DB Error: " + exception.Message);
rsArray = new Dictionary<string, object>[] { errMsg };
this.eMessage = exception.Message;
}
}
else
{
this.rState = 999;
}
return rsArray;
}