Changeset 272

Timestamp:

12/06/07 14:17:24 (12 years ago)

Author:

exi

Message:

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

Location:

dev

Files:

• common/includes/class.kill.php (modified) (1 diff)
• install/install_step42.php (modified) (1 diff)
• packages/database/kb3_items_dropped/sql_tbldata_items_dropped.sql.gz (deleted)

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())
             {

dev/install/install_step42.php

@@ -1 +1 @@
 <?php
-$stoppage = true;
+$stoppage = false;
 
 include_once('../kbconfig.php');