biow0lf / evedev-kb

Automatically exported from code.google.com/p/evedev-kb
1 stars 0 forks source link

Some addition in class.kill.php and class.killlisttatble.php #185

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Is it possible to add this function (or something that does the same thing but 
better coded [AND kll_ship_id = 670 must be changed]) in class.kill.php :

    /**
     * Return Podkill ID
     * @return integer
     */
    function getPodKillID()
    {
        $this->execQuery();
        $qry = DBFactory::getDBQuery();
        $sql = "SELECT kll_id
            FROM kb3_kills
            WHERE kll_timestamp <= ADDTIME( '" . $this->timestamp . "' , '00:03:00' )
            AND kll_timestamp >= SUBTIME( '" . $this->timestamp . "', '00:03:00' )
            AND kll_ship_id = 670
            AND kll_victim_id = " . $this->getVictimID();
        $qry->execute($sql);
        $_row = $qry->getRow();
        return $_row['kll_id'];
    }

And this in class.killlisttable.php (in the while boucle [function generate]) :

            // Podkill ?
            $kll['pod_id'] = $kill->getPodKillID();

So in the tpl, we can display a small image on the shipimage to see if the 
pilot has been podded.

I've already done here : http://babylonknights.com/kb/ See the Hurricane 
"eliteranger derp" killed at 04:03 on Wednesday, December 7th

I think this can be added in the core files without any issue 'cause modifying 
core files is a bad thing when updating the board.

(Sorry for my engish)

Original issue reported on code.google.com by khyinn on 9 Dec 2011 at 10:32