public static GR5_Persona GetPersona(ClientInfo client) { List <List <string> > results = GetQueryResults("SELECT * FROM personas WHERE pid=" + client.PID); foreach (List <string> entry in results) { GR5_Persona p = new GR5_Persona(); p.PersonaID = client.PID; p.Name = client.name; p.PortraitID = Convert.ToUInt32(entry[3]); p.DecoratorID = Convert.ToUInt32(entry[4]); p.AvatarBackgroundColor = Convert.ToUInt32(entry[5]); p.GRCash = Convert.ToUInt32(entry[6]); p.IGC = Convert.ToUInt32(entry[7]); p.AchievementPoints = Convert.ToUInt32(entry[8]); p.LastUsedCharacterID = Convert.ToByte(entry[9]); p.MaxInventorySlot = Convert.ToUInt32(entry[10]); p.MaxScrapYardSlot = Convert.ToUInt32(entry[11]); p.GhostRank = Convert.ToUInt32(entry[12]); p.Flag = Convert.ToUInt32(entry[13]); return(p); } return(null); }
public RMCPacketResponsePlayerProfileService_LoadCharacterProfiles(ClientInfo client) { persona = DBHelper.GetPersona(client); characters = DBHelper.GetCharacters(client.PID); }