Monthly Archives: February 2015

CSM X Ballot

I really should post here more. But you know how it is, when you don’t have anything in particular to say.


Anyhoo, The election is here, and I thought it would be worth name checking a few people who you should consider having on your ballot. Of course, the first person should be me, Steve Ronuken. I’d be an idiot to say otherwise. But if you decide that you prefer someone else, just stick me somewhere lower down. Every little helps.

I’m not going to be listing positions on the ballot (other than me first πŸ˜‰ ), because you should vote for people who you think will represent your space and play style best. So someone in Wormholes should probably have Corbexxx second on the list, where as someone in Low should have Sugar Kyle. I’m going to keep the blurbs pretty short, but I do suggest looking them up some more in other media. Shamelessly lifted from Sugar’s blog:

Steve Ronuken

Vote for me, please πŸ™‚ This term’s been great for getting stuff out to the third-party community, then onto everyone else. And industry is in a healthier (if not perfect) place than it used to be. More to do though. Next term, I’m expecting to see more coming out for CREST, which can be a real game changer.

Sugar Kyle

As has been stated by pretty much every other candidate, Sugar’s been doing a wonderful job on CSM 9. Approachable, diligent, and a hard worker. She’s not one for drama either, which I’m a fan of. While she’s spending her time mostly in lowsec, she’s got a good head on her shoulders, and a good understanding of other spaces.


Not the most prolific writer, but a good communicator, and always going to the wider community for feedback and research.

Bam Stroker

Some people talk about helping the community. Bam’s involved in it. Just look at Eve Down Under. I think he’s going to be useful. Sure, he’s in PL, but you can’t have everything.

Jayne Fillon

NPSI is important. Jayne’s been a good representative for it. He’s a touch abrasive, but a chunk of that comes from not suffering fools gladly. NPSI leads to better player retention, as it draws people into wider social groups, and more activities.


Another candidate with good lowsec (FW in this case) experience. And has just branched into wormholes πŸ™‚ Which is handy, for an alternate viewpoint. And Lore!

Psianh Auvyander

Psianh’s a mercenary. And a trainer of mercenaries. I think that brings a useful perspective.

Cagali Cagali

BNI Education, Recruiting and HR. Newbies are important. CagaliΒ² has to work with them on a regular basis. And a degree of nullsec experience is handy, from the non-incumbent perspective.



I have this terrible feeling I’m missing someone. Anyway, go vote (when it opens). You don’t need to fill in all the positions, but do at least 5.

CREST market data

This has been out for a while, but I’ve now got something public ( ) out there, I thought I’d write some words.

Of all the things which have happened in my CSM term, the availability of ‘live’ market data is one of the ones I’m happiest about. It might not seem like a big step, but we now have access to data directly from Tranquility, in a way that has a very low cache time. (I’m expecting some future ones to be even smaller, but that’s more specific data) It’s been a long time coming, and is a step towards removing the ‘requirement’ for the grey area of cache scraping. (Along with the dgmExpressions table being added to the SDE). Grey areas are bad, because they lead people to push the boundaries, and I don’t want to see someone banned for that.

But enough electioneering (Vote for me! πŸ™‚ ), I thought I’d write a little about what it’s doing. I had help in the form of Capt Out’s Crest Explorer which gave me a head start, rather than needing to implement the core ‘Log into the SSO’ bit. After that, it’s just a matter of:

  • Grab the region list. (filtering out the Wormholes)
  • Grab the base market groups.
  • Wait for the user to click something
    • If it’s a market group, grab that specific group, and loop through it for direct children
    • If it’s an item, if a region is selected, grab buy and sell orders, before cramming them into tables
    • If it’s a region, grab the region data for where to get buy and sell order data

That’s pretty much it. There are some twiddly bits (like languages) but the rest of it is just AJAX calls, and looping through the result sets for display. I’d hope the code is fairly simple to understand (if you know any javascript/jquery) but if you have any questions, feel free to throw them my way. for the source. MIT licensed.