Changeset 279

Timestamp:

Aug 25, 2009, 1:47:56 PM (15 years ago)

Author:

maron

Message:

Souvislosti u překladů

Location:

trunk

Files:

• TranslationList.php (modified) (2 diffs)
• includes/global.php (modified) (2 diffs)
• sql/connexion.sql (added)
• sql/updates/278.sql (added)

trunk/TranslationList.php

@@ -7 +7 @@
 $TranslationItemPerPage = 200;
 if(array_key_exists('group', $_GET)) $GroupId = $_GET['group'] * 1; else $GroupId = 1;
+if(array_key_exists('connexion_id', $_GET)) { 
+  $_SESSION['connexion_id'] = $_GET['connexion_id'];
+}
 $DbResult = $Database->SQLCommand('SELECT Id FROM `group` WHERE `Id`='.$GroupId);
 if(mysql_num_rows($DbResult) == 0)
@@ -133 +136 @@
 
   WritePages('?group='.$GroupId.'&action=notran', 'AS items WHERE items.Language = 0 AND
-    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND VersionEnd = "'.$BuildNumber_max.'")  AND VersionEnd = "'.$BuildNumber_max.'"');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND VersionEnd = "'.$BuildNumber_max.'"  AND VersionEnd = "'.$BuildNumber_max.'")');
 
   WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND
-    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
+    NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry)  AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'")', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
+} else
+if($Action == 'connexion') 
+{ //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
+        $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
+    echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
+        <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&amp;action=connexion">Souvislosti</a> - > 
+        <strong>Vypsání souvislostí ze skupiny '.$Line['Name'].'</strong><br /><br />');
+
+    WritePages('?group='.$GroupId.'&amp;action=connexion', ' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"');
+    WriteQuests('SELECT * FROM '.$Table.' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'connexion');
+
+} else
+if($Action == 'connexion_list') 
+{ //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
+    echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&amp;action=filter">Filtr textů</a> ->
+        <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&amp;action=connexion">Souvislosti</a> - > 
+        <strong>Vypsání souvislostí</strong><br /><br />');
+    echo('<table class="BaseTable"><tr><th>Pořadové číslo</th><th>Název</th>');
+    echo('</tr>');
+    $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE  `Group` = '.$GroupId);        
+    while($Line = mysql_fetch_assoc($ID)) 
+    {
+      echo('<tr><td><a href="?group='.$GroupId.'&amp;action=connexion&amp;connexion_id='.$Line['Id'].'">'.$Line['Id'].'</a></td>
+      <td>'.$Line['Name'].'</td>');
+    }
+        echo ('</table>');
 } else
 if($Action == 'nocomplete') 

trunk/includes/global.php

@@ -130 +130 @@
 function ShowTranslatedMenu()
 {
-  global $TranslationTree, $Config;
+  global $TranslationTree, $Config,$Database;
 
   echo('<strong>Překladové skupiny:</strong><br /><div id="TranslationMenu">');
@@ -147 +147 @@
     echo('&nbsp;<a title="Zde můžete začít překládat" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=notran">Nepřeložené</a><br />
       &nbsp;<a title="Přeložené texty, můžete zde hlasovat, nebo opravovat překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=Translate">Přeložené</a><br />');
-    if(Licence(LICENCE_USER)) 
+        $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$Group['Id']);
+    if (mysql_num_rows($ID) > 0)  
+    echo('&nbsp;<a title="Vypsání souvislostí" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=connexion_list">Souvislosti</a><br />');
+ 
+        if(Licence(LICENCE_USER)) 
     {
       echo('&nbsp;<a title="Nedokončené překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=mydevelop">Rozepsané</a><br />