Changeset 272 for dev/common

Show
Ignore:
Timestamp:
12/06/07 14:17:24 (14 years ago)
Author:
exi
Message:

Fixed sql error on kill.
Step 42 should now continue to 43.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/common/includes/class.kill.php

    r254 r272  
    10141014                $this->value = 0; 
    10151015            $qry = new DBQuery(); 
    1016             $qry->execute("select basePrice, price from kb3_invtypes left join kb3_item_price using (typeID) where typeID='".$this->item_->getID()."'"); 
     1016            $qry->execute("select basePrice, price 
     1017                            from kb3_invtypes 
     1018                            left join kb3_item_price on kb3_invtypes.typeID=kb3_item_price.typeID 
     1019                            where kb3_invtypes.typeID='".$this->item_->getID()."'"); 
    10171020            if ($row = $qry->getRow()) 
    10181021            {