[Sommaire] [Imprimer]

   1  <?php
   2  /*********************************************************************************
   3  ** The contents of this file are subject to the vtiger CRM Public License Version 1.0
   4   * ("License"); You may not use this file except in compliance with the License
   5   * The Original Code is:  vtiger CRM Open Source
   6   * The Initial Developer of the Original Code is vtiger.
   7   * Portions created by vtiger are Copyright (C) vtiger.
   8   * All Rights Reserved.
   9  *
  10   ********************************************************************************/
  11  
  12  require_once ("config.php");
  13  require_once ("include/database/PearDatabase.php");
  14  define("dbserver", $dbconfig['db_hostname']);
  15  define("dbuser", $dbconfig['db_username']);
  16  define("dbpass", $dbconfig['db_password']);
  17  define("dbname", $dbconfig['db_name']);
  18  
  19  function get_structure()
  20  {
  21      global $log;
  22          $log->debug("Entering get_structure() method ...");
  23      mysql_connect(dbserver, dbuser, dbpass);
  24      mysql_select_db(dbname);
  25      $tables = mysql_list_tables(dbname);
  26      while ($td = mysql_fetch_array($tables))
  27      {
  28          $table = $td[0];
  29          $r = mysql_query("SHOW CREATE TABLE `$table`");
  30          if ($r)
  31          {
  32              $insert_sql = "";
  33              $d = mysql_fetch_array($r);
  34              $d[1] .= ";";
  35              $SQL[] = str_replace("\n", "", $d[1]);
  36              $table_query = mysql_query("SELECT * FROM `$table`");
  37              $num_fields = mysql_num_fields($table_query);
  38              while ($fetch_row = mysql_fetch_array($table_query)){
  39                  $insert_sql .= "INSERT INTO $table VALUES(";
  40                  for ($n=1;$n<=$num_fields;$n++){
  41                      $m = $n - 1;
  42                      $insert_sql .= "'".$fetch_row[$m]."', ";
  43                  }
  44                  $insert_sql = substr($insert_sql,0,-2);
  45                  $insert_sql .= ");\n";
  46              }
  47              if ($insert_sql != ""){
  48                  $SQL[] = $insert_sql;
  49              }
  50          }
  51      }
  52      $log->debug("Exiting get_structure method ...");
  53      return $SQL;
  54  }
  55  
  56  function save_structure($filename, $root_directory)
  57  {
  58      global $log;
  59          $log->debug("Entering save_structure(".$filename.",".$root_directory.") method ...");
  60      $sql = get_structure();
  61      $sql = implode("\r", $sql);
  62      $handle = fopen($root_directory.'/'.$filename,"wb") ;
  63      fwrite($handle,$sql,9999999999);
  64      fclose($handle);
  65          $log->debug("Exiting save_structure method ...");
  66  }
  67  
  68  ?>