WebDev

SMF Arcade => SMF Arcade Support + Plugins => Topic started by: Chen Zhen on July 06, 2013, 01:44:52 PM

Title: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on July 06, 2013, 01:44:52 PM
SMF 1.1.11  -  OR  -  SMF 2.0 RC3 installation package:


E-Arcade 2.5.9  -  TO  -  SMF Arcade 2.0.1.8 Conversion

OR

E-Arcade Beta4  -  TO  -  SMF Arcade 2.5Rc1 Conversion


This is a tool designed for renaming E-Arcade to SMF Arcade database tables/columns.


Instructions:

- Make sure to backup your database prior to using this tool

- Make sure BOTH arcades are uninstalled in your Admin / Packages menu

- Install and apply this tool to commence the database changes

- Uninstall/Delete this tool from your Admin / Packages list

- Delete E-Arcade from your Admin / Packages list

- Install SMF Arcade from your Admin / Packages list

- Do not run this install package ever again.



***** WARNING *****

Current SMF Arcade users beware - this tool may delete your current db entries if you try to use it.

This tool has but only 1 purpose and that is to convert from E-Arcade  - TO -  SMF Arcade

The change-over is not reversable. Once you commence the process, you can not revert back to E-Arcade.
(Unless you restore the database backup from the first step)


Only download, install and continue with this installation if you have read and understand the purpose of this tool.
The author of this tool is not responsible for any data loss due to improper use.




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



Notes:

    * Transfers user data such as scores (with comments), favorites, categories and ratings
    * Transfers game data such as save-types, dimensions, background color, descriptions and help text
    * DOES NOT transfer tournaments or any tournament information, therefore these must start anew.
    * The process is not reversible and converting to SMF Arcade is permanent.
      (Unless you restore the database backup from the first step)



The package is attached.


Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on February 17, 2017, 11:22:10 AM
Will this work for the current version of SMFarcade? I'm trying to help someone who's site is using E-Arcade Beta4-SMF2 and having problems so I'd like to switch them to the current version of smfarcade.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on February 17, 2017, 02:53:21 PM
Yes it should work.
Unless that is the latest version from SMF that someone took over then I am not sure as to what changes were made.
This tool will convert the necessary tables to what SMF Arcade uses.
The newer version of the SMF Arcade that I released has an auto-adjust score type sub-routine that should fix score types for their games.
This is because E-Arcade did not save the score type to the database unlike SMF Arcade.
Also if I remember correctly it attempts to create unique game folders for each game because E-Arcade was not designed to do so.
Imo just in case something goes awry it might be best to copy all arcade related directories to their local hdd via ie. Filezilla prior to using the tool.
It may require each game to attempt to save a score once prior to its auto adjustment of a score.

Let me know if the person has issues.
Worse case scenario if things get really botched is to start with all scores anew.
It won't delete their games or anything like that.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on February 17, 2017, 06:06:00 PM
Thanks alot! I'll let them know. :)
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on February 19, 2017, 12:03:49 AM

I forgot to mention that the auto adjustment of save types is optional.
They must enable it in:
 Admin -> Arcade -> Advanced -> Auto Adjust Improper Save Types
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on February 19, 2017, 07:17:41 AM
Oh yeah, I was looking at that a few days ago for someone else on their site.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on February 19, 2017, 09:27:15 PM

Let me know if everything worked as expected.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on October 21, 2020, 08:09:20 PM
Does this converter tool still work for the current version of SMF Arcade, or is there a newer one somewhere?

I have been using E-Arcade Beta4-SMF2 (with SMF 2.0.17) up until now, but would very much like to switch to the latest version of SMF Arcade - of course retaining all current games and high scores. So can I do that with the tool in this thread, or have tables used by SMF Arcade changed since then (so that the tool doesn't work these days)?

Considering the thread is from 2013, I thought I'd better ask before doing anything...
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on October 21, 2020, 08:24:20 PM
I'm not sure it will work anymore.

What you can do is backup your database via phpmyadmin (possibly to a compressed zip file) and then attempt to run the tool.
Afterward you can install SMF Arcade and see if your games and scores are all showing/available.

If it doesn't work you can always restore the copy of the database that you made.

The games you had for E-Arcade should work in SMF Arcade either way its just that you will likely have to reinstall all of them & start scores from scratch.
There is a skin & list available that is close to what you had in E-Arcade as well.
Keep in mind that flash will not be available in main stream browsers as of Dec.31 of this year.
This means most people will have to download a non main stream browser that supports flash to play those old games.

HTML5/javascript is the new format for games now.
An updated version of this arcade is due for release within the next week or so.
It supports most of the HTML5 games you see on sites these days.
There is a list of sites that allow downloading of games in this support section.
The updated version of the arcade will play them but you will have to wait about a week as we have a few things to sort out prior to its release.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on October 21, 2020, 08:38:55 PM

Actually the app/tool seems to have been lost.
A few years ago I lost a lot of older files on a previous server that were never recovered.
Some of which I no longer have copies of on my own drives and this appears to be one that I can't locate.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on October 22, 2020, 10:20:57 AM
Is it one of these packages???
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on October 28, 2020, 10:39:57 PM

Thanks for those files!
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 02, 2020, 06:06:38 AM
Thank you. I see that the new version of SMF Arcade has been released now, so I will make a backup of the database and try out the tool - hopefully it still works, so that the games and scores can be kept from e-Arcade. :)
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on November 02, 2020, 11:59:59 AM
The older games you have are swf flash which will no longer be supported in mainstream browsers starting. Dec.31 2020.

