Hi folks.
If you are disappointed of your past records are not visible anymore when playing G&K then there are a few simple steps to fix it.
1) download SQLite shell for your OS from here http://www.sqlite.org/download.html. For Win32/Win64 it is sqlite-shell-win32-x86-NNNNNNN.zip
2) 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
3) Download View attachment merge.txt and View attachment split.txt to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
4) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
5) Copy HallOfFameDatabase.db to safe place (to allow to restore if something went wrong)
6) execute sqlite3.exe HallOfFameDatabase.db (see Note 0 below if you have difficulties here)
7) within opened SQLite shell execute .read merge.txt
8) within opened SQLite shell execute .exit
9) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
Note 0: If you do not know how to do execute command at 6th step then press Win+R buttons, and execute
C:\CORRECT_PATH_TO_REPLAYS_FOLDER\sqlite3.exe HallOfFameDatabase.db.
Do not forget to replace CORRECT_PATH_TO_REPLAYS_FOLDER with correct path
Note 1: All records from Vanilla Hall of Fame will be moved to G&K Hall of Fame.
Note 2: It is safe to merge HoFs as many times as required, e.g. you can merge, then disable G&K, play Vanilla and then merge new vanilla records into G&K using the same steps without any changes.
Note 3: If you want split them back into two HoF then you can do steps above but replace script at 7th step with following: .read split.txt
Split operation is possible whenever you want to do it. You can do as many split/merge/split/merge operations as required BUT DO NOT FORGET TO MAKE BACKUPS AND VERIFY RESULTS!
Enjoy!
PS
Also, there is my previous post about fixing broken Hall of Fame http://forums.civfanatics.com/showthread.php?t=435916K then there are a few simple steps to fix it.
If you are disappointed of your past records are not visible anymore when playing G&K then there are a few simple steps to fix it.
1) download SQLite shell for your OS from here http://www.sqlite.org/download.html. For Win32/Win64 it is sqlite-shell-win32-x86-NNNNNNN.zip
2) 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
3) Download View attachment merge.txt and View attachment split.txt to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
4) Go to "Documents\My games\Sid Meier's Civilization 5\Replays\" folder
5) Copy HallOfFameDatabase.db to safe place (to allow to restore if something went wrong)
6) execute sqlite3.exe HallOfFameDatabase.db (see Note 0 below if you have difficulties here)
7) within opened SQLite shell execute .read merge.txt
8) within opened SQLite shell execute .exit
9) it's all. Run CIV5 and verify hall of fame is ok. If not then restore it from saved copy and ask question of forum
Note 0: If you do not know how to do execute command at 6th step then press Win+R buttons, and execute
C:\CORRECT_PATH_TO_REPLAYS_FOLDER\sqlite3.exe HallOfFameDatabase.db.
Do not forget to replace CORRECT_PATH_TO_REPLAYS_FOLDER with correct path
Note 1: All records from Vanilla Hall of Fame will be moved to G&K Hall of Fame.
Note 2: It is safe to merge HoFs as many times as required, e.g. you can merge, then disable G&K, play Vanilla and then merge new vanilla records into G&K using the same steps without any changes.
Note 3: If you want split them back into two HoF then you can do steps above but replace script at 7th step with following: .read split.txt
Split operation is possible whenever you want to do it. You can do as many split/merge/split/merge operations as required BUT DO NOT FORGET TO MAKE BACKUPS AND VERIFY RESULTS!
Enjoy!
PS
Also, there is my previous post about fixing broken Hall of Fame http://forums.civfanatics.com/showthread.php?t=435916K then there are a few simple steps to fix it.
