ta2edchimp / BattleReporter

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

Admin: Refetch killmails for missing lossvalues #48

Closed ta2edchimp closed 9 years ago

ta2edchimp commented 9 years ago

In Admin.php:22, change query according to extracted brCorporations and brAlliances table:

$combatants = $db->query(
    "select c.*, ifnull(cc.corporationName, 'Unknown') as corporationName, ifnull(a.allianceName, '') as allianceName " .
    "from invGroups as g right outer join invTypes as t " .
        "on g.groupID = t.groupID " .
    "right outer join brCombatants as c " .
        "on t.typeID = c.shipTypeID " .
    "left outer join brCorporations as cc " .
        "on c.corporationID = cc.corporationID " .
    "left outer join brAlliances as a " .
        "on c.allianceID = a.allianceID " .         
    "where c.died = 1 and c.priceTag <= 0"
);