/// <summary> /// 根据指定的账户查找登录信息 /// </summary> /// <param name="account"></param> /// <returns></returns> public PlayerLoginMessage GetPlayerLoginMessageByAccount(int account) { PlayerLoginMessage playerLoginMessage = null; MySqlCommand cmd = new MySqlCommand("select * from tb_playloginmessage where loginaccount=" + account.ToString(), mySqlConnection); MySqlDataReader reader = null; try { mySqlConnection.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { playerLoginMessage = new PlayerLoginMessage(); playerLoginMessage.LoginId = int.Parse(reader[0].ToString()); playerLoginMessage.LoginAccount = int.Parse(reader[1].ToString()); playerLoginMessage.LoginPassword = reader[2].ToString(); playerLoginMessage.LoginPlayer = int.Parse(reader[3].ToString()); break; } } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { cmd.Dispose(); reader.Close(); mySqlConnection.Close(); } return(playerLoginMessage); }
private Player Login() { var message = new PlayerLoginMessage(PlayerId, _authToken); var rawResponse = _messageSender.Send(message); using (var stream = new MemoryStream(Encoding.UTF8.GetBytes(rawResponse))) { var response = (Response <Player>)_loginResponseSerializer.ReadObject(stream); var player = response.Data[0].Result; _lastLoginTimeSec = player.Liveness.LastLoginTime; return(player); } }
/// <summary> /// 向数据库中插入登录账户信息 /// </summary> /// <param name="playerLoginMessage"></param> public void InsertPlayerLoginMessage(PlayerLoginMessage playerLoginMessage) { string insert_sql = "insert into tb_playloginmessage(loginAccount,loginPassword,playerid) values(" + playerLoginMessage.LoginAccount + ",'" + playerLoginMessage.LoginPassword + "'," + playerLoginMessage.LoginPlayer + ")"; MySqlCommand cmd = new MySqlCommand(insert_sql, mySqlConnection); try { mySqlConnection.Open(); cmd.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { mySqlConnection.Close(); cmd.Dispose(); } }
public void BroadcastPlayerLoginMessage(PlayerLoginMessage message) { OnRaisePlayerLoginEvent(new ScrimMessageEventArgs <PlayerLoginMessage>(message)); TrySaveToLogFile(message.Info); }