Changeset 243 for quests/ListQuests.php

Timestamp:

Jan 17, 2008, 6:08:55 PM (17 years ago)

Author:

maron

Message:

páru oprav: ve formuláři Q přidán status, limit přeložených, statistika

File:

• quests/ListQuests.php (modified) (3 diffs)

quests/ListQuests.php

@@ -1 +1 @@
 <?php
 include('includes/global.php');
+
+//Poèet questù na stránce
+  $NumberQuests = 200;
 
   if(array_key_exists('order', $_GET)) {
     $order = $_GET['order'];
     $desc = $_GET['desc'];
+    $_SESSION['order'] = $_GET['order'];
+    $_SESSION['desc'] = $_GET['desc'];
   } else {
-    $order = '';
-    $desc = 'desc';
+    if (isset($_SESSION['order'])) {
+      $order = $_SESSION['order'];
+      $desc = $_SESSION['desc'];
+    } else {
+      $order = '';
+      $desc = 'desc';
+    }
   }
 
@@ -64 +74 @@
 
           for ($i=0; $i<24; ++$i) {
-            $limity = 200;
+            $limity = $NumberQuests;
             $limitx = $i*$limity;
             $Under = $limitx+$limity;
@@ -84 +94 @@
 
       if(array_key_exists('Translate', $_GET)) {
+        if(array_key_exists('trans_limitx', $_GET)) {
+          $_SESSION['limitx'] = mysql_escape_string($_GET['trans_limitx']); 
+          $_SESSION['limity'] = mysql_escape_string($_GET['trans_limity']);
+        } else {
+          if (isset($_SESSION['limitx']) == false) {
+            $_SESSION['limitx'] = '0'; 
+            $_SESSION['limity'] = $NumberQuests;
+          }
+        }
+      
+        $Line = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM quests WHERE quests.Language = '1' AND quests.Complete = '1'"));        
+        $CountLists = $Line[0]/$NumberQuests;
+        
+        echo 'Poèet questù: <b>'.$Line[0].'</b> Zobrazit stránku: ';
+        for ($i=0; $i< $CountLists; ++$i) {
+          $limity = $NumberQuests;
+          $limitx = $i*$limity;
+          $Page = $i+1;
+          if ($_SESSION['limitx'] == $limitx) $color = 'style="color: red"';
+          else $color = '';
+                echo '<a '.$color.' href="ListQuests.php?Translate&amp;trans_limitx='.$limitx.'&amp;trans_limity='.$limity.'">'.$Page.'</a> ';
+        }
+
         WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM
-        quests WHERE quests.Language = '1' AND quests.Complete = '1'", '', 'Translate');
+        quests WHERE quests.Language = '1' AND quests.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
       }