Now you should decide which ones allow to identify surplus rows, for example VictoryType, Score, PlayerTeamWonĤ) execute select VictoryType, Score, PlayerTeamWon, rowid from Victories ĥ) Notice rowid - it is hidden unique ID column. you tried last turns multiple times and game remembered all attempts or you just want to remove some shameful records ) then do followingģ) you will see list of columns in table Victories.
If not then restore it from saved copy and ask question of forumĪlso, if you have surplus entries in Hall of fame which you want to delete (e.g. Where PlayerCivilizationName='' or PlayerCivilizationName is null ĩ) it's all. || lower(substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),2)) Set PlayerCivilizationName = substr(replace(PlayerCivilizationType, 'CIVILIZATION_',''),1,1) missed rows, "you are not finished any games" label over your results etc) then reasons are missed player's and player civilization's names and it is easy to fixġ) download SQLite shell for your OS from here Ģ) extract sqlite3.exe (from here and forward there will be Windows OS instructions) to your "Documents\My games\Sid Meier's Civilization 5\Replays\" folderģ) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folderĤ) Copy HallOfFameDatabase.db to save place (to allow to restore if something went wrong)ĥ) execute sqlite3.exe HallOfFameDatabase.dbĦ) execute update Victories set PlayerLeaderName='YOUR_NAME_HERE' ħ) execute (copy/paste/execute all text in bold below as single query)
If one day you have got broken Hall of fame (i.e.
0 kommentar(er)
