it's easy
public static void SaveCharacterSettings(Player player, int id)
{
try
{
MySqlConnector.Execute("INSERT INTO character_settings (charId, setting_" + id + ") VALUES (" +
player.PlayerId + ",0x" +
Functions.BytesToHex(id == 1 ? player.Setting1 : new byte[] {0x00}) +
") ON DUPLICATE KEY UPDATE setting_" + id + " = 0x" +
Functions.BytesToHex(id == 1 ? player.Setting1 : new byte[] {0x00}));
}
catch (Exception e)
{
Logger.Log.WarnException("DbScrPlayer: Can't insert or update char settings.", e);
}
}