Changeset 227

Timestamp:

Jan 14, 2008, 9:43:21 PM (17 years ago)

Author:

maron

Message:

statistika, shoutbox

Location:

quests

Files:

• action.php (modified) (4 diffs)
• includes/global.php (modified) (5 diffs)
• index.php (modified) (2 diffs)
• statistic.php (modified) (1 diff)
• statistic.png (deleted)

quests/action.php

@@ -7 +7 @@
     $Database->SQLCommand("DELETE FROM quests WHERE ID = '$questID' AND Language <> '0'");
     echo 'Quest byl smazán!';   
+  }
+
+  if (array_key_exists('shoutbox', $_GET)) {
+    $shoutbox = $_GET['shoutbox'];
+    if ($shoutbox == '') {
+      echo '<form action="action.php?shoutbox=1" method="post">
+      U¾ivatel: ';
+      if (Licence(0)) echo '<b>'.$_SESSION['User'].'</b><br />'; else  echo '<input type="text" name="user"><br />';
+            echo 'Text zprávy: <input type="text" name="text" size="20"><br />
+            <input type="submit" value="Ulo¾it"><br />
+            </form>';
+    } else {
+      if (Licence(0)) $user = $_SESSION['User']; else {
+        $user = $_POST['user'];
+        $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE user = '$user'"));
+        if (!$Line) {} else die('Toto jméno je registrováno nemù¾ete psát za nìj. Pokud jste '.$user.' pak se pøihlaste.');
+      }
+      $text = $_POST['text'];
+      $Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` ) 
+      VALUES ( '$user', '$text', now(), '".$_SERVER['REMOTE_ADDR']."');");
+      echo 'Zpráva vlo¾ena!';   
+    }
   }
 
@@ -22 +44 @@
     if (($vote > 5) OR ($vote < 1)) die ('Spadná známka');
     
-  //TODO:  if (Licence(0)) die('Hlasovat mù¾ou jenom registrovaní!');
+  //TODO:  if (Licence(0)) die('Hlasovat mùµou jenom registrovaní!');
 
 
@@ -35 +57 @@
     
       $Database->SQLCommand("INSERT INTO `quests_vote` ( `IDquest` , `IDuser` , `vote` ) VALUES ( '$questID', '$IDuser', '$vote');");
-      echo 'Hlas byl ulo¾en! Hlasoval jste: '.$vote.'<br /> Nyní je známka questu '.$NewVote;   
+      echo 'Hlas byl uloµen! Hlasoval jste: '.$vote.'<br /> Nyní je známka questu '.$NewVote;   
     
     } else echo 'Ji¾ jste hlasoval!';
@@ -100 +122 @@
   ShowFooter();      
 ?>
+

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 />
@@ -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/index.php

@@ -30 +30 @@
   - Názvy mìst, míst, postav, vìcí aj. pøekládejte pouze jednodu¹í slova jako mìsto, moèál, les.. slo¾itìj¹í vykloòujte (pø. Stormwind city  -> Mìsto Stormwind, at Camp Taurajo  ->  u Tábora Taurajo)<br /> 
   <br />
-  - Zaèít pøekládat mù¾ete kliknutím na Nepøelo¾ené Questy<br><br>
+  - Zaèít pøekládat mù¾ete kliknutím na Nepøelo¾ené Questy<br><br />
   
   
@@ -44 +44 @@
     $ID = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user Where ID ='$UserID'"));        
     if ($ID['Email'] == '' )    
-      Echo '<br><br /><span style="color: red"><b>Nemáte nastavený e-mail, <a href="Options.php">nastavit</a></b></span>';
+      Echo '<span style="color: red"><b>Nemáte nastavený e-mail, <a href="Options.php">nastavit</a></b></span>';
 
         

quests/statistic.php

@@ -2 +2 @@
 
   include('includes/global.php');
-  
-  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(entry) FROM quests WHERE Language <> '0' AND Complete = '1'"));
-  $NumberTranslate = $ID[0];
-  
-  $ID = mysql_fetch_row($Database->SQLCommand("SELECT count(*) FROM quests WHERE Language = '0'"));
-  $NumberAJQuests = $ID[0];
 
-  $Percent = ($NumberTranslate/$NumberAJQuests)*100;
+?>
 
-  $PercentBar = $Percent*4;
-  $obrazek = imagecreatetruecolor(400,60);
-  $Color1 = imagecolorallocate($obrazek,225,246,247);
-  $Color2 = imagecolorallocate($obrazek,77,225,251);
-  $Color3 = imagecolorallocate($obrazek,2,59,199);
-  imagefilledrectangle($obrazek,0,0,400,59,$Color1);
-  imagefilledrectangle($obrazek,0,0,$PercentBar,59,$Color2);
-  imagestring($obrazek, 10, 120, 15, $NumberTranslate.'/'.$NumberAJQuests, $Color3);
-  imagestring($obrazek, 10, 120, 30, $Percent.' %', $Color3);
-  imagestring($obrazek, 1, 240, 50, 'Aktualizováno: '.date("m.d.y  H:i"), $Color3);
- 
- 
- // header('Content-Type: image/png');
-  imagepng($obrazek,'statistic.png');
-  imagedestroy($obrazek);
-  
-  echo '<img src="statistic.png">';
+<b>Statistika pøelo¾ených questù:</b><br>
+ <img alt="quests" src="quests_statistic.php" title="statistika pøekladu úkolù">
+
+<?php  
           
   ShowFooter();