Changeset 272 for dev/common

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:

• dev/common/includes/class.kill.php (modified) (1 diff)

dev/common/includes/class.kill.php

@@ -1014 +1014 @@
                 $this->value = 0;
             $qry = new DBQuery();
-            $qry->execute("select basePrice, price from kb3_invtypes left join kb3_item_price using (typeID) where typeID='".$this->item_->getID()."'");
+            $qry->execute("select basePrice, price
+                            from kb3_invtypes
+                            left join kb3_item_price on kb3_invtypes.typeID=kb3_item_price.typeID
+                            where kb3_invtypes.typeID='".$this->item_->getID()."'");
             if ($row = $qry->getRow())
             {