Changeset 133 for dev/common/class.toplist.php

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:

• dev/common/class.toplist.php (modified) (2 diffs)

dev/common/class.toplist.php

@@ -228 +228 @@
 
         $this->sql_ .= " ".$this->sqlbottom_;
-        // echo $this->sql_."<br>";
+        // echo $this->sql_."<br/><br/>";
         $this->qry_->execute($this->sql_);
     }
@@ -389 +389 @@
         $sql = "select count(kll.kll_id) as cnt, kll.kll_fb_plt_id as plt_id
                 from kb3_kills kll
-              inner join kb3_inv_detail ind
-                      on ( ind.ind_kll_id = kll.kll_id)
               inner join kb3_pilots plt
-                      on ( plt.plt_id = ind.ind_plt_id ";
+                      on ( plt.plt_id = kll.kll_fb_plt_id ";
         if ($this->inv_crp_)
             $sql .= " and plt.plt_crp_id in ( ".substr($this->inv_crp_, 0, strlen($this->inv_crp_) - 2)." )";