So we have...

Rouge's agot search site, and agot dabbler (beautiful interface btw).

Then Gualdo on the octgn plugin.

And me... with a mostly 85% complete deck builder/database built on ruby.

(Oh and porting octgn to Mac cuz im sick of using it in vmware... cards dont always render right.)

Maybe we should uh... collaborate? Setup a sourceforge meta-project and uh group to pool our resources?

I for one know Perl, Ruby, C, C++, Java, Oracle PL/SQL and MySQL (in addition to other langua but I doubt... they would be relevant).

Let me know.

You already know my deal - and I'm willing to help out when I have time. I'm a .NET expert, and I hope to be delving into the OCTGN codebase soon enough in order to add some nice functionality. I may also take a peek at the plug-in and improve some of the menus. Anyway, you have already pinged me a bunch over the phone, and feel free to continue doing that.

We have started from several month the built in of a "Tzumain like" site with integration of OCTGN2 built in. And in september/october will be online beta version. The idea to improve the OCTGN2 engine is great. Since it is an auto update click once application maybe we have to contact the "owner" to coordinate our moves but is only my thinking.

I think that would be great to integrate meeting room inside OCTGN2. Also the Mac version of OCTGN2 is not bad, but at the moment we never thought about that.

bloodycelt said:

Good to hear that someone is working on this. Please let me know as soon as it's up and running. Glad I'm not the only Mac user with OCTGN frustrations. I'm also glad that you have the skills and insight to do something about it by creating a port!

When I first got into this game, I noticed redundant efforts though some were outdated and fading [Tzumainn, the Lackey plugin]. I am glad for Rogue's site as his precision is intense. And of course Gualdo's phenomenal efforts.

In addition to the Gualdo/Sixpounder effort there is a french effort that does all kinds of deck exporting to various formats, but it is in French.

To me the heart of a collaboration is to unify a single mysql database. A single db would minimize the countless hours of data entry and other db maintenance. Main caveat is that public hosts don't allow low level access to change mysql settings. Such access to tweak allows for better text search. At this point the guys just starting new projects would benefit most, but in the long run it would be great.

Another main concern I have is the OCTGN AGOT UUID's and how they may differ from the european and US version as far as my research has shown. I believe that the spanish have their own UUID's unfortunately. I think that putting both UUIDs in an deck exporting app with a toggle on which plugin version is fine but it would be much better if we could internationally link the plugins by using the same UUIDs in each plugin... It's not impossible.

And, I am also putting a deck editor on my site [dbler] ...I actually made some big changes last night in preparation to use more space on the page...

I am looking forward to seeing the various instances of deck editors that are coming out soon. Maybe once all is displayed and layed out there could be a merging.

Well... one could use REST or SOAP for the database. I have a mysql database already working, just need a host. (The database does use Views so it requires 5.1 or higher.)

related to different versions of OCTGN2... there is one universal version and one built by eloooi only for spanish people. He said to me that spanish people when play with "out of spain" ones knows they have to change plugin. Of course we could make a unified version without problem but since OCTGN2 is free anyone can do what he want :-)

I agree that the part of dataentry is very very boring.

We have completed all LCG and most of all CCG so far (only 5ke is missing).

one question bloodycelt, in your DB you have ALL old sets??? if yes could be great if you don't mind take a look in it to make a comparison. As I told our proof is to have a tool that unify all languages so for example we have a main table and anotherone with all the local languages. We will publish at first english one.

Then countries that need it can contact us and we can add translation... in this case if you have already all DB in french could be a great addition...

I would have to change the schema only slightly to add multi-lingual support.

The actual data currently is not correct... I've been noticing issues in my db. I built an import tool to use darthjeff's excel sheet (which is up to AToR i think). The import tool broke on some things like Strength, etc.

After Aug 19th... my free time will increase until April or so.

It would be very nice to have a deck import function in OCTGN to convert a simple list: qty, name, and expansion set to OCTGN format deck.

The alternative is currently to export a list to an XML file from a db that holds all the UUID numbers, and then have the user save the file it to that unusual OCTGN directory... in my opinion isn't going 'take off' very well. Not to mention multiple UUID sets for various versions of the plugins (it would also lessen dependency on a 'universal' UUID db) plugin as localized plugins may appear.

I miss only 5KE in our DB that i'm going to create manually tomorrow :-) boring!!!

I have a excel importer to that started from excel tzumain published and then updated with all LCG staff and missing sets. After I finish it I will be glad to distribute without problems.

