source: extensions/database_migration/include/tab_export.inc.php @ 6552

<?php
// +-----------------------------------------------------------------------+
// | database_migration - a plugin for Piwigo                              |
// +-----------------------------------------------------------------------+
// | Copyright(C) 2010 Nicolas Roudaire             http://www.nikrou.net  |
// +-----------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or modify  |
// | it under the terms of the GNU General Public License version 2 as     |
// | published by the Free Software Foundation                             |
// |                                                                       |
// | This program is distributed in the hope that it will be useful, but   |
// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
// | General Public License for more details.                              |
// |                                                                       |
// | You should have received a copy of the GNU General Public License     |
// | along with this program; if not, write to the Free Software           |
// | Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,            |
// | MA 02110-1301 USA                                                     |
// +-----------------------------------------------------------------------+

if (empty($_SESSION['dm_export_done']) || !empty($_GET['action'])) {
  $structure_file = PHPWG_ROOT_PATH .'/install/piwigo_structure-mysql.sql';
  $content = file_get_contents($structure_file);
  $pattern = '!CREATE TABLE `([^`]*)`!';
  preg_match_all($pattern, $content, $matches);

  $destination_dir = $conf['local_data_dir'] . '/plugins/database_migration';
  mkgetdir($destination_dir);
  $export = array();

  foreach ($matches[1] as $table) {
    $filename = sprintf('%s/%s.dump', $destination_dir, $table);
    $fh = fopen($filename, 'w+');
    $query = '
SELECT * FROM '.$table;
    $result = pwg_query($query);
    $export[] = array('table' => $table, 'lines_count' => mysql_num_rows($result));
    while ($row = pwg_db_fetch_assoc($result)) {
      $insert = '
INSERT INTO '.$table.' (';
      $insert_values = ') VALUES (';

      foreach ($row as $key => $value) {
        $insert .= $key.', ';
        if (is_null($value)) {
          $insert_values .= 'null, ';
        } else {
          $insert_values .= '\''.$value.'\', ';
        }
      }
      $insert = substr($insert, 0, -2);
      $insert_values = substr($insert_values, 0, -2);
      fputs($fh, $insert.$insert_values.');');
    }
    fclose($fh);
  }

  $_SESSION['dm_export_done'] = true;
  $GLOBALS['template']->assign('EXPORT', $export);
} else {
  $GLOBALS['template']->assign('EXPORT_DONE', true);
  $GLOBALS['template']->assign('U_FORCE_EXPORT', $dm_base_url.'&amp;tab=export&amp;action=force');
}
?>