Topic: Arcade Testing, Round #13

[Ken (OP)]

Test #13 - SMF 1.1.11
1. Start with some kind of fresh install for this arcade test.
    That is to say - either a fresh smf 1.1.11 install or make sure all the smf arcade and e-arcade database variables are dropped.
    (table prefixes for smf 1 will be... 'arcade_ ...' )
    This includes the smf arcade values located in the YOUR-DB_settings table that begin with a 'arcade_' prefix.  ...Done
1.a Dropped all db tables.
1.b Deleted all files from server
1.c Upload and install a fresh copy of SMF 1.1.11

2. Install E-Arcade 259 with some games including v32 save types ...Done

3. Uninstall and delete E-Arcade ...Done

4. Clear error log ...Done

5. Install the tool ...Done

6. Copy the display from the tool and post it. ...Done

eArcade 2.5.9 to SMF Arcade 2.0.1.8 conversion tool


Editing current database for: kenkayjm_tp098

Creating/altering SMF Arcade settings variables:

arcadeCheckLevel - created in - settings
arcadeDatabaseVersion - created in - settings
arcadeDefaultCategory - created in - settings
arcadeEnabled - created in - settings
arcadeGameInformationSide - created in - settings
arcadeMaxScores - created in - settings
arcadePermissionMode - created in - settings
arcadePostPermission - created in - settings
arcadePostsPlay - created in - settings
arcadePostsPlayPerDay - created in - settings
arcadeVersion - created in - settings
arcadeCheckConvert1 - created in - settings

Done.
Deleting possible pre-existing SMF Arcade tables/columns:


Done.
Renaming E-Arcade 2.5.9 db tables/columns to SMF Arcade 2.0.1.8 db tables/columns:

id_game - renamed to - ID_GAME - from - arcade_games
internal_name - renamed to - internalName - from - arcade_games
game_name - renamed to - gameName - from - arcade_games
id_category - renamed to - ID_CAT - from - arcade_games
game_width - renamed to - gameWidth - from - arcade_games
game_height - renamed to - gameHeight - from - arcade_games
game_file - renamed to - gameFile - from - arcade_games
game_directory - renamed to - gameDirectory - from - arcade_games
score_type - renamed to - scoreType - from - arcade_games
member_groups - renamed to - memberGroups - from - arcade_games
game_bg_colour - renamed to - gameBackgroundColor - from - arcade_games
game_rating - renamed to - gameRating - from - arcade_games
number_plays - renamed to - numPlays - from - arcade_games
number_rates - renamed to - numRates - from - arcade_games
id_member_first - renamed to - ID_MEMBER_CHAMPION - from - arcade_games
id_score_first - renamed to - ID_CHAMPION_SCORE - from - arcade_games
id_best - renamed to - ID_PB - from - arcade_personalbest
id_game - renamed to - ID_GAME - from - arcade_personalbest
id_member - renamed to - ID_MEMBER - from - arcade_personalbest
id_category - renamed to - ID_CAT - from - arcade_categories
category_name - renamed to - catName - from - arcade_categories
category_order - renamed to - catOrder - from - arcade_categories
member_groups - renamed to - memberGroups - from - arcade_categories
id_favorite - renamed to - ID_FAVORITE - from - arcade_favorite
id_member - renamed to - ID_MEMBER - from - arcade_favorite
id_game - renamed to - ID_GAME - from - arcade_favorite
id_rating - renamed to - ID_RATE - from - arcade_rates
id_member - renamed to - ID_MEMBER - from - arcade_rates
id_game - renamed to - ID_GAME - from - arcade_rates
rate_time - renamed to - rateTime - from - arcade_rates
id_score - renamed to - ID_SCORE - from - arcade_scores
id_game - renamed to - ID_GAME - from - arcade_scores
id_member - renamed to - ID_MEMBER - from - arcade_scores
start_time - renamed to - startTime - from - arcade_scores
end_time - renamed to - endTime - from - arcade_scores
champion_from - renamed to - championFrom - from - arcade_scores
champion_to - renamed to - championTo - from - arcade_scores
game_duration - renamed to - gameDuration - from - arcade_scores
member_ip - renamed to - memberIp - from - arcade_scores
score_status - renamed to - scoreStatus - from - arcade_scores

Done.
Attempting to add extra needed tables/columns:

Table: arcade_gameofday -> created with needed columns

Done.
Deleting E-Arcade tables and columns:

category_icon - dropped - from arcade_categories
id_member_second - dropped - from arcade_games
id_score_second - dropped - from arcade_games
id_member_third - dropped - from arcade_games
id_score_third - dropped - from arcade_games
topic_id - dropped - from arcade_games
my_plays - dropped - from arcade_personalbest
playing_time - dropped - from arcade_personalbest
time_gained - dropped - from arcade_personalbest
Table: arcade_settings - dropped - from kenkayjm_tp098
Table: arcade_shouts - dropped - from kenkayjm_tp098
Table: arcade_tournament - dropped - from kenkayjm_tp098
Table: arcade_tournament_players - dropped - from kenkayjm_tp098
Table: arcade_tournament_rounds - dropped - from kenkayjm_tp098
Table: arcade_tournament_scores - dropped - from kenkayjm_tp098
Table: arcade_v3temp - dropped - from kenkayjm_tp098

Done.
Transferring gamedata files from main Games directory to arcade/gamedata/... :


Done.
Further Instructions:

- Uninstall/Delete this package from your package manager.
- Delete E-Arcade 2.5.9 from your package manager.
- Install SMF Arcade 2.0.1.8+ with your package manager.

- Visit Askusaquestion.net to download arcade games.
- Visit SMF Arcade Forums for SMF Arcade support.

Testing:

Many thanks to the SMF Arcade Beta Testers for helping me test this application.

Notes:

- If necessary, please make sure to set your -url to games- and -path to games- directories properly in your SMF Arcade as you had previously in E-Arcade.
- This tool is not reversable! Do not attempt to uninstall SMF Arcade and then re-install E-Arcade or your game data will be lost.

9. Install v32/Tar games uploader ...Done

10. Test some games including v32 save type ...Done

NOTES:
Some errors in previous tests may have been caused by, or contributed to by the use of an older copy of the tool... there is no way to check that of course, but certain clues lead me to think that the possibility exists.