KB: Our Losses to UCE not showing?

[friznit]

Any idea why UCE's kills aren't showing up on the KB?

[Fear]

How odd. That makes no sense but I shall try to figure it out.

[Fear]

Found out why, this was hard-written into the code:

Code: Select all

if (!in_array($inv->getAllianceID(), $invall) && $inv->getAllianceID() != 14)
            {
                array_push($invall, $inv->getAllianceID());
                $qry->execute("insert into kb3_inv_all values ( ".$this->getID().", ".$inv->getAllianceID()." )") or die($qry->getErrorMsg());
            }
            

and UCE's alliance ID is 14.

This will mean to correct I shall have to re-process every killmail.

Looks like some testing code that they forgot to remove before releasing.

[Fear]

MOAR updates:

Removed bug from code and ran a query to create the missing data as best as I could.

Code: Select all

insert into kb3_inv_all
select kb3_inv_crp.inc_kll_id, 14
from kb3_inv_crp,kb3_corps
where kb3_inv_crp.inc_crp_id=kb3_corps.crp_id
and kb3_corps.crp_all_id=14

Code included here as a reference so I know what I did if I have to come back to it.

Should be all fixed now.

[Fear]

For anyone who is interested, I've worked out what happened.

Alliance ID 14 is typically 'None', however for some reason in our database the alliance 'None' has ID 2, not 14.

I have amended the code to exclude alliance ID 2 now and then I ran this:

Code: Select all

DELETE FROM kb3_inv_all WHERE ina_all_id =2

to remove all the entries made in error to date.

This is the last post on the subject I promise.

[friznit]

Woo! I think.

[northwesten]

no no pl4ease go on i interested