Changeset 215 for quests/ListQuests.php

Timestamp:

Jan 12, 2008, 3:37:31 PM (17 years ago)

Author:

maron

Message:

Nejdůležitější Q a ochrana AJ Q

File:

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

quests/ListQuests.php

@@ -61 +61 @@
     }
 
-        if(array_key_exists('selection', $_GET)) {
-    
+        if(array_key_exists('selection', $_GET)) {              
+                
+                echo '<br /><b>Prioritnì by jste mìli pøekládat tyto questy:</b><br />';
+                
+          $ID = $Database->SQLCommand("SELECT * FROM `quests_status` ORDER BY CountQuest DESC");
+          echo '<table border="1" cellpadding="2" cellspacing="0">
+              <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>Poèet splnìní na serveru</th></tr>';
+          $i = 0;
+          while ($Line = mysql_fetch_array($ID)) {
+            if ($i < '6') {
+            $LineTranslate = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language <> 0 AND entry = '".$Line['QuestEntry']."'"));
+            if (!$LineTranslate) {
+              $LineAJQuest = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language = 0 AND entry = '".$Line['QuestEntry']."'"));
+              echo '<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
+              <td>'.$LineAJQuest['entry'].'</td>
+              <td>'.$LineAJQuest['Title'].'</td>
+              <td>'.$Line['CountQuest'].'</td></tr>';
+              $i = $i +1;
+              }
+            }
+          }
+                
+          echo '</table><br />';
+          
+          echo '<b>Ostatní:</b><br /><br />';
+
           for ($i=0; $i<30; ++$i) {
             $limity = 200;
@@ -70 +94 @@
           }
                 echo '<a href="ListQuests.php?limitx='.$limitx.'&amp;limity=6000">Zbytek</a><br />';
+
+
     //  echo '<a href="ListQuests.php?limitx=3500&amp;limity=4000">3500-4000</a><br />';
         }