<?php
require 'header.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
redirect("license.php");
}
printHead();
?>
<h1>Thank you for installing <?php
echo \GO::config()->product_name;
?>
!</h1>
<p>This page checks if your system meets the requirements to run <?php
echo \GO::config()->product_name;
?>
.</p>
<p>If this page prints errors or warnings, please visit this page for more information: <a target="_blank" href="https://www.group-office.com/wiki/Installation">https://www.group-office.com/wiki/Installation</a></p>
<h2>System test</h2>
<?php
require 'gotest.php';
if (!output_system_test()) {
echo '<p style="color: red;">Because of a fatal error in your system setup the installation can\'t continue. Please fix the errors above first.</p>';
} else {
echo continueButton();
}
printFoot();
$msg .= "There was a problem removing the file {" . $name . "} from the filesystem.<br />Please contact the ystem administrator.";
$c = "red";
}
$b = $msg;
} else {
/** only remove this entry **/
$sql = "DELETE from dropbox where id=" . $_POST['db_id'];
if ($result = $db->query($sql)) {
$msg .= "Successfully removed the file {" . $name . "} entry in the database<br />";
} else {
$msg .= "There was a problem removing the file {" . $name . "} entry from the database.<br />";
$c = "red";
}
$b = $msg;
}
$b .= "<center>" . continueButton($_GET['lev'], $_GET['cat']) . "</center>";
$main .= make_box($t, $b, $c);
}
/** Now display the users files he/she has saved **/
$b = "";
/** display my files **/
$t = "My Files";
$sql = "SELECT * from dropbox where file_owner=" . $myID . " AND file_recipient=" . $myID;
$sql = "SELECT users.first_name, users.last_name, file_name, date_dropped, file_description, file_id, dropbox.id\n\tFROM dropbox, users \n\tWHERE file_recipient=" . $myID . "\n\t\tAND file_owner=" . $myID . "\n\t\tAND users.user_id=dropbox.file_owner";
$result = $db->query($sql);
if ($result) {
$b .= "<table border=0 cellspacing=10 cellpadding=3>";
while ($row = $result->fetch_assoc()) {
$b .= "<tr><td rowspan=1 valign=middle align=center width=70><img src=images/dropBox_saveFile2.png /></td>";
$b .= "<td>\n\t\t\t\t<table class=\"dropbox\">\n\t\t\t\t\t<tr><th align=left colspan=2>" . $row['file_title'] . "</th></tr>\n\t\t\t\t\t<td align=right>Author: </td><td class=\"dropbox\">" . $row['first_name'] . " " . $row['last_name'] . "</td></tr>\n\t\t\t\t\t<td align=right>File Name: </td><td class=\"dropbox\">" . $row['file_name'] . "</td></tr>\n\t\t\t\t\t<td align=right>Submitted: </td><td class=\"dropbox\">" . $row['date_dropped'] . "</td></tr>\n\t\t\t\t\t<td align=right>Comment: </td><td>" . $row['file_description'] . "</td></tr>\n\t\t\t\t</table>\n\t\t\t\t</td>";
$b .= "<td>\n\t\t\t\t<form method=POST id=removeDB action=index.php?lev=" . $_SESSION[$_CONF['sess_name'] . '_lev'] . "&cat=" . $_SESSION[$_CONF['sess_name'] . '_cat'] . ">\n\t\t\t\t<input type=submit name=confirm value=REMOVE onClick=\"return confirmRemove()\" />\n <input type=submit name=download id=download value=Download />\n\t\t\t\t<input type=hidden id=fid name=fid value=" . $row['file_id'] . " />\n\t\t\t\t<input type=hidden id=db_id name=db_id value=" . $row['id'] . " />\n\t\t\t\t<input type=hidden name=whosefiles value=mine />\n\t\t\t\t</td></tr>";
}
}
printHead();
if (isset($error)) {
errorMessage($error);
}
?>
<h1>Database connection</h1>
<p>
Create a database now and fill in the values to connect to your database.<br />
The database user should have permission to perform select-, insert-, update- and delete queries. It must also be able to lock tables.<br /><br />
If you are upgrading then now is the last time to back up your database! Fill in the fields and click at 'Continue' to upgrade your database structure.
</p>
<div class="cmd">
$ mysql -u root -p<br />
mysql> CREATE DATABASE groupoffice;<br />
mysql> GRANT ALL PRIVILEGES ON groupoffice.* TO 'groupoffice'@'localhost'<br />
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;<br />
mysql> quit;<br />
</div>
<?php
\GO\Base\Html\Input::render(array("label" => "Host", "name" => "db_host", "value" => \GO::config()->db_host));
\GO\Base\Html\Input::render(array("label" => "Port", "name" => "db_port", "value" => \GO::config()->db_port));
\GO\Base\Html\Input::render(array("label" => "Name", "name" => "db_name", "value" => \GO::config()->db_name));
\GO\Base\Html\Input::render(array("label" => "Username", "name" => "db_user", "value" => \GO::config()->db_user));
\GO\Base\Html\Password::render(array("label" => "Password", "name" => "db_pass", "value" => ""));
continueButton();
printFoot();
