ta2edchimp / BattleReporter

Advanced editable BattleReport platform for EVE Online.
1 stars 1 forks source link

Battle Overview: rework battle party sorting #36

Closed ta2edchimp closed 9 years ago

ta2edchimp commented 9 years ago

Sort battle parties not by pilot names, but by:

ta2edchimp commented 9 years ago

T1 Logi Frigs

T1 Logi Cruisers

T2 Logi Cruiser

SELECT * 
FROM `invTypes` 
WHERE typeName IN ('Inquisitor', 'Bantam', 'Navitas', 'Burst', 'Augoror', 'Osprey', 'Exequror', 'Scythe', 'Guardian', 'Basilisk', 'Oneiros', 'Scimitar')
ORDER BY mass DESC, typeName ASC

Carrier

Maybe complete Caps group, else:

Potential SQL for Caps group:

SELECT * 
FROM `invTypes` 
WHERE groupID IN (
    SELECT groupID 
    FROM invGroups
    WHERE groupName = 'Carrier' OR groupName = 'Supercarrier'
        OR groupName = 'Capital Industrial Ship' OR groupName = 'Titan'
        OR groupName = 'Dreadnought' OR groupName = 'Jump Freighter'
) ORDER BY mass DESC, typeName ASC