Changeset 455 for trunk/form.php

Timestamp:

Apr 13, 2010, 10:03:12 AM (14 years ago)

Author:

george

Message:

• Upraveno: Přístup k databázi převeden na objektový pomocí rozšířené PHP třídy mysqli. Při práci s databází použít globální objekt $System a jeho prvek $Database ($System->Database->query("SELECT ...");.
• Upraveno: Při vkládání nové zprávy do Kecátka neprovádět přesměrování, ale rovnou zobrazit výpis. U některých překladatelů toto způsobovalo opakované vložení zprávy.

File:

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

trunk/form.php

@@ -30 +30 @@
   $TextID = $_GET['ID'] * 1;  
 
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `ID` = '.$TextID);
-  $Line = mysql_fetch_assoc($DbResult);
+  $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE `ID` = '.$TextID);
+  $Line = $DbResult->fetch_assoc();
   if(!$Line) ErrorMessage('Překlad nenalezen.');
     
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0) AND (`Entry` = '.$Line['Entry'].') AND (`VersionEnd` = '.$Line['VersionEnd'].') LIMIT 1');
-  $LineAJ = mysql_fetch_assoc($DbResult);
+  $DbResult = $System->Database->query('SELECT * FROM `'.$Table.'` WHERE (`Language` = 0) AND (`Entry` = '.$Line['Entry'].') AND (`VersionEnd` = '.$Line['VersionEnd'].') LIMIT 1');
+  $LineAJ = $DbResult->fetch_assoc();
   if(!$Line) ErrorMessage('Anglický originál k překladu nenalezen.');
   
-  $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
-  $LineUser = mysql_fetch_array($IDUser);
+  $IDUser = $System->Database->query('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
+  $LineUser = $IDUser->fetch_array();
   
   echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
@@ -47 +47 @@
   if(($Line['Take'] <> 0) and ($Line['Take'] <> $Line['ID'])) 
   {
-    $Language = mysql_fetch_assoc($Database->SQLCommand('SELECT `Language`,`VersionStart`,`VersionEnd` FROM `'.$Table.'` WHERE `ID` = '.$Line['Take']));
+    $DbResult = $System->Database->query('SELECT `Language`,`VersionStart`,`VersionEnd` FROM `'.$Table.'` WHERE `ID` = '.$Line['Take']);
+    $Language = $DbResult->fetch_assoc();
     // echo $Language['Language'].'  '.$Line['Take'];
     if($Language['Language'] <> 0)
@@ -63 +64 @@
   echo('<br />');
    
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`Language` <> 0) AND (`Complete` = 1)');
-  $Version = mysql_fetch_row($DbResult);
+  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`Language` <> 0) AND (`Complete` = 1)');
+  $Version = $DbResult->fetch_row();
   $Version = $Version[0];
   if($Version > 0)
@@ -75 +76 @@
       <option value="-1">Vyberte text k porovnání</option>
       <option value="-1">Zobrazit/porovnat všechny</option>'); 
-    $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'].') AND (`Complete` = 1)');  
-    while($version = mysql_fetch_array($DataID))
+    $DataID = $System->Database->query('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'].') AND (`Complete` = 1)');  
+    while($version = $DataID->fetch_array())
     {     
       if ($version['ID'] == $Line['Take']) echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' (převzato)</option>');