We already prepared DB with all cards, images and multilanguage structure. And also the function to build and export OCTGN2 is already in work (since the octgn card guid is managed with a text field no problem to manage different plugins, but I'm not so happy to do that cause I think the way is "unify" players and not have different enviroments).

The only thing we have planned not for "starting date" cause it requires more effort is the meeting room. But will be on the way after the first release.

I miss these 3 cards from 5KE... if someone can send them to me via mail: [email protected] would be great

* Executioner's Block Location Stark
Myrcella Lannister Character Martell
* The Vale Location s-l-b-g-t-m

mercurial said:

Very nice to hear. Thank you.

I'm PHP programmer and I like simple solutions (I have too much work, so everything not really needed is not done - as it's waste of time - and where's time to play?). I'm glad that other people do something, but DB that I own has one positive side - I can do what I want, I can change things, which normally is not recommended - DB lives just like our game. Having central DB don't give me such possibility. But of course I would support any such project as much as I can.

I wanted to do website when you could see currently awaiting OCTGN players (very simple of course - player's contact info, House deck(s) and time left - no registration needed), but lastly hadn't time. So I eagerly await meeting room from our Italian friends.

Gualdo said:

I love it, as long it's LCG

I want also underline a thing... i'm not god... i'm not a good programmer... i am a holy **** programmer... but I put all my free times in this kind of thing cause I love to work to the comunity (utopist socialist inside)... and all the fields well coded in OCTGN2 plugins LCG are from the DB of Rogue that always helped me a lot...

In the future tzumain italian project i will be managing database and i'm gonna due the "manual work"... my friend sixpounder is a genius in this enviroment... me not ;-)

Just to explain that the results of OCTGN2 (it is an american guy not in the forum that one day wrote me an email giving me a draft of plugin) it is a collective work... I made also a Lackey plugin before (as I think lot of people did before)... so let's cooperate for the future...

If some hard skilled programmer can work on the meeting room with OCTGN2 before we start working in that would be great... we can so focuse on site, deck builder, statistics, octgn2 compatibility...

For old sets I started from spreadsheed downloaded from tzumain site... bad thing is that in some sets fields like influence were coded inside card text and not in a influence field... but I think now the DB is complete with 5ke plugin... and step by step all errors found will be corrected so we will have a final complete mysql database...

Unfortunately .NET is sort of a pain, since I own a mac. I run octgn in vmware but things are buggy. After the 19th I'll have a lot more free time since my real job will have released the portals I've been working on.

On a silly note, every time I read the title of the post I want to rip off my ear and throw it at you ala Robin Hood Men in Tights.

Yeah- and I cringe thinking of the majesty of Act III Scene II.

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.

mercurial said:

I don't know PHP but here is the SQL side:

I assume this will work you might need to specity Engine or something, also I don't know your schema so I cant specify foreign keys.

CREATE TABLE card_popularity (

id INT NOT NULL AUTO INCREMENT, Primary Key

card_id INT NOT NULL, Foreign Key to card table.

visitor_id VARCHAR(255) NOT NULL, IP Address

points_award INT NOT NULL,

date_viewed TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, The timestamp auto puts itself as current time.

PRIMARY KEY(id)

);

The Insert is simple:

INSERT INTO card_popularity (card_id, visitor_id, points_award) VALUES (<card_id>, <ip address>, <points>)

The Query which you may want to cache into another table... but since you need different data times etc... you need an entry per lookup.

SELECT card_id FROM card_popularity

WHERE DATEDIFF(GETDATE(),MAX(date_viewed)) < <number of days: 1,7,30>

GROUP BY card_id

ORDER BY SUM(points_award) DESC

LIMIT 0,<X>

Please note this is not tested, but this would be the gist of an inefficnent but working solution, obviously this would need optimization but I figure it should give you something. Hope this helps.

Thanks bloodycelt, that's definitely a useful primer. I wanted to reply also to say that if you (or someone else) wants to own the pop contest function (take your time with it, test it in your own environment, make the code uniquely yours) that would be nicethat is what I'm looking for. Sorry you don't know PHP, though you should be able to pick it up without breaking a sweat. There is plenty that can extend from the main app.. a lot of creativity. On the flip, I'm very much attached to my deck editor since I had spent enough time on it in spring to not want to it now, and I'm going to try to exert a little willpower to get her completed.

Heh, if I had seen this topic a week and a half ago I might not have started my project. I got tired of trying to build my decks with OCTGN so I started work on a deckbuilder and it grew from there. Not trying to step on anyone's toes here but I'm pretty much done.

To check it out go to www.cardgamedb.com .

So what does it have?

Currently I'm focusing on Game of Thrones but plan to branch out into other games eventually.

A Deckbuilder : this is what I started on first. It allows you to filter for cards and add them to your deck with a double click, you can remove them from the deck with a double click. You can save your deck on cardgamedb.com and come back and edit it later, you can save it to your hard drive as a .txt or OCTGN file, or generate BBCode to easily post it just about anywhere. Decks saved on the site can then be submitted to the site and once approved it will be posted in the deck section with a copy being posted in the forums. This section is done except for data entry for the cards. Hopefully that can get done tomorrow. I'll also be adding in more search options. Suggestions for new features are welcome

A Card Gallery : Since the deckbuilder shows images of the cards I needed some nice quality images to display so I scanned in all the cards at a nice resolution and took them for a trip through photoshop to make sure they were all lined up correctly and color corrected. scanning 800ish cards sucks but they are all in except for Ill's Gift which will be in in a couple days.

A Card Spoiler : A more typical card spoiler organized by sets. You can rate individual cards and potentially comment on them (not sure whether it would be better to allow comments in Card Gallery or Spoiler)

A Submitted Decks Section : Submit the deck to the site and once approved it shows up in this section. Allows rating and integrated forum comments.

A Member Map : I didn't write this and IMO it needs some work, but initially it does the job. It is a google maps powered app which lets you set your location. I had one a few years back I coded that did alot more once I get the time I'll likely rewrite it. If anyone decides to use it I'd put the pin on your city not house.

A Small Chat Room : Something the forums came with. 5 user limit but can be expanded if people use it.

Last but not least Forums : All this is integrated with Invision Power Board. A fairly advanced forum with all the bells and whistles. It has facebook and twitter integration, multiple ways to brodcast your posts/decks (Twitter, FB, Digg, Buzz, Reddit, etc) to the world. It also has Facebook 'Like' options, user ratings, topic ratings, RSS feeds, PM system, and extensive user profiles.

The major parts are done. I"m now just down to adding more facebook integration and getting all of the cards into the database but it should be fully functional. I'm still considering it in a beta status because I haven't had a chance to do much testing outside firefox 3.6+. I've done decks with the deckbuilder start to finish in IE, FF, and Chrome and all seem to be working but alittle more testing is needed.

On the programming side so far my biggest challenge has been relearning the nuances of PHP, I've been in a classic ASP and .NET world at work for so long that I haven't touched PHP in years. Its also been fun learning Prototype Javascript library, it makes the AJAX calls and JSON stuff much easier and I couldn't imagine how much more of a pain this would have been to code the JS side of it without it. I'm planning on going over my code and cleaning it up and my Javascript is messy in places, so I'll need to go back and do some adjustments on that. I've been working on it for 11 days or so now and total about 40 or 50 hours of work I'd guess.

Once i get the rest of the card data in I'll make a proper announcement I suppose, but I'd be interested in any of yall's opinions in the meantime.

Darksbane said:

Nice! with a quick once over I really like it. I'll add my general suggestion and have a plot gold/income/claim search function. Also, along those lines what about a gold cost filter and/or an influence costs/bonus filter too?

Very nice!!! Most of all the high quality scan!!! When you'll have update all maybe I'll ask you them to substitute OCTGN2 ones ;-)

Nice! Boy is that looking slick so far.

I am quite surprised at how fast you built it.

I do think however one BIG feature any of these sites need in the wake of mainn going down, is community access to use it. And the code and DB is open source so when one goes down, its easier for someone else to carry the torch.

Just my 2 cents. Kudos on the quick turn around. In terms of interface, however: I so far like Dabbler's. (I think the site is... agot.dabbler.gotdns.org or something like that... mercurial help me out... ).

Another thing to consider and its mostly handled via CSS... a mobile friendly version. In this day and age being able to look a card or more importantly TO rulings and errata would be a boon via mobile.

bloodycelt said:

I second that. Before I buy a chapter pack at the store, I always used to like to double check the contents on tzumainn.

@Lars: Those filters will be coming soon, once I get the full card data in.

@Bloodycelt: Given the sites tight integration with the forums most of the code wouldn't make much sense unless you owned a copy of the forums (around $150) and knew the basics of programming for it. Once I get the rest finished community access to csv/xml dumps of database info should be easy enough. As far as mobile goes, except for the deck builder which has some features the iphone's safari browser doesn't support, the rest of the site should already be mostly formatted for easy mobile viewing. The only issue on mobile viewing of the rest of the site is the images I'm using on pages like this one are alittle big for the iphone. Landscape view looks ok though. It does need a little tweaking on some of the database dump pages but I should be able to fine tune that in the coming weeks.

@jmccarthy: You should be able to do that now, although not all cards are in my database yet. Browse on your phone to http://www.cardgamedb.com/index.php/GoTCards.html and it should show the sets which you can drill down into to view contents. It is working well on my iphone now. Formatting could use alittle work but it is fairly easily readable.

Thanks for the input and kind words. Database entry is going alittle slower than I'd hoped. So I'd say another day or two to finish out the packs