[Sommaire] [Imprimer]

   1  <?php
   2  if (!isset($gCms)) exit;
   3  
   4  // create a permission
   5  $db =& $this->cms->GetDb();
   6  $this->CreatePermission('Manage Menu', 'Manage Menu');
   7  
   8  # Setup permissions
   9  $perm_id = $db->GetOne("SELECT permission_id FROM ".cms_db_prefix()."permissions WHERE permission_name = 'Manage Menu'");
  10  $group_id = $db->GetOne("SELECT group_id FROM ".cms_db_prefix()."groups WHERE group_name = 'Admin'");
  11  
  12  $count = $db->GetOne("SELECT count(*) FROM " . cms_db_prefix() . "group_perms WHERE group_id = ? AND permission_id = ?", array($group_id, $perm_id));
  13  if (isset($count) && intval($count) == 0)
  14  {
  15      $new_id = $db->GenID(cms_db_prefix()."group_perms_seq");
  16      $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()) . ")";
  17      $db->Execute($query);
  18  }
  19  
  20  $group_id = $db->GetOne("SELECT group_id FROM ".cms_db_prefix()."groups WHERE group_name = 'Designer'");
  21  
  22  $count = $db->GetOne("SELECT count(*) FROM " . cms_db_prefix() . "group_perms WHERE group_id = ? AND permission_id = ?", array($group_id, $perm_id));
  23  if (isset($count) && intval($count) == 0)
  24  {
  25      $new_id = $db->GenID(cms_db_prefix()."group_perms_seq");
  26      $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()) . ")";
  27      $db->Execute($query);
  28  }
  29  
  30  ?>