Changeset 245 for quests

Timestamp:

Jan 18, 2008, 4:07:44 PM (17 years ago)

Author:

maron

Message:

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

Location:

quests

Files:

• ListQuests.php (modified) (2 diffs)
• TODO.txt (modified) (1 diff)
• export.php (modified) (1 diff)
• form.php (modified) (1 diff)
• quests_statistic.php (modified) (1 diff)
• statistic.php (modified) (2 diffs)
• structure (added)
• structure/dictionary.sql (added)
• structure/log.sql (added)
• structure/quests.sql (added)
• structure/quests_status.sql (added)
• structure/quests_vote.sql (added)
• structure/shoutbox.sql (added)
• structure/user.sql (added)

quests/ListQuests.php

@@ -54 +54 @@
             if ($address == 'selection') echo '<td>'.$Line['CountQuest'].'</td>'; else
             if ($address <> 'limitx') echo '<td>'.@$Line['User'].'</td>
-            <td>'.$Line['Vote'].'</td>
+            <td>'.substr($Line['Vote'], 0, 4).'</td>
             <td>'.$Line['CountVote'].'</td>';
             echo '</tr>';
@@ -64 +64 @@
         if(array_key_exists('selection', $_GET)) {              
                 
-                echo '<table border="1" cellpadding="10"><tr><td>
+                echo '<table border="1" cellspacing="0" cellpadding="10"><tr><td>
           <br /><b>Prioritnì by jste mìli pøekládat tyto questy:</b><br /><br />';
                 
-                WriteQuests("SELECT * FROM quests, quests_status 
+                WriteQuests("SELECT quests.ID,entry,Title,CountQuest FROM quests, quests_status 
           WHERE quests.language = 0 AND quests.entry = quests_status.questentry ORDER BY quests_status.CountQuest DESC", 18, 'selection');
           

quests/TODO.txt

@@ -16 +16 @@
  - V exportu filtr jenom od urèitých uživatelù  hotovo
  - omezení poètu pøeložených Q na stránce       hotovo
+ - va statistice moderátory                     hotovo
+ - struktura tabulek do souboru                 hotovo
  - Rozdìlení pomocí ras
  - import
  - u slovníku pouze rušit odkaz, ne na pozadí
  - jiné texty než questy - hlavní texty
-(npc_text,  page_text, quest_end_scripts, quest_start_scripts)
+ - search možno order by
+(npc_text,  page_text, - prioritnì  quest_end_scripts, quest_start_scripts)

quests/export.php

@@ -197 +197 @@
     $ID = $Database->SQLCommand("SELECT user,ID FROM `user`");
       while ($Line = mysql_fetch_array($ID))
-        echo '<option selected="selected" value="'.$Line['ID'].'">'.$Line['user'].'</option>';
+        echo '<option value="'.$Line['ID'].'">'.$Line['user'].'</option>';
    
 ?>          

quests/form.php

@@ -61 +61 @@
     <input type="hidden" name="user" value="<?php echo $User ?>">
     <input type="hidden" name="ID" value="<?php echo $QuestID ?>">
-    <table border="1">
+    <table border="1" cellpadding="1" cellspacing="0">
       <tr>
         <th>Èíslo Q.: <?php echo $LineAJ['entry'];?></th>

quests/quests_statistic.php

@@ -18 +18 @@
 
   $Percent = ($NumberTranslate/$NumberAJQuests)*100;
+  $Percent = substr($Percent, 0, 5);
 
   $PercentBar = $Percent*4;

quests/statistic.php

@@ -18 +18 @@
 </b><br /><br />
 <b>Seznam u¾ivatelù: </b>
-<table border="1" cellpadding="1" cellspacing="0">
+<table border="1" cellpadding="2" cellspacing="0">
 <?php  
 
@@ -32 +32 @@
 
   echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
-  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'">Poèet pøelo¾ených</a></th>
+  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
+  <th><a href="statistic.php?order=vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Známka</a></th>
+  <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
   <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
 
-  $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");
+  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,GM,
+  (SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate,
+  (SELECT avg(vote) FROM `quests` WHERE User = user.id AND Complete = 1) as vote
+   FROM `user` ORDER BY $order $desc");
       while ($Line = mysql_fetch_array($ID))
-        echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';
+        echo '<tr><td>'.$Line['user'].'</td>
+        <td>'.$Line['NumberTranslate'].'</td>
+        <td>'.substr($Line['vote'], 0, 4).'</td>
+        <td>'.$Moderators[$Line['GM']].'</td>
+        <td>'.$Line['LastLogin'].'</td></tr>';