Changeset 151 for trunk/action.php

Timestamp:

Mar 12, 2009, 11:47:40 AM (16 years ago)

Author:

maron

Message:

opravy databáze

File:

• trunk/action.php (modified) (1 diff)

trunk/action.php

@@ -8 +8 @@
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
+
+
+if(($Action == 'dbkit') and Licence(LICENCE_ADMIN)) 
+{
+        echo ('<form action="?action=dbkit" method="post">');
+        echo('Najít: <input type="text" name="find" /><br />');
+        echo('Nahradit: <input type="text" name="replace" /><br />');
+        echo('<input type="submit" value="Najít/nahradit" /><br />');
+    echo('</form>');
+    
+    if (array_key_exists('find',$_POST)) {
+        echo ('Začínám nahrazovat: <br />');
+        $find = $_POST['find'];
+        $replace = $_POST['replace'];
+        
+          foreach($TranslationTree as $Group) {
+        $Table = $Group['TablePrefix'];
+        echo ($Table.' ');
+                
+                $sql = 'SELECT * FROM '.$Table.' WHERE (Language <> 0) AND (';
+                foreach($Group['Items'] as $Item) {
+                        if($Item['Column'] != '') $sql .= '`'.$Item['Column'].'` LIKE "%'.$find.'%" OR ';
+                }
+                $sql = substr($sql,0,strlen($sql)-4);
+                $sql .= ')';
+                
+            $ID = $Database->SQLCommand($sql);
+                while ($Line = mysql_fetch_assoc($ID)) {
+                        $sql = 'UPDATE '.$Table;
+                        foreach($Group['Items'] as $Item) {
+                                $Column_text = addslashes(str_replace($find,$replace,$Line[$Item['Column']]));
+                                $sql .= ' SET '.$Item['Column'].' = "'.$Column_text.'"';
+                        }
+                        $sql .= ' WHERE ID = '.$Line['ID'];
+                    $Database->SQLCommand($sql);
+                    echo ('.');
+                }
+                
+                echo (' <strong>Hotovo</strong> <br />');
+                if (mysql_num_rows($ID) > 0) {
+                        WriteLog('Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
+                        echo (' Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'<br />');
+                }
+          }
+        }
+}
+
 
 if(($Action == 'delete') and Licence(LICENCE_MODERATOR))