Changeset 365 for trunk/form.php

Timestamp:

Mar 9, 2010, 11:29:05 AM (15 years ago)

Author:

george

Message:

• Upraveno: Jména tabulek v databází upraveny na stejná s prvními velkými písmeny.
• Upraveno: Doplněny SQL uvozovky do mnoha SQL dotazů.

File:

• trunk/form.php (modified) (6 diffs)

trunk/form.php

@@ -17 +17 @@
   if(!$Line) die('Překlad nenalezen.');
     
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `Language` = 0  AND `entry` = '.$Line['entry'].' AND `VersionEnd` = '.$Line['VersionEnd'].' LIMIT 1');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `Language` = 0  AND `Entry` = '.$Line['Entry'].' AND `VersionEnd` = '.$Line['VersionEnd'].' LIMIT 1');
   $LineAJ = mysql_fetch_assoc($DbResult);
   if(!$Line) die('Anglický originál k překladu nenalezen.');
   
   $User = @$_SESSION['User'];
-  $IDUser = $Database->SQLCommand('SELECT * FROM `user` WHERE `id` = '.$Line['User']);
+  $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
   $LineUser = mysql_fetch_array($IDUser);
   
   echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
       
-  if(($Line['Language'] <> 0) and ($LineUser['user'] <> '')) 
-    echo('Přeložil: <strong>'.$LineUser['user'].'</strong> <br />');
+  if(($Line['Language'] <> 0) and ($LineUser['Name'] <> '')) 
+    echo('Přeložil: <strong>'.$LineUser['Name'].'</strong> <br />');
   if(($Line['Take'] <> 0) and ($Line['Take'] <> $Line['ID'])) 
   {
@@ -47 +47 @@
   echo('<br />');
    
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE `entry` = '.$Line['entry'].' AND `Language` <> 0');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE `Entry` = '.$Line['Entry'].' AND `Language` <> 0');
   $Version = mysql_fetch_row($DbResult);
   $Version = $Version[0];
   if($Version > 0)
   {
-    echo('<form action="comparison.php" method="get"><a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>  
+    echo('<form action="comparison.php" method="get"><a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['Entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>  
       <input type="hidden" name="group" value="'.$GroupId.'" />
-      <input type="hidden" name="entry" value="'.$Line['entry'].'" />
+      <input type="hidden" name="entry" value="'.$Line['Entry'].'" />
       <input type="hidden" name="ID2" value="'.$TextID.'" />
       <select onchange="this.form.submit();" name="ID1">
       <option value="-1">Vyberte text k porovnání</option>
       <option value="-1">Zobrazit/porovnat všechny</option>'); 
-    $DataID = $Database->SQLCommand('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE (`entry` = '.$Line['entry'].') AND (`ID` <> '.$Line['ID'].')');  
+    $DataID = $Database->SQLCommand('SELECT *, (SELECT `User`.`Name` AS `UserName` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`ID` <> '.$Line['ID'].')');  
     while($version = mysql_fetch_array($DataID))
     {     
@@ -65 +65 @@
       else 
       {
-        if($version['Language'] == 0) $version['User'] = 'Předloha';
-        echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$Version['User'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
+        if($version['Language'] == 0) $version['UserName'] = 'Předloha';
+        echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$Version['UserName'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
       }
     }
@@ -72 +72 @@
   } else
   {
-    echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>'); 
+    echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['Entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>'); 
   }
 
@@ -87 +87 @@
 
   if($TranslationTree[$GroupId]['WowheadName'] != '')
-    $WowheadLink = '<a href="http://www.wowhead.com/?'.$TranslationTree[$GroupId]['WowheadName'].'='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a>';
-    else $WowheadLink = $LineAJ['entry'];
+    $WowheadLink = '<a href="http://www.wowhead.com/?'.$TranslationTree[$GroupId]['WowheadName'].'='.$LineAJ['Entry'].'">'.$LineAJ['Entry'].'</a>';
+    else $WowheadLink = $LineAJ['Entry'];
   
-  echo('<input type="hidden" name="entry" value="'.$LineAJ['entry'].'" />
+  echo('<input type="hidden" name="entry" value="'.$LineAJ['Entry'].'" />
     <input type="hidden" name="user" value="'.$User.'" />
     <input type="hidden" name="ID" value="'.$TextID.'" />
@@ -107 +107 @@
   else if($_SESSION['UserID'] != '')
   {
-    $IDUser = $Database->SQLCommand('SELECT * FROM `user` WHERE `id` = '.$_SESSION['UserID']);
+    $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID']);
     $LineUser = mysql_fetch_array($IDUser);
-    $Language = $LineUser['Language'];  //jiný user vyčítám
+    $Language = $LineUser['Language'];  // jiný user vyčítám
   } else $Language = 0;
   WriteLanguages($Language);