Changeset 212

Timestamp:

Jun 20, 2009, 3:52:12 PM (15 years ago)

Author:

maron

Message:

DB oprava sloupce Take a ShortCut

File:

• trunk/action.php (modified) (3 diffs)

trunk/action.php

@@ -49 +49 @@
         echo('Nahradit: <input type="text" name="replace" /><br />');
         echo('<input type="submit" value="Najít/nahradit" /><br />');
-    echo('</form>');
+    echo('</form><br />');
+        echo ('<a href="?action=dbkit&amp;Take">Opravit data v sloupci Take</a><br />');
+        echo ('<a href="?action=dbkit&amp;ShortCut">Opravit data v sloupci ShortCut</a><br />');
     
     if (array_key_exists('find',$_POST)) {
@@ -87 +89 @@
           }
         }
+        
+        //oprava dat v sloupci Take
+    if (array_key_exists('Take',$_GET)) {
+        echo ('Začínám opravovat Take: <br />');
+        
+          foreach($TranslationTree as $Group) {
+        $Table = $Group['TablePrefix'];
+        echo ($Table.' ');
+                
+                $sql = 'SELECT ID,entry as entry_tran, (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig FROM '.$Table.' WHERE (Language <> 0) AND (Take = 0)';
+                
+            $ID = $Database->SQLCommand($sql);
+                while ($Line = mysql_fetch_assoc($ID)) {
+                        $sql = 'UPDATE '.$Table.' SET Take = '.$Line['ID_orig'].' WHERE ID = '.$Line['ID'];
+                    $Database->SQLCommand($sql);
+                    echo ('.');
+                }
+                
+                echo (' <strong>Hotovo</strong> <br />');
+                if (mysql_num_rows($ID) > 0) {
+                        WriteLog('Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
+                        echo (' Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
+                }
+          }
+        }       
+        //oprava dat ShortCut
+    if (array_key_exists('ShortCut',$_GET)) {
+        echo ('Začínám opravovat Take: <br />');
+                        
+                        
+                $Tables = array ('global_strings','glue_strings');      
+
+          foreach($Tables as $Table) {
+        echo ($Table.' ');
+                $sql = 'SELECT gs_orig.ID,
+gs_tran.entry,
+gs_tran.ShortCut as ShortCut_tran,
+gs_orig.ShortCut  as ShortCut_orig
+FROM '.$Table.' as gs_tran
+JOIN '.$Table.' as gs_orig ON gs_orig.entry = gs_tran.entry
+WHERE gs_tran.Language <> 0 AND gs_tran.ShortCut <> gs_orig.ShortCut';
+                
+            $ID = $Database->SQLCommand($sql);
+                while ($Line = mysql_fetch_assoc($ID)) {
+                        $sql = 'UPDATE '.$Table.' SET ShortCut = '.$Line['ShortCut_orig'].' WHERE ID = '.$Line['ID'];
+                    $Database->SQLCommand($sql);
+                    echo ('.');
+                }
+                
+                echo (' <strong>Hotovo</strong> <br />');
+                if (mysql_num_rows($ID) > 0) {
+                        WriteLog('Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
+                        echo (' Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
+                }
+          }
+        }       
 }
 
@@ -109 +167 @@
         else echo('<input type="text" name="user" /><br />');
     echo('Text zprávy: <br>
-      <textarea name="text" cols="40"></textarea> <br />
-      <input type="submit" value="Uložit" /><br /></fieldset>
+      <textarea  onkeydown="ResizeTextArea(this)" name="text" cols="40"></textarea> <br />
+      <input type="submit" value="Odeslat" /><br /></fieldset>
       </form>');
   } else