Changeset 282

Timestamp:

Sep 4, 2009, 1:27:18 PM (15 years ago)

Author:

george

Message:

• Upraveno: Změna formátu stránek na XHTML 1.1 a oprava validace některých stránek.

Location:

trunk

Files:

• download.php (modified) (5 diffs)
• includes/global.php (modified) (7 diffs)
• includes/rss.php (added)
• index.php (modified) (9 diffs)
• registrace.php (modified) (3 diffs)
• rss.php (deleted)

trunk/download.php

@@ -8 +8 @@
 {
 
-        global $Database;
+  global $Database;
 
-        $TranslationTree = GetTranslationTree();
-        $Group = $TranslationTree[$TableID];
+  $TranslationTree = GetTranslationTree();
+  $Group = $TranslationTree[$TableID];
 
-        $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE (Language <> 0) AND (Complete = 1) AND User IN('.$Users.')'));
-        $NumberTranslate = $ID[0];
+  $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(distinct(entry)) FROM '.$Group['TablePrefix'].' WHERE (Language <> 0) AND (Complete = 1) AND User IN('.$Users.')'));
+  $NumberTranslate = $ID[0];
   
-        $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Group['TablePrefix'].' WHERE (Language = 0)'));
-        $NumberAJ = $ID[0];
+  $ID = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Group['TablePrefix'].' WHERE (Language = 0)'));
+  $NumberAJ = $ID[0];
 
