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;
}
