Changeset 412

Show
Ignore:
Timestamp:
07/09/09 19:31:07 (11 years ago)
Author:
kovell
Message:

Fixes: Upgrade correctly calculates ship loss value

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/upgrade.php

    r411 r412  
    389389                                        $sql = 'UPDATE kb3_kills 
    390390                                                natural join tmp_price_ship 
    391                                                 natural left join tmp_price_destroyed '; 
    392                                         if(config::get(kd_droptototal)) $sql .= ' natural left join tmp_price_dropped '; 
     391                                                left join tmp_price_destroyed on kb3_kills.kll_id = tmp_price_destroyed.kll_id '; 
     392                                        if(config::get(kd_droptototal)) $sql .= ' left join tmp_price_dropped on kb3_kills.kll_id = tmp_price_dropped.kll_id '; 
    393393                                        $sql .= 'SET kb3_kills.kll_isk_loss = tmp_price_ship.value + ifnull(tmp_price_destroyed.value,0) '; 
    394394                                        if(config::get(kd_droptototal)) $sql .= ' + ifnull(tmp_price_dropped.value,0) ';