public static void loadCommunities(Character chr) { using(var con = new MySqlConnection(MasterServer.Instance.SqlConnection.mConnectionString)) using(var cmd = con.CreateCommand()) { con.Open(); cmd.CommandText = "SELECT * FROM chars_com WHERE charID=" + chr.getuID(); using(var reader = cmd.ExecuteReader()) { reader.Read(); if(!reader.HasRows) { return; } else { Community com = chr.getCommunity(); for(int i = 0;i < 40;i++) { byte type = reader.GetByte(i * 2 + 1); string person = reader.IsDBNull(i * 2 + 2) == true ? null : reader.GetString(i * 2 + 2); if(person != null) com.addPersona(type, person); } } } } }
public static void SaveCommunities(Character chr) { int i = 0; StringBuilder sb = new StringBuilder(); foreach(string s in chr.getCommunity().getFriendsList()) { sb.Append(",t" + i + "=0,n" + i + "=" + s == null ? "null" : "'" + s + "'"); i++; } foreach(string s in chr.getCommunity().getIgnoresList()) { sb.Append(",t" + i + "=1,n" + i + "=" + s == null ? "null" : "'" + s + "'"); i++; } Save("chars_com", sb, "charID", chr.getuID()); return; }