PDA

View Full Version : HS Database dump?


LMB
October 20th, 2009, 03:44 AM
I've been tossing around an idea for generating cards in a different, more traditional CCG style (because, seriously... what were they thinking when they came up with this wacky shape?) and was thinking if I had all the stats/values/etc from all the cards in a database I could make a template with HTML and use PHP to create "pages" that I'd output as a PDF file that I could easily print.

Writing the code is easy, inputting all that data... not something I really want to do. So, does anyone know of a HS SQL data file out there anywhere? It doesn't matter if it's exactly how I want it, I can always load it into a table that fits and write a script to convert it to a form more convenient for my project.

Harlax
October 20th, 2009, 07:30 AM
...

Cavalier
October 20th, 2009, 09:47 AM
There are several spreedsheets about that have the data compiled, although usually pretty roughly from a DB perspective. I personally have gleened data from GaryLASQ's web site (http://heroscape.glasq.com/) and Bixby's Hextreme HeroScape Spreadsheet (http://www.heroscapers.com/community/showthread.php?t=6173) for my own personal use.

Ryougabot
October 20th, 2009, 12:01 PM
You have reminded me to update my spreadsheet (http://www.heroscapers.com/community/downloads.php?do=file&id=53). You can use the data in the sheet to drive a SQL query.

On a side note, the shape of the cards is probably an artistic decision. Everything in HS is base 6, everything an CCG is base 4. Also, the cards all fit between two 7-hex tiles without moving.

LMB
October 20th, 2009, 10:26 PM
You have reminded me to update my spreadsheet (http://www.heroscapers.com/community/downloads.php?do=file&id=53). You can use the data in the sheet to drive a SQL query.

On a side note, the shape of the cards is probably an artistic decision. Everything in HS is base 6, everything an CCG is base 4. Also, the cards all fit between two 7-hex tiles without moving.

I'm sure the decision was artistic it just makes so many other things difficult... at least for me.

I have all my cards in protective covers but they cost more and look less attractive than card covers and they don't seem to protect the card as well. It's still possible to bend the "corners" and this happens too often when I'm teaching a young person how to play the game. With homebrewed cards that I can replace just by running a script I'll be able to focus more of teaching the game and having fun than having to say "Whoa junior, take it easy on those cards!"

I'll download your spreadsheet and see what I can do with it, thanks for pointing it out.

Ryougabot
October 21st, 2009, 10:48 AM
I updated it with all the correct powers. Have fun.