1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
from collections import defaultdict
import operator
import db
def search(q):
with db.cursor() as c:
corps = db.query(c, '''
SELECT DISTINCT corporation_id, corporation_name FROM characters
WHERE corporation_name LIKE ?
''', '%{}%'.format(q))
return {'corporations': corps}
def corporation(corp_id):
with db.cursor() as c:
kills = db.query(c, '''
SELECT DISTINCT(kills.kill_id), kill_time,
solarSystemName as system_name, security, regionName as region
FROM kills
JOIN characters ON characters.kill_id = kills.kill_id
JOIN eve.mapSolarSystems ON solar_system_id = solarSystemID
JOIN eve.mapRegions ON mapSolarSystems.regionID = mapRegions.regionID
WHERE corporation_id = ?
''', corp_id)
kill_ids = list(map(operator.itemgetter('kill_id'), kills))
char_rows = db.query(c, '''
SELECT
kill_id, victim, final_blow,
character_id, character_name, corporation_id, corporation_name, alliance_id, alliance_name, faction_id, faction_name,
ship_type_id, typeName AS ship_name
FROM characters
JOIN eve.invTypes ON ship_type_id = typeID
WHERE kill_id IN ({})
'''.format(','.join(map(str, kill_ids))))
characters = defaultdict(dict)
for kill_id in kill_ids:
characters[kill_id]['attackers'] = 1 # count final_blow now
for char in char_rows:
kill_id = char['kill_id']
if char['victim']:
characters[kill_id]['victim'] = char
elif char['final_blow']:
characters[kill_id]['final_blow'] = char
else:
characters[kill_id]['attackers'] += 1
for kill in kills:
chars = characters[kill['kill_id']]
kill['victim'] = chars['victim']
kill['final_blow'] = chars['final_blow']
kill['attackers'] = chars['attackers']
return kills
def kill(kill_id):
with db.cursor() as c:
kill = db.get(c, '''
SELECT kill_time, solarSystemName, security FROM kills
JOIN eve.mapSolarSystems ON solar_system_id = solarSystemID
WHERE kill_id = ?
''', kill_id)
characters = db.query(c, '''
SELECT character_id, character_name, damage, victim, final_blow,
corporation_id, corporation_name, alliance_id, alliance_name, faction_id, faction_name,
ship_type_id, weapon_type_id,
ship.typeName AS ship_name, weapon.typeName AS weapon_name
FROM characters
JOIN eve.invTypes AS ship ON ship_type_id = ship.typeID
LEFT JOIN eve.invTypes AS weapon ON weapon_type_id = weapon.typeID
WHERE kill_id = ?
''', kill_id)
attackers = []
for char in characters:
if char['victim']:
victim = char
elif char['final_blow']:
final_blow = char
else:
attackers.append(char)
item_rows = db.query(c, '''
SELECT type_id, flag, dropped, destroyed, singleton,
typeName AS item_name
FROM items
JOIN eve.invTypes ON type_id = typeID
WHERE kill_id = ? ORDER BY flag ASC
''', kill_id)
items = {}
for item in item_rows:
flag = item['flag']
if 125 <= flag <= 132:
slot = 'subsystem'
elif 27 <= flag <= 34:
slot = 'high'
elif 19 <= flag <= 26:
slot = 'medium'
elif 11 <= flag <= 18:
slot = 'low'
elif 92 <= flag <= 99:
slot = 'rig'
elif flag == 87:
slot = 'drone bay'
elif flag == 5:
slot = 'cargo'
elif 133 <= flag <= 143:
slot = 'special hold'
elif flag == 89:
slot = 'implant'
else:
slot = '???'
if slot not in items:
items[slot] = {'dropped': {}, 'destroyed': {}}
if item['dropped']:
d = 'dropped'
else:
d = 'destroyed'
item_key = '{},{}'.format(item['type_id'], item['singleton'])
if item_key not in items[slot][d]:
items[slot][d][item_key] = [0, item['item_name']]
items[slot][d][item_key][0] += item[d]
return {
'kill': kill,
'victim': victim,
'final_blow': final_blow,
'attackers': attackers,
'items': items,
}
|
