fuzzysteve

select coalesce(typename,'Role Bonus') name,bonusText,
coalesce(if(invTraits.unitid=139,bonus,concat(bonus,displayName)),'') bonus 
from invTraits 
left join invTypes on (invTraits.skillid=invTypes.typeid) 
left join eveUnits on (eveUnits.unitID=invTraits.unitID) 
where invTraits.typeid=:id


requires:
https://www.fuzzwork.co.uk/dump/rubicon-1.1-94321/invTraits.sql.bz2

fuzzysteve

+------------------------+----------+----------+
| reprocessingEfficiency | count(*) | Security |
+------------------------+----------+----------+
|                    0.5 |     2708 | high     |
|                    0.4 |        1 | high     |
|                   0.35 |       26 | high     |
|                   0.32 |       95 | high     |
|                    0.3 |      155 | high     |
|                   0.25 |       10 | high     |
|                    0.5 |     1476 | low      |

fuzzysteve

<?php
$ch = curl_init();
$url="http://public-crest-sisi.testeveonline.com/industry/systems/";
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, true);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
$result = curl_exec($ch);

if ($result===false) {

fuzzysteve

SELECT it2.typename,
it2.typeid,
coalesce(dta2.valueInt,dta2.valueFloat) multiplier,
coalesce(dta3.valueInt,dta3.valueFloat) me,
coalesce(dta4.valueInt,dta4.valueFloat) te,
coalesce(dta5.valueInt,dta5.valueFloat) runs
FROM invTypes 
JOIN industryActivityMaterials iam ON (iam.materialtypeid=invTypes.typeid and iam.activityid=8 and groupid=716)
JOIN industryActivityProducts iap ON (iam.typeid=iap.typeid)
JOIN dgmTypeAttributes dta on (dta.typeid=invTypes.typeid and dta.attributeID=1115)

fuzzysteve

<?php
namespace FuzzyCrest;

use FuzzyCrest;

class CrestHandler
{

    private $useragent="Fuzzwork Market agent 1.0";
    private $expiry=0;

fuzzysteve

function loadSystemVolume(typeid,systemID,sellbuy,cachebuster){
  if (typeof systemID == 'undefined'){
    systemID=30000142;
  }
  if (typeof typeid == 'undefined'){
    throw 'need typeids';
  }
  if (typeof cachebuster == 'undefined'){
    cachebuster=1;
  }

fuzzysteve

Sub LoadPrices()
    Dim oHttp As Object
    Dim jsonText As String
    Dim jsonObj As Dictionary
    Dim jsonRows As Collection
    Dim jsonRow As Dictionary
    Dim costInex As Collection
    Dim ws As Worksheet
    Dim currentRow As Long
    Dim startColumn As Long

fuzzysteve

from collections import defaultdict

import sys

# --------
# - Read in the BLT file
# --------

fname = sys.argv[2]
fp = open(fname, "r")

fuzzysteve

import argparse
import textwrap
import wx
from wx.lib.pubsub import pub
import os
import csv
import requests
import grequests
import time
import locale

fuzzysteve

import base64
from email.mime.text import MIMEText
import mimetypes
import httplib2
import os
import ConfigParser
import re
import datetime
from email import utils