Changeset 219

Timestamp:

Jan 12, 2008, 11:52:25 PM (17 years ago)

Author:

maron

Message:

Změna načítání prioritních questů

Location:

quests

Files:

• ListQuests.php (modified) (2 diffs)
• priorite.php (modified) (2 diffs)

quests/ListQuests.php

@@ -65 +65 @@
                 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");
+          $ID = $Database->SQLCommand("SELECT * FROM `quests_status` ORDER BY CountQuest DESC LIMIT 10");
           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>
@@ -78 +74 @@
               <td>'.$LineAJQuest['Title'].'</td>
               <td>'.$Line['CountQuest'].'</td></tr>';
-              $i = $i +1;
-              }
-            }
           }
                 

quests/priorite.php

@@ -16 +16 @@
   echo 'Nahrávání ID questù hotovo<br />';  
   
+  //mazání pøelo¾ených Q
+  $ID = $Database->SQLCommand("SELECT entry FROM `quests`.`quests` WHERE Language <> 0 AND Complete = 1");
+  while ($Line = mysql_fetch_array($ID)) {
+    $entry = $Line['entry'];
+  
+    $Database->SQLCommand("DELETE FROM `quests`.`quests_status` WHERE QuestEntry = '$entry'");
+  
+  }
+  
+  echo 'Mazání pøelo¾ených ve statusu hotovo<br />';  
+  
   //Plnìní poètu
   $ID = $Database->SQLCommand("SELECT QuestEntry FROM `quests_status`");
@@ -26 +37 @@
   }
 
-  echo 'Nahrávání poètu questù od úživatelù<br />';
+  echo 'Nahrávání poètu questù od ú¾ivatelù<br />';