Changeset 23 for lists/SystemList.php

Timestamp:

Oct 22, 2008, 12:54:08 PM (16 years ago)

Author:

george

Message:

• Opraveno: Odkazy na konstanty id typů.
• Upraveno: Definice událostí manipulace se seznamy jako třídy a jejich načítání "na přání".

File:

• lists/SystemList.php (modified) (1 diff)

lists/SystemList.php

@@ -1 +1 @@
 <?php
 
-function ListSystemListOnAdd($Parameters)
+class ListSystemList
 {
-  global $Database;
+  function OnAdd($Parameters)
+  {
+    global $Database;
 
-  $Database->query('CREATE TABLE IF NOT EXISTS `'.$Parameters['TableName'].'` (
-  `Id` int(11) NOT NULL auto_increment,
-  `ItemId` int(11) NOT NULL,
-  `Author` int(11) NOT NULL,
-  `ValidTimeFrom` datetime default NULL,
-  `ValidTimeTo` datetime default NULL,
-  `CreationTime` datetime default NULL,
-  `DeletionTime` datetime default NULL,
-  PRIMARY KEY  (`Id`)
-  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
-  //echo($Database->LastQuery);
-}
+    $Database->query('CREATE TABLE IF NOT EXISTS `'.$Parameters['TableName'].'` (
+    `Id` int(11) NOT NULL auto_increment,
+    `ItemId` int(11) NOT NULL,
+    `Author` int(11) NOT NULL,
+    `ValidTimeFrom` datetime default NULL,
+    `ValidTimeTo` datetime default NULL,
+    `CreationTime` datetime default NULL,
+    `DeletionTime` datetime default NULL,
+    PRIMARY KEY  (`Id`)
+    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
+    //echo($Database->LastQuery);
+  }
 
-function ListSystemListOnEdit($Parameters)
-{
-  global $Database;
+  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'].'`');
+    $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'].'`');
+  }
 }