private void HandleClr(GameServerClient client, int nID, byte[] cmdParams, int count)
{
string cmdDatas = new UTF8Encoding().GetString(cmdParams, 0, count);
string[] fields = cmdDatas.Split(new char[]
{
':'
});
int kingType = Convert.ToInt32(fields[0]);
KingRoleGetData data = DataHelper.BytesToObject <KingRoleGetData>(cmdParams, 0, count);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
string sql = string.Format("DELETE FROM t_king_role_data WHERE king_type={0}", kingType);
client.sendCmd <bool>(nID, conn.ExecuteNonQueryBool(sql, 0));
}
}
private void HandleGet(GameServerClient client, int nID, byte[] cmdParams, int count)
{
KingRoleGetData data = DataHelper.BytesToObject <KingRoleGetData>(cmdParams, 0, count);
string sql = string.Format("SELECT roledata_ex FROM t_king_role_data WHERE king_type={0}", data.KingType);
using (MyDbConnection3 conn = new MyDbConnection3(false))
{
MySQLDataReader reader = conn.ExecuteReader(sql, new MySQLParameter[0]);
RoleDataEx rd = new RoleDataEx
{
RoleID = -1
};
if (reader.Read())
{
string s = new ASCIIEncoding().GetString((byte[])reader["roledata_ex"]);
byte[] d = Convert.FromBase64String(s);
rd = DataHelper.BytesToObject <RoleDataEx>(d, 0, d.Length);
}
client.sendCmd <RoleDataEx>(nID, rd);
}
}
