Magic Online DB parsed!

by **Max mtg** » 02 Jul 2011, 15:20

Hello,

Hope, anyone comments on my topic on these sunny and warm days.
Well, I have made a mtgo card database parser and now one can have the latest oracle-fresh cards and their descriptions right from magic online.

The program is provided in source codes, so no malware should be inside.
There are three projects:
- WinUI is a windows appication to browse through the database and has a nice "make booster" function (no need to buy boosters just to see what will be there inside).
- Logics contains reader for mtgo data
- WebUI is a asp.net mvc website where one can see all cards that belong to each set and get some detailed information on each card by clicking on its image ot name.

Here is the download link: http://www.mediafire.com/?oaamu9tykb7eyy5
To build it one needs either Visual Studio 2010 or Visual Web Developer 2010 Express with asp.net mvc 3 framework installed.

If you do not see much pictures compared to screenshots, check the web.config and app.config files (to set up paths to mtgo and saved cards images (used by forms app) on your disk). Ask questions here is it does not work.

Personally I have no idea what to do about this next. A browser-based client for magic online (or its analogue) would be most wonderful, but I have no idea how deal with the copyrights wizards have implied on the game and artworks from it.

Sorry, before Sept 28th the file was password-protected. There is not password on the rar now

by **kevlahnota** » 28 Sep 2011, 02:31

Hi, what's the password?

by **Max mtg** » 28 Sep 2011, 04:32

Thanks for your question. I was sure the archive does not need any password and was wondering why there are no replies to my topic.

Of course, there is a version without password: http://www.mediafire.com/?oaamu9tykb7eyy5
It hasn't changed much for last months since my efforts were focused on Forge.

Please post any questions right here

by **TheWolfen** » 24 Apr 2012, 21:35

any way to get this working again? at the moment im getting an ArrayOutOfBoundsException, if i try to compile it. :/

also, my visual C# 2010 express with ASP can't open the webUI project, maybe because this would be for Visual Web Developer 2010 then?!

any help would be appreciated.

by **mark** » 19 May 2012, 20:20

if you just need the database, you can use the one in the attached zip file. I used magiccard.info's downtime today to write my own database :-)

I also wrote a minimalistic CGI that enables me to search the db from my browser, but I did not include the CGI because everyone can do this better after 30 minutes of hacking, and in his favorite language too :-)

Here is the readme:

You can download cockatrice from http://cockatrice.de/ and use it's oracle program to download
the carddata you need. This will create a file cards.xml, which is a fat and slow, plain XML
datafile.

The oracle2sql.pl Perl script converts this XML file into SQL instructions, which you can
redirect into a file, e.g. with
perl oracle2sql.pl > database.sql

You can feed this file into sqlite3, e.g. with the command
sqlite3 -init database.sql database.db

Then you can write your application/CGI/whatever to use the database.db file, which is smaller
and much faster than this XML bloat.
You can see the database scheme at the beginning of the oracle2sql.pl script; there is a table
for the sets, one for cards and one for the n-m-relation between sets and cards.
Extend it if you like, e.g. HQ URLs are not used for now.

For your convenience I included all mentioned files in this archive, except for cockatrice sources,
of course. I used the git version, it works.
This archive includes all cards up to and including Avacyn Restored.