#!/usr/bin/env php
<?php
require_once("/usr/local/share/hostingplatform/esrpc.php");

$server = new ESRPCConnection();
$worker = new Worker($server->get());
$server->setTarget($worker);
$server->connect();
$server->serve();

class Worker {
	var $api;

	function __construct($api) {
		$this->api = $api;
	}

	function restoreMySQLDatabases($packagename, $version, $password) {
		if ($handle = opendir("/var/local/hostingplatform/snapshots/" . $packagename . "/" . $version . "/databases/mysql/")) {
		    while (false !== ($database = readdir($handle))) {

			if ($database != "." && $database != "..") {
			    shell_exec("cat /var/local/hostingplatform/snapshots/" . escapeshellcmd($packagename) . "/" . escapeshellcmd($version) . "/databases/mysql/" . escapeshellcmd($database) . "/*.sql | mysql -u" . escapeshellcmd($packagename) . " -p" . escapeshellcmd($password) . " " . escapeshellcmd($database));
			}
		    }
		    closedir($handle);
		}
		return true;
	}
}