Home › Database access › SQL statements in the exe

Engine executable. Settings and tools of the game program (CivilizationVI.exe), usable without a mod. Mostly undocumented debug and configuration functionality; descriptions come from analysis of the executable and have not all been tried in the running game.

SQL statements in the exe

Grouped by the subsystem of the function that uses them. ? and @name are bound parameters.

AmbientAudio (2)
Statement Used by Database
SELECT count(*) from CivilizationAudioTags AmbientAudio::StartupStrategyGame game databases
SELECT CivilizationType, MusicOverride from CivilizationAudioTags AmbientAudio::StartupStrategyGame game databases
AppLuaDBLibrary (3)
Statement Used by Database
SELECT rowid, * FROM %s order by rowid AppLuaDBLibrary::lua_RegisterDatabase game databases
SELECT BaseTable, PropertyName, TargetTable, IsCollection, Query from NavigationProperties; AppLuaDBLibrary::lua_RegisterDatabase game databases
SELECT Name, Value FROM GlobalParameters AppLuaDBLibrary::lua_RegisterGlobalParametersLibrary game databases
AppLuaGameSummaryLibrary (17)
Statement Used by Database
SELECT NULL as RulesetType, * from StatisticCategories where Category NOT IN(Select Category from StatisticCategoryRulesetOverrides where RulesetType = ?1) UNION Select * from StatisticCategoryRulesetOverrides where RulesetType = ?1 AppLuaGameSummaryLibrary::lGetStatisticsCategories game databases
SELECT NULL as RulesetType, * from Statistics where Visible = 1 and DataPoint NOT IN(Select DataPoint from StatisticRulesetOverrides where RulesetType = ?1) UNION Select * from StatisticRulesetOverrides where Visible = 1 and RulesetType = ?1 AppLuaGameSummaryLibrary::lGetStatistics game databases
SELECT GamePlayers.PlayerObjectId from GamePlayers inner join GameObjects on GamePlayers.PlayerObjectId = GameObjects.ObjectId where GameObjects.GameId = ? AppLuaGameSummaryLibrary::lGetGraphs; AppLuaGameSummaryLibrary::lGetReports HallofFame.sqlite
SELECT MIN(X), MAX(X) from DataSetValues where DataSetId = ? AppLuaGameSummaryLibrary::lGetGraphs HallofFame.sqlite
SELECT X,Y from DataSetValues where DataSetId = ? order by X AppLuaGameSummaryLibrary::lGetGraphs HallofFame.sqlite
SELECT * from Graphs inner join GraphQueries on Graphs.Query = GraphQueries.Query where Scope = ? AppLuaGameSummaryLibrary::lGetGraphs game databases
SELECT NULL as RulesetType, * from Graphs g inner join GraphQueries gq on g.Query = gq.Query where Visible = 1 and Scope = ?1 and g.Graph NOT IN(SELECT Graph from GraphRulesetOverrides where RulesetType = ?2 and Scope = ?1) UNION SELECT * from GraphRulesetOverrides g inner join GraphQueries gq on g.Query = gq.Query where Visible = 1 and RulesetType = ?2 and Scope = ?1 AppLuaGameSummaryLibrary::lGetGraphs game databases
SELECT * from Reports inner join ReportQueries on Reports.Query = ReportQueries.Query where Scope = ? AppLuaGameSummaryLibrary::lGetReports game databases
SELECT * from ReportColumns where Report = ? order by SortOrder AppLuaGameSummaryLibrary::lGetReports game databases
SELECT NULL as RulesetType, * from Reports r inner join ReportQueries rq on r.Query = rq.Query where Visible = 1 and Scope = ?1 and r.Report NOT IN(SELECT Report from ReportRulesetOverrides where Scope = ?1 and RulesetType = ?2) UNION SELECT * from ReportRulesetOverrides r inner join ReportQueries rq on r.Query = rq.Query where Visible = 1 and Scope = ?1 and RulesetType = ?2 AppLuaGameSummaryLibrary::lGetReports game databases
SELECT NULL as RulesetType, * from ReportColumns where Visible = 1 and Report = ?1 and Report NOT IN(SELECT Report from ReportColumnRulesetOverrides where Report = ?1 and RulesetType = ?2) UNION SELECT * from ReportColumnRulesetOverrides where Visible = 1 and Report = ?1 and RulesetType = ?2 ORDER BY SortOrder AppLuaGameSummaryLibrary::lGetReports game databases
SELECT RulesetType as 'Ruleset', Name, Description, IsScenario, SortIndex from Rulesets AppLuaGameSummaryLibrary::lGetAvailableRulesets game databases
SELECT Domain from RulesetDomainOverrides where Ruleset = ? and ParameterId = 'PlayerLeader' LIMIT 1 AppLuaGameSummaryLibrary::lGetLeaderProgress; AppLuaGameSummaryLibrary::lGetRulesetPlayableLeaders game databases
SELECT LeaderType, LeaderName, CivilizationType, CivilizationName, LeaderIcon, CivilizationIcon from Players where Domain = @Domain and HumanPlayable = 1 and LeaderType not in (select value from RulesetUnSupportedValues where Domain=@Domain and Ruleset=@Ruleset) AppLuaGameSummaryLibrary::lGetLeaderProgress; AppLuaGameSummaryLibrary::lGetRulesetPlayableLeaders game databases
SELECT VictoryType as 'Type', Name, Icon from Victories where Domain = ? and Visible = 1 AppLuaGameSummaryLibrary::lGetVictoryProgress game databases
select VictoryType, GamePlayers.LeaderType from Games inner join GamePlayers on GamePlayers.PlayerObjectId = (select GamePlayers.PlayerObjectId from GamePlayers inner join GameObjects on GamePlayers.PlayerObjectId = GameObjects.ObjectId where GamePlayers.IsLocal = 1 and GameObjects.GameId = Games.GameId and GamePlayers.TeamId = Games.VictorTeamId order by GamePlayers.PlayerId limit 1)where Games.Ruleset = ? and GameId not in (SELECT GameId FROM ChallengeGames) order by LastPlayed desc AppLuaGameSummaryLibrary::lGetVictoryProgress HallofFame.sqlite
SELECT Type, Kind, Name, Icon from RulesetTypes where Ruleset = ? AppLuaGameSummaryLibrary::lGetRulesetTypes game databases
AppLuaLocaleLibrary (1)
Statement Used by Database
SELECT AudioLanguage, Locale from AudioLanguages ORDER BY AudioLanguage AppLuaLocaleLibrary::lGetAudioLanguages game databases
AppLuaSearchLibrary (1)
Statement Used by Database
SELECT TranslateCharacter FROM CivilopediaTranslateCharacters where Character = ? AppLuaSearchLibrary::lAddData game databases
AppModdingFramework (1)
Statement Used by Database
SELECT PackageId, DllPrefix, GameCores.GameCore from GameCores inner join Rulesets on Rulesets.GameCore = GameCores.GameCore where RuleSetType = ? LIMIT 1 AppModdingFramework::GetDLLPathFromConfig Mods.sqlite
AppUIManager (3)
Statement Used by Database
SELECT SupportsSmallCaps FROM Languages WHERE Locale = ? LIMIT 1 AppUIManager::AppUIManager game databases
SELECT StyleSheet, DefaultFont from FontStyleSheets where Language = ? LIMIT 1 AppUIManager::GetStyleSheetAndDefaultFont game databases
SELECT StyleOverride FROM FontStyleSheets WHERE Language = ? LIMIT 1 AppUIManager::GetStyleSheetLanguageOverrides game databases
Application::Data (10)
Statement Used by Database
PRAGMA foreign_keys = ON; Application::Data::ConfigurationDatabase::CreateConnection; Application::Data::GameplayDatabase::CreateConnection (+5) game databases
PRAGMA recursive_triggers = ON; Application::Data::ConfigurationDatabase::CreateConnection; Application::Data::GameplayDatabase::CreateConnection game databases
INSERT INTO %s(%s, rank) VALUES('rank', 'bm25(15.0, 10.0, 5.0)') Application::Data::FullTextSearch::CreateContext game databases
INSERT INTO %s(type, name, description, tags) values(?,?,?,?) Application::Data::FullTextSearch::CreateContext game databases
DELETE FROM %s Application::Data::FullTextSearch::ClearData game databases
INSERT INTO %s(%s) VALUES('optimize'); Application::Data::FullTextSearch::Optimize game databases
PRAGMA foreign_keys = OFF; Application::Data::GameplayDatabase::Bootstrap game databases
PRAGMA defer_foreign_keys = OFF; Application::Data::GameplayDatabase::Bootstrap game databases
SELECT Value from GlobalParameters where Name = ? LIMIT 1 Application::Data::GameplayDatabase::Initialize game databases
SELECT SQL from Migrations where MinVersion <= ?1 AND MaxVersion >= ?1 ORDER by SortIndex Application::Data::GameSummaryDatabase::MigrateDatabaseData Mods.sqlite
Application::GameSummary (16)
Statement Used by Database
DELETE FROM Games WHERE GameId = ? Application::GameSummary::DeleteGame HallofFame.sqlite
SELECT seq from sqlite_sequence where name = ? LIMIT 1 Application::GameSummary::BeginGameTransfer game databases
INSERT INTO Games('Ruleset','GameMode','TurnCount','GameSpeedType','MapSizeType','Map','StartEraType','StartTurn','VictorTeamId','VictoryType','LastPlayed') VALUES(?,?,?,?,?,?,?,?,?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO GameObjects('GameId','PlayerObjectId','Type','Name','PlotIndex','ExtraData','Icon') VALUES(?,?,?,?,?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO GamePlayers('PlayerObjectId','IsLocal','IsAI','IsMajor','LeaderType','LeaderName','CivilizationType', 'CivilizationName','DifficultyType','Score','PlayerId','TeamId') VALUES(?,?,?,?,?,?,?,?,?,?,?,?) Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO ObjectDataPointValues('DataPoint','ObjectId','ValueObjectId','ValueType','ValueString','ValueNumeric') VALUES(?,?,?,?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO GameDataPointValues('DataPoint','GameId','ValueObjectId','ValueType','ValueString','ValueNumeric') VALUES(?,?,?,?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO DataSets('DataSet','ObjectId','Type') VALUES(?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO DataSets('DataSet','GameId','Type') VALUES(?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO DataSetValues('DataSetId','X','Y') VALUES(?,?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
INSERT INTO ChallengeGames('ChallengeId','GameId') VALUES(?,?); Application::GameSummary::BeginGameTransfer HallofFame.sqlite
SELECT AggregateDataPoint from DataPointAggregateUpdates where Scope = ? order by SortIndex Application::GameSummary::DeleteAggregateDataPoints game databases
DELETE FROM RulesetDataPointValues where DataPoint = ? and Ruleset =? Application::GameSummary::DeleteAggregateDataPoints HallofFame.sqlite
SELECT AggregateDataPoint, Operation, DataPoint, ExtraData, DataPointAggregateUpdates.Query, SQL from DataPointAggregateUpdates inner join DataPointAggregateQueries using(Query) where Scope = ? order by SortIndex Application::GameSummary::UpdateAggregateDataPoints game databases
SELECT 1 FROM ObjectDataPointValues WHERE DataPoint = @DataPoint AND ObjectId = @ObjectId LIMIT 1 Application::GameSummary::UpdateAggregateDataPoints HallofFame.sqlite
SELECT 1 FROM GameDataPointValues where DataPoint = @DataPoint and GameId = @GameId LIMIT 1 Application::GameSummary::UpdateAggregateDataPoints HallofFame.sqlite
Civ6App (2)
Statement Used by Database
SELECT AudioLanguage from DefaultAudioLanguages where Locale = ? LIMIT 1 Civ6App::UpdateLanguageIniSettings game databases
SELECT Locale from SteamLanguages where SteamLanguage = ? LIMIT 1 Civ6App::UpdateLanguageIniSettings game databases
CivTech::Input (3)
Statement Used by Database
SELECT ActionId, InputActions.Name AS 'Name',Description, InputCategories.Name AS 'Category', InputContexts.Value AS 'Context', LayoutType FROM InputActions INNER JOIN InputCategories ON InputActions.CategoryId = InputCategories.CategoryId INNER JOIN InputContexts ON InputActions.ContextId = InputContexts.ContextId ORDER BY InputActions.ActionId CivTech::Input::Manager::ReloadInputActions game databases
SELECT "Index", GestureType, GestureData FROM InputActionDefaultGestures WHERE ActionId = ? CivTech::Input::Manager::ReloadInputActions game databases
SELECT KeyId, KeyString, KeyIcon, KeyType FROM InputKeyData CivTech::Input::Manager::LoadKeyData game databases
Database::XMLSerializer (3)
Statement Used by Database
DELETE FROM %s WHERE %s NOT IN (SELECT %s FROM %s) Database::XMLSerializer::DeleteMissingReferences game databases
DELETE FROM Database::XMLSerializer::DeleteRow game databases
UPDATE Database::XMLSerializer::UpdateRow game databases
DatabaseIconProvider (3)
Statement Used by Database
SELECT Name, OtherName from IconAliases DatabaseIconProvider::ScrapeDatabase game databases
SELECT Name, IconSize, IconsPerRow, FileName, OffsetH, OffsetV, Baseline from IconTextureAtlases order by Name, IconSize DESC DatabaseIconProvider::ScrapeDatabase game databases
SELECT Name, Atlas, "Index" from IconDefinitions order by Name DatabaseIconProvider::ScrapeDatabase game databases
GameCore::App (10)
Statement Used by Database
SELECT L.LeaderType from Leaders as L inner join CivilizationLeaders AS CL on CL.LeaderType = L.LeaderType inner join Civilizations as C on CL.CivilizationType = C.CivilizationType where IsBarbarianLeader=0 and StartingCivilizationLevelType='CIVILIZATION_LEVEL_FULL_CIV' ORDER BY L.rowid GameCore::App::Telemetry::Listener::OnPostLoadBegin game databases
SELECT count(*) from Eras GameCore::App::UI::Tree::TreeManager::GetEraList game databases
SELECT EraType, ChronologyIndex from Eras GameCore::App::UI::Tree::TreeManager::GetEraList game databases
SELECT Cost, EraType, UITreeRow FROM %s where %s = ? GameCore::App::UI::Tree::TreeManager::GetListFromGameCore game databases
SELECT 1 FROM sqlite_master where type='table' AND name='%s' LIMIT 1 GameCore::App::UI::Tree::TreeManager::GetListFromDB; GameCore::App::UI::Tree::TreeManager::GetListFromGameCore game databases
SELECT RandomPrereqs from %s WHERE %s = ? GameCore::App::UI::Tree::TreeManager::GetListFromDB; GameCore::App::UI::Tree::TreeManager::GetListFromGameCore game databases
SELECT count(*) FROM %s GameCore::App::UI::Tree::TreeManager::GetListFromDB game databases
SELECT rowid, %s, Cost, EraType, UITreeRow FROM %s GameCore::App::UI::Tree::TreeManager::GetListFromDB game databases
SELECT %s from %sPrereqs WHERE %s = ? GameCore::App::UI::Tree::TreeManager::GetListFromDB game databases
SELECT %s FROM %s WHERE %s = ? GameCore::App::UI::Tree::TreeManager::GetUnlocks; GameCore::App::UI::Tree::TreeManager::GetUnlocksForDBRow game databases
GameCore::Color (7)
Statement Used by Database
INSERT INTO Colors(Type, Color) VALUES(?,?) GameCore::Color::Manager::PopulateDatabase game databases
SELECT Type, Color, Red, Green, Blue, Alpha from Colors GameCore::Color::Manager::PopulateDatabase game databases
INSERT INTO PlayerColors(Type, Usage, PrimaryColor, SecondaryColor) VALUES(?,?,?,?) GameCore::Color::Manager::PopulateDatabase game databases
SELECT Type, Usage, PrimaryColor, SecondaryColor from PlayerColors GameCore::Color::Manager::PopulateDatabase game databases
SELECT count(*) from Colors GameCore::Color::Manager::ScrapeDatabase game databases
SELECT Type, Color from Colors GameCore::Color::Manager::ScrapeDatabase game databases
SELECT Type, Usage, PrimaryColor, SecondaryColor, Alt1PrimaryColor, Alt1SecondaryColor, Alt2PrimaryColor, Alt2SecondaryColor, Alt3PrimaryColor, Alt3SecondaryColor from PlayerColors GameCore::Color::Manager::ScrapeDatabase game databases
GameCore::Serializer (7)
Statement Used by Database
SELECT Type, Value from StartPositions GameCore::Serializer::Manager::ApplyModdingState Mods.sqlite
SELECT CivilizationType from Players GameCore::Serializer::Manager::ApplyModdingState Mods.sqlite
SELECT Value from MapAttributes where Name = 'Ruleset' LIMIT 1 GameCore::Serializer::Manager::ApplyModdingState Mods.sqlite
SELECT Value from MetaData where Name = 'IsMod' LIMIT 1 GameCore::Serializer::Manager::ApplyModdingState; Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT ID FROM ModDependencies GameCore::Serializer::Manager::ApplyModdingState Mods.sqlite
INSERT INTO MetaData (Name, Value) VALUES (?,?) GameCore::Serializer::Manager::SaveMetaData; 0x8b23a0 Mods.sqlite
SELECT Value from ModProperties where Name = 'DBVersion' GameCore::Serializer::Manager::UnserializeWorldBuilderState; ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
GameCoreInUseCriterion (1)
Statement Used by Database
SELECT GameCore FROM Rulesets WHERE RuleSetType = ? LIMIT 1 GameCoreInUseCriterion::BeforeCheck game databases
Modding::FileService (5)
Statement Used by Database
SELECT Path from ModFiles a inner join ComponentFiles b on a.FileRowId = b.FileRowId where b.ComponentRowId = ? ORDER BY b.Priority DESC, Path ASC Modding::FileService::Initialize Mods.sqlite
SELECT Path from ModFiles a inner join SettingFiles b on a.FileRowId = b.FileRowId where b.SettingRowId = ? ORDER BY b.Priority DESC, Path ASC Modding::FileService::Initialize Mods.sqlite
SELECT Path FROM ModFiles WHERE ModRowId = ? ORDER BY Path ASC Modding::FileService::Initialize Mods.sqlite
SELECT 1 FROM ModFiles WHERE ModRowId = ? AND Path = ? LIMIT 1 Modding::FileService::Initialize Mods.sqlite
SELECT Path FROM ScannedFiles INNER JOIN Mods ON ScannedFiles.ScannedFileRowId = Mods.ScannedFileRowId WHERE ModRowId = ? LIMIT 1 Modding::FileService::Initialize Mods.sqlite
Modding::Framework (26)
Statement Used by Database
SELECT 1 FROM ModCompatibilityWhitelist WHERE ModRowId = ? AND GameVersion = ? LIMIT 1 Modding::Framework::IsModIgnoreCompatibility Mods.sqlite
SELECT 1 FROM Mods WHERE ModId = ? LIMIT 1 Modding::Framework::IsModInstalled Mods.sqlite
SELECT 1 FROM Mods WHERE ModRowId = ? LIMIT 1 Modding::Framework::IsModHandleValid Mods.sqlite
SELECT ModRowId FROM Mods WHERE ModId = ? ORDER BY ModRowId LIMIT 1 Modding::Framework::GetModHandle; Modding::Framework::EnableMods (+1) Mods.sqlite
SELECT ModId FROM Mods WHERE ModRowId = ? LIMIT 1 Modding::Framework::GetModId Mods.sqlite
SELECT Version FROM Mods WHERE ModRowId = ? LIMIT 1 Modding::Framework::GetModVersion Mods.sqlite
SELECT ModRowId FROM Mods ORDER BY ModRowId Modding::Framework::GetInstalledMods Mods.sqlite
SELECT ModGroupItems.ModRowId, Disabled FROM ModGroupItems WHERE ModGroupItems.ModGroupRowId = ? ORDER BY ModGroupItems.ModRowId Modding::Framework::GetEnabledMods Mods.sqlite
DELETE FROM ModGroupItems where ModGroupRowId = ? Modding::Framework::ResetGroup Mods.sqlite
SELECT SettingRowId FROM Settings WHERE ModRowId = ? ORDER BY SettingRowId; Modding::Framework::GetModSettings Mods.sqlite
SELECT SettingId FROM Settings WHERE SettingRowId = ? LIMIT 1 Modding::Framework::GetSettingId; 0xb35a10 Mods.sqlite
SELECT ModRowId FROM Settings WHERE SettingRowId = ? LIMIT 1 Modding::Framework::GetSettingModHandle; 0xb35ac0 Mods.sqlite
SELECT SettingType FROM Settings WHERE SettingRowId = ? LIMIT 1 Modding::Framework::GetSettingType Mods.sqlite
SELECT ComponentRowId FROM Components WHERE ModRowId = ? ORDER BY ComponentRowId Modding::Framework::GetModComponents Mods.sqlite
SELECT ComponentId FROM Components WHERE ComponentRowId = ? LIMIT 1 Modding::Framework::GetComponentId; 0xb32ac0 Mods.sqlite
SELECT ModRowId FROM Components WHERE ComponentRowId = ? LIMIT 1 Modding::Framework::GetComponentModHandle Mods.sqlite
SELECT ComponentType FROM Components WHERE ComponentRowId = ? LIMIT 1 Modding::Framework::GetComponentType Mods.sqlite
SELECT ModGroupRowId from ModGroups ORDER BY ModGroupRowId Modding::Framework::GetModGroups Mods.sqlite
SELECT Name, CanDelete, SortIndex from ModGroups WHERE ModGroupRowId = ? LIMIT 1 Modding::Framework::GetModGroupDetails Mods.sqlite
SELECT ModGroupRowId from ModGroups where Selected = 1 LIMIT 1 Modding::Framework::GetSelectedModGroup; Modding::Framework::Initialize Mods.sqlite
UPDATE ModGroups SET Selected = CASE WHEN ModGroupRowId = ? THEN 1 ELSE 0 END Modding::Framework::ChangeSelectedModGroup Mods.sqlite
INSERT INTO ModGroups(Name) VALUES(?) Modding::Framework::CreateModGroup Mods.sqlite
INSERT INTO ModGroupItems(ModGroupRowId, ModRowId, Disabled) SELECT ?, ModRowId, Disabled from ModGroupItems where ModGroupRowId = ? Modding::Framework::CreateModGroup Mods.sqlite
DELETE FROM ModGroups where ModGroupRowId = ? and CanDelete = 1 Modding::Framework::DeleteModGroup Mods.sqlite
DELETE FROM ModCompatibilityWhitelist WHERE ModRowId = ? AND GameVersion = ? Modding::Framework::SetModIgnoreCompatibility Mods.sqlite
SELECT SQL from Migrations where MinVersion < ?1 AND MaxVersion >= ?1 ORDER by SortIndex Modding::Framework::MigrateDatabaseData Mods.sqlite
Modding::ModAssociationsService (2)
Statement Used by Database
SELECT OtherModId, OtherModTitle from ModRelationships where ModRowId = ? and Relationship = ? Modding::ModAssociationsService::Initialize Mods.sqlite
SELECT OtherModId, OtherComponentId from ComponentRelationships where ComponentRowId = ? and Relationship = ? Modding::ModAssociationsService::Initialize Mods.sqlite
Modding::ModDiscoveryService (6)
Statement Used by Database
DELETE FROM ScannedFiles WHERE Path = ? Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
INSERT INTO ScannedFiles(Path, LastWriteTime) VALUES(?,?) Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
INSERT INTO AdditionalScannedFiles(ScannedFileRowId, Path, LastWriteTime) VALUES(?,?,?) Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
SELECT ScannedFileRowId, Path, LastWriteTime FROM ScannedFiles Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
SELECT ModGroupItems.ModGroupRowId, Mods.ModId FROM ModGroupItems INNER JOIN Mods ON ModGroupItems.ModRowId = Mods.ModRowId WHERE Mods.ScannedFileRowId = ? Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
SELECT Path, LastWriteTime FROM AdditionalScannedFiles WHERE ScannedFileRowId = ? Modding::ModDiscoveryService::DiscoverMods Mods.sqlite
Modding::ModLoaderService (21)
Statement Used by Database
INSERT INTO ModRelationships(ModRowID, OtherModID, Relationship, OtherModTitle) VALUES(?,?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ModFiles(ModRowId, Path) VALUES(?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO Mods(ScannedFileRowId, ModId, Version) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseRootBuffer Mods.sqlite
INSERT INTO ModProperties(ModRowId, Name, Value) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
SELECT FileRowId from ModFiles WHERE ModRowId = ? and Path = ? LIMIT 1 Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
SELECT ComponentRowId from Components WHERE ModRowId = ? and ComponentId = ? LIMIT 1 Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO Settings(ModRowId, SettingId, SettingType) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO SettingFiles(SettingRowId, FileRowId, Priority) VALUES (?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO SettingProperties(SettingRowId, Name, Value) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO Components(ModRowId, ComponentId, ComponentType) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ComponentFiles(ComponentRowId, FileRowId, Priority) VALUES (?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ComponentProperties(ComponentRowId, Name, Value) VALUES(?,?,?) Modding::ModLoaderService::ParseMod; Modding::XmlModLoader::ParseModXml Mods.sqlite
SELECT Name, Value from ModProperties Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Value from MetaData where Name = ? LIMIT 1 Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT ID, Title from ModDependencies Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Type, ID from ModSettings Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Name, Value from ModSettings_Items WHERE Type = ? and ID = ? Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Name, Value from ModSettings_Properties WHERE Type = ? and ID = ? Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Type, ID from ModComponents Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Name, Value from ModComponents_Items WHERE Type = ? and ID = ? Modding::ModLoaderService::ParseMod Mods.sqlite
SELECT Name, Value from ModComponents_Properties WHERE Type = ? and ID = ? Modding::ModLoaderService::ParseMod Mods.sqlite
Modding::PropertyService (3)
Statement Used by Database
SELECT Value FROM ModProperties WHERE ModRowId = ? AND Name = ? LIMIT 1 Modding::PropertyService::Initialize Mods.sqlite
SELECT Value FROM ComponentProperties WHERE ComponentRowId = ? AND Name = ? LIMIT 1 Modding::PropertyService::Initialize Mods.sqlite
SELECT Value FROM SettingProperties WHERE SettingRowId = ? AND Name = ? LIMIT 1 Modding::PropertyService::Initialize Mods.sqlite
Modding::XmlModLoader (9)
Statement Used by Database
INSERT INTO LocalizedText(ModRowId, Tag, Locale, Text) VALUES(?,?,?,?) Modding::XmlModLoader::ParseLocalizationBuffer; Modding::ModLoaderService::ParseMod (+1) Mods.sqlite
INSERT INTO SettingCriteria(SettingRowId, CriteriaRowId) VALUES (?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ComponentCriteria(ComponentRowId, CriteriaRowId) VALUES (?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ComponentReferences(ComponentRowId, Uri, Priority) VALUES (?,?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO ComponentRelationships(ComponentRowId, OtherModId, OtherComponentId, Relationship) VALUES (?,?,?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO Criteria(ModRowId, CriteriaId, Any) VALUES (?,?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO Criterion(CriteriaRowId, CriterionType, Inverse) VALUES(?,?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
INSERT INTO CriterionProperties(CriterionRowId, Name, Value) VALUES(?,?,?) Modding::XmlModLoader::ParseModXml Mods.sqlite
SELECT CriteriaRowId from Criteria where ModRowId = ? and CriteriaId = ? LIMIT 1 Modding::XmlModLoader::ParseModXml Mods.sqlite
ModdingComponentDiscoveryService (1)
Statement Used by Database
SELECT Criteria.CriteriaRowId, Criteria.Any from ComponentCriteria inner join Criteria on ComponentCriteria.CriteriaRowId = Criteria.CriteriaRowId where ComponentRowId = ? ModdingComponentDiscoveryService::FilterComponents Mods.sqlite
ModdingMapSettingHandler (2)
Statement Used by Database
INSERT INTO Maps(File, Name, Description, StaticMap, Domain) VALUES(?,?,?,?,?) ModdingMapSettingHandler::BeginApplySettings Mods.sqlite
INSERT INTO Maps(File, Name, Description, StaticMap) VALUES(?,?,?,?) ModdingMapSettingHandler::BeginApplySettings Mods.sqlite
ModdingSettingDiscoveryService (1)
Statement Used by Database
SELECT Criteria.CriteriaRowId, Criteria.Any from SettingCriteria inner join Criteria on SettingCriteria.CriteriaRowId = Criteria.CriteriaRowId where SettingRowId = ? ModdingSettingDiscoveryService::FilterSettings Mods.sqlite
ModdingWorldBuilderSettingHandler (7)
Statement Used by Database
INSERT INTO MapLeaders (Map, LeaderType) VALUES (?,?) ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
SELECT LeaderType from Players WHERE LeaderType <> 'RANDOM' AND LeaderType <> 'UNDEFINED' ORDER BY LeaderType ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
INSERT INTO MapSupportedValues (Map, Domain, Value) VALUES (?,?,?) ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
SELECT MapSizeType from Map ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
SELECT Value from MapAttributes WHERE Name = 'Ruleset' ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
SELECT Domain from RulesetDomainOverrides WHERE Ruleset = ? and ParameterId = 'Map' ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase Mods.sqlite
SELECT Language, ID, Value from ModText ModdingWorldBuilderSettingHandler::LoadWorldBuilderDatabase; Modding::ModLoaderService::ParseMod Mods.sqlite
Network::Manager (1)
Statement Used by Database
SELECT Name FROM Victories where VictoryType = ? LIMIT 1 Network::Manager::OnTeamVictory game databases
WorldView_StartupGame (1)
Statement Used by Database
SELECT Make_Hash(FeatureType),AddsFreshWater from Features WorldView_StartupGame game databases
unnamed functions (16)
Statement Used by Database
SELECT VictoryDomain FROM Rulesets WHERE RulesetType = ? LIMIT 1 0xb55b0 game databases
SELECT DISTINCT VictoryType AS 'Type', Name, Icon FROM Victories WHERE Domain = ? AND Visible = 1 0xb55b0 game databases
SELECT VictoryType, GamePlayers.LeaderType FROM GAMES INNER JOIN GamePlayers ON GamePlayers.PlayerObjectId = (SELECT GamePlayers.PlayerObjectId FROM GamePlayers INNER JOIN GameObjects ON GamePlayers.PlayerObjectId = GameObjects.ObjectId WHERE GamePlayers.IsLocal = 1 and GameObjects.GameId = Games.GameId and GamePlayers.TeamId = Games.VictorTeamId LIMIT 1) WHERE GameId IN (SELECT GameId FROM ChallengeGames WHERE ChallengeId in ( 0xb55b0 HallofFame.sqlite
SELECT Domain FROM RulesetDomainOverrides WHERE Ruleset = ? AND ParameterId = 'PlayerLeader' LIMIT 1 0xb4bd0 game databases
SELECT LeaderType, LeaderName, CivilizationType, CivilizationName, LeaderIcon, CivilizationIcon FROM Players WHERE Domain = @Domain AND HumanPlayable = 1 AND LeaderType NOT IN (SELECT value FROM RulesetUnSupportedValues WHERE Domain=@Domain AND Ruleset=@Ruleset) 0xb4bd0 game databases
SELECT LeaderType, CASE WHEN GamePlayers.TeamId = Games.VictorTeamId THEN Games.VictoryType ELSE NULL END VictoryType FROM GamePlayers INNER JOIN GameObjects ON GamePlayers.PlayerObjectId = GameObjects.ObjectId INNER JOIN Games ON GameObjects.GameId = Games.GameId WHERE GamePlayers.IsLocal = 1 AND Games.Ruleset = ? AND Games.GameId IN (SELECT GameId FROM ChallengeGames WHERE ChallengeId in ( 0xb4bd0 HallofFame.sqlite
SELECT * FROM Games WHERE Games.GameId IN (SELECT GameId FROM ChallengeGames WHERE ChallengeId in ( 0xb5e10 HallofFame.sqlite
SELECT COUNT(VictoryType) FROM GAMES INNER JOIN GamePlayers ON GamePlayers.PlayerObjectId = (SELECT GamePlayers.PlayerObjectId FROM GamePlayers INNER JOIN GameObjects ON GamePlayers.PlayerObjectId = GameObjects.ObjectId WHERE GamePlayers.IsLocal = 1 and GameObjects.GameId = Games.GameId and GamePlayers.TeamId = Games.VictorTeamId LIMIT 1) WHERE GameId IN (SELECT GameId FROM ChallengeGames WHERE ChallengeId = ?) LIMIT 2 0xb6130 HallofFame.sqlite
SELECT GamePlayers.LeaderName, COUNT(VictoryType)FROM GAMES INNER JOIN GamePlayers ON GamePlayers.PlayerObjectId = (SELECT GamePlayers.PlayerObjectId FROM GamePlayers INNER JOIN GameObjects ON GamePlayers.PlayerObjectId = GameObjects.ObjectId WHERE GamePlayers.IsLocal = 1 and GameObjects.GameId = Games.GameId and GamePlayers.TeamId = Games.VictorTeamId LIMIT 1) WHERE GameId IN (SELECT GameId FROM ChallengeGames WHERE ChallengeId = ?) ORDER BY LastPlayed DESC LIMIT 1 0xb4800 HallofFame.sqlite
SELECT Domain, File FROM Maps WHERE Name = ? 0xb8840 game databases
PRAGMA defer_foreign_keys = ON; 0xbc330; Application::Data::GameplayDatabase::Bootstrap (+8) game databases
SELECT FeatureType, Name FROM Features WHERE NaturalWonder=1 0x17e810 game databases
SELECT Name, VictoryType, EnabledByDefault FROM Victories 0x1801f0 game databases
SELECT Name FROM DomainValues where Domain = ? and Value = ? LIMIT 1 0x181380 game databases
Cannot SELECT without a mailbox. 0xc00ba0 game databases
SELECT %s 0xc00ba0 game databases