Show
Ignore:
Timestamp:
06/14/09 14:06:02 (11 years ago)
Author:
kovell
Message:

kills posted with external id of null, not 0
kb3_pilots unique index on external id changed to index (default is 0, not null)
kb3_kills columns created in correct order

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/common/includes/class.kill.php

    r370 r374  
    851851                if ( $this->timestamp_ == "" || !$this->victimid_ || !$this->victimship_->getID() || !$this->solarsystem_->getID() || 
    852852                !$this->victimallianceid_ || !$this->victimcorpid_ || !$this->getFBAllianceID() || !$this->getFBCorpID() || 
    853                 !$this->getFBPilotID() ) 
    854                 return 0; 
     853                !$this->getFBPilotID() ) return 0; 
    855854                if ($id == null) 
    856855                { 
     
    868867                $qry = new DBQuery(); 
    869868                $sql = "INSERT INTO kb3_kills 
    870             (kll_id , kll_timestamp , kll_victim_id , kll_all_id , kll_crp_id , kll_ship_id , kll_system_id , kll_fb_plt_id , kll_points , kll_dmgtaken, kll_isk_loss) 
     869            (kll_id , kll_timestamp , kll_victim_id , kll_all_id , kll_crp_id , kll_ship_id , kll_system_id , kll_fb_plt_id , kll_points , kll_dmgtaken, kll_external_id, kll_isk_loss) 
    871870            VALUES (".$qid.", 
    872871                    date_format('".$this->timestamp_."', '%Y.%m.%d %H:%i:%s'), 
     
    879878            ".$this->calculateKillPoints().", 
    880879            ".$this->dmgtaken.", 
     880                        NULL, 
    881881            ".$this->calculateISKLoss()." )"; 
    882882                $qry->autocommit(false);