[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Adding fields to users table...";
   4  
   5  $dbdict = NewDataDictionary($db);
   6  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."users", "admin_access I1");
   7  $dbdict->ExecuteSQLArray($sqlarray);
   8  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."users", "first_name C(50)");
   9  $dbdict->ExecuteSQLArray($sqlarray);
  10  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."users", "last_name C(50)");
  11  $dbdict->ExecuteSQLArray($sqlarray);
  12  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."users", "email C(255)");
  13  $dbdict->ExecuteSQLArray($sqlarray);
  14  
  15  $db->Execute("UPDATE ".cms_db_prefix()."users SET admin_access = 1");
  16  
  17  echo "[done]</p>";
  18  
  19  echo "<p>Adding hierarchy position to pages table...";
  20  
  21  $dbdict = NewDataDictionary($db);
  22  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."pages", "hierarchy_position C(255)");
  23  $dbdict->ExecuteSQLArray($sqlarray);
  24  
  25  #set_all_pages_hierarchy_position();
  26  
  27  echo "[done]</p>";
  28  
  29  echo "<p>Creating htmlblobs table...";
  30  
  31  $dbdict = NewDataDictionary($db);
  32  $flds = "
  33      htmlblob_id I,
  34      htmlblob_name C(255),
  35      html X,
  36      owner I,
  37      create_date DT,
  38      modified_date DT
  39  ";
  40  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  41  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."htmlblobs", $flds, $taboptarray);
  42  $dbdict->ExecuteSQLArray($sqlarray);
  43  
  44  $db->CreateSequence($config["db_prefix"]."htmlblobs_seq");
  45  
  46  echo "[done]</p>";
  47  
  48  echo "<p>Creating additional_htmlblob_users table...";
  49  
  50  $dbdict = NewDataDictionary($db);
  51  $flds = "
  52      additional_htmlblob_users_id I KEY,
  53      user_id I,
  54      htmlblob_id I
  55  ";
  56  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  57  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."additional_htmlblob_users", $flds, $taboptarray);
  58  $dbdict->ExecuteSQLArray($sqlarray);
  59  
  60  echo "[done]</p>";
  61  
  62  echo "<p>Creating htmlblob permissions...";
  63  
  64  cms_mapi_create_permission($gCms, 'Add Html Blobs', 'Add Html Blobs');
  65  cms_mapi_create_permission($gCms, 'Modify Html Blobs', 'Modify Html Blobs');
  66  cms_mapi_create_permission($gCms, 'Remove Html Blobs', 'Remove Html Blobs');
  67  
  68  echo "[done]</p>";
  69  
  70  echo "<p>Clearing cache and template directories... ";
  71  
  72  function clear_dir_6($dir){
  73  
  74      $path = dirname(dirname(__FILE__))."/tmp/".$dir."/";
  75  
  76      $handle=opendir($path);
  77      while ($file = readdir($handle)) {
  78          if ($file != "." && $file != ".." && is_file($path.$file)) {
  79              #echo ($path.$file);
  80              unlink($path.$file);
  81          }
  82      }
  83  }
  84  
  85  clear_dir_6("templates_c");
  86  clear_dir_6("cache");
  87  
  88  echo "[done]</p>";
  89  
  90  echo "<p>Updating schema version... ";
  91  
  92  $query = "UPDATE ".cms_db_prefix()."version SET version = 7";
  93  $db->Execute($query);
  94  
  95  echo "[done]</p>";
  96  
  97  # vim:ts=4 sw=4 noet
  98  ?>