... this is a working draft of a post for SMF Arcade, so expect to see lots of edits.Just save-types I am concerned about... if they installed SMF Arcade prior to the tool... and also not.
For example... 20 games.. as many save types as possible.. see if it sets them properly.
Test: SMF2 RC3 installations - Scenario #2:
* Install E-Arcade
... Done. * Install gamepack plus different game types
... Done. * Set some favorites, rate some games, get some high scores, enter some game descriptions
... Done. * Uninstall E-Arcade
... Done. * Install SMF Arcade
... Done, no games or data transfered. * Uninstall SMF Arcade and then clear your error log
... Done, no errors. * Install and run the conversion tool
... Done, no errors. * Uninstall and delete the conversion tool
... Done, no errors. * Install SMF Arcade
... Done, no errors. * Run all Admin/Arcade maintenance
... Done, with errors.Update GameCache = Unable to move directories from "X:/xampp/htdocs/Games/yeti/gamedata" to "X:\xampp\htdocs/arcade/gamedata". Please do it manually!
Plus this in the forum error log = http://localhost/index.php?action=admin;area=arcademaintenance;maintenance=updateGamecache;f13b1b173=92b09d1b1a9cd55ffe69c7ed8a43538f
2: rename(X:/xampp/htdocs/Games/yeti/gamedata/revengeDR,X:\xampp\htdocs/arcade/gamedata/revengeDR) [<a href='function.rename'>function.rename[/url]]: No such file or directory
File: X:/xampp/htdocs/Sources/Subs-ArcadeAdmin.php
Line: 942
* Check to see if old data for arcade was transferred (scores/stats)
... Done, no errors. * Check to see if games function (including proper dimensions), save scores (proper save type set), etc.
... Done, with errors.When saving a score, this error page comes up = An error occurred while saving score
Plus this in the error log =
Apply Filter: Only show the error messages of this URL
http://localhost/index.php?action=arcade
Apply Filter: Only show the errors with the same message
Error while saving score for game "1i Champi". Submit system might be invalid, should be "v1game" or user tried to cheat.
Apply Filter: Only show the error messages of this member Ken
* Make sure all functions work in arcade including tournaments
... Tournaments/Arena not working: the setup page shows, but will not save/make a match. * Make sure all Arcade Admin functions work properly
... Done. * Double check error log after testing
... Done, no errors except as noted above.NOTE:
Just for fun and giggles I copied the description readout after the conversion tool install:
eArcade Beta4 to SMF Arcade 2.5 conversion tool
Editing current database for: SMF2
Checking if SMF Arcade installation was already attempted and then deleting/renaming specific tables if necessary:
Table: arcade_categories - dropped - from SMF2
Table: earcade_categories - renamed to - arcade_categories
Table: arcade_favorite - dropped - from SMF2
Table: earcade_favorite - renamed to - arcade_favorite
Table: arcade_games - dropped - from SMF2
Table: earcade_games - renamed to - arcade_games
Table: earcade_personalbest - renamed to - arcade_personalbest
Table: arcade_rates - dropped - from SMF2
Table: earcade_rates - renamed to - arcade_rates
Table: arcade_scores - dropped - from SMF2
Table: earcade_scores - renamed to - arcade_scores
Table: arcade_settings - dropped - from SMF2
Table: earcade_settings - renamed to - arcade_settings
Table: earcade_shouts - dropped - from SMF2
Table: earcade_tournament - dropped - from SMF2
Table: earcade_tournament_players - dropped - from SMF2
Table: earcade_tournament_rounds - dropped - from SMF2
Table: earcade_tournament_scores - dropped - from SMF2
Table: earcade_v3temp - dropped - from SMF2
Table: arcade_settings - dropped - from SMF2
Done.
Creating/altering SMF Arcade settings variables:
GamecacheUpdate - created in - settings
arcadeCheckConvert2 - created in - settings
Done.
Deleting possible pre-existing SMF Arcade tables/columns:
Done.
Renaming E-Arcade Beta 4 db tables/columns to SMF Arcade 2.5 db tables/columns:
id_category - renamed to - id_cat - from - arcade_games
id_member_first - renamed to - id_champion - from - arcade_games
id_score_first - renamed to - id_champion_score - from - arcade_games
number_plays - renamed to - num_plays - from - arcade_games
number_rates - renamed to - num_rates - from - arcade_games
id_category - renamed to - id_cat - from - arcade_categories
category_name - renamed to - cat_name - from - arcade_categories
category_order - renamed to - cat_order - from - arcade_categories
game_duration - renamed to - duration - from - arcade_scores
Done.
Attempting to add extra needed tables and columns:
Table: arcade_settings -> created with needed columns
personal_best - added to table - arcade_scores
player_name - added to table - arcade_scores
validate_hash - added to table - arcade_scores
thumbnail_small - added to table - arcade_games
submit_system - added to table - arcade_games
local_permissions - added to table - arcade_games
extra_data - added to table - arcade_games
num_favorites - added to table - arcade_games
num_games - added to table - arcade_categories
Done.
Transferring submit_system and extra_data info for each game:
(This may take a few minutes depending on how many games are in your database)
Game id: 1 submit_system: v1game - updated in - arcade_games
Game id: 1 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:300;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 2 submit_system: ibp - updated in - arcade_games
Game id: 2 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:300;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 3 submit_system: ibp - updated in - arcade_games
Game id: 3 extra_data: a:4:{s:5:"width";i:650;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 4 submit_system: ibp - updated in - arcade_games
Game id: 4 extra_data: a:4:{s:5:"width";i:300;s:6:"height";i:320;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:214;i:1;i:211;i:2;i:206;}} - updated in - arcade_games
Game id: 5 submit_system: ibp - updated in - arcade_games
Game id: 5 extra_data: a:4:{s:5:"width";i:550;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:51;i:1;i:102;i:2;i:255;}} - updated in - arcade_games
Game id: 6 submit_system: ibp - updated in - arcade_games
Game id: 6 extra_data: a:4:{s:5:"width";i:650;s:6:"height";i:450;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 7 submit_system: ibp - updated in - arcade_games
Game id: 7 extra_data: a:4:{s:5:"width";i:600;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 8 submit_system: ibp - updated in - arcade_games
Game id: 8 extra_data: a:4:{s:5:"width";i:600;s:6:"height";i:430;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:204;i:2;i:0;}} - updated in - arcade_games
Game id: 9 submit_system: ibp - updated in - arcade_games
Game id: 9 extra_data: a:4:{s:5:"width";i:500;s:6:"height";i:375;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 10 submit_system: ibp - updated in - arcade_games
Game id: 10 extra_data: a:4:{s:5:"width";i:500;s:6:"height";i:375;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 11 submit_system: ibp - updated in - arcade_games
Game id: 11 extra_data: a:4:{s:5:"width";i:550;s:6:"height";i:413;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:153;i:1;i:153;i:2;i:153;}} - updated in - arcade_games
Game id: 12 submit_system: ibp - updated in - arcade_games
Game id: 12 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:300;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 13 submit_system: ibp - updated in - arcade_games
Game id: 13 extra_data: a:4:{s:5:"width";i:490;s:6:"height";i:200;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 14 submit_system: ibp - updated in - arcade_games
Game id: 14 extra_data: a:4:{s:5:"width";i:480;s:6:"height";i:284;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 15 submit_system: ibp - updated in - arcade_games
Game id: 15 extra_data: a:4:{s:5:"width";i:650;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 16 submit_system: ibp - updated in - arcade_games
Game id: 16 extra_data: a:4:{s:5:"width";i:620;s:6:"height";i:420;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 17 submit_system: ibp - updated in - arcade_games
Game id: 17 extra_data: a:4:{s:5:"width";i:640;s:6:"height";i:480;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:102;i:1;i:102;i:2;i:102;}} - updated in - arcade_games
Game id: 18 submit_system: ibp - updated in - arcade_games
Game id: 18 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 19 submit_system: ibp - updated in - arcade_games
Game id: 19 extra_data: a:4:{s:5:"width";i:550;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:153;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 20 submit_system: ibp - updated in - arcade_games
Game id: 20 extra_data: a:4:{s:5:"width";i:550;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:255;i:1;i:255;i:2;i:255;}} - updated in - arcade_games
Game id: 21 submit_system: ibp - updated in - arcade_games
Game id: 21 extra_data: a:4:{s:5:"width";i:600;s:6:"height";i:520;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:102;i:1;i:102;i:2;i:102;}} - updated in - arcade_games
Game id: 22 submit_system: ibp32 - updated in - arcade_games
Game id: 22 extra_data: a:4:{s:5:"width";i:550;s:6:"height";i:400;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 23 submit_system: v1game - updated in - arcade_games
Game id: 23 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:300;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Game id: 24 submit_system: v1game - updated in - arcade_games
Game id: 24 extra_data: a:4:{s:5:"width";i:400;s:6:"height";i:300;s:13:"flash_version";i:10;s:16:"background_color";a:3:{i:0;i:0;i:1;i:0;i:2;i:0;}} - updated in - arcade_games
Done.
Deleting E-Arcade tables and columns:
category_icon - dropped - from arcade_categories
id_rating - dropped - from arcade_rates
start_time - dropped - from arcade_scores
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
game_width - dropped - from arcade_games
game_height - dropped - from arcade_games
game_bg_colour - dropped - from arcade_games
topic_id - dropped - from arcade_games
Table: arcade_personalbest - dropped - from SMF2
Done.
Further Instructions:
- Uninstall/Delete this package from your package manager.
- Delete E-Arcade Beta 4 from your package manager.
- Install SMF Arcade 2.5 with your package manager.
- Visit Askusaquestion.net to download arcade games.
- Visit SMF Arcade Forums for SMF Arcade support.
Testing:
Many thanks to Ken and skhilled @ SMF Arcade Forum for testing this tool prior to its public release.
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.
- Make sure to perform score tables maintenance in Admin -> Arcade -> Maintenance.
- 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.
