Changeset 38 for trunk/database_list.php

Timestamp:

May 12, 2009, 11:30:51 AM (15 years ago)

Author:

george

Message:

• Přidáno: Typy Color pro výběr barvy a Text pro psaní obsáhlejších textů.
• Opraveno: Ukládání položek do jiných databází než v které je systém.

File:

• trunk/database_list.php (modified) (3 diffs)

trunk/database_list.php

@@ -9 +9 @@
     $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
-    $TableName = $DbRow['TableName'];
 
-    $this->Database->insert(array('Table' => $TableName), $Values);
+    $this->Database->insert(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database']), $Values);
     return($this->Database->insert_id);
   }
@@ -19 +18 @@
     $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
     $DbRow = $DbResult->fetch_assoc();
-    $TableName = $DbRow['TableName'];
-    $this->Database->delete(array('Table' => $TableName, 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
+    $this->Database->delete(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database'], 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
   }
 
@@ -27 +25 @@
     $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(array('Table' => $TableName), $Values);
+    $this->Database->replace(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database']), $Values);
   }
 }