Show
Ignore:
Timestamp:
12/02/06 05:17:10 (14 years ago)
Author:
exi
Message:

Reduced one potential sql-bug.
Added ability to identify items as t2 via their techlevel rather than just 'II'.
Fixed item location 0 to not cause skipping that item.
Added anzahl/quantity-replace for the german killpreparser.
Fixed final blow award to show correct numbers.
Removed unnecessary code from db.php.
Added a table data check to the sql importer and made the importer more verbose, this should minimize support requests caused by empty table data.
Fixed a small misalignment of the comment block.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/common/class.toplist.php

    r129 r133  
    228228 
    229229        $this->sql_ .= " ".$this->sqlbottom_; 
    230         // echo $this->sql_."<br>"; 
     230        // echo $this->sql_."<br/><br/>"; 
    231231        $this->qry_->execute($this->sql_); 
    232232    } 
     
    389389        $sql = "select count(kll.kll_id) as cnt, kll.kll_fb_plt_id as plt_id 
    390390                from kb3_kills kll 
    391               inner join kb3_inv_detail ind 
    392                       on ( ind.ind_kll_id = kll.kll_id) 
    393391              inner join kb3_pilots plt 
    394                       on ( plt.plt_id = ind.ind_plt_id "; 
     392                      on ( plt.plt_id = kll.kll_fb_plt_id "; 
    395393        if ($this->inv_crp_) 
    396394            $sql .= " and plt.plt_crp_id in ( ".substr($this->inv_crp_, 0, strlen($this->inv_crp_) - 2)." )";