Friends,Programmers, lend me your ears...

By bloodycelt, in 1. AGoT General Discussion

bloodycelt said:

In this day and age being able to look a card or more importantly TO rulings and errata would be a boon via mobile.

Besides the FAQ is there another document which would contain more information? If it is just the FAQ I can pretty easily create something that would be useful to refrence on the go.

On the mobile front again, does anyone have a touchphone besides iphone? I think I fixed the image width issues on the card pages but can only test on my iphone. It is looking good on it though. I'm also not sure if an Ipad will display the small or large image, I'll have to borrow a friends. Oh well back to data entry...

Booya. I'm excited.

Darksbane said:

bloodycelt said:

In this day and age being able to look a card or more importantly TO rulings and errata would be a boon via mobile.

Besides the FAQ is there another document which would contain more information? If it is just the FAQ I can pretty easily create something that would be useful to refrence on the go.

On the mobile front again, does anyone have a touchphone besides iphone? I think I fixed the image width issues on the card pages but can only test on my iphone. It is looking good on it though. I'm also not sure if an Ipad will display the small or large image, I'll have to borrow a friends. Oh well back to data entry...

Mobile: Chapter Pack Contents.... looking up what a card does, rulings from (mostly ktom) on a card, and the FAQ.

In terms of community thing: well the big chunk of code i've been working on is a management suite to add/edit/etc cards for the agot database. The second piece after is a REST and SOAP interface for programmers to use said database.

(Though I'll need a host at that point).

The idea is for the largely non-programmer community to have some custodians of the agot database... and to maintain it even if I or you or gualdo are unable to do so. (Exports are nice... but Imports was more of my idea).

mercurial said:

all ear throwing aside..

if anyone is interested....

I need a straight up php/mysql popularity function and table(s) to tally up how many times each card is viewed. Eeach time a card is shown, your function is called to award X points to the card ID for each unique visitor every 24 hours. If the function call is from a list, it is awarded 1 point; from a single card view page it gets 3 points. Your mysql table can store visitor IPs and timestamps for this purpose, for example. Then I need a function to return which X cards are the most popular in the last 24 hours, the last week, month, and ever. Input creativity, code comments, good performance..

If that sort of thing sounds like fun to you, then please email me [email protected]

bloodycelts, did you post your scripts? If not is it live? I am interested in seeing your work.

Are you looking to do a majority of the work in PHP or mySQL? I prefer to do most of the computational work in PHP (a result of the fact that I'm more comfortable with OO/procedural then declarative programming), and only use SQL for simple insert/select/update type statements.

Ok a first draft of a rulings type database:

http://www.cardgamedb.com/index.php/GoT/GoTRulings.html

Very rough so far, I threw a couple records in there as examples. I turned on wiki style editing for this database so anyone can edit anything and add with approval. Added a WYSIWYG editor for ease of formatting. Eventually wiki style editing would likely be restricted to some 'advanced' user group, so not just anyone can change things. Any suggestions? Perhaps it would benefit from more fields being added, like seperate fields for the question and answer. Once it is decided what would be useful and I get the fields nailed down my todo would be something like:

Display ruling/errata for specific cards in that cards page.

Make a robust search page to retrieve the data.

Make sure all pages are formatted nicely for mobile access.

If anyone else can think of other features LMK.

In other news I should have all the card data approved and visible tomorrow. I added Illyrio's Gift tonight and I gotta say the art on those cards is sweet. Art just seems to be gettign better and better for this game.

Nice work on the new site!

As far as additional features go, I sort of liked the ability on Tzu's page to rate cards (0-5, half star increments) with short comments (ratings without comments are a bit bland, it's nice to hear people reason out their opinions). Also, not sure if you can yet comment certain cards? (Might be I just missed that) The HQ scans of the cards are beautiful!

I also like the idea of branching out to other LCGs: CoC only has card information on boardgamegeek (and you hate to jump through too many hoops just to get to a .pdf or .xls file), and a deckbuilder that's not a web application, which limits its usability quite a lot methinks. WH has one site for viewing cards that I'm aware of: http://deckbox.org/games/whi/cards?o=d&p=5&s=e but I'm not sure if it has any other features, maybe a deckbuilder, haven't really studied this.

On the original subject of this thread, I'm more of a Open Source C++/Qt/SQL programmer myself, so I don't have that much experience creating web applications. However, if someone needs an extra arm or leg with something, I'll gladly try to find the time to contribute! :)

~Oh, and do you want those ears in good ole' Van Gogh fashion via post, or can I use DHL or something?

WWDrakey said:

Nice work on the new site!

As far as additional features go, I sort of liked the ability on Tzu's page to rate cards (0-5, half star increments) with short comments (ratings without comments are a bit bland, it's nice to hear people reason out their opinions). Also, not sure if you can yet comment certain cards? (Might be I just missed that) The HQ scans of the cards are beautiful!

I also like the idea of branching out to other LCGs: CoC only has card information on boardgamegeek (and you hate to jump through too many hoops just to get to a .pdf or .xls file), and a deckbuilder that's not a web application, which limits its usability quite a lot methinks. WH has one site for viewing cards that I'm aware of: http://deckbox.org/games/whi/cards?o=d&p=5&s=e but I'm not sure if it has any other features, maybe a deckbuilder, haven't really studied this.

Card rating and comments are already in I added a comment and rated The King's Ground as an example ( and because I like that card :D ). Comments are on the bottom and rate is in upper right but I'm considering moving it around to make it more visible.

I didn't realize CoC was so underrepressented, I had planned to hit Invasion next since I have all the cards but if CoC could use it more I'll do it first. All the card data is finally in so now I'll be focusing on the rulings stuff and mobile access.

Love the work so far. One thing I noticed is that the deck editor filter does not appear to have events as one of the types. It would also be nice to have filters by set.

Great job on what is done though!