public void GetProfileData()
{
var connection = SqlConnection.Instance();
connection.DatabaseName = "lorisangel";
string[] columns = { "background", "avatar", "colour" };
try
{
var rows = SqlHelper.SelectDataFromTable <ProfileDatabaseRow>(connection, "profiles", columns, $"id = '{User.Id}'");
if (rows.Count > 0)
{
Data = new ProfileData(rows[0].background, rows[0].avatar, rows[0].colour);
}
else
{
Data = new ProfileData();
string[] insColumns = { "id", "background", "avatar", "colour" };
object[] values = { User.Id, Data.Background, Data.AssembleAvatarString(), Data.Colour };
SqlHelper.InsertIntoTable(connection, "profiles", insColumns, values);
}
}
catch (Exception ex)
{
Util.Log(LogType.Error, "MySql", ex.Message);
}
}
