[Sommaire] [Imprimer]

   1  <?php
   2  if (!isset($gCms)) exit;
   3  
   4  $current_version = $oldversion;
   5  $db =& $this->cms->GetDb();
   6  switch($current_version)
   7  {
   8      case "1.0":
   9      case "1.1":
  10          $this->CreatePermission('Manage Menu', 'Manage Menu');
  11  
  12          # Setup permissions
  13          $perm_id = $db->GetOne("SELECT permission_id FROM ".cms_db_prefix()."permissions WHERE permission_name = 'Manage Menu'");
  14          $group_id = $db->GetOne("SELECT group_id FROM ".cms_db_prefix()."groups WHERE group_name = 'Admin'");
  15  
  16          $count = $db->GetOne("SELECT count(*) FROM " . cms_db_prefix() . "group_perms WHERE group_id = ? AND permission_id = ?", array($group_id, $perm_id));
  17          if (isset($count) && intval($count) == 0)
  18          {
  19              $new_id = $db->GenID(cms_db_prefix()."group_perms_seq");
  20              $query = "INSERT INTO " . cms_db_prefix() . "group_perms (group_perm_id, group_id, permission_id, create_date, modified_date) VALUES (".$new_id.", ".$group_id.", ".$perm_id.", ". $db->DBTimeStamp(time()) . ", " . $db->DBTimeStamp(time()) . ")";
  21              $db->Execute($query);
  22          }
  23  
  24          $group_id = $db->GetOne("SELECT group_id FROM ".cms_db_prefix()."groups WHERE group_name = 'Designer'");
  25  
  26          $count = $db->GetOne("SELECT count(*) FROM " . cms_db_prefix() . "group_perms WHERE group_id = ? AND permission_id = ?", array($group_id, $perm_id));
  27          if (isset($count) && intval($count) == 0)
  28          {
  29              $new_id = $db->GenID(cms_db_prefix()."group_perms_seq");
  30              $query = "INSERT INTO " . cms_db_prefix() . "group_perms (group_perm_id, group_id, permission_id, create_date, modified_date) VALUES (".$new_id.", ".$group_id.", ".$perm_id.", ". $db->DBTimeStamp(time()) . ", " . $db->DBTimeStamp(time()) . ")";
  31              $db->Execute($query);
  32          }
  33  
  34          $current_version = '1.2';
  35  }
  36  
  37  ?>