fuzzysteve

import socket
import ssl
from ssl import CERT_OPTIONAL
import datetime
import logging

def ssl_cert_info(hostname):
    ssl_date_fmt = r'%b %d %H:%M:%S %Y %Z'

    context = ssl.create_default_context()

fuzzysteve

3	13692	Jin'taan
32	12858	Suitonia
14	12667	The Judge
45	9353	Steve Ronuken
29	9237	Sullen Decimus
16	8551	rhiload Feron-drake
25	8122	Innominate
51	7852	Dancul1001
7	7479	Yukiko Kami
53	7095	Aryth

fuzzysteve

3   124910  Jin'taan
32  117452  Suitonia
14  115639  The Judge
45  86364   Steve Ronuken
29  83680   Sullen Decimus
16  78109   rhiload Feron-drake
25  73778   Innominate
51  71117   Dancul1001
53  68836   Aryth
7   68104   Yukiko Kami

fuzzysteve

# Please Configure the following variables....
$smtpServer="###########SMTP SERVER GOES HERE###########"
$expireindays = 10
$from = "############EMAIL GOES HERE##############"
$logging = "Enabled" # Set to Disabled to Disable Logging
$logFile = "c:\scripts\logs\o365passwordreminder.csv" # ie. c:\mylog.csv
$date = Get-Date -format ddMMyyyy
#
###################################################################################################################

fuzzysteve

from sqlalchemy import create_engine, Column, MetaData, Table, Index
from sqlalchemy import Integer, String, Text, Float, Boolean, BigInteger, Numeric, SmallInteger, DateTime
import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time

fuzzysteve

from sqlalchemy import create_engine, Column, MetaData, Table, Index
from sqlalchemy import Integer, String, Text, Float, Boolean, BigInteger, Numeric, SmallInteger, DateTime
import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time

fuzzysteve

DROP TABLE IF EXISTS `invVolumes`;
CREATE TABLE `invVolumes` (
  `typeid` int(11) NOT NULL,
  `volume` int(11) DEFAULT NULL,
  PRIMARY KEY (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into invVolumes (typeid,volume)  select typeid,  2500 from invTypes where groupid=324 ;
insert into invVolumes (typeid,volume)  select typeid,  15000 from invTypes where groupid=1201 ;
insert into invVolumes (typeid,volume)  select typeid,  15000 from invTypes where groupid=27 ;

fuzzysteve

 207356 | Jita IV - Moon 4 - Caldari Navy Assembly Plant
 113827 | Amarr VIII (Oris) - Emperor Family Academy
  68836 | Dodixie IX - Moon 20 - Federation Navy Assembly Plant
  45757 | Rens VI - Moon 8 - Brutor Tribe Treasury
  41056 | Hek VIII - Moon 12 - Boundless Creation Factory
  11556 | Saranen V - Moon 9 - Quafe Company Warehouse
  10494 | O1Y-ED VII - Shop Only dock and clone At cita
   8260 | Stacmon V - Moon 9 - Federation Navy Assembly Plant
   7699 | TVN-FM X - TVNo Carriers Near Thera Holes
   7407 | Tash-Murkon Prime II - Moon 1 - Kaalakiota Corporation Factory

fuzzysteve

import time
import requests
from requests_futures.sessions import FuturesSession
import requests_futures
from concurrent.futures import as_completed
import datetime
import csv
import time
from tqdm import tqdm
import sys

fuzzysteve

select it.typeid,typename,
coalesce(a1.valuefloat,a1.valueint,0) Low,
coalesce(a2.valuefloat,a2.valueint,0) Medium,
coalesce(a3.valuefloat,a3.valueint,0) High,
coalesce(a4.valuefloat,a4.valueint,0) Drone,
coalesce(a5.valuefloat,a5.valueint,0) Rig,
coalesce(a6.valuefloat,a6.valueint,0) Subsystem,
it.raceID,
raceName,
coalesce(metagroupname,"Tech I") tech,