<?php
/*
 * This script is one step of the project deletion process. It takes care of all things related to drupal. In detail:
 * 1. It removes the project database from the drupal database server
 * 2. It removes the project directory from the drupal directory (/data/www/origo/drupal/sites/project_name)
 * 3. It removes the symbolic link for the site detection (/data/www/origo/drupal/sites/project_name.origo-domain.ch)
 *
 * The database must contain a user with the same name as in the origo.conf file (origo_manager), with
 * all the needed privileges. 
 */


// Settings
$db_server = 'localhost';
@$login_data = parse_ini_file("/etc/origo/origo.conf");
$origo_path = '/data/www/origo/drupal/';
$origo_server = $login_data['origo_domain'];
$verbose = false;

// argument parsing. 
$project_id = (int)$argv[1];
$project_name = strtolower($argv[2]);


if (!empty($project_name) && $project_id > 0) {
  /*
   * Remove project files
   */

  prln('Connecting to database '.$login_data['manager_user'].':'.$login_data['manager_password'].'@'.$db_server );
  mysql_connect($db_server, $login_data['manager_user'], $login_data['manager_password']) or die(mysql_error());
  
  //remove database and user for Drupal
  prln('Removing users and database. ');
  mysql_query("DROP USER 'origo_" . $project_id . "'@'localhost'") or prln(mysql_error());
  mysql_query("DROP DATABASE `origo_" . $project_name . "`") or prln(mysql_error());

  prln('Removing sites directory');
  //remove site directory
  removeDir($origo_path . 'sites/' . $project_name);

  //symbolic link for drupal site detection
  unlink($origo_path . 'sites/' . $project_name . '.' . $origo_server);


  /*
   * No DB changes are necessary because the complete database has already been dropped
   */
  
  prln ("project removed");
} else {
  prln( "usage:\n  arg1\t project id\n  arg2\t project name ");
}

function removeDir($dir) {
  if(!$dh = @opendir($dir)) return;
  while (($obj = readdir($dh))) {
    if($obj=='.' || $obj=='..') continue;
    if (!@unlink($dir.'/'.$obj)) removeDir($dir.'/'.$obj, true);
  }
  closedir($dh);
  @rmdir($dir);
}

function prln($str)
{
  global $verbose;
  if ($verbose) 
    echo $str."\n";
}

?>