Changeset 244

Timestamp:

Jul 12, 2009, 1:41:25 PM (15 years ago)

Author:

maron

Message:

Vylepšení opravy sloupce Take

File:

• trunk/action.php (modified) (1 diff)

trunk/action.php

@@ -110 +110 @@
         echo ($Table.' ');
                 
-                $sql = 'SELECT ID,entry as entry_tran, (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig FROM '.$Table.' WHERE (Language <> 0) AND (Take = 0)';
+                $sql = 'SELECT ID,entry as entry_tran, Take,
+                 (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig
+                  FROM '.$Table.' as tran WHERE (Language <> 0) AND ((Take = 0) OR (ID = Take) OR NOT EXISTS(SELECT 1 FROM '.$Table.' WHERE ID = tran.Take))';
                 
             $ID = $Database->SQLCommand($sql);