Changeset 16 for lists

Timestamp:

Oct 21, 2008, 9:05:41 AM (16 years ago)

Author:

george

Message:

• Opraveno: Načítání smazaných položek typů a seznamů.
• Upraveno: Menu nyní realizováno přes seznam SystemMenu namísto vlastností seznamů.
• Přidáno: Obrázky pro akce zobrazit, editovat a smazat.

Location:

lists

Files:

• SystemList.php (modified) (1 diff)
• SystemListItem.php (modified) (1 diff)

lists/SystemList.php

@@ -18 +18 @@
 }
 
+function ListSystemListOnEdit($Parameters)
+{
+  global $Database;
+
+  $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE ItemId='.$Parameters['ItemId'].' ORDER BY `Id` DESC LIMIT 1,1');
+  $DbRow = $DbResult->fetch_assoc();
+  if($DbRow['TableName'] != $Parameters['TableName'])
+    $Database->query('RENAME TABLE `'.$DbRow['TableName'].'` TO `'.$Parameters['TableName'].'`');
+}
+
 ?>

lists/SystemListItem.php

@@ -6 +6 @@
 
   //print_r($Parameters);
-  $DbResult = $Database->select('SystemType', 'DbDataType', 'Id='.$Parameters['Type']);
+  $DbResult = $Database->query('SELECT DbDataType FROM SystemType WHERE ItemId='.$Parameters['Type'].' ORDER BY Id DESC LIMIT 1');
   //echo($Database->LastQuery);
   $DbRow = $DbResult->fetch_assoc();
-  $DbResult = $Database->select('SystemList', 'TableName', 'Id='.$Parameters[$Parameters['Column']]);
+  $DbResult = $Database->query('SELECT TableName FROM SystemList WHERE ItemId='.$Parameters[$Parameters['Column']].' ORDER BY Id DESC LIMIT 1');
   //echo($Database->LastQuery);
   $DbRow2 = $DbResult->fetch_assoc();