Changeset 12 for types/PointerOneToOne.php

Timestamp:

Oct 13, 2008, 9:44:52 AM (16 years ago)

Author:

george

Message:

• Opraveno: Editační prvek pro typ odkaz nabízel nesprávně i více historických záznamů pro jednu položku.

File:

• types/PointerOneToOne.php (modified) (1 diff)

types/PointerOneToOne.php

@@ -27 +27 @@
 
   foreach($Lists[$TargetTable]['Items'] as $ListItem)
-    if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
-  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, Id';
-  $DbResult = $Database->select($TargetTable, $Columns);
+    if($ListItem['VisibleInPointer'] == 1) $Columns .= 't1.`'.$ListItem['Name'].'`," ",';
+  $Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, t1.Id, t1.ItemId';
+  $DbResult = $Database->query('SELECT '.$Columns.' FROM `'.$TargetTable.'` AS t1 LEFT JOIN `'.$TargetTable.'` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL)');
   //echo($Database->LastQuery);
   if($DbResult->num_rows > 0)