Changeset 245 for quests


Ignore:
Timestamp:
Jan 18, 2008, 4:07:44 PM (17 years ago)
Author:
maron
Message:

struktura, statistika, oprava zobrazení prioritních questů

Location:
quests
Files:
8 added
6 edited

Legend:

Unmodified
Added
Removed
  • quests/ListQuests.php

    r243 r245  
    5454            if ($address == 'selection') echo '<td>'.$Line['CountQuest'].'</td>'; else
    5555            if ($address <> 'limitx') echo '<td>'.@$Line['User'].'</td>
    56             <td>'.$Line['Vote'].'</td>
     56            <td>'.substr($Line['Vote'], 0, 4).'</td>
    5757            <td>'.$Line['CountVote'].'</td>';
    5858            echo '</tr>';
     
    6464        if(array_key_exists('selection', $_GET)) {             
    6565               
    66                 echo '<table border="1" cellpadding="10"><tr><td>
     66                echo '<table border="1" cellspacing="0" cellpadding="10"><tr><td>
    6767          <br /><b>Prioritnì by jste mìli pøekládat tyto questy:</b><br /><br />';
    6868               
    69                 WriteQuests("SELECT * FROM quests, quests_status
     69                WriteQuests("SELECT quests.ID,entry,Title,CountQuest FROM quests, quests_status
    7070          WHERE quests.language = 0 AND quests.entry = quests_status.questentry ORDER BY quests_status.CountQuest DESC", 18, 'selection');
    7171         
  • quests/TODO.txt

    r244 r245  
    1616 - V exportu filtr jenom od urèitých uživatelù  hotovo
    1717 - omezení poètu pøeložených Q na stránce       hotovo
     18 - va statistice moderátory                     hotovo
     19 - struktura tabulek do souboru                 hotovo
    1820 - Rozdìlení pomocí ras
    1921 - import
    2022 - u slovníku pouze rušit odkaz, ne na pozadí
    2123 - jiné texty než questy - hlavní texty
    22 (npc_text,  page_text, quest_end_scripts, quest_start_scripts)
     24 - search možno order by
     25(npc_text,  page_text, - prioritnì  quest_end_scripts, quest_start_scripts)
  • quests/export.php

    r244 r245  
    197197    $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
    198198      while ($Line = mysql_fetch_array($ID))
    199         echo '<option selected="selected" value="'.$Line['ID'].'">'.$Line['user'].'</option>';
     199        echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
    200200   
    201201?>         
  • quests/form.php

    r244 r245  
    6161    <input type="hidden" name="user" value="<?php echo $User ?>">
    6262    <input type="hidden" name="ID" value="<?php echo $QuestID ?>">
    63     <table border="1">
     63    <table border="1" cellpadding="1" cellspacing="0">
    6464      <tr>
    6565        <th>Èíslo Q.: <?php echo $LineAJ['entry'];?></th>
  • quests/quests_statistic.php

    r231 r245  
    1818
    1919  $Percent = ($NumberTranslate/$NumberAJQuests)*100;
     20  $Percent = substr($Percent, 0, 5);
    2021
    2122  $PercentBar = $Percent*4;
  • quests/statistic.php

    r243 r245  
    1818</b><br /><br />
    1919<b>Seznam u¾ivatelù: </b>
    20 <table border="1" cellpadding="1" cellspacing="0">
     20<table border="1" cellpadding="2" cellspacing="0">
    2121<?php 
    2222
     
    3232
    3333  echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
    34   <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'">Poèet pøelo¾ených</a></th>
     34  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
     35  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Známka</a></th>
     36  <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
    3537  <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
    3638
    37   $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,(SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate FROM `user` ORDER BY $order $desc");
     39  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
     40  (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
     41  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote
     42   FROM `user` ORDER BY $order $desc");
    3843      while ($Line = mysql_fetch_array($ID))
    39         echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';
     44        echo '<tr><td>'.$Line['user'].'</td>
     45        <td>'.$Line['NumberTranslate'].'</td>
     46        <td>'.substr($Line['vote'], 0, 4).'</td>
     47        <td>'.$Moderators[$Line['GM']].'</td>
     48        <td>'.$Line['LastLogin'].'</td></tr>';
    4049         
    4150         
Note: See TracChangeset for help on using the changeset viewer.