<?php

$db_server = 'localhost';

$login_data = parse_ini_file("/etc/origo/origo.conf");


$origo_path = '/data/www/origo/drupal/';
$origo_server = 'origo.ethz.ch';

$project_id = (int)$argv[1];
$project_name = strtolower($argv[2]);


function generate_password()
{
  $rows = array();
  array_push($rows, range('A' , 'Z'));
  array_push($rows, range('a' , 'z'));
  array_push($rows, range(0 , 9));
  $min_length = 8;
  $max_length = 11;
  $shuffle = 3;


  $chars = array();
  foreach($rows as $row)
  $chars = array_merge($chars, $row);
  for ($i = 0 ; $i < $shuffle ; $i++)
  shuffle($chars);

  $password = '';
  $length = rand($min_length , $max_length);
  for ($i = 0 ; $i < $length ; $i++)
  $password .= $chars[array_rand($chars , 1)];

  return $password;
}

$password = generate_password();

mysql_connect($db_server, $login_data['manager_user'], $login_data['manager_password']);

if (!empty($project_name)) {
  /*
   * Create project and copy files for drupal
   */
  
  //create database and user for Drupal
  mysql_query("CREATE USER 'origo_" . $project_id . "'@'localhost' IDENTIFIED BY '" . $password . "'");
  mysql_query("CREATE DATABASE `origo_" . $project_name . "`");
  mysql_query("GRANT ALL PRIVILEGES ON `origo_" . $project_name . "` . * TO 'origo_" . $project_id . "'@'localhost'");

  //create site directory
  mkdir($origo_path . 'sites/' . $project_name, 0755);
  
  //symbolic link for drupal site detection
  symlink($project_name, $origo_path . 'sites/' . $project_name . '.' . $origo_server);

  //copy initial settings from template
  copy($origo_path . 'sites/template/settings.php', $origo_path . 'sites/' . $project_name . '/settings.php');

  //set rights on settings file
  exec('chmod 666 ' . $origo_path . 'sites/' . $project_name . '/settings.php');
  
  //copy files directory
  exec('cp -R ' . $origo_path . 'sites/template/files ' . $origo_path . 'sites/'  . $project_name . '/files');
  
  //set owner for files directory
  exec('chown -R www-data:www-data ' . $origo_path . 'sites/' . $project_name . '/files');
  
  
  /*
   * Drupal installation using the Origo profile
   */
  require_once "HTTP/Request.php";

  $req =& new HTTP_Request('http://' . $project_name . '.' . $origo_server . '/install.php?profile=origo');
  $req->setMethod(HTTP_REQUEST_METHOD_POST);
  $req->addPostData('db_type', 'mysqli');
  $req->addPostData('db_path', 'origo_' . $project_name);
  $req->addPostData('db_user', 'origo_' . $project_id);
  $req->addPostData('db_pass', $password);
  $req->addPostData('db_host', 'localhost');
  $req->addPostData('form_id', 'install_settings_form');

  $req->sendRequest();

  $req = new HTTP_Request('http://' . $project_name . '.' . $origo_server . '/install.php?profile=origo');
  $req->sendRequest();

  /*
   * DB changes after Drupal installation
   */
  mysql_select_db('origo_' . $project_name);
  
  //set own project id and name
  mysql_query("INSERT INTO `variable` ( `name` , `value` ) VALUES ('origo_project_id', 'i:".$project_id.";')");
  mysql_query("INSERT INTO `variable` ( `name` , `value` ) VALUES ('origo_project_name', 's:".strlen($project_name).":\"".$project_name."\";')");
  
  //set site name
  mysql_query("UPDATE `variable` SET `value` = 's:" . strlen($project_name) . ":\"".ucwords($project_name)."\";' WHERE CONVERT( `variable`.`name` USING utf8 ) = 'site_name' LIMIT 1 ;");
  
  //set file directory 
  mysql_query("INSERT INTO `variable` ( `name` , `value` ) VALUES ('file_directory_path', 's:".(strlen($project_name)+12).":\"sites/".$project_name."/files\";');");

  //set donwload page title to project name
  mysql_query("UPDATE `node` SET `title` = '" . ucwords($project_name) . "' WHERE `node`.`nid` =5 AND `node`.`vid` =30 LIMIT 1 ;");
  //mysql_query("UPDATE `menu` SET `title` = '".ucwords($project_name)."' WHERE `menu`.`mid` =145 LIMIT 1 ;");
  mysql_query("UPDATE `node_revisions` SET `title` = '" . ucwords($project_name) . "' WHERE `node_revisions`.`vid` =29 LIMIT 1 ;");

  //adapt file path for example download
  //mysql_query("UPDATE `files` SET `filepath` = 'sites/".$project_name."/files/Minestrone-1.0.zip' WHERE `files`.`fid` =8 LIMIT 1 ;");
  
  //set project name in sample blog
  mysql_query("UPDATE `node` SET `title` = '" . ucwords($project_name) . " project created' WHERE `node`.`nid` =10 AND `node`.`vid` =15 LIMIT 1 ;");
  mysql_query("UPDATE `node_revisions` SET `title` = '" . ucwords($project_name) . " project created', `body` = 'Today " . ucwords($project_name) . " was created and now the work can begin.\r\nHave fun working on " . ucwords($project_name) . ".', `teaser` = 'Today " . ucwords($project_name) . " was created and now the work can begin.\r\nHave fun working on " . ucwords($project_name) . ".' WHERE `node_revisions`.`vid` =15 LIMIT 1 ;");
  
  //set correct alias for home page
  mysql_query("UPDATE `url_alias` SET `dst` = 'wiki/".strtolower($project_name)."' WHERE `src` ='node/5';");
  
  //remove latest items from menu
  mysql_query("UPDATE `menu` SET `type` = '48' WHERE `menu`.`path` ='tracker' LIMIT 1 ;");
  
  //remove logout from left menu
  mysql_query("UPDATE `menu` SET `type` = '48' WHERE `menu`.`path` ='logout' LIMIT 1 ;");
  
  /*
   * Update settings file 
   */

  copy($origo_path . 'sites/' . $project_name . '/settings.php', $origo_path . 'sites/' . $project_name . '/settings.save');
  
  exec('patch -p0 ' . $origo_path . 'sites/' . $project_name . '/settings.php < ' . $origo_path . 'sites/template/settings.patch');
 
  //set rights on settings file
  exec('chmod 644 ' . $origo_path . 'sites/' . $project_name . '/settings.php');  
  
}

?>