public void PilotInformations() { string sqlPilotInformations = "SELECT user_nome, user_apelido, utilizadores.rank, ranks.rank, utilizadores.user_id, utilizadores.levelid, utilizadores.eps from utilizadores left join ranks on utilizadores.rank = ranks.rankid where user_email=@PilotId"; MySqlConnection conn = new MySqlConnection(Login.ConnectionString); try { conn.Open(); MySqlCommand sqlCmd = new MySqlCommand(sqlPilotInformations, conn); sqlCmd.Parameters.AddWithValue("@PilotId", Properties.Settings.Default.Email); MySqlDataReader sqlCmdRes = sqlCmd.ExecuteReader(); if (sqlCmdRes.HasRows) { while (sqlCmdRes.Read()) { result.UserName = (string)sqlCmdRes[0]; result.UserSurname = (string)sqlCmdRes[1]; result.Rank = (string)sqlCmdRes[3]; result.UserID = (int)sqlCmdRes[4]; result.AdminLevel = (int)sqlCmdRes[5]; result.UserEps = (int)sqlCmdRes[6]; } } PilotInfo.PilotInfos(result.UserID); } catch (Exception crap) { MessageBox.Show(crap.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); } }
/// <summary> /// Writes pilot info into a packet /// </summary> /// <param name="packet"></param> /// <param name="info"></param> public static void WritePilotInfo(this ServerBasePacket packet, PilotInfo info) { packet.WriteInt(info.AbilityPointsAvailable); packet.WriteByte((byte)info.HpLevel); packet.WriteByte((byte)info.MoveSpeedLevel); packet.WriteByte((byte)info.EnLevel); packet.WriteByte((byte)info.ScanRangeLevel); packet.WriteByte((byte)info.SpLevel); packet.WriteByte((byte)info.AimLevel); packet.WriteByte(0); // Unknown packet.WriteByte(0); // Unknown packet.WriteInt(info.MeleeLevel); packet.WriteInt(info.RangedLevel); packet.WriteInt(info.SiegeLevel); packet.WriteInt(info.RocketLevel); //packet.WriteInt(0); // Unknown packet.WriteByte(0); // NOTE: Not sure why everything after here is offset by one, so i am just doing 3 bytes instead of 4 here packet.WriteByte(0); packet.WriteByte(0); }
void Awake() { CurrentRoom = null; // Setting up references. groundCheck = transform.Find("groundCheck"); wallClimbCheck = transform.Find("climbWallCheck"); mRoofClimbCheck = transform.Find("climbRoofCheck"); anim = GetComponent<Animator>(); Physics2D.IgnoreLayerCollision(LayerMask.NameToLayer("Climbable"), LayerMask.NameToLayer("Player")); mPilotInfo = new PilotInfo(); mPilotInfo.PlayerName = ""; mLatestCorrectPos = transform.position; mOnUpdatePos = transform.position; }