bool load_settings(MythSettingList &settings, const QString &hostname) { MSqlQuery query(MSqlQuery::InitCon()); QString list = extract_query_list(settings, MythSetting::kFile); if (!list.isEmpty()) { QMap<QString,QString> map = GetConfigFileSettingValues(); if (map.isEmpty()) return false; MythSettingList::const_iterator it = settings.begin(); for (; it != settings.end(); ++it) fill_setting(*it, map, MythSetting::kFile); } list = extract_query_list(settings, MythSetting::kHost); QString qstr = "SELECT value, data " "FROM settings " "WHERE hostname = '" + hostname + "' AND " " value in (" + list + ")"; if (!list.isEmpty()) { if (!query.exec(qstr)) { MythDB::DBError("HttpConfig::LoadMythSettings() 1", query); return false; } fill_settings(settings, query, MythSetting::kHost); } list = extract_query_list(settings, MythSetting::kGlobal); qstr = "SELECT value, data " "FROM settings " "WHERE hostname IS NULL AND " " value in (" + list + ")"; if (!list.isEmpty()) { if (!query.exec(qstr)) { MythDB::DBError("HttpConfig::LoadMythSettings() 2", query); return false; } fill_settings(settings, query, MythSetting::kGlobal); } return true; }
bool load_settings(MythSettingList &settings, const QString &hostname) { MSqlQuery query(MSqlQuery::InitCon()); QString list = extract_query_list(settings, MythSetting::kHost); QString qstr = "SELECT value, data " "FROM settings " "WHERE hostname = '" + hostname + "' AND " " value in (" + list + ")"; if (!list.isEmpty()) { if (!query.exec(qstr)) { MythDB::DBError("HttpConfig::LoadMythSettings() 1", query); return false; } fill_settings(settings, query, MythSetting::kHost); } list = extract_query_list(settings, MythSetting::kGlobal); qstr = "SELECT value, data " "FROM settings " "WHERE hostname IS NULL AND " " value in (" + list + ")"; if (!list.isEmpty()) { if (!query.exec(qstr)) { MythDB::DBError("HttpConfig::LoadMythSettings() 2", query); return false; } fill_settings(settings, query, MythSetting::kGlobal); } return true; }