[Sommaire] [Imprimer]

   1  <?php
   2  
   3  $perm_table = cms_db_prefix() . 'permissions';
   4  $perm_seq_table = cms_db_prefix() . 'permissions_seq';
   5  
   6  
   7  // Check if the "Modify Page Structure" permission exists...
   8  $query = "
   9      SELECT 1 FROM $perm_table WHERE permission_name = 'Modify Page Structure'
  10  ";
  11  $result = $db->Execute($query);
  12  if ($result->RecordCount() == 0) 
  13  {
  14      echo '<p>Creating "Modify Page Structure" permission...</p>';
  15      
  16      $perm_id = $db->GenID($perm_seq_table);
  17      $name   = 'Modify Page Structure';
  18      
  19      $timestamp = $db->DBTimeStamp(time());
  20      if ($timestamp[0] != "'")
  21      {
  22          $timestamp = "'$timestamp'";
  23      }
  24      
  25      $query = "
  26          INSERT INTO 
  27              $perm_table
  28          (permission_id, permission_name, permission_text, create_date, modified_date) 
  29              VALUES
  30          ('$perm_id', '$name', '$name', $timestamp, $timestamp)
  31      ";
  32      $result = $db->Execute($query);
  33      if ($result) 
  34      {
  35          $groupperm_id = $db->GenID($config['db_prefix'] . 'group_perms_seq');
  36          $table  = $config['db_prefix'] . 'group_perms'; 
  37          $query = "
  38              INSERT INTO 
  39                  $table
  40              (group_perm_id, group_id, permission_id, create_date, modified_date) 
  41                  VALUES 
  42              ('$groupperm_id', 1, $perm_id, $timestamp, $timestamp)
  43          ";
  44          $result = $db->Execute($query);
  45      }
  46  }
  47  echo '<p>Updating schema version... ';
  48  
  49  $query = 'UPDATE '.cms_db_prefix().'version SET version = 28';
  50  $db->Execute($query);
  51  echo '[done]</p>';  
  52  
  53  ?>