HTML5/JavaScript games are the new norm.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 03, 2020, 06:17:04 PM
Quote from: Chen Zhen on November 02, 2020, 11:59:59 AMThe older games you have are swf flash which will no longer be supported in mainstream browsers starting. Dec.31 2020.

HTML5/JavaScript games are the new norm.
I'm well aware of that, and it's very unfortunate. It's of course positive from a security point of view, but the problem is that the vast majority of Flash games most likely will never be ported to HTML5. :(

Are there any gamepacks available with HTML5 games compatible with SMF Arcade? The only thing I can find is to download individual games, which normally would be preferable - but if it's not possible to transfer everything from e-Arcade so I have to start all over, then it would be useful with a reasonably sized pack of decent games, in order for the arcade not to be completely empty at the beginning.

I can see old posts on this forum referring to gamepacks downloadable here, but I can't seem to find any such - nor can I find any gamepacks on the other web sites linked to either. :(
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on November 03, 2020, 06:41:17 PM
Gamepacks are in the download section.
Click on "Downloads" from the navigation bar and you will find many gamepacks.
Some of the latter ones contain HTML5 games and should state what type they are in the download details/description.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: vince on November 03, 2020, 07:28:29 PM
I'm in the process of maki g some html5 game packs for dl and will update here when I'm ready I also have lots of jva html5 games but I think I'm gonna just ditch them , I also believe  as to what Chen stated they may be intrusive . The new ones I'm collecting now come from trusted sources
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 04, 2020, 04:32:22 PM
Quote from: Chen Zhen on November 03, 2020, 06:41:17 PMGamepacks are in the download section.
Click on "Downloads" from the navigation bar and you will find many gamepacks.
Some of the latter ones contain HTML5 games and should state what type they are in the download details/description.
Thank you. I can see it now, although I could have sworn that category wasn't there when I checked yesterday...
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 09, 2020, 06:18:30 AM
I have executed the E-Arcade to SMF Arcade conversion tool with no problems, but now when I try to install SMF Arcade I get the following error:

"Specified key was too long; max key length is 1000 bytes
File: /var/www/html/forum/Packages/temp/arcadeinstall/Subs-Install.php
Line: 34

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php."

What does that mean, and how do I resolve this?
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 12, 2020, 07:51:09 PM
Quote from: Chen Zhen on October 21, 2020, 08:24:20 PMThere is a skin & list available that is close to what you had in E-Arcade as well.
Could you please tell me what skin and list type (and possibly other settings) I should choose, in order to get a look as close to e-Arcade as possible?

I have tried looking around in the Arcade Settings, but there isn't a lot of information available on what everything means...
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on November 12, 2020, 08:01:05 PM
Navigate to:

Admin -> Arcade -> Arcade Settings



Adjust these settings:

Select List Type -> Retro

Select Skin Type -> Defiant



When you opt the skin type, specific settings will come up for that skin & list.
You can use those to adjust the appearance of the skin and/or list on your arcade page.



If you want your users to have the option of changing the skin and/or list to their taste you can go to your SMF permission settings and allow various membergroups those profile options. The settings you put in the arcade admin are the defaults.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on November 14, 2020, 09:19:27 PM
Quote from: Daniel Hofverberg on November 09, 2020, 06:18:30 AMNote: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php."

What does that mean, and how do I resolve this?


It means that you've probably upgraded your forum via the admin link in SMF instead of doing it manually. This is a long time bug that they refuse to acknowledge or fix. To fix it, follow this article I've created long ago in the link below. Just make sure that you download the large upgrade package for the SMF version that you are currently using (2.0.17) found here:

https://download.simplemachines.org/

Then follow the article I've made here:

https://www.docskillz.com/docs/index.php?page=page202
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Chen Zhen on November 14, 2020, 09:23:20 PM
I moved that part to a fresh thread about the issue & solved the problem.

ref.
https://web-develop.ca/index.php?topic=616
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Daniel Hofverberg on November 17, 2020, 05:15:41 AM
Quote from: Skhilled on November 14, 2020, 09:19:27 PM
Quote from: Daniel Hofverberg on November 09, 2020, 06:18:30 AMNote: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0. The above error might possibly go away if you execute the latest version of upgrade.php."

What does that mean, and how do I resolve this?


It means that you've probably upgraded your forum via the admin link in SMF instead of doing it manually. This is a long time bug that they refuse to acknowledge or fix. To fix it, follow this article I've created long ago in the link below. Just make sure that you download the large upgrade package for the SMF version that you are currently using (2.0.17) found here:

https://download.simplemachines.org/

Then follow the article I've made here:

https://www.docskillz.com/docs/index.php?page=page202
Thank you. I have managed to upgrade the database now.

It had nothing to do with this issue, as was resolved in this thread (https://web-develop.ca/index.php?topic=616), apart from getting rid of the message about the outdated database - but of course it's good to have the latest database structure for SMF.
Title: Re: E-Arcade to SMF Arcade conversion tool
Post by: Skhilled on November 18, 2020, 11:17:39 AM
No problem. ;D

It can be annoying and can cause issues with some mods. Some mods are coded to make sure the db is the same version as the forum files. It's more of a PITA than anything else. LOL
EhPortal 1.29 © 2021, WebDev