Changeset 211 for quests/ListQuests.php

Timestamp:

Jan 12, 2008, 12:35:24 AM (17 years ago)

Author:

maron

Message:

Počet hlasování, a kontrola známek

File:

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

quests/ListQuests.php

@@ -3 +3 @@
 
   if(array_key_exists('Translate', $_GET)) {
-      $ID = $Database->SQLCommand("SELECT ID,entry,Title,Vote, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM
+      $ID = $Database->SQLCommand("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM
       quests WHERE quests.Language = '1' AND quests.Complete = '1' order by 2");
       echo '<table border="1" cellpadding="2" cellspacing="0">
-            <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>U¾ivatel</th><th>Známka</th></tr>';
+            <tr><th>Poøadové èíslo</th><th>ID questu</th><th>Název Questu</th><th>U¾ivatel</th><th>Známka</th><th>Poèet hlasování</th></tr>';
       while ($Line = mysql_fetch_array($ID)) {
         echo '<tr><td><a href="form.php?ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
@@ -12 +12 @@
         <td>'.$Line['Title'].'</td>
         <td>'.$Line['User'].'</td>
-        <td>'.$Line['Vote'].'</td></tr>';
+        <td>'.$Line['Vote'].'</td>
+        <td>'.$Line['CountVote'].'</td></tr>';
        }
       echo '</table>';