Some time ago I uninstalled Civ5; before I did so I made sure to make a backup of the Replays folder, so that I could keep my Hall Of Fame results (in HallOfFameDatabase.db).
I recently reinstalled Civ5 but forgot to restore the Replays folder from my backup. Naturally, after playing a few games, the scores from these games were saved into a new HallOfFameDatabase.db.
Using sqlite3.exe I have tried to merge the new scores into the original HallOfFameDatabase.db file. First I renamed the new file as HallOfFameDatabase2.db, then I carried out the following (I moved both files into the root of the C-drive for simplicity):
attach 'c:\halloffamedatabase.db' as hof;
attach 'c:\halloffamedatabase2.db' as hof2;
insert into hof.victories select * from hof2.victories;
Once this was been done, I can clearly see the rows from the new file appearing in the original file. However, within the game itself, none of the new scores are visible - only the original scores are shown.
Similarly, I used:
delete from hof.victories where score < 5000;
to remove all scores below 5000. In the old file there were 10 scores > 5000, and in the new file there is just 1. Again, after the deletion, I can see 11 rows in the table, but only the original 10 appear in the game itself.
Is there something I am missing to ensure the game displays the new records that have been merged with the original records?
I recently reinstalled Civ5 but forgot to restore the Replays folder from my backup. Naturally, after playing a few games, the scores from these games were saved into a new HallOfFameDatabase.db.
Using sqlite3.exe I have tried to merge the new scores into the original HallOfFameDatabase.db file. First I renamed the new file as HallOfFameDatabase2.db, then I carried out the following (I moved both files into the root of the C-drive for simplicity):
attach 'c:\halloffamedatabase.db' as hof;
attach 'c:\halloffamedatabase2.db' as hof2;
insert into hof.victories select * from hof2.victories;
Once this was been done, I can clearly see the rows from the new file appearing in the original file. However, within the game itself, none of the new scores are visible - only the original scores are shown.
Similarly, I used:
delete from hof.victories where score < 5000;
to remove all scores below 5000. In the old file there were 10 scores > 5000, and in the new file there is just 1. Again, after the deletion, I can see 11 rows in the table, but only the original 10 appear in the game itself.
Is there something I am missing to ensure the game displays the new records that have been merged with the original records?