public CGConnect(byte[] bytes) { Stream stream = new MemoryStream(bytes); // read packet id this.ID = (PacketID)ReadUInt16(stream); // read size this.BodySize = ReadUInt32(stream); // read timestamp this.TimeStamp = ReadUInt32(stream); // check packet id if (this.ID == PacketID.CGConnect) { // read authkey this.AuthKey = ReadInt32(stream); // read PCType this.PCType = (PCType)stream.ReadByte(); // read szPCName this.PCName = ReadString(stream); // read MacAddress this.MacAddress = ReadMacAddress(stream); _binit = true; } }
public CLCreatePC(Stream stream) { // read size this.BodySize = ReadUInt32(stream); // read timestamp this.TimeStamp = ReadUInt32(stream); // read Name this.Name = ReadString(stream); // read Slot this.Slot = (Slot)stream.ReadByte(); // read BitSet this.BitSet = (byte)stream.ReadByte(); // read Colors this.ColorHair = ReadUInt16(stream); this.ColorSkin = ReadUInt16(stream); this.ColorShirt = ReadUInt16(stream); this.ColorShirt2 = ReadUInt16(stream); this.ColorJeans = ReadUInt16(stream); this.ColorJeans2 = ReadUInt16(stream); // read STR DEX & INT this.STR = ReadUInt16(stream); this.DEX = ReadUInt16(stream); this.INT = ReadUInt16(stream); // read PCType this.PCType = (PCType)stream.ReadByte(); }
public CLSelectPC(Stream stream) { // read size this.BodySize = ReadUInt32(stream); // read timestamp this.TimeStamp = ReadUInt32(stream); // read name this.Name = ReadString(stream); // read pctype this.PCType = (PCType)stream.ReadByte(); }
public static ErrorID CreatePC(string name, PCType race) { ErrorID result = ErrorID.None; // check if pc exists if (CheckPCExists(name)) { return(ErrorID.AlreadyRegisteredId); } // build query string string cmdstr = String.Format("INSERT INTO PlayerChar (Name, Race) VALUES ('{0}', '{1}')", name, Enum.GetName(typeof(PCType), race)); // execute query MySqlCommand cmd = new MySqlCommand(cmdstr, mysqlconn); int cmdres = cmd.ExecuteNonQuery(); // return result return(result); }
public static PCType GetPCType(string pcname) { PCType result = PCType.NONE; //build query string string cmdstr = String.Format(@"SELECT Race FROM PlayerChar WHERE Name = '{0}'", pcname); //execute query MySqlCommand cmd = new MySqlCommand(cmdstr, mysqlconn); MySqlDataReader datareader = cmd.ExecuteReader(); //read data if (datareader.HasRows) { datareader.Read(); result = (PCType)Enum.Parse(typeof(PCType), datareader.GetString(0)); } datareader.Close(); //return result return(result); }
public static PCInfo[] GetPCInfoList(string userid) { PCInfo[] result = new PCInfo[3]; // build query string string cmdstr = String.Format(@"SELECT SLOT1, SLOT2, SLOT3 FROM Player WHERE UserID = '{0}'", userid); // execute query MySqlCommand cmd = new MySqlCommand(cmdstr, mysqlconn); MySqlDataReader datareader = cmd.ExecuteReader(); // read data if (datareader.HasRows) { datareader.Read(); string name1 = null; string name2 = null; string name3 = null; if (!datareader.IsDBNull(0)) { name1 = datareader.GetString(0); } if (!datareader.IsDBNull(1)) { name2 = datareader.GetString(1); } if (!datareader.IsDBNull(2)) { name3 = datareader.GetString(2); } datareader.Close(); if (name1 != null) { PCType pctype = GetPCType(name1); if (pctype == PCType.SLAYER) { PCSlayerInfo pc = GetPCSlayerInfo(name1); pc.Slot = Slot.SLOT1; result[0] = pc; } else if (pctype == PCType.VAMPIRE) { PCVampireInfo pc = GetPCVampireInfo(name1); pc.Slot = Slot.SLOT1; result[0] = pc; } else if (pctype == PCType.OUSTER) { PCOusterInfo pc = GetPCOusterInfo(name1); pc.Slot = Slot.SLOT1; result[0] = pc; } } if (name2 != null) { PCType pctype = GetPCType(name2); if (pctype == PCType.SLAYER) { PCSlayerInfo pc = GetPCSlayerInfo(name2); pc.Slot = Slot.SLOT2; result[1] = pc; } else if (pctype == PCType.VAMPIRE) { PCVampireInfo pc = GetPCVampireInfo(name2); pc.Slot = Slot.SLOT2; result[1] = pc; } else if (pctype == PCType.OUSTER) { PCOusterInfo pc = GetPCOusterInfo(name2); pc.Slot = Slot.SLOT2; result[1] = pc; } } if (name3 != null) { PCType pctype = GetPCType(name3); if (pctype == PCType.SLAYER) { PCSlayerInfo pc = GetPCSlayerInfo(name3); pc.Slot = Slot.SLOT3; result[2] = pc; } else if (pctype == PCType.VAMPIRE) { PCVampireInfo pc = GetPCVampireInfo(name3); pc.Slot = Slot.SLOT3; result[2] = pc; } else if (pctype == PCType.OUSTER) { PCOusterInfo pc = GetPCOusterInfo(name3); pc.Slot = Slot.SLOT3; result[2] = pc; } } } // return result return(result); }
public static ErrorID CreatePC(string name, PCType race) { ErrorID result = ErrorID.None; // check if pc exists if (CheckPCExists(name)) return ErrorID.AlreadyRegisteredId; // build query string string cmdstr = String.Format("INSERT INTO PlayerChar (Name, Race) VALUES ('{0}', '{1}')", name, Enum.GetName(typeof(PCType), race)); // execute query MySqlCommand cmd = new MySqlCommand(cmdstr, mysqlconn); int cmdres = cmd.ExecuteNonQuery(); // return result return result; }