Changeset 1546

Timestamp:

08/24/06 20:51:31 (2 years ago)

Author:

mbonetti

Message:

experimental: XML dump of the installation.

Location:

trunk/gregarius

Files:

• admin/channels.php (modified) (1 diff)
• admin/opml.php (modified) (2 diffs)
• ajax.php (modified) (1 diff)
• schema.php (modified) (2 diffs)

trunk/gregarius/admin/channels.php

@@ -741 +741 @@
         break;
 
-
+    case 'dump':
+        // Make sure this is a POST
+        if(!isset($_POST['dumpact'])) {
+            die('Sorry, you can\'t access this via a GET');
+        }
+        $tbl = array('"','"');
+        error_reporting(E_ALL);
+        rss_require('schema.php');
+        $tables=getExpectedTables();
+        unset($tables['cache']);
+        //$tables=array('channels','tag','config');
+        $bfr='';
+        $bfr .= '<'.'?xml version="1.0" encoding="UTF-8"?'.'>'."\n";
+        $bfr .= '<dump prefix="'.getTable('').'" date="'.date('r').'">'."\n";
+        foreach($tables as $table => $prefixed) {
+            $rs = rss_query("select * from $prefixed");
+            $bfr .="<$table>\n";
+            while($row=rss_fetch_assoc($rs)) {
+                $r="<row ";
+                foreach($row as $key => $val) {
+                    $val=htmlspecialchars($val);
+                    $r.=" $key=\"$val\" ";
+                }
+                $r .= "/>\n";
+                $bfr .=$r;
+            }
+            $bfr .="</$table>\n";
+        }
+        $bfr .='</dump>'."\n";
+        $gzdata = gzencode($bfr, 9);
+        $tempfname=tempnam("/tmp", "rss.dump").'.xml.gz';
+        $df=fopen($tempfname,'w');
+        fwrite($df, $gzdata);
+        fclose($df);
+        die($tempfname);
+        break;
     default:
         break;

trunk/gregarius/admin/opml.php

@@ -91 +91 @@
     // export
     opml_export_form();
-
+    dump_export_form();
     echo "</div>\n";
 }
@@ -113 +113 @@
 }
 
+
+/***** DUMP ******/
+
+function dump_export_form() {
+
+    echo "<fieldset style=\"vertical-align:top\">\n<legend>".__('XML Dump:')."</legend>\n";
+    echo "<form method=\"post\" action=\"".$_SERVER['PHP_SELF']."\">\n"
+    ."<p><label for=\"action\">". __('Dump your Gregarius installation to XML'). "</label>\n"
+    ."<input type=\"submit\" name=\"dumpact\" id=\"action\" value=\"".__('Dump!')."\" />"
+    ."<input type=\"hidden\" name=\"". CST_ADMIN_DOMAIN ."\" value=\"".CST_ADMIN_DOMAIN_CHANNEL."\"/>\n"
+    ."<input type=\"hidden\" name=\"".CST_ADMIN_METAACTION."\" value=\"dump\"/>\n"
+    ."</p>\n</form>\n"
+    ."</fieldset>\n";
+}
+
 ?>

trunk/gregarius/ajax.php

@@ -215 +215 @@
       toggle.innerHTML="<?php echo  LBL_TAG_SUBMITTING ?>";
         submit_tag(id,fld.value);
-    } else if (toggle.innerHTML == "<?php echo  LBL_TAG_EDIT ?>") {
+    } else if (toggle.innerHTML == "<?php echo LBL_TAG_EDIT ?>") {
        var isIE=document.all?true:false;
        // the tag container

trunk/gregarius/schema.php

@@ -38 +38 @@
     $missing_tables = array();
     $actual_tables=array();
-    $expected_tables = array (
+    $expected_tables = getExpectedTables();
+    
+    $rs = rss_query( "show tables", true, true );
+    while(list($tbl) = rss_fetch_row($rs)) {
+        $actual_tables[]=$tbl;
+    }
+    
+    foreach ($expected_tables as $base => $tbl) {
+        $exists = array_search($tbl,$actual_tables);
+        if ($exists === FALSE || $exists === NULL) {
+            $missing_tables[]=$base;
+        }
+    }
+    
+    $updated  = 0;
+    if (count($missing_tables) > 0) {
+        $msg = (count($actual_tables)?"Updating":"Creating")
+            .' your database schema! This should be a one-time operation,'
+            .' if you see this message over and over again please import your database schema'
+            .' manually.';
+        rss_error($msg, RSS_ERROR_WARNING);
+
+        foreach($missing_tables as $table) {
+            $updated += call_user_func("_init_$table"); 
+        }
+        
+        if ($updated == count($missing_tables)) {
+            rss_error("Successfully created $updated of $updated database tables!", RSS_ERROR_NOTICE);
+        } else {
+            rss_error(
+                (count($missing_tables) - $updated) . " out of "
+            . count($missing_tables) ." tables could not be created!",RSS_ERROR_ERROR);
+        }
+    }
+    
+    if ($updated) {
+        rss_invalidate_cache();
+    }
+    return $updated;
+}
+
+function getExpectedTables() {
+$expected_tables = array (
         "channels" => trim(getTable("channels")),
         "config" => trim(getTable("config")),
@@ -52 +94 @@
 
     );
-    
-    $rs = rss_query( "show tables", true, true );
-    while(list($tbl) = rss_fetch_row($rs)) {
-        $actual_tables[]=$tbl;
-    }
-    
-    foreach ($expected_tables as $base => $tbl) {
-        $exists = array_search($tbl,$actual_tables);
-        if ($exists === FALSE || $exists === NULL) {
-            $missing_tables[]=$base;
-        }
-    }
-    
-    $updated  = 0;
-    if (count($missing_tables) > 0) {
-        $msg = (count($actual_tables)?"Updating":"Creating")
-            .' your database schema! This should be a one-time operation,'
-            .' if you see this message over and over again please import your database schema'
-            .' manually.';
-        rss_error($msg, RSS_ERROR_WARNING);
-
-        foreach($missing_tables as $table) {
-            $updated += call_user_func("_init_$table"); 
-        }
-        
-        if ($updated == count($missing_tables)) {
-            rss_error("Successfully created $updated of $updated database tables!", RSS_ERROR_NOTICE);
-        } else {
-            rss_error(
-                (count($missing_tables) - $updated) . " out of "
-            . count($missing_tables) ." tables could not be created!",RSS_ERROR_ERROR);
-        }
-    }
-    
-    if ($updated) {
-        rss_invalidate_cache();
-    }
-    return $updated;
-}
-
+    return $expected_tables;
+}
 function rss_query_wrapper($query, $dieOnError=true, $preventRecursion=false) {
     global $out;