Changeset 471

Timestamp:

Apr 22, 2010, 8:58:41 AM (15 years ago)

Author:

george

Message:

• Upraveno: Zobrazení odkazu na původní text při překládání i pro anglické originály.

Location:

trunk

Files:

• form.php (modified) (1 diff)
• sql/updates/470.sql (modified) (1 diff)

trunk/form.php

@@ -60 +60 @@
     $Language = $DbResult->fetch_assoc();
     // echo $Language['Language'].'  '.$Line['Take'];
-    if($Language['Language'] <> 0)
-      echo('Převzato z: <a href="form.php?group='.$GroupId.'&amp;ID='.$Line['Take'].'">'.$Line['Take'].'</a> <br />');
+    
+    $DbResult = $System->Database->query('SELECT `Name` FROM `Language` WHERE `Id` ='.$Language['Language']);
+    $Lang = $DbResult->fetch_assoc();
+    
+    echo('Původní text: <strong>');
+    echo(' ID <a href="form.php?group='.$GroupId.'&amp;ID='.$Line['Take'].'">'.$Line['Take'].'</a></strong>');
+    echo(' ('.$Lang['Name'].')');
+    echo(' <br />');
   }
   echo('Text: ');

trunk/sql/updates/470.sql

@@ -2 +2 @@
 UPDATE  `DbVersion` SET  `Version` =  'Rev. 470' WHERE  `DbVersion`.`Id` =1;
 
-ALTER TABLE  `ShoutBox` CHANGE  `User`  `UserName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NUL;
+ALTER TABLE  `ShoutBox` CHANGE  `User`  `UserName` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
 ALTER TABLE  `ShoutBox` ADD  `User` INT NOT NULL AFTER  `ID`;
 ALTER TABLE  `ShoutBox` ADD INDEX (  `User` );
 
-UPDATE `ShoutBox` SET `User` = (SELECT `ID` FROM `User` WHERE `User`.`Name` = `ShoutBox`.`UserName`)
+UPDATE `ShoutBox` SET `User` = (SELECT `ID` FROM `User` WHERE `User`.`Name` = `ShoutBox`.`UserName`);