Changeset 130

Timestamp:

Feb 23, 2009, 7:14:54 PM (16 years ago)

Author:

maron

Message:

účinější filtrování stejných překladů u výpočtu levelu

File:

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

trunk/img_level.php

@@ -65 +65 @@
         foreach($TranslationTree as $Group) { //překladové skupiny
                 if($Group['TablePrefix'] != '') {
-                $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE User = '.$user_ID.' AND Complete = 1 GROUP BY Take');
+                        $groupby = 'GROUP BY';
+                        foreach($TranslationTree[$Group['Id']]['Items'] as $Index => $TextItem) {  
+                                if ($groupby == 'GROUP BY') $groupby .= ' '.$TextItem['Column'];
+                                else $groupby .= ', '.$TextItem['Column'];
+                        }       
+                $IDtran = $Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE User = '.$user_ID.' AND Complete = 1 '.$groupby);
                         while ($Line = mysql_fetch_array($IDtran)) {   //jednotlivé překlady
                                 $LineComparison = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM `'.$Group['TablePrefix'].'` WHERE ID = '.$Line['Take']));