Changeset 243

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

Location:

quests

Files:

• ListQuests.php (modified) (3 diffs)
• TODO.txt (modified) (1 diff)
• export.php (modified) (2 diffs)
• form.php (modified) (1 diff)
• statistic.php (modified) (1 diff)

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

quests/TODO.txt

@@ -15 +15 @@
  - Popisky u odkazù v menu                      hotovo
  - V exportu filtr jenom od urèitých uživatelù  hotovo
+ - omezení poètu pøeložených Q na stránce       hotovo
  - Rozdìlení pomocí ras
  - import
  - jiné texty než questy
-

quests/export.php

@@ -197 +197 @@
     $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
       while ($Line = mysql_fetch_array($ID))
-        echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
+        echo '<option selected="selected" value="'.$Line['ID'].'">'.$Line['user'].'</option>';
    
-?>                
+?>          
           
         </select><br>&nbsp; Exportovat pouze od tìchto u¾ivatalù
@@ -222 +222 @@
       </td></tr>
     </table>
-    <br><input type="submit" value="Generovat"> SQL soubor Questù (Sta¾ení)
+    <br><input type="submit" value="Generovat SQL soubor Questù"> (Sta¾ení)
   </form>  
   <b>Èeský pøeklad MaNGOS Minimanageru:</b><br />

quests/form.php

@@ -20 +20 @@
        // echo $Language['Language'].'  '.$Line['Take'];
         if ($Language['Language'] <> 0)
-          echo 'Pøevzato z: <a href="form.php?ID='.$Line['Take'].'">'.$Line['Take'].'</a>';
+          echo 'Pøevzato z: <a href="form.php?ID='.$Line['Take'].'">'.$Line['Take'].'</a> ';
       }
+    if ($Line['Language'] <> '0') {
+      echo 'Quest je: ';
+      if ($Line['complete'] == 1) echo ' <b>Hotov</b>';
+      else echo ' <b> Ulo¾en v rozepsaných</b>';
+    }
 //    Speciální znaky: $B - Odøádkování, $N - Jméno, $C - povolání
 ?>    

quests/statistic.php

@@ -9 +9 @@
 <br />
 <br />
-Poèet vyexportování questù: <b>
+Poèet stáhnutí questù: <b>
 <?php