Changeset 279 for trunk/TranslationList.php

Timestamp:

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

Author:

maron

Message:

Souvislosti u překladů

File:

• trunk/TranslationList.php (modified) (2 diffs)

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')