Changeset 233

Timestamp:

Jan 15, 2008, 5:25:15 PM (17 years ago)

Author:

maron

Message:

Statistika, oprava global.php

Location:

quests

Files:

• includes/global.php (modified) (6 diffs)
• statistic.php (modified) (1 diff)

quests/includes/global.php

@@ -90 +90 @@
     <tr>
       <td width="150" valign="top">
-      <br />
-      <b>Odkazy:</b><br />
       <a href="index.php">Domù</a><br />
       <a href="http://wow.zdechov.net/forum/viewforum.php?f=22">Forum projektu</a><br />
@@ -98 +96 @@
       <a href="Options.php" Title="Nastavení u¾ivatele">Nastavení</a><br />
       <a href="statistic.php">Statistika</a><br />
-      <a Title="Slovník wow výrazù" href="javascript: window.open(\'dictionary.php\', \'Slovník\', \'width=400, height=400\'); blur()">Slovníèek</a><br />
+      <a Title="Slovník wow výrazù" href="javascript: window.open(\'dictionary.php\', \'Slovník\', \'width=400, height=412\'); blur()">Slovníèek</a><br />
       <a href="export.php" Title="Zdes i mù¾ete stáhnout pøelo¾ené texty">Download</a><br />
       <br />
@@ -115 +113 @@
       
       echo '<br /><form action="action.php" method="get">
-<input type="text" name="search" size="13"><br>
+<input type="text" name="search" size="8">
 <input type="submit" value="Hledat">
 </form>
@@ -121 +119 @@
       
 if (Licence(0)) {
-  echo 'Jste pøihlá¹en jako: <b>'.$_SESSION['User'].'</b> <a href="index.php?Logout">Odhlásit</a>';
+ // echo 'Jste pøihlá¹en jako: <b>'.$_SESSION['User'].'</b> <a href="index.php?Logout">Odhlásit</a>';
 } else {
   echo '    
@@ -140 +138 @@
   ';
 }
-  echo '<br /><br />Online u¾ivatelé:<br />';
+  
+  echo '<p style="  overflow: auto;  width: 100%; height: 200px;">
+  <b>Shoutbox: </b><a href="action.php?shoutbox">Vlo¾it</a>
+  <table border="1"  cellpadding="1" cellspacing="0">';
+    $ID = $Database->SQLCommand("SELECT * FROM shoutbox ORDER BY ID DESC LIMIT 10");
+      while ($Line = mysql_fetch_array($ID))
+        echo '<tr><td><small><b>'.$Line['user'].'</b>: '.$Line['text'].'</small></td></tr>';
+  echo '</table>
+  </p>
+  ';
+
+  echo 'Online u¾ivatelé:<br />';
   $ID = $Database->SQLCommand("SELECT user FROM `user` WHERE LastLogin >= Now()-300");
       while ($Line = mysql_fetch_array($ID))
@@ -159 +168 @@
       </td>     
     </tr>
-    <tr><td></td><td>  <span style="color: grey">Program naprogramoval maron (maron2@cetrum.cz)</span> </td></tr>
+    <tr>
+    <td></td><td>  <span style="color: grey">Program naprogramoval maron (maron2@cetrum.cz)</span>';
+if (Licence(0))
+  echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jste pøihlá¹en jako: <b>'.$_SESSION['User'].'</b> <a href="index.php?Logout">Odhlásit</a>';
+    echo ' </td></tr>
   </table>
   </body>

quests/statistic.php

@@ -7 +7 @@
 <b>Statistika pøelo¾ených questù:</b><br>
  <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù">
-
+<br />
+<br />
+<b>Seznam u¾ivatelù: </b>
+<table border="1" cellpadding="1" cellspacing="0">
+<tr><th>Jméno</th><th>Poèet pøelo¾ených</th><th>Poslední pøipojení</th></tr>
 <?php  
+  $ID = $Database->SQLCommand("SELECT user,Email,LastLogin,(SELECT count(*) FROM `quests` WHERE User = user.id AND User <> 0) as NumberTranslate FROM `user` ORDER BY NumberTranslate DESC");
+      while ($Line = mysql_fetch_array($ID))
+        echo '<tr><td>'.$Line['user'].'</td><td>'.$Line['NumberTranslate'].'</td><td>'.$Line['LastLogin'].'</td></tr>';
+          
+          
+  echo '</table>';
           
   ShowFooter();