Changeset 422 for dev/mods

Show
Ignore:
Timestamp:
07/14/09 07:36:00 (11 years ago)
Author:
kovell
Message:

Fixes: Rank mod toplists correctly limit by plt/crp/all, install not incorrectly called automatically. Modifying the cost of a kill updates the summary tables.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/mods/rank_mod/rank.php

    r392 r422  
    2525        if ($this->invall_) 
    2626            $sqlbottom .= " and ind.ind_all_id = ".$this->invall_->getID(); 
    27  
     27                $sqlbottom .= " and itm.volume < '12000' 
     28                                                          and itm.typeName != 'Unknown' 
     29                                                          group by ind.ind_wep_id order by 1 desc"; 
    2830        $this->setSQLTop($sql); 
    29                 $this->setSQLBottom(" and itm.volume < '12000' 
    30                                                           and itm.typeName != 'Unknown' 
    31                                                           group by ind.ind_wep_id order by 1 desc"); 
     31                $this->setSQLBottom($sqlbottom); 
    3232    } 
    3333} 
     
    5555            $sqlbottom .= " and ind.ind_all_id = ".$this->invall_->getID(); 
    5656 
     57                $sqlbottom .= " and ind.ind_shp_id != 31 
     58                             and shp.shp_class != 17 
     59                             group by ind.ind_shp_id order by 1 desc"; 
    5760        $this->setSQLTop($sql); 
    58         $this->setSQLBottom(" and ind.ind_shp_id != 31 
    59                              and shp.shp_class != 17 
    60                              group by ind.ind_shp_id order by 1 desc"); 
     61        $this->setSQLBottom($sqlbottom); 
    6162    } 
    6263} 
     
    232233$shiplist->addInvolvedPilot($pilot); 
    233234$shiplist->generate(); 
     235 
    234236 
    235237// modified the topshiplist to show also the class (1 query = all data) XD