[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo '<p>Creating "Modify Events" permission...';
   4  
   5  $perm_id = $db->GenID(cms_db_prefix() . 'permissions_seq');
   6  $table  = cms_db_prefix() . 'permissions';
   7  $name   = 'Modify Events';
   8  $timestamp = $db->DBTimeStamp(time());
   9  if ($timestamp[0] != "'")
  10  {
  11      $timestamp = "'$timestamp'";
  12  }
  13  $query ="
  14      INSERT INTO 
  15          `$table`
  16      (permission_id, permission_name, permission_text, create_date, modified_date) 
  17          VALUES
  18      ('$perm_id', '$name', '$name', $timestamp, $timestamp)
  19  ";
  20  $result = $db->Execute($query);
  21  if ($result) 
  22  {
  23      $groupperm_id = $db->GenID(cms_db_prefix() . 'group_perms_seq');
  24      $table  = cms_db_prefix() . 'group_perms'; 
  25      $query = "
  26          INSERT INTO 
  27              `$table` 
  28          (group_perm_id, group_id, permission_id, create_date, modified_date) 
  29              VALUES 
  30          ('$groupperm_id', 1, $perm_id, $timestamp, $timestamp)
  31      ";
  32      $result = $db->Execute($query);
  33  }
  34  echo '[done]</p>';
  35  
  36  echo '<p>Updating schema version... ';
  37  $query = 'UPDATE '.cms_db_prefix().'version SET version = 27';
  38  $db->Execute($query);
  39  echo '[done]</p>';
  40  
  41  # vim:ts=4 sw=4 noet
  42  ?>