Changeset 15 for database_list.php

Timestamp:

Oct 19, 2008, 8:16:37 PM (16 years ago)

Author:

george

Message:

• Upraveno: Mezitabulkovéí odkazy na položky jsou nyní realizovány jako odkazy na id položky(ItemId) namísto id řádku v tabulce(Id).

File:

• database_list.php (modified) (1 diff)

database_list.php

@@ -15 +15 @@
     $Values['ItemId'] = $AutoincrementId + 1; 
     $this->Database->insert($TableName, $Values);
+    return($Values['ItemId']);
   }
 
   function DeleteItem($TableName, $Id)
   {
-    $this->Database->update($TableName, 'Id='.$Id, array('DeletionTime' => 'NOW()'));
+    $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
+    $DbRow = $DbResult->fetch_assoc();
+    $this->Database->update($TableName, 'Id='.$DbRow['Id'], array('DeletionTime' => 'NOW()'));
   }
 
   function EditItem($TableName, $Values, $Id)
   {
-    $DbResult = $this->Database->select($TableName, 'ItemId', 'Id='.$Id);
-    $DbRow = $DbResult->fetch_assoc();
-    $Values['ItemId'] = $DbRow['ItemId'];
+    $this->DeleteItem($TableName, $Id);
+    $Values['ItemId'] = $Id;
     $Values['Author'] = $this->System->Modules['User']->User['Id'];
     $Values['CreationTime'] = 'NOW()';