<?php

// $Id$

/**
 * @file
 * Include file containing Drupal update hooks for the origo_home module.
 *
 * Note: Besides updates for the origo_home module, we "misuse" the update
 * mechanism to set options for other modules, so that all Origo projects will
 * receive them.
 */

/**
 * Update #1, 2009-11-04
 * Purge pathauto-settings, and (re-)add proper ones.
 */
function origo_home_update_6100() {
  $ret = array();

  // We "misuse" the origo-home module to propagate new settings for the
  // pathauto module.
  // Note: we could use the issue-tracker update routines to add its new
  // settings (see rev. 3383), but to forgo prevent any clashes when dropping
  // all settings, we include it here all the same.

  db_query("DELETE FROM {variable} WHERE name LIKE 'pathauto_%'");

  variable_set('pathauto_modulelist', array(
    'blog',
    'node',
    'taxonomy',
    'user',
    'forum'
  ));

  variable_set('pathauto_taxonomy_supportsfeeds', 'category/[vocab-raw]/[catpath-raw]');
  variable_set('pathauto_taxonomy_pattern', '');
  variable_set('pathauto_taxonomy_bulkupdate', 0);
  variable_set('pathauto_taxonomy_applytofeeds', '');
  variable_set('pathauto_taxonomy_2_pattern', '');
  variable_set('pathauto_taxonomy_1_pattern', '');
  variable_set('pathauto_ignore_words', '');
  variable_set('pathauto_node_blog_pattern', 'blog/[author-name-raw]/[title-raw]');
  variable_set('pathauto_indexaliases', FALSE);
  variable_set('pathauto_indexaliases_bulkupdate', FALSE);
  variable_set('pathauto_max_component_length', '100');
  variable_set('pathauto_max_length', '100');
  variable_set('pathauto_node_bulkupdate', 0);
  variable_set('pathauto_node_forum_pattern', '');
  variable_set('pathauto_node_image_pattern', 'image/[title-raw]');
  variable_set('pathauto_node_page_pattern', '');
  variable_set('pathauto_node_pattern', '');
  variable_set('pathauto_node_story_pattern', 'news/[title-raw]');
  variable_set('pathauto_punctuation_quotes', '1');
  variable_set('pathauto_separator', '_');
  variable_set('pathauto_update_action', '2');
  variable_set('pathauto_user_bulkupdate', 0);
  variable_set('pathauto_user_pattern', 'user/[user-raw]');

  // pathauto_user_supportsfeeds            | N;        ??????

  variable_set('pathauto_verbose', 0);
  variable_set('pathauto_node_applytofeeds', 'feed');
  variable_set('pathauto_punctuation_hyphen', '1');
  variable_set('pathauto_quotes', '0');
  variable_set('pathauto_blog_pattern', 'blog/[user-raw]');
  variable_set('pathauto_blog_applytofeeds', 'feed');
  variable_set('pathauto_node_book_pattern', '[book]/[title-raw]');
  variable_set('pathauto_node_wiki_pattern', 'wiki/[title-raw]');
  variable_set('pathauto_node_issue_pattern', 'issues/[issue-id]');
  variable_set('pathauto_transliterate', FALSE);
  variable_set('pathauto_blog_supportsfeeds', 'feed');
  variable_set('pathauto_node_supportsfeeds', 'feed');
  variable_set('pathauto_forum_supportsfeeds', '0/feed');
  variable_set('pathauto_case', '1');
  variable_set('pathauto_max_bulk_update', '50');
  variable_set('pathauto_reduce_ascii', 0);
  variable_set('pathauto_blog_bulkupdate', 0);
  variable_set('pathauto_forum_pattern', '[vocab-raw]/[catpath-raw]');
  variable_set('pathauto_forum_bulkupdate', 0);
  variable_set('pathauto_forum_applytofeeds', '0/feed');
  variable_set('pathauto_taxonomy_3_pattern', '');

  // enable all replacement-patterns
  variable_set('pathauto_punctuation_double_quotes', '1');
  variable_set('pathauto_punctuation_backtick', '1');
  variable_set('pathauto_punctuation_comma', '1');
  variable_set('pathauto_punctuation_period', '1');
  variable_set('pathauto_punctuation_underscore', '1');
  variable_set('pathauto_punctuation_colon', '1');
  variable_set('pathauto_punctuation_semicolon', '1');
  variable_set('pathauto_punctuation_pipe', '1');
  variable_set('pathauto_punctuation_left_curly', '1');
  variable_set('pathauto_punctuation_left_square', '1');
  variable_set('pathauto_punctuation_right_curly', '1');
  variable_set('pathauto_punctuation_right_square', '1');
  variable_set('pathauto_punctuation_plus', '1');
  variable_set('pathauto_punctuation_equal', '1');
  variable_set('pathauto_punctuation_asterisk', '1');
  variable_set('pathauto_punctuation_ampersand', '1');
  variable_set('pathauto_punctuation_percent', '1');
  variable_set('pathauto_punctuation_caret', '1');
  variable_set('pathauto_punctuation_dollar', '1');
  variable_set('pathauto_punctuation_hash', '1');
  variable_set('pathauto_punctuation_at', '1');
  variable_set('pathauto_punctuation_exclamation', '1');
  variable_set('pathauto_punctuation_tilde', '1');
  variable_set('pathauto_punctuation_left_parenthesis', '1');
  variable_set('pathauto_punctuation_right_parenthesis', '1');
  variable_set('pathauto_punctuation_question_mark', '1');
  variable_set('pathauto_punctuation_less_than', '1');
  variable_set('pathauto_punctuation_greater_than', '1');
  variable_set('pathauto_punctuation_back_slash', '1');

  cache_clear_all('variables', 'cache');

  return $ret;
}

/**
 * Update #2, 2010-04-12
 * Set proper Customerror code, fixes #859.
 */
function origo_home_update_6101() {
  $ret = array();
  // We "misuse" the origo-home module to propagate new settings for the
  // customerror module.

  variable_set('customerror_403', '<?php global $user; if ($user->uid): ?> <p>Sorry <?php print $user->name; ?>, you don\'t have permission to view the page you\'ve just tried to access.</p><p>If you feel that you have received this message in error, please contact us with specific details so that we may review your access to this web site.</p> <?php else: ?> <p>This page may be available to clients and registered users only. Please select from one of the other options available to you below.</p><ul><li><a href="<?php echo get_origo_project_link(); ?>/user/login?<?php print drupal_get_destination(); ?>">Login</a> to view this page</li><li>Use the search form in the top right corner</li><li>Go to the <a href="<?php echo get_origo_project_link(); ?>">home page</a></li></ul><?php endif; ?>');
  variable_set('customerror_403_title', 'Error 403 Forbidden: Access to this page is denied');

  variable_set('customerror_404', '<p>Sorry, no content was found at the requested path - it\'s possible that you\'ve requested this page in error.</p><p>Use the search form in the top right, or go to the <a href="<?php echo get_origo_project_link(); ?>">home page.</a></p>');
  variable_set('customerror_404_title', 'Error 404 Not Found: No content found at the requested URL');

  cache_clear_all('variables', 'cache');
  return $ret;
}

/**
 * Update #3, 2010-06-09
 * Enable additional languages in geshifilter, fixes #938
 */
function origo_home_update_6102() {
  $ret = array();

  // geshi filter setup
  $languages = array('php', 'drupal5', 'drupal6', 'javascript', 'java', 'c', 'cpp', 'python', 'ruby', 'actionscript', 'ada', 'asm', 'apache', 'asp', 'bash', 'cfm', 'cil', 'cobol', 'csharp', 'css', 'delphi', 'diff', 'eiffel', 'fortran', 'freebasic', 'gettext', 'groovy', 'haskel', 'ini', 'java5', 'latex', 'lisp', 'lua', 'make', 'matlab', 'mirc', 'mysql', 'objc', 'ocaml', 'oracle11', 'oracle8', 'pascal', 'perl', 'plsql', 'povray', 'powershell', 'prolog', 'qbasic', 'rails', 'reg', 'robots', 'scala', 'scheme', 'scilab', 'smalltalk', 'smarty', 'sql', 'tcl', 'vb', 'vbnet', 'verilog', 'vhdl', 'xml');
  foreach ($languages as $language) {
    variable_set('geshifilter_language_enabled_' . $language, TRUE);
    variable_set('geshifilter_language_tags_' . $language, '<' . $language . '>');
  }

  return $ret;
}

/**
 * Update #4 - Set nicer 403/404 messages, fixes #992
 */
function origo_home_update_6103() {
  $ret = array();
  // We "misuse" the origo-home module to propagate new settings for the
  // customerror module - again.
  variable_set('customerror_403', '<?php global $user; if ($user->uid): ?><h1>Oops! Looks like you followed a bad link.</h1><p>Sorry <?php print $user->name; ?>, you don\'t have permission to view the page you\'ve just tried to access.</p><p>If you feel that you have received this message in error, please contact us with specific details so that we may review your access to this web site.</p><ul><li>Use the search form in the top right corner</li><li>Go to the <a href="<?php echo get_origo_project_link(); ?>">home page</a></li></ul><?php else: ?><p>This page may be available to clients and registered users only. Please select from one of the other options available to you below.</p><ul><li><a href="<?php echo get_origo_project_link(); ?>/user/login?<?php print drupal_get_destination(); ?>">Login</a> to view this page</li></ul><?php endif; ?><br/><br/><i>Error 403 Forbidden: Access to this page is denied</i>');
  variable_set('customerror_403_title', '');

  variable_set('customerror_404', '<h1>Oops! Looks like you followed a bad link.</h1><p>Sorry, no content was found at the requested path - it\'s possible that you\'ve requested this page in error.</p><p>Use the search form in the top right, or go to the <a href="<?php echo get_origo_project_link(); ?>">home page.</a></p><br/><p><i>Error 404 Not Found: No content found at the requested URL</i></p>');
  variable_set('customerror_404_title', '');

  cache_clear_all('variables', 'cache');
  return $ret;
}

/**
 * Update #5 - Update to newer GeshiFilter Module, set some settings
 *  - Enable line numbering of code blocks
 *  - Use inline css
 *  - Use div containers
 */
function origo_home_update_6104() {
  $ret = array();

  variable_set('geshifilter_default_line_numbering', "1");  // use line numbers
  variable_set('geshifilter_css_mode', "1");                // use inline css
  variable_set('geshifilter_code_container', "1");          // use div container

  cache_clear_all('variables', 'cache');
  return $ret;
}

/**
 * Update #6 - Add new permission "access nonpublic statistics" for members, owners and admins.
 */
function origo_home_update_6105() {
  $ret = array();
  module_load_include('inc', 'user', 'user.admin');

  // Update permissions
  // We do this by faking a call to "user_admin_perm_submit"
  $form_state = array();
  $form_state['values'] = array();

  // Owners - RID = 3
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics");
  foreach ($perm_tokens as $token) {
    $form_state['values'][3][trim($token)] = TRUE;
  }

  // Members - RID = 4
  $perm_tokens = explode(', ', "create blog entries, delete own blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, create forum topics, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics");
  foreach ($perm_tokens as $token) {
    $form_state['values'][4][trim($token)] = TRUE;
  }

  // Admins - RID = 5
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo admin access, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics");
  foreach ($perm_tokens as $token) {
    $form_state['values'][5][trim($token)] = TRUE;
  }

  // Note: this will also clear the cache
  user_admin_perm_submit(NULL, $form_state);

  cache_clear_all();
  return $ret;
}

/**
 * Update #7 - (Re-) Add permission "delete issue" for owners and admins (issue #1084).
 */
function origo_home_update_6106() {
  $ret = array();
  module_load_include('inc', 'user', 'user.admin');

  module_load_include('inc', 'user', 'user.admin');
  $form_state = array();
  $form_state['values'] = array();
  $role_permissions = array();

  // retrieve current permissions for Owners (RID = 3) and Admins (RID = 5)
  $result = db_query('SELECT r.rid, p.perm FROM {role} r LEFT JOIN {permission} p ON r.rid = p.rid WHERE r.rid in (3, 5)');

  while ($role = db_fetch_object($result)) {
    $role_permissions[$role->rid] = explode(', ', $role->perm);
    $form_state['values'][$role->rid] = array();

    // add new permission, if not already set
    if (!in_array('delete issue', $role_permissions[$role->rid])) {
      $output = "it's not in it!";
      $role_permissions[$role->rid][] = 'delete issue';
    }

    // enter into faked form
    foreach ($role_permissions[$role->rid] as $perm) {
      $form_state['values'][$role->rid][trim($perm)] = TRUE;
    }
  }
  // submit the fake form, thereby saving the permissions.
  // Note: this will also clear the cache
  user_admin_perm_submit(NULL, $form_state);

  return $ret;
}

/**
 * Update #8, 2010-09-06
 * Set the new default theme.
 */
function origo_home_update_6107() {
  $ret = array();

  // set to default
  variable_set('theme_default', 'oxymoron');
  $ret[] = array('success' => TRUE, 'query' => "variable_set('theme_default', 'oxymoron')");

  // assign new blocks
  $ret[] = db_query("REPLACE INTO `blocks` (`module`, `delta`, `theme`, `status`, `weight`, `region`, `custom`, `throttle`, `visibility`, `pages`, `title`, `cache`) VALUES
    ('blog', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('comment', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('diff', 'inline', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('forum', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('forum', '1', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('google_cse', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('google_cse', '1', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('image', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('image', '1', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('img_assist', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('menu', 'primary-links', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('menu', 'secondary-links', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('node', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('origo_home', '0', 'oxymoron', 1, -10, 'main_navi', 0, 0, 0, '', '', 1),
    ('origo_home', '1', 'oxymoron', 1, -11, 'main_navi', 0, 0, 0, '', '', 1),
    ('origo_home', '2', 'oxymoron', 1, -10, 'main_navi', 0, 0, 0, '', '', 1),
    ('origo_home', '3', 'oxymoron', 1, -12, 'main_navi', 0, 0, 0, '', '', 1),
    ('search', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('system', '0', 'oxymoron', 0, 10, 'left', 0, 0, 0, '', '', -1),
    ('user', '0', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('user', '1', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1),
    ('user', '2', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', 1),
    ('user', '3', 'oxymoron', 0, 0, 'left', 0, 0, 0, '', '', -1);");

  return $ret;
}

/**
 * Update #9, 2011-07-02.
 * - Let the Home button point to the site frontpage, #1352
 * - Add permissions to members, owners and admin that allow to bypass the spam-filters, #1390
 */
function origo_home_update_6108() {
  $ret = array();

  // ----------------
  // Update menu link

  $menu_link= null;
  $tree =  menu_tree_all_data('primary-links');
  foreach($tree as $item) {
    if ($item['link']['link_path'] == "node/5") {
      $menu_link= $item['link'];
      break;
    }
  }

  if ($menu_link != null) {
    $menu_link['href']= '<front>';
    $menu_link['link_path']= '<front>';

    menu_link_save($menu_link);
  }

  // ------------------
  // Extend Permissions

  module_load_include('inc', 'user', 'user.admin');

  // Update permissions
  // We do this by faking a call to "user_admin_perm_submit"
  $form_state = array();
  $form_state['values'] = array();

  // Owners - RID = 3
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics, bypass filters");
  foreach ($perm_tokens as $token) {
    $form_state['values'][3][trim($token)] = TRUE;
  }

  // Members - RID = 4
  $perm_tokens = explode(', ', "create blog entries, delete own blog entries, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, create forum topics, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics, bypass filters");
  foreach ($perm_tokens as $token) {
    $form_state['values'][4][trim($token)] = TRUE;
  }

  // Admins - RID = 5
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo admin access, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics, bypass filters, administer spam");
  foreach ($perm_tokens as $token) {
    $form_state['values'][5][trim($token)] = TRUE;
  }

  // Note: this will also clear the cache
  user_admin_perm_submit(NULL, $form_state);
  return $ret;
}

/**
* Update #10, 2011-10-23.
* - Restore permissions for owners to delete issues (regression from last update), #1410
*/
function origo_home_update_6109() {
  $ret = array();

  // ------------------
  // Extend Permissions

  module_load_include('inc', 'user', 'user.admin');

  // Update permissions
  // We do this by faking a call to "user_admin_perm_submit"
  $form_state = array();
  $form_state['values'] = array();

  // Owners - RID = 3
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, delete issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics, bypass filters");
  foreach ($perm_tokens as $token) {
    $form_state['values'][3][trim($token)] = TRUE;
  }

  // Admins - RID = 5
  $perm_tokens = explode(', ', "create blog entries, delete any blog entry, delete own blog entries, edit any blog entry, edit own blog entries, access comments, administer comments, post comments, post comments without approval, access private developer pages, administer forums, create forum topics, delete any forum topic, delete own forum topics, edit any forum topic, edit own forum topics, search Google CSE, create images, edit images, edit own images, view original images, access advanced options, access all images, access img_assist, use original size, create issue, edit issue, delete issue, access content, create wiki content, delete any wiki content, delete own wiki content, edit any wiki content, edit own wiki content, revert revisions, view revisions, origo admin access, origo create project, origo create release, origo delete release, origo project settings, origo request application key, search content, use advanced search, purge trash, restore trash, view trash, upload files, view uploaded files, access user profiles, access nonpublic statistics, bypass filters, administer spam");
  foreach ($perm_tokens as $token) {
    $form_state['values'][5][trim($token)] = TRUE;
  }

  // Note: this will also clear the cache
  user_admin_perm_submit(NULL, $form_state);
  return $ret;
}