Category: Dev

Updated Bill of Materials (BOM) SQL for the SDE

Just an update for my previous post on SQL for blueprints using the SDE. Now you can generate a complete BOM with a single statement. I now have a use for getting /all/ the numbers out in a single query and that is what you'll find below. You could even, if you so wanted, join […] Read more

Using the Eve Central API with PHP

We're going back to basics here. One thing that many sites, which are using the SDE from Eve, want to do, is access price data from EVE Central api . I don't do this myself, having a EMDR relay , and consumer to provide my market data, but back when I was starting out, I […] Read more

Dev Track Day 2 - Part 2

This was the WebGL session. It's great. Really really great. The only problem is, potentially, delivering the models to the clients. Other than that, it's wonderful. If you can take the loading time, it's great. https://github.com/ccpgames/ go fork it. Not a huge amount to say really. It was demos of graphics stuff. which looked great. Read more

Dev Track - Day 2 - Part 1

Just a small gap between the SSO session and the WebGL session. The SSO looks to be fairly simple to work with. It's a shame that the demo mobile applications which were demonstrated didn't use a native browser, using an embedded one, which is far from good practice with OAUTH2, but they do make them […] Read more

Dev Track - Day 1

Just a quick post, jotted down before I go to get some lunch this morning. the Dirty breakfast at the laundromat is calling my name, and it's quite persuasive. You can see the sessions at http://www.twitch.tv/ccpdevtrack , just hit the videos link on the right hand side. I'd especially recommend you watch the legal one, […] Read more

Market Data API - What I'd like

There's been a bunch of posts on the forums about how cache scraping is bad and against the EULA and how CCP Sreegs hates it. Now, it's been said by some GMs that it's ok, so that's not something I'm going to go into. Sreegs did say that, while he doesn't like scraping for market […] Read more

Useful bits and pieces - Eve SDE

Once you get comfortable with the CCP way of doing things, the SDE isn't too bad to work with. You'll have to dig around in it to get some of the numbers you want, and sometimes it's the opposite way round from what you'd expect, but it's not too bad, most of the time. Here […] Read more

Eve SDE SQL – Blueprint Details - Part 2

I covered the basics of Blueprint details from the SDE back in my last post , which covers most of what people actually want to know. There are a few extra bits which the more dedicated coders will want. They're simple enough to work out, but it's time you might not want to have to […] Read more

Eve SDE SQL - Blueprint Details

As you may know, I'm the 'author' of one of the blueprint calculators that some people use in EVE Online. The one at http://www.fuzzwork.co.uk/blueprints/ If you didn't know that, how did you get here? ;) Anyway, it's not uncommon to see people asking how to get the materials for building something out of the Static […] Read more

Ship Fit Viewer

Been working on a little something, and it looks to be working out nicely. I had been wanting to be able to put in ship fits here, and have them look semi reasonable. And now, I can. Now up on github, with basic integration instructions. https://github.com/fuzzysteve/Ship.js Feel free to use the code directly from here, […] Read more