EVE Forums

 
Capture Portrait
  • Date of Birth: 2011-06-26 15:46
  • First Forum Visit: 2011-09-06 21:11
  • Number of Posts: 7,609
  • Bounty: 0 ISK
  • Likes Received: 6,491

Steve Ronuken

Security Status 4.9
  • Fuzzwork Enterprises Member since
  • Vote Steve Ronuken for CSM Member since

Last 20 Posts

  • Vote Xenuria for CSM 12 in Council of Stellar Management

    Mr Hyde113 wrote:
    I had to share car rides with Xenuria to and from the airport at both summits. He did not murder me.
    +1

    Edit: Also he got you pink skins.



    I should note, pink skins have been heavily pushed in the past. Sugar _kept_ asking for them. Big smile

    (Pink skins being short hand for 'oh god, give me bright colors')

  • sde-20170216-TRANQUILITY Converted in EVE Technology and Research Center

    Just in case people missed it, the conversion script is available from https://github.com/fuzzysteve/yamlloader

    Takes a wee while to do the conversion, and really needs to be on a 64 bit machine (some of the yaml is quite large, and I've not implemented a patch someone sent a pull request in for.)

    You'll want to get the libyaml library installed, because otherwise it's painful as hell. And an appropriate database library. I've used this with postgres, mysql, sqlite and mssql (but I don't do the latter, because I run this all on a linux box, and the mssql for linux installer doesn't like it)

  • Compressed Ore Calculator? in EVE Gameplay Center

    What you want to do is build a spreadsheet using a linear programming solver.

    Both excel and google sheets can do this.

    Ore compression is just a reworded diet problem. nutrients as minerals, foods as ores, price as volume.

  • Citadel Market Data in EVE Technology and Research Center

    As I said, I'm rolling citadel prices into the regional averages.

    (in an attempt to keep the data down to a minimum)

  • Marketable Items TypeID in EVE Technology and Research Center

    Jaseac wrote:
    I tried to use the version from eve-marketdata.com, and that one didn't seem to be right. i downloaded the latest file off of https://www.fuzzwork.co.uk/dump/latest/ but the numbers it has for items is completely wrong



    In what way?

    https://www.fuzzwork.co.uk/dump/latest/invTypes.csv.bz2 right?

  • Marketable Items TypeID in EVE Technology and Research Center

    you want to get rid of everything which doesn't have an entry in marketgroupid.

    If you have a copy of invTypes, it's the easiest way to do it.

  • Silly question about CSM summit in Iceland in Council of Stellar Management

    Knitram Relik wrote:
    Thanks for the detailed info. Obviously it's more work than play for the CSM. It's good to know that CCP pays for most of the expenses. I assume that if a CSM wanted to bring a guest that flight and extra cost would be on the CSM. I'm not planning on running for CSM anytime soon. I'm just more interested in it from an academic standpoint.



    Correct.

    Depending on the room, you can probably share with one person. (Every room I've been in was a double)

  • How to deal with huge amount of market data? in EVE Technology and Research Center

    there's no orders on page 4809. That's why it's an empty array.

    Ask for each page in turn, checking the size of the returned array. When it's empty, stop asking.

  • How to deal with huge amount of market data? in EVE Technology and Research Center

    That's interesting. I _think_ you've got a bug.

    I'm downloading the entire market and it's around the 170MB mark. And that's for _everything_

    If you can read python https://github.com/fuzzysteve/FuzzMarket/blob/master/scripts/aggloader-esi.py may be of interest.

    It's how I'm downloading everything (including public citadels. There's a config file I've not included which has some details in it)

  • sde-20170216-TRANQUILITY Converted in EVE Technology and Research Center

    Mysql
    https://www.fuzzwork.co.uk/dump/mysql56-sde-20170216-TRANQUILITY.tbz2

    SQLite
    https://www.fuzzwork.co.uk/dump/sde-20170216-TRANQUILITY/eve.db.bz2

    Postgres
    https://www.fuzzwork.co.uk/dump/sde-20170216-TRANQUILITY/postgres-20161213-TRANQUILITY.dmp.bz2

    Postgres, in the evesde schema
    https://www.fuzzwork.co.uk/dump/sde-20170216-TRANQUILITY/postgres-20161213-TRANQUILITY-schema.dmp.bz2

    Everything else

    https://www.fuzzwork.co.uk/dump/sde-20170216-TRANQUILITY/

  • Silly question about CSM summit in Iceland in Council of Stellar Management

    CCP cover the flight, and the hotel for the duration of the summit.

    An individual member can arrange with CCP for flights to be early/late, and cover extra days at a hotel themselves. I.e. fly in 4 days early (ccp's dime), cover 4 nights in a hotel yourself, do the summit (ccp's dime), fly out (ccp's dime)

    Depending on which hotel it is, transport to ccp can be covered. Transport back isn't (as you'll probably be stopping off in the city center for dinner)

    Breakfast is available at the hotel, or at CCP. (free)
    Lunch is available at CCP (free)
    Dinner is available at CCP for one day (or 2, depending on which days the summit is on. free)
    A final dinner is covered by CCP.

    So you have to cover dinner the other nights, and any booze.


    If I had to pay for it, I probably wouldn't be doing every summit, just from a cost perspective.


    From the last one:
    Fly in on Sunday.
    Summit runs Monday till Thursday, 9am or 10am till 5pm or 6pm
    Fly out on Friday. (yay, my flight took off at 7:40 am. and the airport is an hour out of Reykjavik)

  • I run for CSM on the platform of Completing Captians Quarters. in Council of Stellar Management

    The CSM doesn't get to set CCP's development priorities.

    And one feature which may have no work done on it (I'm being very very generous with that "may") is a very weak platform to run on.

    At the very least, let people know what you do, and what you know.

  • Sick and tired of shield miners in EVE Technology and Research Center

    The real reason has been given.

    More low slots = people will just cram them full of mining laser upgrades, not tank.

  • Citadel Market Data in EVE Technology and Research Center

    on the API page :D

  • How to handle expiring ESI tokens? in EVE Technology and Research Center

    Ilvari wrote:
    Thanks, I figured it was silly if we had to do it that way, but because Swagger works like that I was a bit concerned.

    Just for reference, how I'll be doing it:
    1. Send the user to https://login.eveonline.com/oauth/authorize?response_type=code&redirect_uri=https%3A%2F%2Fwebsite.com%2Fcallback.html&realm=ESI&client_id=776000000000098c0bf36f4e144e1d&scope=esi-markets.structure_markets.v1

    He authorizes the app, then gets redirected to a website that fetches the code from the URL and displays it to the user. The user then copy & pastes the code into the application

    2. Upon entering the code, have the application do a
    curl -i --compressed -X POST --header "Accept: application/json" --header "Authorization: Basic NzcsMw==" --data "grant_type=authorization_code&code=P-tux11g4Qo0000000000000000YtpYWYPu0" "https://login.eveonline.com/oauth/token"
    request with that code, then discard the code, and store the refresh_token

    3. Next, ever time the API needs to be queried, do a
    curl -i --compressed -X POST --header "Accept: application/json" --header "Authorization: Basic NzcMw==" --data "grant_type=refresh_token&refresh_token=UKmRhoj0000000000000000000Wdr9H_vI5Q1" "https://login.eveonline.com/oauth/token"
    to get an access token

    I don't really want to go through the effort of having to include an entire HTTP server (and then be responsible for its security) with a little app. Using a pre-existing website to do that seems to be the smarter choice.



    To neaten it up a little, I'd present the refresh token to the user to copy and paste, rather than the access code.

    Just means you're always working with that, rather than having to provide a route to provide an access code, which requires the storage of an refresh token.

  • Question about Quering Recipies in EVE Technology and Research Center

    <3

  • Question about Quering Recipies in EVE Technology and Research Center

    Kosomot wrote:
    Thanks Steve;

    So I'm looking at all that now, and it looks like it's all YAML data now.

    Am i lookingat the wrong data set, maybe there is a SQL dump i'm missing.

    Hmm..


    Thanks for the help.




    If you check my site, there are sql conversions :D

  • Question about Quering Recipies in EVE Technology and Research Center

    The SDE has the recipes in it.

    planetSchematics for the schematics
    planetSchematicsTypeMap for the details of what goes in and what comes out
    invTypes to take the typeids in TypeMap to names.

    planetSchematicsPinMap for what schematic goes into which facility

  • Citadel Market Data in EVE Technology and Research Center

    Citadels are now implemented on my site :)

    However, I'm just rolling them into the region, wrt the prices I'm providing via the api on the site.

  • How to handle expiring ESI tokens? in EVE Technology and Research Center

    David Davaham wrote:
    OMG no

    I am not sure how to do it for desktop applications, but what i have heard is that you need to make your callback http://localhost. Make sure you pick a random port number to listen on as well. Something in the tens of thousands. Have them click on a button that they authorize in your application with. They click that button, authorize the app and then they are redirected back to the localhost address that you have as your call back. Display an html website or something that is easy. Take the accessToken and refreshToken that you receive from that and make calls to the /auth/token endpoint to get a new accessToken every 19 minutes or how ever often you want to do. You just have to make sure you have some sort of method of make and receive calls using HTTPS from you application without it hindering user experience.



    For desktop apps, this is one way to do it, yes.

    You do _not_ want to do the username/password entry within the application itself. This is a massive security risk, and I'll yell about any applications I see that do this. (Personal use is fine, but not if you distribute it)

    Send the user to their system browser. Have them auth there, have it send it back to your app in one of the following manners:

    Embed a webserver: This is a fairly easy, and portable. It's not the easiest of things to do, but it works.

    Define a custom url scheme, and use that to get back to your application. So your callback url is something like myawesomeapp://localhost/auth And that's set to open up your application, and auth it.

    The second is a touch more complicated to do, as you'll need to work out how to register it, and have a way to pass the auth over from a second instance of the app, to the one that started things.

    https://msdn.microsoft.com/en-us/library/aa767914(v=vs.85).aspx covers registering it on windows. Most installers have a way to do this.

    As for the second part, one way is to open up socket when the app starts. If you can't bind it, then it's the second instance, and you pass the auth over via the socket.


    An alternate method is to handle the auth entirely on a webserver, and just present the refresh token to the user, who can then copy and paste it into the local app. (in the same way you'd do an api key)

Forum Signature

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter