[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Creating userplugins table...";
   4  
   5  $dbdict = NewDataDictionary($db);
   6  $flds = "
   7      userplugin_id I,
   8      userplugin_name C(255),
   9      code X,
  10      create_date DT,
  11      modified_date DT
  12  ";
  13  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  14  $sqlarray = $dbdict->CreateTableSQL($config["db_prefix"]."userplugins", $flds, $taboptarray);
  15  $dbdict->ExecuteSQLArray($sqlarray);
  16  
  17  $db->CreateSequence($config["db_prefix"]."userplugins_seq");
  18  
  19  echo "[done]</p>";
  20  
  21  echo "<p>Creating css table...";
  22  
  23  $dbdict = NewDataDictionary($db);
  24  $flds = "
  25      css_id I,
  26      css_name C(255),
  27      css_text X,
  28      create_date DT,
  29      modified_date DT
  30  ";
  31  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  32  $sqlarray = $dbdict->CreateTableSQL($config["db_prefix"]."css", $flds, $taboptarray);
  33  $dbdict->ExecuteSQLArray($sqlarray);
  34  
  35  $db->CreateSequence($config["db_prefix"]."css_seq");
  36  
  37  echo "[done]</p>";
  38  
  39  echo "<p>Creating css_assoc table...";
  40  
  41  $dbdict = NewDataDictionary($db);
  42  $flds = "
  43      assoc_to_id I,
  44      assoc_css_id I,
  45      assoc_type C(80),
  46      create_date DT,
  47      modified_date DT
  48  ";
  49  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  50  $sqlarray = $dbdict->CreateTableSQL($config["db_prefix"]."css_assoc", $flds, $taboptarray);
  51  $dbdict->ExecuteSQLArray($sqlarray);
  52  
  53  echo "[done]</p>";
  54  
  55  echo "<p>Creating siteprefs table...";
  56  
  57  $dbdict = NewDataDictionary($db);
  58  $flds = "
  59      sitepref_name C(255),
  60      sitepref_value text,
  61      create_date DT,
  62      modified_date DT
  63  ";
  64  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  65  $sqlarray = $dbdict->CreateTableSQL($config["db_prefix"]."siteprefs", $flds, $taboptarray);
  66  $dbdict->ExecuteSQLArray($sqlarray);
  67  
  68  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('enablecustom404').", ".$db->qstr('0').")");
  69  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('custom404').", ".$db->qstr('<p>Page could not be found.</p>').")");
  70  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('custom404template').", ".$db->qstr('-1').")");
  71  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('enablesitedownmessage').", ".$db->qstr('0').")");
  72  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('sitedownmessage').", ".$db->qstr('<p>Site is currently down for maintenance.</p>').")");
  73  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('sitedownmessagetemplate').", ".$db->qstr('-1').")");
  74  $db->Execute("INSERT INTO ".$config["db_prefix"]."siteprefs (sitepref_name, sitepref_value) VALUES (".$db->qstr('useadvancedcss').", ".$db->qstr('1').")");
  75  
  76  echo "[done]</p>";
  77  
  78  echo "<p>Creating modify CSS permission...";
  79  
  80  cms_mapi_create_permission($gCms, 'Modify Site Preferences', 'Modify Site Preferences');
  81  
  82  echo "[done]</p>";
  83  
  84  echo "<p>Creating modify CSS permission...";
  85  
  86  cms_mapi_create_permission($gCms, 'Modify CSS', 'Modify CSS');
  87  cms_mapi_create_permission($gCms, 'Add CSS', 'Add CSS');
  88  cms_mapi_create_permission($gCms, 'Remove CSS', 'Remove CSS');
  89  cms_mapi_create_permission($gCms, 'Add CSS association', 'Add CSS association');
  90  cms_mapi_create_permission($gCms, 'Edit CSS association', 'Edit CSS association');
  91  cms_mapi_create_permission($gCms, 'Remove CSS association', 'Remove CSS association');
  92  
  93  echo "[done]</p>";
  94  
  95  echo "<p>Adding head_tags to pages table...";
  96  
  97  $dbdict = NewDataDictionary($db);
  98  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."pages", "head_tags X");
  99  $dbdict->ExecuteSQLArray($sqlarray);
 100  
 101  echo "[done]</p>";
 102  
 103  echo "<p>Creating modify code blocks permission...";
 104  
 105  cms_mapi_create_permission($gCms, 'Modify Code Blocks', 'Modify Code Blocks');
 106  
 107  echo "[done]</p>";
 108  
 109  echo "<p>Creating clear admin log permission...";
 110  
 111  cms_mapi_create_permission($gCms, 'Clear Admin Log', 'Clear Admin Log');
 112  
 113  echo "[done]</p>";
 114  
 115  echo "<p>Clearing cache and template directories... ";
 116  
 117  function clear_dir_5($dir){
 118  
 119      $path = dirname(dirname(__FILE__))."/smarty/cms/".$dir."/";
 120  
 121      $handle=opendir($path);
 122      while ($file = readdir($handle)) {
 123          if ($file != "." && $file != ".." && is_file($path.$file)) {
 124              #echo ($path.$file);
 125              unlink($path.$file);
 126          }
 127      }
 128  }
 129  
 130  clear_dir_5("templates_c");
 131  clear_dir_5("cache");
 132  
 133  echo "[done]</p>";
 134  
 135  #echo "<p>Deleting stylesheet column... ";
 136  #$dbdict = NewDataDictionary($db);
 137  #$sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."templates", "stylesheet");
 138  #$dbdict->ExecuteSQLArray($sqlarray);
 139  #echo "[done]</p>";
 140  
 141  echo "<p>Updating schema version... ";
 142  
 143  $query = "UPDATE ".cms_db_prefix()."version SET version = 6";
 144  $db->Execute($query);
 145  
 146  echo "[done]</p>";
 147  
 148  # vim:ts=4 sw=4 noet
 149  ?>