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