Changeset 123 for trunk

Timestamp:

Feb 22, 2009, 7:51:01 PM (16 years ago)

Author:

maron

Message:

Při stejném překladu uložení všech

Location:

trunk

Files:

• index.php (modified) (1 diff)
• save.php (modified) (2 diffs)

trunk/index.php

@@ -37 +37 @@
 
   $Output = '<br /><strong>Poslední překlady:</strong><div class="NewsBox">';
-  $DbResult = $Database->SQLCommand('SELECT date,user.user,text FROM log JOIN user ON user.ID = log.User WHERE type = 1 ORDER BY date DESC LIMIT 10');
+  $DbResult = $Database->SQLCommand('SELECT date,user.user,text FROM log JOIN user ON user.ID = log.User WHERE type = 1 ORDER BY date DESC LIMIT 30');
   while($DbRow = mysql_fetch_assoc($DbResult))
     $Output .= '<strong>'.$DbRow['user'].'('.date('d.m.Y', MysqlDateTimeToTime($DbRow['date'])).')</strong>

trunk/save.php

@@ -22 +22 @@
   //if(( == '') AND ($complete == 1)) die('Musite zadat název textu');
     
+  $LineAJ = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE Language = 0 AND entry = '.$entry));
   $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE user='.$UserID.' AND entry = '.$entry));
   if(!$Line) 
   {
-        $Columns = '`entry`, `Language` , `User` , `Complete` , `Take`';
-        $Values = $entry.','.$Language.','.$UserID.','.$complete.','.$TextID;
+        $Columns = '`Language` , `User` , `Complete` , `Take`';
+        $Values = $Language.','.$UserID.','.$complete.','.$TextID;
         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
         {
@@ -36 +37 @@
         }  
         //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
-    $Database->SQLCommand('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
-          $LastID = mysql_insert_id();
-    echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uložen!<br />');
-    WriteLog($TranslationTree[$GroupId]['Name'].' <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> uložen! Převzat z: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 1);
-  } else 
-  {
+  //  $Database->SQLCommand('INSERT INTO `'.$Table.'` (`entry`, '.$Columns.') VALUES ('.$entry.','.$Values.')');
+        //  $LastID = mysql_insert_id();
+
+        //kontrolování stejných textů
+        $Where = 'Language = 0 ';
+        foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
+        {
+      if(array_key_exists($GroupItem['Column'], $_POST))
+          {
+                $Where .= ' AND `'.$GroupItem['Column'].'` = "'.$LineAJ[$GroupItem['Column']].'"';
+          }
+        }  
+        $SameTranID = $Database->SQLCommand('SELECT * FROM '.$Table.' WHERE '.$Where);
+        while($SameTranLine = mysql_fetch_assoc($SameTranID)) {
+                $Line = mysql_fetch_array($Database->SQLCommand('SELECT * FROM '.$Table.' WHERE user='.$UserID.' AND entry = '.$SameTranLine['entry']));
+                if(!$Line) {
+                    $Database->SQLCommand('INSERT INTO `'.$Table.'` (`entry`, '.$Columns.') VALUES ('.$SameTranLine['entry'].','.$Values.')');
+                    $LastIDs[] = mysql_insert_id();
+                }
+        }
+        
+        echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uložen!<br />');
+        foreach($LastIDs as $LastID) {
+                if (count($LastIDs) > 1) echo 'Nalezen stejný překlad, systémově přeložen: <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> Převzat z: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a><br />';
+        WriteLog($TranslationTree[$GroupId]['Name'].' <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> uložen! Převzat z: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 1);
+        }
+  } else {
     $sql = 'UPDATE '.$Table.' SET `Complete` = '.$complete;
         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)