[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Creating sequences...";
   4  
   5  
   6  function upgrade_create_sequence_table($db, $tablename, $idcol) {
   7  
   8      $num = $db->GetOne("SELECT MAX($idcol) FROM $tablename");
   9      $db->DropSequence($tablename."_seq");
  10      $db->CreateSequence($tablename."_seq", $num + 1);
  11      $dict = NewDataDictionary($db);
  12      $sqlarray = $dict->AlterColumnSQL($tablename, "$idcol I"); 
  13      $dict->ExecuteSQLArray($sqlarray);
  14  
  15  }
  16  
  17  upgrade_create_sequence_table($db, $config["db_prefix"]."additional_users", "additional_users_id");
  18  upgrade_create_sequence_table($db, $config["db_prefix"]."group_perms", "group_perm_id");
  19  upgrade_create_sequence_table($db, $config["db_prefix"]."groups", "group_id");
  20  upgrade_create_sequence_table($db, $config["db_prefix"]."pages", "page_id");
  21  upgrade_create_sequence_table($db, $config["db_prefix"]."permissions", "permission_id");
  22  upgrade_create_sequence_table($db, $config["db_prefix"]."templates", "template_id");
  23  upgrade_create_sequence_table($db, $config["db_prefix"]."users", "user_id");
  24  
  25  echo "[done]</p>";
  26  
  27  echo "<p>Creating modules table...";
  28  
  29  $dbdict = NewDataDictionary($db);
  30  $flds = "
  31      module_name C(255),
  32      status C(255),
  33      version C(255),
  34      active L
  35  ";
  36  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  37  $sqlarray = $dbdict->CreateTableSQL($config["db_prefix"]."modules", $flds, $taboptarray);
  38  $dbdict->ExecuteSQLArray($sqlarray);
  39  
  40  echo "[done]</p>";
  41  
  42  echo "<p>Adding parent_id to pages table...";
  43  
  44  $dbdict = NewDataDictionary($db);
  45  $sqlarray = $dbdict->AddColumnSQL($config["db_prefix"]."pages", "parent_id I NOTNULL DEFAULT 0");
  46  $dbdict->ExecuteSQLArray($sqlarray);
  47  
  48  echo "[done]</p>";
  49  
  50  echo "<p>Removing section_id from pages table...";
  51  
  52  $dbdict = NewDataDictionary($db);
  53  $sqlarray = $dbdict->DropColumnSQL($config["db_prefix"]."pages", "section_id");
  54  $dbdict->ExecuteSQLArray($sqlarray);
  55  
  56  echo "[done]</p>";
  57  
  58  echo "<p>Removing sections table...";
  59  
  60  $dbdict = NewDataDictionary($db);
  61  $sqlarray = $dbdict->DropTableSQL($config["db_prefix"]."sections");
  62  $dbdict->ExecuteSQLArray($sqlarray);
  63  
  64  echo "[done]</p>";
  65  
  66  echo "<p>Adding module admin permission... ";
  67  
  68  $new_id = $db->GenID($config["db_prefix"]."permissions_seq");
  69  $query = "INSERT INTO ".$config["db_prefix"]."permissions (permission_id, permission_name, permission_text, create_date, modified_date) VALUES ($new_id,'Modify Modules','Modify Modules',".$db->DBTimeStamp(time()).",".$db->DBTimeStamp(time()).")";
  70  $db->Execute($query);
  71  
  72  echo "[done]</p>";
  73  
  74  echo "<p>Clearing cache and template directories... ";
  75  
  76  function clear_dir_3($dir){
  77  
  78      $path = dirname(dirname(__FILE__))."/smarty/cms/".$dir."/";
  79  
  80      $handle=opendir($path);
  81      while ($file = readdir($handle)) {
  82          if ($file != "." && $file != ".." && is_file($path.$file)) {
  83              #echo ($path.$file);
  84              unlink($path.$file);
  85          }
  86      }
  87  }
  88  
  89  clear_dir_3("templates_c");
  90  clear_dir_3("cache");
  91  
  92  echo "[done]</p>";
  93  
  94  echo "<p>Updating schema version... ";
  95  
  96  $query = "UPDATE ".$config["db_prefix"]."version SET version = 4";
  97  $db->Execute($query);
  98  
  99  echo "[done]</p>";
 100  
 101  # vim:ts=4 sw=4 noet
 102  ?>