Changeset 300 for dev/common/kill_detail.php

Timestamp:

12/23/07 18:10:16 (15 years ago)

Author:

exi

Message:

fix for ticket:59
fixed update of item values

Files:

• dev/common/kill_detail.php (modified) (3 diffs)

dev/common/kill_detail.php

@@ -19 +19 @@
             $Val = $_POST[$IID];
             $qry = new DBQuery();
-            $qry->execute("UPDATE kb3_items SET itm_value ='".$Val."' WHERE itm_id='".$IID."'");
+            $qry->execute("INSERT INTO kb3_item_price (typeID, price) VALUES ('".$IID."', '".$Val."') ON DUPLICATE KEY UPDATE price = '".$Val."'");
         }
     }
@@ -26 +26 @@
 if ($page->isAdmin())
 {
-    if (isset($_GET['view']) && $_GET['view']== 'FixSlot'){
-        $smarty->assign('fixSlot', 'true');
-    }
-
-
-         $smarty->assign('admin', 'true');
-         if (isset($_POST['submit']) && $_POST['submit'] == 'UpdateSlot')
-     {
-         $IID = $_POST['IID'];
-         $KID = $_POST['KID'];
-         $Val = $_POST[$IID];
-         $table = $_POST['TYPE'];
-         $old = $_POST['OLDSLOT'];
-         $qry = new DBQuery();
-         $qry->execute("UPDATE kb3_items_".$table." SET itd_itl_id ='".$Val."' WHERE itd_itm_id=".$IID." AND itd_kll_id = ".$KID." AND itd_itl_id = ".$old);
-     }
+    if (isset($_GET['view']) && $_GET['view']== 'FixSlot')
+    {
+            $smarty->assign('fixSlot', 'true');
+    }
+
+    $smarty->assign('admin', 'true');
+    if (isset($_POST['submit']) && $_POST['submit'] == 'UpdateSlot')
+    {
+        $IID = $_POST['IID'];
+        $KID = $_POST['KID'];
+        $Val = $_POST[$IID];
+        $table = $_POST['TYPE'];
+        $old = $_POST['OLDSLOT'];
+        $qry = new DBQuery();
+        $qry->execute("UPDATE kb3_items_".$table." SET itd_itl_id ='".$Val."' WHERE itd_itm_id=".$IID." AND itd_kll_id = ".$KID." AND itd_itl_id = ".$old);
+    }
 }
 
@@ -241 +241 @@
     $menubox->addOption("link", "Delete", "javascript:openWindow('?a=admin_kill_delete&kll_id=".$kill->getID()."', null, 420, 300, '' );");
     $menubox->addOption("link", "Fix Slots", "?a=kill_detail&kll_id=".$kill->getID()."&view=FixSlot");
-    
+
 }
 $page->addContext($menubox->generate());