Changeset 148 for trunk/includes/global_function.php

Timestamp:

Mar 8, 2009, 8:33:08 AM (16 years ago)

Author:

maron

Message:

Odkazy na následující a předcházející, ShotCut

File:

• trunk/includes/global_function.php (modified) (1 diff)

trunk/includes/global_function.php

@@ -183 +183 @@
 }
 
+function FollowingTran($TextID,$Table,$GroupId, $Prev = false) {
+  
+  global $Database;
+  
+        if ($Prev) {
+                $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND 
+  NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry)
+   AND ID < '.$TextID.' ORDER BY ID DESC LIMIT 1';
+        } else {
+                $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND 
+  NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry)
+   AND ID > '.$TextID.' ORDER BY ID LIMIT 1';
+        }
+  
+  $Next = mysql_fetch_array($Database->SQLCommand($sql));
+  if (!$Next) {} else {
+        if ($Prev)
+                echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Předcházející '.$Next['ID'].'</a> ');
+        else
+                echo('<a href="form.php?group='.$GroupId.'&amp;ID='.$Next['ID'].'">Následující '.$Next['ID'].'</a> ');
+  
+  }
+        
+}
 
 ?>