: QDialog(parent),

ui(new Ui::PreferencesDialog)

{

ui->setupUi(this);

ui->treeSyntaxHighlighting->setColumnHidden(0, true);

// Model to sort the languages in the language combo box

QSortFilterProxyModel *proxy = new QSortFilterProxyModel(ui->languageComboBox);

proxy->setSourceModel(ui->languageComboBox->model());

// Prevent setModel() from deleting the current model (now source of the proxy model)

ui->languageComboBox->model()->setParent(proxy);

ui->languageComboBox->setModel(proxy);

loadSettings();

{

QString s = QFileDialog::getExistingDirectory(

this,

tr("Choose a directory"),

getSettingsValue("db", "defaultlocation").toString(),

QFileDialog::ShowDirsOnly | QFileDialog::DontResolveSymlinks);

if(!s.isEmpty())

ui->locationEdit->setText(s);

{

ui->encodingComboBox->setCurrentIndex(ui->encodingComboBox->findText(getSettingsValue("db", "defaultencoding").toString(), Qt::MatchFixedString));

ui->locationEdit->setText(getSettingsValue("db", "defaultlocation").toString());

ui->checkHideSchemaLinebreaks->setChecked(getSettingsValue("db", "hideschemalinebreaks").toBool());

ui->foreignKeysCheckBox->setChecked(getSettingsValue("db", "foreignkeys").toBool());

ui->spinPrefetchSize->setValue(getSettingsValue("db", "prefetchsize").toInt());

for(int i=0; i < ui->treeSyntaxHighlighting->topLevelItemCount(); ++i)

{

QString name = ui->treeSyntaxHighlighting->topLevelItem(i)->text(0);

QString colorname = getSettingsValue("syntaxhighlighter", name + "_colour").toString();

QColor color = QColor(colorname);

ui->treeSyntaxHighlighting->topLevelItem(i)->setTextColor(2, color);

ui->treeSyntaxHighlighting->topLevelItem(i)->setBackgroundColor(2, color);

ui->treeSyntaxHighlighting->topLevelItem(i)->setText(2, colorname);

ui->treeSyntaxHighlighting->topLevelItem(i)->setCheckState(3, getSettingsValue("syntaxhighlighter", name + "_bold").toBool() ? Qt::Checked : Qt::Unchecked);

ui->treeSyntaxHighlighting->topLevelItem(i)->setCheckState(4, getSettingsValue("syntaxhighlighter", name + "_italic").toBool() ? Qt::Checked : Qt::Unchecked);

ui->treeSyntaxHighlighting->topLevelItem(i)->setCheckState(5, getSettingsValue("syntaxhighlighter", name + "_underline").toBool() ? Qt::Checked : Qt::Unchecked);

}

ui->spinEditorFontSize->setValue(getSettingsValue("editor", "fontsize").toInt());

ui->spinLogFontSize->setValue(getSettingsValue("log", "fontsize").toInt());

ui->listExtensions->addItems(getSettingsValue("extensions", "list").toStringList());

fillLanguageBox();

{

setSettingsValue("db", "defaultencoding", ui->encodingComboBox->currentText());

setSettingsValue("db", "defaultlocation", ui->locationEdit->text());

setSettingsValue("db", "hideschemalinebreaks", ui->checkHideSchemaLinebreaks->isChecked());

setSettingsValue("db", "foreignkeys", ui->foreignKeysCheckBox->isChecked());

setSettingsValue("db", "prefetchsize", ui->spinPrefetchSize->value());

for(int i=0; i < ui->treeSyntaxHighlighting->topLevelItemCount(); ++i)

{

QString name = ui->treeSyntaxHighlighting->topLevelItem(i)->text(0);

setSettingsValue("syntaxhighlighter", name + "_colour", ui->treeSyntaxHighlighting->topLevelItem(i)->text(2));

setSettingsValue("syntaxhighlighter", name + "_bold", ui->treeSyntaxHighlighting->topLevelItem(i)->checkState(3) == Qt::Checked);

setSettingsValue("syntaxhighlighter", name + "_italic", ui->treeSyntaxHighlighting->topLevelItem(i)->checkState(4) == Qt::Checked);

setSettingsValue("syntaxhighlighter", name + "_underline", ui->treeSyntaxHighlighting->topLevelItem(i)->checkState(5) == Qt::Checked);

}

setSettingsValue("editor", "fontsize", ui->spinEditorFontSize->value());

setSettingsValue("log", "fontsize", ui->spinLogFontSize->value());

QStringList extList;

foreach(QListWidgetItem* item, ui->listExtensions->findItems(QString("*"), Qt::MatchWrap | Qt::MatchWildcard))

extList.append(item->text());

setSettingsValue("extensions", "list", extList);

// Warn about restarting to change language

QVariant newLanguage = ui->languageComboBox->itemData(ui->languageComboBox->currentIndex());

if (newLanguage != getSettingsValue("General", "language"))

QMessageBox::information(this, QApplication::applicationName(),

tr("The language will change after you restart the application."));

setSettingsValue("General", "language", newLanguage);

accept();

{

// Have a look in the cache first

QHash<QString, QVariant>::iterator cacheIndex = m_hCache.find(group + name);

if(cacheIndex != m_hCache.end())

{

return cacheIndex.value();

} else {

// Nothing found in the cache, so get the value from the settings file or get the default value if there is no value set yet

QSettings settings(QApplication::organizationName(), QApplication::organizationName());

QVariant value = settings.value(group + "/" + name, getSettingsDefaultValue(group, name));

// Store this value in the cache for further usage and return it afterwards

m_hCache.insert(group + name, value);

return value;

}

{

// Set the group and save the given value

QSettings settings(QApplication::organizationName(), QApplication::organizationName());

settings.beginGroup(group);

settings.setValue(name, value);

settings.endGroup();

// Also change it in the cache

m_hCache[group + name] = value;

{

// db/defaultencoding?

if(group == "db" && name == "defaultencoding")

return "UTF-8";

// db/defaultlocation?

if(group == "db" && name == "defaultlocation")

return QDir::homePath();

// db/hideschemalinebreaks?

if(group == "db" && name == "hideschemalinebreaks")

return false;

// db/foreignkeys?

if(group == "db" && name == "foreignkeys")

return true;

// db/prefetchsize?

if(group == "db" && name == "prefetchsize")

return 50000;

// MainWindow/geometry?

if(group == "MainWindow" && name == "geometry")

return "";

// MainWindow/windowState?

if(group == "MainWindow" && name == "windowState")

return "";

// SQLLogDock/Log?

if(group == "SQLLogDock" && name == "Log")

return "Application";

// General/recentFileList?

if(group == "General" && name == "recentFileList")

return QStringList();

// General/language?

if(group == "General" && name == "language")

return QLocale::system().name();

// syntaxhighlighter?

if(group == "syntaxhighlighter")

{

// Bold? Only tables, functions and keywords are bold by default

if(name.right(4) == "bold")

return name == "keyword_bold" || name == "table_bold" || name == "function_bold";

// Italic? Nothing by default

if(name.right(6) == "italic")

return false;

// Underline? Nothing by default

if(name.right(9) == "underline")

return false;

// Colour?

if(name.right(6) == "colour")

{

if(name == "keyword_colour")

return QColor(Qt::darkBlue).name();

else if(name == "function_colour")

return QColor(Qt::blue).name();

else if(name == "table_colour")

return QColor(Qt::darkCyan).name();

else if(name == "comment_colour")

return QColor(Qt::darkGreen).name();

else if(name == "identifier_colour")

return QColor(Qt::darkMagenta).name();

else if(name == "string_colour")

return QColor(Qt::red).name();

else if(name == "currentline_colour")

return QColor(236, 236, 245).name();

}

}

// editor/fontsize or log/fontsize?

if((group == "editor" || group == "log") && name == "fontsize")

return 9;

// extensions/list?

if(group == "extensions" && name == "list")

return QStringList();

// Unknown combination of group and name? Return an invalid QVariant!

return QVariant();

{

if(item->text(column).left(1) != "#")

return;

QColor colour = QColorDialog::getColor(QColor(item->text(column)), this);

if(colour.isValid())

{

item->setTextColor(column, colour);

item->setBackgroundColor(column, colour);

item->setText(column, colour.name());

}

{

QString file = QFileDialog::getOpenFileName(

this,

tr("Select extension file"),

PreferencesDialog::getSettingsValue("db", "defaultlocation").toString(),

tr("Extensions(*.so *.dll);;All files(*)"));

if(QFile::exists(file))

ui->listExtensions->addItem(file);

{

if(ui->listExtensions->currentIndex().isValid())

ui->listExtensions->takeItem(ui->listExtensions->currentIndex().row());

{

// Use the path relative to the main executable

QDir translationsDir(QCoreApplication::applicationDirPath() + "/translations",

"sqlb_*.qm");

// Add default language

ui->languageComboBox->addItem("English (United States)", "en_US");

foreach(const QFileInfo &file, translationsDir.entryInfoList())

{

QLocale locale(file.baseName().remove("sqlb_"));

// Prevent invalid locales from being added to the box

if(locale.name() == "C")

continue;

QString language = QLocale::languageToString(locale.language()) + " (" +

QLocale::countryToString(locale.country()) + ")";

ui->languageComboBox->addItem(language, locale.name());

}

ui->languageComboBox->model()->sort(0);

// Try to select the language for the stored locale

int index = ui->languageComboBox->findData(getSettingsValue("General", "language"),

Qt::UserRole, Qt::MatchExactly);

// If there's no translation for the current locale, default to English

if(index < 0)

index = ui->languageComboBox->findData("en_US", Qt::UserRole, Qt::MatchExactly);

ui->languageComboBox->setCurrentIndex(index);