Changeset 219 for quests/ListQuests.php


Ignore:
Timestamp:
Jan 12, 2008, 11:52:25 PM (17 years ago)
Author:
maron
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • quests/ListQuests.php

    r215 r219  
    6565                echo '<br /><b>Prioritnì by jste mìli pøekládat tyto questy:</b><br />';
    6666               
    67           $ID = $Database->SQLCommand("SELECT * FROM `quests_status` ORDER BY CountQuest DESC");
     67          $ID = $Database->SQLCommand("SELECT * FROM `quests_status` ORDER BY CountQuest DESC LIMIT 10");
    6868          echo '<table border="1" cellpadding="2" cellspacing="0">
    6969              <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>Poèet splnìní na serveru</th></tr>';
    70           $i = 0;
    7170          while ($Line = mysql_fetch_array($ID)) {
    72             if ($i < '6') {
    73             $LineTranslate = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language <> 0 AND entry = '".$Line['QuestEntry']."'"));
    74             if (!$LineTranslate) {
    7571              $LineAJQuest = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests WHERE Language = 0 AND entry = '".$Line['QuestEntry']."'"));
    7672              echo '<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
     
    7874              <td>'.$LineAJQuest['Title'].'</td>
    7975              <td>'.$Line['CountQuest'].'</td></tr>';
    80               $i = $i +1;
    81               }
    82             }
    8376          }
    8477               
Note: See TracChangeset for help on using the changeset viewer.