Changeset 30 for database_list.php

Timestamp:

Dec 16, 2008, 8:15:34 AM (16 years ago)

Author:

george

Message:

• Přidáno: Podpora pro určování v definicích krom tabulky také jméno databáze a jméno primárního identifikačního sloupce.

File:

• database_list.php (modified) (2 diffs)

database_list.php

@@ -7 +7 @@
   function AddItem($TableId, $Values)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
+    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
 
-    $this->Database->insert($TableName, $Values);
+    $this->Database->insert(array('Table' => $TableName), $Values);
     return($this->Database->insert_id);
   }
@@ -17 +17 @@
   function DeleteItem($TableId, $ItemId)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
+    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
-    $this->Database->delete($TableName, 'Id='.$ItemId, array('DeletionTime' => 'NOW()'));
+    $this->Database->delete(array('Table' => $TableName, 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
   }
 
   function EditItem($TableId, $Values, $ItemId)
   {
-    $DbResult = $this->Database->query('SELECT TableName FROM SystemList WHERE Id='.$TableId);
+    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
     $TableName = $DbRow['TableName'];
     $this->DeleteItem($TableId, $ItemId);
     $Values['Id'] = $ItemId;
-    $this->Database->replace($TableName, $Values);
+    $this->Database->replace(array('Table' => $TableName), $Values);
   }
 }