-        if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
-        $Percent = substr($Percent, 0, 5);
-        
-        if (($TableID == 14) or ($TableID == 15)) $result = true;       
-        
-                return ($Group['Name'].': '.$NumberTranslate.'/'.$NumberAJ.'  '.$Percent.'%
-        ');
+  if($NumberAJ > 0) $Percent = ($NumberTranslate / $NumberAJ) * 100; else $Percent = 0;
+  $Percent = substr($Percent, 0, 5);
+  
+  if (($TableID == 14) or ($TableID == 15)) $result = true; 
+  
+    return ($Group['Name'].': '.$NumberTranslate.'/'.$NumberAJ.'  '.$Percent.'%
+  ');
 }
 
-        if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
-                if (array_key_exists('verse', $_POST)) { //ukládání
-                $Database->SQLCommand('INSERT INTO `verseclient` (`verse` ,`date` ,`text` ,`user`)
-                                                                        VALUES ( "'.$_POST['verse'].'", NOW( ) , "'.$_POST['text'].'", "'.$_SESSION['UserID'].'");');
-                        WriteLog('Nová verze ('.$_POST['verse'].') češitny pro clienta uložena.',4);
-                } else { //formulář    
-                        echo ('<form action"" method="post">'.
-                        'Verze: <input type="text" name="verse" /> <input type="submit" value="Uložit" /><br />'.
-                        'Popis: <textarea rows="20" cols="60"  name="text">');
-                        $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT ExportSetting FROM user Where ID = '.$_SESSION['UserID']));
-                        $ExportSetting = unserialize($Line['ExportSetting']);                   
-                         
-                        $Tables = 'Texty obsažené v addonu: Přeložené/nepřeložené  ProcentaPřeložených%
+  if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
+    if (array_key_exists('verse', $_POST)) { //ukládání
+        $Database->SQLCommand('INSERT INTO `verseclient` (`verse` ,`date` ,`text` ,`user`)
+                  VALUES ( "'.$_POST['verse'].'", NOW( ) , "'.$_POST['text'].'", "'.$_SESSION['UserID'].'");');
+      WriteLog('Nová verze ('.$_POST['verse'].') češitny pro clienta uložena.',4);
+      } else { //formulář    
+      echo ('<form action"" method="post">'.
+      'Verze: <input type="text" name="verse" /> <input type="submit" value="Uložit" /><br />'.
+      'Popis: <textarea rows="20" cols="60" name="text">');
+      $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT ExportSetting FROM user Where ID = '.$_SESSION['UserID']));
+      $ExportSetting = unserialize($Line['ExportSetting']);     
+       
+      $Tables = 'Texty obsažené v addonu: Přeložené/nepřeložené  ProcentaPřeložených%
         ';  
-                        foreach($ExportSetting['groups'] as $Index) $Tables .= GetPercentOfTable($Index,implode(',', $ExportSetting['users-selection']));
-                        
-                        $ID = $Database->SQLCommand('SELECT user FROM user WHERE ID IN('.implode(',', $ExportSetting['users-selection']).')'); 
-                        $Users = 'Vyexportovány překlady od uživatelů: ( '; 
-                        while($Line = mysql_fetch_assoc($ID)) $Users .= $Line['user'].', '; $Users .= ' )';
-                        //Výpis
-                        echo ('
+      foreach($ExportSetting['groups'] as $Index) $Tables .= GetPercentOfTable($Index,implode(',', $ExportSetting['users-selection']));
+      
+      $ID = $Database->SQLCommand('SELECT user FROM user WHERE ID IN('.implode(',', $ExportSetting['users-selection']).')'); 
+      $Users = 'Vyexportovány překlady od uživatelů: ( '; 
+      while($Line = mysql_fetch_assoc($ID)) $Users .= $Line['user'].', '; $Users .= ' )';
+      //Výpis
+      echo ('
   '.$Users.'
   '.$Tables);
-                                
-                        echo ('</textarea></form>');
-                }
-        }
+        
+      echo ('</textarea></form>');
+    }
+  }
 
 if(array_key_exists('addon', $_GET)) 
@@ -63 +63 @@
   while($Line = mysql_fetch_assoc($ID)) 
   {
-        echo('<tr>'.
+    echo('<tr>'.
       '<td><strong>'.$Line['verse'].'</strong> <a href="tmp/Addon/CzWoW_'.$Line['verse'].'.zip">Stáhnout</a> <br />'.$Line['date'].'</td>'.
       '<td>'.str_replace(chr(13),'<br />',$Line['text']).'</td>');
-        echo('</tr>');
+  echo('</tr>');
   }
   echo('</table>');         
 } else
 {
-        
-        
+  echo('<br /><h3><a href="export/">Export textů</a> - Export podle vlastního výběru do SQL, XML, LUA nebo Addonu</h3>'.
+    '<br />Exportovat podle zálohovaného nastavení:<form action="export" method="get"><div>'.
+    '<input name="action" value="output" type="hidden" />'.
+    '<textarea name="ExportSetting" rows="10" cols="40"></textarea>'.
+    '<input type="submit" value="Exportovat" /></div></form><br /><br />');
 
-  echo('
-  <br />
-  <h3><a href="export/">Export textů</a> - Export podle vlastního výběru do SQL, XML, LUA nebo Addonu</h3>
-  <br />Exportovat podle zálohovaného nastavení:<form action="export" method="get">
-    <input name="action" value="output" type="hidden">
-    <textarea name="ExportSetting" rows="10" cols="40"></textarea><input type="submit" value="Exportovat" /></form><br />
-  <br />');
-
-if (Licence(LICENCE_USER)) {    
+if (Licence(LICENCE_USER)) 
+{  
   $ID = $Database->SQLCommand('SELECT * FROM tasks WHERE User = '.$_SESSION['UserID'].' ORDER BY Date DESC LIMIT 10');
   if (mysql_num_rows($ID) > 0) 
@@ -90 +86 @@
     while($Line = mysql_fetch_assoc($ID)) 
     {
-          if ($Line['Active'] == 0)
-          {
-            $Active = 'Hotovo';
-                $Download = '<a href="'.$Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_DBC.zip">Stáhnout - CzWoW_DBC.zip</a>';
-          } else {
-                $Active = 'Čeká na zpracování'; 
-                $Download = 'CzWoW_DBC.zip';
-          }
-          if ($Line['Downloaded'] == 1) $Downloaded = 'Staženo'; else $Downloaded = 'Nestaženo'; 
-        echo('<tr>'.
+    if ($Line['Active'] == 0)
+    {
+      $Active = 'Hotovo';
+      $Download = '<a href="'.$Config['Web']['TempFolder'].$_SESSION['User'].'/CzWoW_DBC.zip">Stáhnout - CzWoW_DBC.zip</a>';
+    } else 
+    {
+      $Active = 'Čeká na zpracování'; 
+      $Download = 'CzWoW_DBC.zip';
+    }
+    if ($Line['Downloaded'] == 1) $Downloaded = 'Staženo'; else $Downloaded = 'Nestaženo'; 
+      echo('<tr>'.
         '<td><strong>'.HumanDate($Line['Date']).'</strong></td>'.
         '<td>'.$Active.'</td>'.
@@ -105 +102 @@
         '<td>'.$Download.'</td>'.
         '<td><textarea>'.$Line['ExportSetting'].'</textarea></td>');
-            echo('</tr>');
+      echo('</tr>');
     }
-    echo('</table><br />');             
+    echo('</table><br />');           
   }
 }
@@ -123 +120 @@
   <br />');
 
-  echo('<h3>Pomocné programy:</h3>
-
-  <a href="download/mpqediten32.zip">Ladik\'s MPQ Editor</a><br />
-  ');
-        
+  echo('<h3>Pomocné programy:</h3>'.
+  '<a href="download/mpqediten32.zip">Ladik\'s MPQ Editor</a><br />');  
 }          
 

trunk/includes/global.php

@@ -15 +15 @@
 
 include('config.php');
-include_once('error.php');
+include('error.php');
 include('databaseconection.php');
 include('global_function.php');
+include('rss.php');
 
 $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
@@ -72 +73 @@
 {
   global $Config;
-    echo('<strong>Hledání:</strong>
-  <form action="'.$Config['Web']['BaseURL'].'action.php" method="get"><input type="hidden" name="action" value="search" />
+  
+  echo('<strong>Hledání:</strong>
+  <form action="'.$Config['Web']['BaseURL'].'action.php" method="get"><div>
+  <input type="hidden" name="action" value="search" />
   <table>
     <tr>
@@ -81 +84 @@
       <th><input type="submit" value="Hledat" /></th>
     </tr>
-  </table>
+  </table></div>
   </form>');
 }
@@ -107 +110 @@
     $Config['Web']['BaseURL'].'Options.php' => array(LICENCE_USER, 'Nastavení uživatele', 'Nastavení'),
     $Config['Web']['BaseURL'].'index.php?Logout' => array(LICENCE_USER, 'Odhlášení ze systému', 'Odhlásit'),
-    'http://embed.mibbit.com/?server=game.zdechov.net%3A6667&channel=%23wowpreklad&forcePrompt=true&charset=utf-8' => array(LICENCE_ANONYMOUS, 'IRC chat pro překladatele', 'Chat'),
+    'http://embed.mibbit.com/?server=game.zdechov.net%3A6667&amp;channel=%23wowpreklad&amp;forcePrompt=true&amp;charset=utf-8' => array(LICENCE_ANONYMOUS, 'IRC chat pro překladatele', 'Chat'),
     $Config['Web']['BaseURL'].'log.php' => array(LICENCE_MODERATOR, 'Log dění (Pouze moderátor)', 'Záznamy'),
     $Config['Web']['BaseURL'].'import/' => array(LICENCE_ADMIN, 'Načtení zdrojových textů do databáze (pouze admin)', 'Import textů'), 
@@ -147 +150 @@
     echo('&nbsp;<a title="Zde můžete začít překládat" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=notran">Nepřeložené</a><br />
       &nbsp;<a title="Přeložené texty, můžete zde hlasovat, nebo opravovat překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=Translate">Přeložené</a><br />');
-        $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$Group['Id']);
+  $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$Group['Id']);
     if (mysql_num_rows($ID) > 0)  
     echo('&nbsp;<a title="Vypsání souvislostí" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=connexion_list">Souvislosti</a><br />');
  
-        if(Licence(LICENCE_USER)) 
+  if(Licence(LICENCE_USER)) 
     {
       echo('&nbsp;<a title="Nedokončené překlady" href="'.$Config['Web']['BaseURL'].'TranslationList.php?group='.$Group['Id'].'&amp;action=mydevelop">Rozepsané</a><br />
@@ -166 +169 @@
   global $Database, $Moderators;
   
-  echo('Online uživatelé:<br />');
+  echo('Online překladatelé:<br />');
   $ID = $Database->SQLCommand('SELECT user, GM, ID FROM `user` WHERE LastLogin >= Now() - 300 AND ((LastLogout < LastLogin) OR (ISNULL(LastLogout)))');
   while ($Line = mysql_fetch_assoc($ID))
@@ -183 +186 @@
   
   echo('<?xml version="1.0" encoding="'.$Config['Web']['Charset'].'"?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cs" lang="cs">
-<head>'.
+  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="cs">'.
+'<head>'.
 '<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />'.
 '<meta name="keywords" content="wow, quest, questy, questů, preklad, mangos, překlad, překládání, přeložený, přeložení, čeština, world of warcraft, open source, free, addon" />'.

trunk/index.php

@@ -2 +2 @@
 
 include('includes/global.php');
-include('rss.php');
   
 function ShowNews()
@@ -29 +28 @@
 }
 
-if(array_key_exists('rss', $_GET))
+function ShowRSSChannel()
 {
+  global $Database, $Config;
+  
   $Items = array();  
   if($_GET['rss'] == 'news')
@@ -38 +39 @@
     {
       $Items[] = array
-          (
+    (
         'Title' => $DbRow['user'].'('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')',
         'Link' =>  $Config['Web']['BaseURL'],
@@ -44 +45 @@
         'Time' => $DbRow['UNIX_TIMESTAMP(news.Time)'],
       );
-    }   
+    } 
     echo(GenerateRSS(array
     (
@@ -60 +61 @@
     {
       $Items[] = array
-          (
+    (
         'Title' => strip_tags($DbRow['text'].' ('.$DbRow['user'].')'),
         'Link' =>  $Config['Web']['BaseURL'],
@@ -66 +67 @@
         'Time' => $DbRow['UNIX_TIMESTAMP(date)'],
       );
-    }   
+    } 
     echo(GenerateRSS(array
     (
@@ -78 +79 @@
   if($_GET['rss'] == 'shoutbox')
   {
-        $TitleLength = 50;
-        mb_internal_encoding('utf-8');
+  $TitleLength = 50;
+  mb_internal_encoding('utf-8');
     $DbResult = $Database->SQLCommand('SELECT UNIX_TIMESTAMP(date), user, text FROM shoutbox ORDER BY ID DESC LIMIT 20');
     while($DbRow = mysql_fetch_assoc($DbResult)) 
     {
-          $Title = mb_substr($DbRow['text'], 0, $TitleLength);
-          if(mb_strlen($Title) == $TitleLength) $Title .= '...';
+    $Title = mb_substr($DbRow['text'], 0, $TitleLength);
+    if(mb_strlen($Title) == $TitleLength) $Title .= '...';
       $Items[] = array
-          (
+    (
         'Title' => $DbRow['user'].': '.$Title,
         'Link' =>  $Config['Web']['BaseURL'],
@@ -92 +93 @@
         'Time' => $DbRow['UNIX_TIMESTAMP(date)'],
       );
-    }   
+    } 
     echo(GenerateRSS(array
     (
@@ -102 +103 @@
     )));
   }
+}
+
+if(array_key_exists('rss', $_GET))
+{
+  ShowRSSChannel();
 } else
 {

trunk/registrace.php

@@ -20 +20 @@
     $Line = mysql_fetch_row($Database->SQLCommand('SELECT * FROM user WHERE user = "'.$User.'"'));
     if(!$Line) 
-        {
+  {
       $Address = $_SERVER['REMOTE_ADDR'];
       $Database->SQLCommand('INSERT INTO `user` (`user` , `pass` , `LastIP` , `LastLogin` , `Email` , `Language` , `team` , `NeedUpdate` )
@@ -36 +36 @@
  // echo $Database->id_connection;
     } else 
-        {
+  {
       echo('Uživatel s touto přezdívkou již existuje. <a href="?">Zpět</a>');
     }
   } else 
   {
-        echo('Hesla se neshodují. <a href="?">Zpět</a>');
+  echo('Hesla se neshodují. <a href="?">Zpět</a>');
   }    
 } else 
@@ -70 +70 @@
     </tr>
     <tr>
-    <tr>
       <td>Patřím do týmu: </td>
       <td><select name="Team"><option value="0">Žádného</option>
       ');
-                $ID = $Database->SQLCommand('SELECT name,ID FROM team');
-                while($Line = mysql_fetch_assoc($ID))
+    $ID = $Database->SQLCommand('SELECT name,ID FROM team');
+    while($Line = mysql_fetch_assoc($ID))
     {
-                        echo('<option value="0'.$Line['ID'].'">'.$Line['name'].'</option>');
-        }
+      echo('<option value="0'.$Line['ID'].'">'.$Line['name'].'</option>');
+      }
       echo('</select></td>
     </tr>